/
Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1
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
Related articles
, multiple selections available,
Related content
Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
Work order inputs do not appear in the Inventory >Transaction History tab - 7.02.00 and 7.02.01
More like this
Inventory->Order->On BackOrder tab shows blank Invoice numbers
Inventory->Order->On BackOrder tab shows blank Invoice numbers
More like this
Where Supply Order Units > 1 stock is being over-ordered using Replenish to Minimum Re-Order method
Where Supply Order Units > 1 stock is being over-ordered using Replenish to Minimum Re-Order method
More like this
Sales order, quote inventory or purchase order part numbers not matching the description
Sales order, quote inventory or purchase order part numbers not matching the description
More like this
Returning stock incorrectly allocated to inventory from Job Costing
Returning stock incorrectly allocated to inventory from Job Costing
More like this
Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only
Inventory Qty as At Report reports warehouse inwards incorrectly when In Transit is not used - 7.01.00 only
More like this