Options

Calculation of VAT % on Purchase Line

knmknm Member Posts: 170
Currently I'm trying to figure out how the "VAT %" on the Purchase Line table gets calculated, but having trouble understanding. And FYI, I'm running the NA version of NAV 2009 R2.

*************************
Right now I have the following line entries:
Item_No.____Quantity____Direct_Unit_Cost____Tax %____Tax Base Amount____Amount Including Tax
Item_A______8,000_______4.17_______________9.25_______33,360_____________36,445.80
Item_A______7,000_______4.17_______________9.25002____29,190_____________31,890.08

*Both of the lines uses the same Tax Detail, where the Tax % = 9.25.
*************************

What I don't understand is in the second line of the example.
Even though the Tax Detail is setup so that it uses the 9.25% as the Tax %, why does the Purchase Line table say that it's 9.25002?
Is NAV calculating the Tax in order to avoid rounding issues?

Please let me know.

Thank you.

Comments

  • Options
    quidammquidamm Member Posts: 12
    Yes, I'm seeing a very similar issue in our client's database on the Sales Order side. The DB is NAV4.03 while the client and server have had a technical upgrade to NAV2009R2 Classic.

    Item_No.____Quantity____Unit_Price_Excl._Tax____Tax %____Tax Base Amount____Amount Including Tax
    Item_A______20_______0.7436_______________19.9731_______14.87_____________17.84
    Item_A______20_______0.7436_______________20.04035______14.87_____________17.85

    Anybody wanna take a swing?
    The problem's usually between the chair and the keyboard!
Sign In or Register to comment.