Item Consumption Quantity Decimals are rounded on Production Order

When creating a production order in Dynamics NAV, line item components are automatically derived from the bill of material, on which the standard quantities are provided.

I have been working on a case in which the consumption quantities are being rounded automatically when creating a production order, for instance, if one of the line components is 1.2 the consumption quantity on the production order is rounded into 2

It would quickly come to mind that the scrap % is the root cause, which could be defined either on the item card level or the production order level. Although, in this specific case, the scrap % is set to zero on all setup levels.

Production Order Components – Quantity

Production Journal – Consumption Quantity

Resolution

The reason for such system behavior is related to a field called “Rounding Precision” on the item card, which by default is set to 1. If you check the MSDN for further information, you will find the following:

Item Card – Rounding Precision

” Defines how calculated consumption quantities are rounded when entered on consumption journal lines. Quantities less than 0.5 will be rounded down. Quantities equal to or greater than 0.5 will be rounded up.

You can set the field to round to the nearest decimal (maximum 6 decimal places) or to the nearest number divisible by any whole or decimal number.

• 0.01 Round to two decimals
• 0.05 Round to a number divisible by 0.05
• 1.00 Round to a whole number (no decimals – divisible by 1.00)
• 10.00 Round to a whole number (no decimals – divisible by 10.00)

“  Reference: MSDN – Rounding Precision Field, Item Table

So basically, you need to setup the rounding precision as 0.001 for instance, and everything will be working as expected.

Production Order Components – Quantity

Best Regards,
Mahmoud M. AlSaadi