Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1

Problem

Used in Work Orders tab is incorrect where Production Quantity > 1 - the quantity reported is for a production quantity of 1 only, not for the actual quantity allocated.

Solution

SQL skills are required

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

Download and run the attached stored procedure to correct the data returned to the Inventory > Order > Used in Work Orders grid

Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1

Problem

Solution

Related articles