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

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 75,802 Super User 2024 Season 2 on at

Like (0)

Report

Qty To Invoice rounding Error

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. . .
Zafar LIT 60 on at

Like (0)

Report

Qty To Invoice rounding Error

@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.
Zafar LIT 60 on at

Like (0)

Report

Qty To Invoice rounding Error

@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.
Suggested answer

YUN ZHU 75,802 Super User 2024 Season 2 on at

Like (0)

Report

Qty To Invoice rounding Error

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
Suggested answer

Jun Wang 7,440 Super User 2024 Season 2 on at

Like (1)

Report

Qty To Invoice rounding Error

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.
gdrenteria 13,011 Most Valuable Professional on at

Like (0)

Report

Qty To Invoice rounding Error

Hi

Maybe this can help you a little,

D365 Business Central : Quantity Rounding Precision - That NAV Guy

Best regards

Gerardo