Small and medium business | Business Central, N...

Qty To Invoice rounding Error

(1) Share

Report

Posted on by Zafar LIT

Hi All,

Hope someone can point me to the right direction i solving this. I have a sales order where I have an Item. This Item has a base unit of measurement in meters and then an additional unit of measure in Rolls. (1 Roll = 15.24M)

Now there is a line that has 0.73754 ROLL as Qty,

Qty.	UoM	Qty Shipped	Qty INvoiced	Qty to Invoice	Shipped Not Invoiced
0.73754	ROLL	0.73754	0.73753	0.00001	0.05

This is a clear rounding issue to the base unit of measure. How do I solve this? Right we cannot post the order to get archived or delete it, because there is still 0.00001 to post. However, the Shipped not invoiced qty is 0.05. I am guessing 0.000005 is what is would accept, but that is 6 decimals which is not allowed.

Anybody have a solution on how we can make de sales order disappear? Or ideally still post it to get archived?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Gerardo Rentería Ga... 25,977 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Maybe this can help you a little,

D365 Business Central : Quantity Rounding Precision - That NAV Guy

Best regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,210 Moderator on at

Like (1)

Report
Copy link

Link copied!

check your inventory if any rounding remaining for this sales line. If yes, you need to adjust it off using item journal.

you could manually archive this order and delete it from the sales order page since BC won't auto delete it for you.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,611 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, is this value imported from outside? Or was it copied?

I just tested it and this problem did not occur.

More details:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Zafar LIT 74 on at

Like (0)

Report
Copy link

Link copied!

@YunZhu

No this was not copied or imported. Just typed in. The system wants me to post 0.000005 to be exact. This however is not possible.

@appliwin123
The order cannot be deleted because there is a quantity shipped that has not yet been invoiced.

@gdrenteria
I am aware of the possibility to change the rounding precision to 1. However, this cannot be set for a item that has open entries I believe or when it is present on sales or purchase documents.

Was this reply helpful? Yes No
Zafar LIT 74 on at

Like (0)

Report
Copy link

Link copied!

@Yun Zhu

The Quantity per unit for 1 Roll is set to 15.24 meters. Additionally, there was no rounding precision set, meaning the rounding precision is zero. Even still I do believe that when trying to replicate the issue, you would not necessarily be able replicate it. It seems like it is a deadlock. I am still looking for a elegant solution. These items were already there for this customer when they implemented Nav 2016. At that time there was no rounding precision feature. This is why these items do not have the rounding precision set.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,611 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Emmm . . .Very strange issue. If you can replicate this problem in a standard environment, you can submit an SR to the Microsoft support team and let them help investigate the cause....If it is not a standard environment, they first suspect that it is a customization problem. . .

Was this reply helpful? Yes No