Rounding on purchase orders
Rounding on Orders
The purchasing system works in two ways when rounding the quantity to reorder to match minimum order quantities:-
- The purchasing system round quantities to order up to minimum reorder quantity if the quantity required is less than the minimum reorder quantity. So if you need 6 and the minimum reorder quantity is 10 the system will buy 10.
- If you need more than the minimum reorder quantity the system rounds down after the first multiple of the minimum order unit. So if you need 56 and the minimum reorder unit is 10 the system will order 50.
The system can't tell if a quantity to reorder comes from back orders or min/max. It always uses the same rounding rules.
The above behaviour was built into Readysell quite a long time ago, in response to requests from customers to keep stock holdings down.
I suggest an option for you to make the quantity to reorder always round up to the next largest minimum order quantity might suit your requirements. The system would order more stock but would tend to always have enough for all back orders.
Minimum Order Quantity
Quantity Calculated
Quantity Required Rounded
Qty Ordered Comment
BEFORE
10
1
10
Round up the first multiple of the minimum order quantity
10
11
10
Round down if quantity ordered is larger than one minimum order quantity
10
22
20
Round down if quantity ordered is larger than one minimum order quantity
NOW
10
1
10
Always round up the to the next multiple of the minimum order quantity
10
11
15
Always round up the to the next multiple of the minimum order quantity
10
22
25
Always round up the to the next multiple of the minimum order quantity
30/07/2012
1. New Feature.Normally automated purchasing rounds the quantity purchased up to the minimum order quantity if the quantity orders is less than the minimum. If the quantity ordered is more than the minimum order quantity the system rounds the quantity down to the nearest multiple of the minimum order quantity. A new system reference allows the system to always round up to the next largest multiple of the minimum order quantity. To enable this feature set system reference:-Type 'PURCHASE',Code 'ROUND-UP-REORDER-QTY',Value 1 to turn on this feature.