Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1
- Beth Blok (Unlicensed)
Owned by Beth Blok (Unlicensed)
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
