/
Warehouse Summary grid Unprocessed Sales Orders to exclude unprocessed credit notes

Warehouse Summary grid Unprocessed Sales Orders to exclude unprocessed credit notes

Owned by Beth Blok (Unlicensed)
Feb 15, 2019
1 min read

Problem

Unprocessed sales order credit notes where Credit into Stock is ticked is included twice in the Warehouse Summary grid - Total SOH and Unprocessed Sales Orders giving an incorrect figure of the total stock on hand

Solution

SQL skills are required

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



The stored procedure that drives that grid has been corrected to exclude unprocessed credit notes from the Unprocessed Sales Orders column.  Download the attached script and apply to 7.02.00 databases

Related articles







Related content

SOH showing items returned on credit note, but items are not on the credit note.
SOH showing items returned on credit note, but items are not on the credit note.
Jiwa 7
More like this
Deleting a line on a sales order credit note errors on Total of SO_LineDetails.Quantity
Deleting a line on a sales order credit note errors on Total of SO_LineDetails.Quantity
Jiwa 7
More like this
SOMGT083 - Sales with COGS by Staff by Debtor Class by Prod Class reports credit notes correctly
SOMGT083 - Sales with COGS by Staff by Debtor Class by Prod Class reports credit notes correctly
Jiwa 7
More like this
Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only
Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only
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
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
Jiwa 7
More like this