Gross value calculation problem

JTPro · 2006-06-19

Hello all,

I have a strange problem with calculation of the gross value onto invoice form. I have three sales lines with the same unit price and number of quantities. The result should be, that all gross values are the same. Unfortunately, the gross value for the second line is different (0,01 greater).
This happens only for the second line. :-k

Is something wrong with Navision?

Thanks in advance for your answers.

Best regards
JTPro

Balello · 2006-06-19

It should be rounding. Probably the system find a value for the invoice that rounded gives one cent more. i don't know the rule it uses, but it's not an error.

JTPro · 2006-06-19

The strange thing is that for the same unit price and quantity, located in the third line, the gross value is proper. The wrong rounded occurs only in the second line. ](*,)

:-k

Best regards
JTpro

Balello · 2006-06-19

Does the invoice have a Invoice Discount?

JTPro · 2006-06-19

No :-k

JTpro

Balello · 2006-06-19

Try to verify the document statistics (on Invoice form press F9). Moreover, what VAT for the two lines? And what's different: "amount" or "line amount".....

JTPro · 2006-06-19

F9 shows also wrong gross value.

VAT: 22%

Field: Amount Including VAT

Best regards
JTpro

Balello · 2006-06-19

So you mean line amount is the same.... I think that means that the system evaluated a residual rounding of 1 cent on the VAT of the invoice, and due to the way it calculates it, that value was linked to the second line of the document.... But VAT is a document value, not single line value... or I'm wrong? :?:

JTPro · 2006-06-19

Hello,

I think you are right.
I noticed that Navision calculates VAT amount, after adding all line amounts, not saparately, for each line. It puts the rounding into second line.

I think this is the way the Navision does VAT calculation.

Best regards
JTpro

Gross value calculation problem

Comments

Categories