Skip to main content

Pre requisite: Set “Qty Calc Rounding” for part as “0”.

Assume the Number = 150.00000000000012

 

When an inventory part has the UoM as Weight (kg), Volume (l), or Length (m), the rounding of the “Qty Required” for Shop Orders work as follows;

ROUND(150.00000000000012, 0+ 2) = 150

 

However, when the UoM is set as “EA” (Each), with a Base unit “pcs”, the function behaves as follows;

TRUNC(150.00000000000012, 0) + POWER(10, 0 * -1) = 151

 

If the “Qty Calc Rounding” for part is “2”. The value for UoM EA is 151.01.

 

It seems when the UoM is EA the quantity is always rounded up regardless of the number.

The general rule of thumb is that demands will always be rounded up and supplies will always be rounded down. Then there is an exception done for units of measure where the base unit is Weight, Volume or Length. For these you would typically have to measure the quantity in some way when issuing parts from stock. The assumption for these is that when there is a difference that is probably beyond measuring capabilities then it can be safely ignored. Probably you do not have a scale accurate enough to tell the difference between 1 kg and 1.00000002 kg anyway if you have specified the decimal precision on the inventory part as 1 decimal.    

Thanks @joanse 

Terms & ConditionsCookie settings