Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Change additional reporting currency
aholmes
Member Posts: 2
I need to test changing the additional reporting currency from THB to PHP in one of our companies. The company has been active since 7/2006. We are currently on NAV5.0, SP1
I confirmed I have exchange rates for PHP starting on 4/30/12. The table contains monthly rates through 1/31/14.
I changed the rate on GL Set-up and noted the update occurring. After the routine was completed, I extracted the General Ledger entries to excel for one account. I wanted to calculate the exchange rate for various posting dates and confirm the rate matches what was defined in the table. I noted the exchange rate for all of the entries was the last rate defined on the table, 45.3688 (1/31/14).
I was thinking the routine would check the posting dates of the transactions against the exchange rate table and recalcuate based on the defined rate for the posting date range. Is this not the case?
Also, are there any other steps to perform to change the additional reporting currency.
Thank you!
I confirmed I have exchange rates for PHP starting on 4/30/12. The table contains monthly rates through 1/31/14.
I changed the rate on GL Set-up and noted the update occurring. After the routine was completed, I extracted the General Ledger entries to excel for one account. I wanted to calculate the exchange rate for various posting dates and confirm the rate matches what was defined in the table. I noted the exchange rate for all of the entries was the last rate defined on the table, 45.3688 (1/31/14).
I was thinking the routine would check the posting dates of the transactions against the exchange rate table and recalcuate based on the defined rate for the posting date range. Is this not the case?
Also, are there any other steps to perform to change the additional reporting currency.
Thank you!
0