Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Gross value calculation problem

Member Posts: 169
edited 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?

Best regards
JTPro
Navision Application Version: 4.0SP1
Navision Database Version: 4.0

• Member Posts: 61
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.

I don't envy anybody who caught up his aim. I travel gladly.
• Member Posts: 169
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
Navision Application Version: 4.0SP1
Navision Database Version: 4.0
• Member Posts: 61
Does the invoice have a Invoice Discount?
I don't envy anybody who caught up his aim. I travel gladly.
• Member Posts: 169
No :-k

JTpro
Navision Application Version: 4.0SP1
Navision Database Version: 4.0
• Member Posts: 61
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".....
I don't envy anybody who caught up his aim. I travel gladly.
• Member Posts: 169
F9 shows also wrong gross value.

VAT: 22%

Field: Amount Including VAT

Best regards
JTpro
Navision Application Version: 4.0SP1
Navision Database Version: 4.0
• Member Posts: 61
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? :?:
I don't envy anybody who caught up his aim. I travel gladly.
• Member Posts: 169
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
Navision Application Version: 4.0SP1
Navision Database Version: 4.0