Problem With Tax % Percentage Calculation

ilayarajav
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.
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
Raja
0
Comments
-
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 Consultan0 -
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,
Raja0 -
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 Consultan0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions