You’re offline. This is a read only version of the page.
2,401
Is it possible to import customer and vendor balances into D365 FFO, with a different/custom exchange rate?
*This post is locked for comments
Just an FYI gents, the General Journal data management file includes the exchange rate, but does not include the document/invoice date.. So you have to use the General Journal file to ensure the exchange rate(s) are correct, and then use excel add-in, to update the document/invoice date(s) to ensure Aging is ok.
Thanks Andre
I'll give it a try
Hi James,
When you use the General Journal entity, like mentioned by Ludwig, you are also able to specify an exchange rate.
Thanks Sohail
My posting date is all 31/Aug, but the invoice date I'm using is different on each line.
I have two questions:
1. Do you know if it is possible to set a different exchange rate table on the these transactions?
2. Will the exchange rate derive based on the invoice date, or transaction date?
Possible for you to add exchange rate with previous date in AX? actually my first preference to resolve your issue from configuration, I don't want from you to customize data entity to full fill your requirement.
As you said you have date fields from previous systems, then the simple things is to create currency exchange rate with previous dates and then upload data..
highly recommend to verify this on any testing environment.
Thanks Sohail
But I'm taking on data for a customer, and they have invoices from their previous system on a different date/time, with an agreed exchange rate.
So i need to be able to control/input the exchange rate on the line.
There is field in both Line level Entity Currency, Just add currency D365FO will handle it self..
Hi Ludwig
When i use data management, i use the entity 'Customer invoice journal line'. This imports into the General Journal screen.
However - when i exported the template for 'Customer invoice journal line', it did not include the exchange rate field.
Once it is imported, i can open up the journal, and update the exchange rate(s), but there are over 1000 lines that i am working with, and dont want to do it one by one, manually.
The excel add-in also does not include the exchange rate field
Hi,
Can't you import those open balances in a GL journal? In those journals you should be able to modify the exchange rate as required.
Best regards,
Ludwig
Thanks Sohail - i have those files, and generated them using Data Management, but the exchange rate field is not on the file..
How do i add it ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (