Additional Currency Posting in NAV 4.0 SP3
tinik
Member Posts: 22
Hi all!
Can anyone help? Presently my base currency is USD and my additional currency is SGD... Whenever I post Purchase Invoices to specific G/L accounts for tax purposes, the posted G/L entries are off by usually .02 cents but the total amount is correct. So its usually .01 more in one entry and .01 less in another. So i changed the decimal places of the exchange rate for SGD and still gets off by several cents. As i understand the system converts the SGD entries into the base currency but rounds it, and then converts it back to the additional currency but gives a different outcome to the document entry. Can anyone pls suggest how to come about a proper setting? Thanks
Best regards,
Tinik
Can anyone help? Presently my base currency is USD and my additional currency is SGD... Whenever I post Purchase Invoices to specific G/L accounts for tax purposes, the posted G/L entries are off by usually .02 cents but the total amount is correct. So its usually .01 more in one entry and .01 less in another. So i changed the decimal places of the exchange rate for SGD and still gets off by several cents. As i understand the system converts the SGD entries into the base currency but rounds it, and then converts it back to the additional currency but gives a different outcome to the document entry. Can anyone pls suggest how to come about a proper setting? Thanks
Best regards,
Tinik
0
Comments
-
I believe there is a report that you need to run to fix the additional currency in gl entry.
There is setup in GL setup field VAT Exchange Rate Adjustment
and then you need to run 595 Adjust Exchange Rates0
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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 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
