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

Page:

Part numbers changing on sales orders, quotes, purchase orders, shipments and bookins
Page:

Changing the status of a purchase order to Closed when all lines are received/booked in
Page:

GST for local creditors using a foreign currency
Page:

The quantity order on a purchase order is rounding up from 4 decimals to a whole number
Page:

Adding details to the Notes tab on Sent and Closed purchase orders

Problem

Solution

SQL skills are required

Related articles