Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Main Accounts Used for...
Finance forum
Answered

Main Accounts Used for Currency Revaluation

Posted on by 60

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.

  • MarkDS Profile Picture
    MarkDS 60 on at
    RE: Main Accounts Used for Currency Revaluation

    Thank you Ludwig, this was what I wanted to confirm.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Main Accounts Used for Currency Revaluation

    Hi MarkDS,

    You can define different accounts for different curriencies but not by transaction type.

    This would require a system modification.

    Best regards,

    Ludwig

  • Suggested answer
    Sten Baumgarten Profile Picture
    Sten Baumgarten 10 on at
    RE: Main Accounts Used for Currency Revaluation

    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

  • MarkDS Profile Picture
    MarkDS 60 on at
    RE: Main Accounts Used for Currency Revaluation

    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?

  • Suggested answer
    Sten Baumgarten Profile Picture
    Sten Baumgarten 10 on at
    RE: Main Accounts Used for Currency Revaluation

    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 

    2806.4.jpg

  • MarkDS Profile Picture
    MarkDS 60 on at
    RE: Main Accounts Used for Currency Revaluation

    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?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Main Accounts Used for Currency Revaluation

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans