Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00
- Beth Blok (Unlicensed)
Owned by Beth Blok (Unlicensed)
Nov 20, 2019
1 min read
Loading data...
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