-- Appended to 20/11/2019 at 17:25:07 -- Connection from  -----------------
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 20/11/2019 at 17:26:30 -- Connection from  -----------------
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 20/11/2019 at 17:26:40 -- Connection from  -----------------
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 20/11/2019 at 17:27:26 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 20/11/2019 at 17:28:17 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '0', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '0', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '0' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 20/11/2019 at 17:28:30 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 25/02/2020 at 00:00:37 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 01/03/2020 at 13:45:50 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 06/03/2020 at 16:11:13 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 06/03/2020 at 20:02:02 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 23/03/2020 at 15:28:25 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 28/03/2020 at 09:08:37 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 04/04/2020 at 22:58:32 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 13/04/2020 at 14:40:23 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 18/04/2020 at 01:03:01 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 23/04/2020 at 16:54:18 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

-- Appended to 29/04/2020 at 04:32:12 ------------------\r\nUPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR4366';
UPDATE dbo.SOPOrderReturnLine SET DespatchReceiptQuantity = '20', AllocatedQuantity = '0', AvailableForDespatch = '0', ReadyForInvoicePrint = '1', StockUnitDespRcptQuantity = '20', InvoiceCreditQuantity = '0', StockUnitInvoiceCreditQuantity = '20' WHERE SOPOrderReturnID='543210' AND ItemCode = 'CR3849';
UPDATE dbo.SOPOrderReturn SET ReadyForInvoicePrint = '1' WHERE DocumentNo = '0009430202';
-------------------------------------------------------------------------------------------

