Rounding Precision HELP

alantviti

I have a dillema on Sales Line:

Quantitiy (5) * Unit Price (3,30) * Discount (15%) = Line Amount (14,02)

In real Math that equals out ot be 14,025 precisely. On my G/L Setup I have the following setup:

Invoice Rounding type (Nearest).
Unit Amount Decimal Places (2:5)
Unit Amount Rounding Precision (0,00001)
Amount Rounding Precision (0,01)

When I increase the Unit price in on the sales line to 3,3009, the Line Amount is still 14,02, even though in the real math it calculates to be 14,028825, and that is not NEAREST rounding.

When I increase the Unit Price to 3,301, the Line Amount is then rounded to 14,03. The real math calculates it to 14,02925.

ANYBODY???

GoMaD

Do you have this problem on an existing form?
Or on a newly created object (form/report/...)

pdj

Because of this line in tab 37 (UpdateAmounts):

"Line Amount" := ROUND(Quantity * "Unit Price",Currency."Amount Rounding Precision") - "Line Discount Amount";

The rounding is done before subtracting any line discount. It can be argued what the "right" way is, but I actually find it to be ok. Using this method is the discount based on the price others would have paid, which must be the hole idea about giving discounts :-)

Sandra

Hi!

First of all ... I love your quote - in real math! That is really fantastic!
But now down to your question. Actually your problem is the 15 % discount. They are rounded with precision 0.01. When you calculate without the 15 % you receive 16.50 .. . Then the discount is given. Not rounding it with precision 0.01 gives you an amount of 2.475. Rounding it 2.48. Subtracted form 16.50 is 14.02 which is absolutly ok.

Amount Rounding Precision (0,01) this will be the one reponsibel for rounding the discount. Actually a calculater put on 2 decimals will give you the same result.

I believe your problem is no problem. Its accounting! We will have to live with it.

Best regards
Sandra

alantviti

Thanx Sandra.

Do you think if I change Amount Rounding Precision to 0,001 (through designer because I can't change it regular way because there are posted entries), there would be some major consequences???

What do you suggest?

The thing is I have a client with the following sales lines:

Quantity(5), Unit price (3,30), Discount (15%)
Quantiti(10), Unit price (3,30), Discount (15%)

For the first line on their report it shows the Unit Price after discount to be 2,80, but for the second one it shows 2,81.

Unit price after discount = Amount after discount /Quantity

I wrote all this so you know where my problem is originating from.

Thank you for your help.

Sandra

Hi Alantviti,

you will continue to have the Problem at some point or other in time. Of course the finer the rounding precision is the more chances you have to hit the correct one. I am not quite sure if I would change the rounding precision because the calculation that is done is correct. You are taking another approche to it. Try it on a calculator that is used by bookkeepers - you know the one with the paper in it. You can change the rounding precisions there and you can test it. I think I would prefer to work with what the standard of Navision puts in - The programm is tested by major consulting companys and accepted. I believe I would keep it the way it is. As I said before - you will have the problem some other time if you change the rounding to 0.001.

I hate the rounding business - We had so many problems when we change to the € with the rounding. We had to change the unit price rounding to 0.00001.

Sorry there is not much I can suggest otherwise. Hope you do get your customer satisfied.

Best regards
Sandra