Problem With Tax % Percentage Calculation

ilayarajavilayarajav Member Posts: 19
I am facing problem with Tax % calculation in Purchase order

For Example
In Purchase order: select any Vendor and any item
Enter Unit cost as : 22.05
Qty : 1,
in Tax Details table setup Tax% as 12.5 for the combination of Tax Area code with Tax Jurdication.

When i Calculate Structure Value, it shows correctly 12.5 in Tax % and corresponding amount in Tax amount field, but at the time of release that particulr p.o, tax percentage change into 12.52 and tax amount remain same.

I Found that at the time of Calculate Structure Value, Tax amount get round off to two digits. when relase the P.O, Tax % again calculated from rounded Tax amount with Base amount. This difference because of Rounding off Tax amount and back calculation at the time of release.

Can anyone give the suggestion to overcome this issue.
Regards,
Raja

Comments

  • darshanmdarshanm Member Posts: 280
    Namaste!

    I am also facing the same prolem. Even I posted this issue
    on Microsoft, But they says that Tax% field is for NAV internal
    purpose and not for user display. On posting NAV will post the correct entry in tax details table.

    As per Microsoft if we want to print tax%, then we should take
    it from tax details table.
    Darshan Mungekar
    Senior Consultan
  • ilayarajavilayarajav Member Posts: 19
    Thanks for your reply.

    Can U tell me, in what logic they are reverse calculating tax % from Tax amount.

    If suppose i need to print the report based on the tax % field from Purchase Invoice line table, then it will give wrong figure only.
    Regards,
    Raja
  • darshanmdarshanm Member Posts: 280
    Namaste!

    if you wanna print Tax%, then use Tax details table, This is
    what Microsoft has suggested. I am not comfortable with
    this idea.
    Darshan Mungekar
    Senior Consultan
Sign In or Register to comment.