Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00

Problem

Where back orders on a warehouse transfer are cancelled by updating the Quantity Ordered field, the underlying back order records were not deleted from the ON_OnBackOrder table

Solution

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

Download and run the attached SQL script over the relevant database to remove incorrect back order records