Consistency and Rounding

eYe

Hi,

On Sales Invoices, working with fractions of fractions on the lines, certain lines of the invoice are rounded up ending up with a value of a couple of cents more than expected. Ok we are sitting with a heavily bastardized system I don't expect a resolution of the rounding issue.

I changed the GLSetup."Amount Rounding Precision", I set it to 0.001 with a codeunit in a test environment, just to see what the impact would be on the posting.

Now, after posting my GL Entries looks like this:
Entry No. Amount
34369 -14,020.01
34370 15,702.40
34371 -15,702.40
34372 -1,051.50
34373 1,051.50
34374 -1,682.40
34375 15,702.40

With consistency check in place, how is this posting even possible as it is out of balance by 0.01??

ara3n

Create Sales invoice in std non bastardized NAV db and post it. See how it works and then make the necessary changes in your system.

jannestig

What have you got 'amount decimal places' and unit amount decimal places set to ?

eYe

Ahh Thanks!!

Amount Decimal Places is 2:2 and
Unit Amount Decimal Places is 2:5

But this means I'll have to use a dataport to see the actual figures of the entries and no longer just copy and paste.
The actual values are as follows:
-14,020.008
15,702.400
-15,702.400
-1,051.496
1,051.504
-1,682.400
15,702.400

Now to find a fix for this rounding. Cause when I try to do the rounding only at the last calculation - I manage to get the dreaded Inconsistency Error.

@ara3n, I wish it was as simple as that. We are running an routine that generates invoices/cr.memos from a seperate table (where the field/record size limit has been reached) that holds numerous calculated values. There is even a table to setup how some of these values should be calculated.
In short it's an issue of having rounding on rounding from the point of calc on source table to generating invoice to posting the invoice.

Thanks for your help guys!