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
0
Comments
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.
Senior Consultan
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.
Raja
if you wanna print Tax%, then use Tax details table, This is
what Microsoft has suggested. I am not comfortable with
this idea.
Senior Consultan