/
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
Problem
Where the Supply tab of an inventory item has a value in the field Order units that is greater than 1, creating purchase orders using the Replenish Re-Order method incorrectly orders the order unit quantity when stock is not required.
Solution
The issue is logged on DEV-5695 and a fix has been provided. Run the attached SQL script to correct the underlying stored procedure.
DEV-5695: Where Supply Order Units > 1 stock is being over-orderedPassed Testing
SQL skills are required
This task requires sound SQL skills to implement
Related articles
, multiple selections available,
Related content
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
More like this
Returning stock incorrectly allocated to inventory from Job Costing
Returning stock incorrectly allocated to inventory from Job Costing
More like this
POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'
POINF022 - Replenish ReOrder report ignored the criteria selection for 'BOM Parents?'
More like this
The quantity order on a purchase order is rounding up from 4 decimals to a whole number
The quantity order on a purchase order is rounding up from 4 decimals to a whole number
More like this
Re-order reports sometimes give an error 'Failed to retrieve data from the database' when running
Re-order reports sometimes give an error 'Failed to retrieve data from the database' when running
More like this
Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00
Deleting warehouse back orders did not update the IN_OnBackOrder table - 7.02.00
More like this