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
- 310 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
Apply Vendor Ledger Entries in Different Currencies
Mehdi
Member Posts: 16
Hi everybody,
I'm facing a problem with vendor application (the same with customer application) in different currencies.
For each invoice entry in a foreign currency, my customer update the exchange rate in the document without updating the Currency exchange table. For payments, as they received on local currency, they post the entry without putting a currency.
In fact, in the Vendor Ledger entries and for the same Vendor, i can have entries in local and foreign currency.
When I wants to apply the invoice (with Foreign currency) with the payment (local currency), NAV ignore the Exchange rate of the invoice and takes the default one from Exchange rate table which cause the generation of exchange losses/gains.
But when you take the two entries before the application, they've got the same LCY Amount!
I know that this is the way it works, but facing this problem, is there a local functionality tool or something else that can fix this way of application.
Thanks!
I'm facing a problem with vendor application (the same with customer application) in different currencies.
For each invoice entry in a foreign currency, my customer update the exchange rate in the document without updating the Currency exchange table. For payments, as they received on local currency, they post the entry without putting a currency.
In fact, in the Vendor Ledger entries and for the same Vendor, i can have entries in local and foreign currency.
When I wants to apply the invoice (with Foreign currency) with the payment (local currency), NAV ignore the Exchange rate of the invoice and takes the default one from Exchange rate table which cause the generation of exchange losses/gains.
But when you take the two entries before the application, they've got the same LCY Amount!
I know that this is the way it works, but facing this problem, is there a local functionality tool or something else that can fix this way of application.
Thanks!
0
Comments
yes this is "standard" behaviour. Sadly. It makes sense in some way, since the application date is the determining the exchange rates for this transaction (application). However, I have implemented a feature called "Apply with the original currency factor" some time ago. For G/L Open Items, though. And in 2009R2. The principle can be applied to the customers and vendor ledger entries, and the current NAV Versions, too.
Core of the feature is that you mark the entries that you want to have handled this way (template flag in the customer/vendor or in the gen. jnl. batch, field in the gen. jnl. line, field in the ledger entries). In the application routine, you give this flag as additional parameter to ExchAmount(), and change the code accordingly.
As you can see in the pictures, this is part of an AddOn (Plexada OpenItems). The AddOn does not solve your problem, though, you would need to implement it for the customers/vendors yourself. If you need help implementing this function or if you want it implemented, please drop me a private message.
with best regards
Jens