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.
Best answer by joanse
View original