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