Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Adjust Exchange Rate - Questions
nverma
Member Posts: 396
1) Does Adjust Exchange Rate (AER) only adjusts open transactions? Or does it work on closed entries.
I did some research and I got mixed answers: The batch job processes all open customer ledger entries and vendor ledger entries. (https://msdn.microsoft.com/en-us/library/hh167262(v=nav.70).aspx)
I also found a knowledge base article which stated the following: When you run the Adjust Exchange Rates batch job in Microsoft Dynamics NAV, the Adjust Exchange Rates process revalues the posted entries that are beyond the specified date range of the batch job. These posted entries may also be closed.
(https://support.microsoft.com/en-ca/kb/942614).
Which is correct?
What I realized is that, most of the closed transactions, contains an incorrect Amount (LCY) and Original Amount (LCY) value. However, all the open transactions, contain the correct figures. Does it have anything to do with "Allow Posting To" and "Allow Posting From" date in G/L Setup? or User Setup.
From what I understood thus far, in the following situation, this will happen:
Invoice --> 01/01/16
Payment --> 04/01/16
If I run the AER with the ending date of 01/30/16, system will create unrealized gain/loss entries. When I apply/process the payment, system will reverse the unrealized gain/loss entries and calculate realized gain/loss on the payment transaction. Correct?
2) Why is that only some closed transactions contain the correct Amount (LCY), while for some we have to look at the detailed ledger and look for additional unrealized gain/loss entries? Why doesn't it updated in the Customer Ledger Entry's Amount (LCY) field in the first place?
I did some research and I got mixed answers: The batch job processes all open customer ledger entries and vendor ledger entries. (https://msdn.microsoft.com/en-us/library/hh167262(v=nav.70).aspx)
I also found a knowledge base article which stated the following: When you run the Adjust Exchange Rates batch job in Microsoft Dynamics NAV, the Adjust Exchange Rates process revalues the posted entries that are beyond the specified date range of the batch job. These posted entries may also be closed.
(https://support.microsoft.com/en-ca/kb/942614).
Which is correct?
What I realized is that, most of the closed transactions, contains an incorrect Amount (LCY) and Original Amount (LCY) value. However, all the open transactions, contain the correct figures. Does it have anything to do with "Allow Posting To" and "Allow Posting From" date in G/L Setup? or User Setup.
From what I understood thus far, in the following situation, this will happen:
Invoice --> 01/01/16
Payment --> 04/01/16
If I run the AER with the ending date of 01/30/16, system will create unrealized gain/loss entries. When I apply/process the payment, system will reverse the unrealized gain/loss entries and calculate realized gain/loss on the payment transaction. Correct?
2) Why is that only some closed transactions contain the correct Amount (LCY), while for some we have to look at the detailed ledger and look for additional unrealized gain/loss entries? Why doesn't it updated in the Customer Ledger Entry's Amount (LCY) field in the first place?
0