Warehouse Summary grid Unprocessed Sales Orders to exclude unprocessed credit notes
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