Announcements
I am aware that D365 can handle foreign currency revaluation/differences and that any ledger postings are normally posted to the main accounts you select on the 'ledger' setup in the general ledger parameters. Do you know if it's possible, as standard, to route different types of currency revaluation to different main accounts? So, for example if you wanted exchange differences on vendor invoices to post somewhere different to exchange differences on customer sales invoices; or say, standard cost differences just due to currency change as opposed to 'normal' purchase price variance etc... Many thanks.
Thank you Ludwig, this was what I wanted to confirm.
Hi MarkDS,
You can define different accounts for different curriencies but not by transaction type.
This would require a system modification.
Best regards,
Ludwig
Hi MarkDS
D365FO use the foreign currency main account setup on ledger or alternative you can set up foreign currency revaluation for each or part of specific currencies.
On the customer and vendor side D365FO revalue open transactions typically invoices. The revaluation don’t consider if open vendor invoices relates to a purchase order or an expense. The revaluation look at either the currency rates (accounting and reporting) used when the open transaction was posted or last revaluated and adjust amount and amount in reporting currency the the currency rates for accounting and reporting currency the date of rate you select when you revalue
Kind regards
Sten Baumgarten
Thank you Sten. I'm still wondering whether there is a system parameter anywhere where you can define different main accounts for different types of currency revaluation e.g. Main account 1000 for currency impact on vendor invoices/Purchase Orders and say main account 2000 for customer sales invoices, for example?
Customer and vendor foreign currency adjustment adjust every open transactions on the customer or vendor.
From a vendor payment prespective it complicates things if you need to split the open vendor account into the different pieces you want to track. Beside splitting you need different financial dimension values to seperate the different types of foreign currency revaluation for each purchase invoice. I you continue that way remenber to select Dimension > Posting to include the financial dimension values on each foreign currency transactions
Thanks Rahul - In general are you saying that specifying the posting by source is not standard i.e. OOB (out of the box)? Also, please can you clarify/expand what you mean by the controlled account being 'enabled for FS evaluation' and what this might achieve?
it should not matter o9n the source, as long the controlled account is enabled for FS evaluation it should be factored in.
The FX realized and unrealized are at ledger level so specifying based on source is not OOB
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156