VAT % incorrect

nverma

Hello,

On Sales Orders, when the user enters a Sales Line of type Item, system ends up calculating the VAT % to 13.00875, which the system ends up rounding to 13.01. Therefore, when the user prints the invoice, it displays the tax % to be 13.01, which is not correct since the tax % should be 13%.

It happens randomly, out of 10 lines, maybe one or two will have this problem and it happens completely randomly.

Another strange thing I noticed is that, the second line calculates the Tax % incorrectly:
Line 1 --> Item (zzz), Quantity (1), Unit price is 68.03, Tax % 12.99427, Amount including Tax (76.87)
Line 2 --> Item (yyy), Quantity (1), Unit price is 68.03, Tax % 13.00897, Amount including Tax (76.88)
Line 3 --> Item (yyy), Quantity (1), Unit price is 68.03, Tax % 12.99427, Amount including Tax (76.87)

Line 2 and Line 3 has the exact same item, but the Tax % differs. Also, if I delete my Line 1, thus my Line 2 will be the first line and line 3 will be the 2nd line on the Sales Order, then the old line 3 will calculate the tax % and amount including tax incorrectly. The problem seems to be the second line.

Any idea why this might be happening.

We are on NAV 2009 R2 (6.00.33137)

nverma

I modified the 'Amount Rounding Precision' of CAD (on Currency table) from 0.01 to 0.001. This seems to have fixed the problem.

I am just not sure if this will have any drastic repercussions. Are there any drawbacks of doing this.