Process Back Orders is not fulfilling back orders on Warehouse Transfers - 7.00.175, 7.02.00, 7.02.01

Problem

Back orders created by a warehouse transfer are not being fulfilled when running Process Back Orders

Solution

The stored procedure for this process needs to be corrected as follows.  The issue will be addressed in next full release.

Change the select statement in usp_Jiwa_GetBackOrderProcessList from:

SELECT * FROM @TempTable WHERE QuantityAvailable > 0 AND DebtorID NOT IN (SELECT DebtorID FROM DB_Main WHERE AccountOnHold = 1)

to:

SELECT * FROM @TempTable WHERE QuantityAvailable > 0 AND (DebtorID IS NULL OR DebtorID NOT IN (SELECT DebtorID FROM DB_Main WHERE AccountOnHold = 1))

Related articles