Solved

Unit of measures with decimals

  • 12 March 2021
  • 2 replies
  • 849 views

Userlevel 6
Badge +11

Hi,

 

In our warehouse, the amount in stock is of a part is a number with decimals. The UoM of this part is PCS, which is defined as an integer.

The decimals are caused by an invertion factor on the sales. The client order a volume, but we fill this volume with pieces. The client can order a non-rounded number, e.g. 2.4L, which then converts to 13.4 PCS (for example).

 

However, we never ‘cut’ the pieces. In this case, we will supply 13 pieces. Or 14, that actually doesn’t matter that much. But how can we avoid that IFS displays the not-rounded number?

 

Thank you!

icon

Best answer by jabous 12 March 2021, 21:33

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +15

 

On the Supplier for Purchase Part Record and the Inventory Part Record there is a field ‘Qty Calc Rounding’.  The default value is 16.  If you only want whole numbers, set it to 1 and see if this is what you are looking for,. 

 

Qty Calc Rounding:
The decimal rounding precision of calculated purchase quantities. This applies to avoid receiving unnecessary decimal quantities when having a purchased inventory part with a conversion factor between purchase UoM and inventory UoM. For non-inventory parts the stated rounding will affect the number of decimals applied to the arrived purchase quantity when processing the receipt. The value of this field ranges between 0 and 20. The default value for this field is 16 and is set for both inventory parts and non-inventory parts. The decimal rounding precision is also used when calculating the quantity to inspect and using a sample inspection percentage.
 

Userlevel 6
Badge +11

Thanks! How can we do the same for a manufactured part?

 

Changing the lot size can bring a lot of decimals, how can avoid this so the amount to be reserved is always limited to 2 decimals for example?