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
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