Rounding Issue upon apply to payment / cash receipt Journal
julkifli33
Member Posts: 1,100
Hi All,
I have one question about rounding issue
I applied my payment journal from vendor ledger entries in both Foreign Currency (different exchange rate)
both are fully applied to my payment journal
in NAV, the amount is the same
Even though it's fully applied, and the remaining amount is 0
but it still remain open (Vendor Ledger Entry)
if i check from backend because there is a 0.0001 difference
for example in NAV :Invoice is 100, Payment 100
but check from SQL : Invoice is 100 and payment is 100.00001
any idea how to solve this problem?
I have one question about rounding issue
I applied my payment journal from vendor ledger entries in both Foreign Currency (different exchange rate)
both are fully applied to my payment journal
in NAV, the amount is the same
Even though it's fully applied, and the remaining amount is 0
but it still remain open (Vendor Ledger Entry)
if i check from backend because there is a 0.0001 difference
for example in NAV :Invoice is 100, Payment 100
but check from SQL : Invoice is 100 and payment is 100.00001
any idea how to solve this problem?
0
Answers
-
Hi, check currencies Amount Rounding Precisions.Regards,
Yury0 -
Hi Yuri,
it's --> 0.000010
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
