Skip to main content
Solved

The rounding in the inventory behaves differently depending on the UoM.

  • November 16, 2021
  • 2 replies
  • 661 views

Dasuni Samarakoon
Hero (Employee)
Forum|alt.badge.img+10

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

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.    

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 4 replies
  • Answer
  • November 17, 2021

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.    


Dasuni Samarakoon
Hero (Employee)
Forum|alt.badge.img+10

Thanks @joanse 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings