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

Owned by Beth Blok (Unlicensed)
Last updated: Jan 11, 2018
1 min read

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