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

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

Owned by Beth Blok (Unlicensed)
Nov 20, 2019
1 min read

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

Related articles







Related content

Deleting back orders on a warehouse transfer outwards form
Deleting back orders on a warehouse transfer outwards form
Jiwa 7
More like this
Order > On Back Order tab does not display back orders from Warehouse Transfer Outwards batches - 7.00.175
Order > On Back Order tab does not display back orders from Warehouse Transfer Outwards batches - 7.00.175
Jiwa 7
More like this
Process Back Orders is not fulfilling back orders on Warehouse Transfers - 7.00.175, 7.02.00, 7.02.01
Process Back Orders is not fulfilling back orders on Warehouse Transfers - 7.00.175, 7.02.00, 7.02.01
Jiwa 7
More like this
When debtor is on hold, backorder processing may not fulfill backorders.
When debtor is on hold, backorder processing may not fulfill backorders.
Jiwa 7
More like this
Inventory->Order->On BackOrder tab shows blank Invoice numbers
Inventory->Order->On BackOrder tab shows blank Invoice numbers
Jiwa 7
More like this
Processing Back Orders on a Warehouse Transfer Out
Processing Back Orders on a Warehouse Transfer Out
Jiwa 7
More like this