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.
https://jiwa.atlassian.net/browse/DEV-5695
SQL skills are required
This task requires sound SQL skills to implement