Rounding issue

diinsy
Member Posts: 1
Hello All,
The amount in the Tax entry and the details tax entry is not matching due to rounding issue. The Vat Rounding precision is set to 1.0 and the VAT rounding type is Nearest. The Invoice rounding precision is also set to 1.0 in the General ledger setup.
The Invoice rounding precision is set to 1.0 and Inv rounding type is Nearest in the General ledger setup , sales & receivable setup and the purchase and payable setup.
Please advice the needed correction required.
Best regards,
DIL
The amount in the Tax entry and the details tax entry is not matching due to rounding issue. The Vat Rounding precision is set to 1.0 and the VAT rounding type is Nearest. The Invoice rounding precision is also set to 1.0 in the General ledger setup.
The Invoice rounding precision is set to 1.0 and Inv rounding type is Nearest in the General ledger setup , sales & receivable setup and the purchase and payable setup.
Please advice the needed correction required.
Best regards,
DIL
0
Answers
-
precision setting 1.0 means rounding to integer values. that gives vague calculation results. better use prec. values like 0.01 or 0.001.
rounding type nearest means: decimal part >= 0.5 round up, otherwise down. depending on the concrete calc. formulas that can end in different amount results.best regards
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/1
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