Skip to main content
Dynamics 365 Community / Forums / Finance forum / Forex Revaluation hist...
Finance forum
Suggested answer

Forex Revaluation history report for Vendor, Customer, Ledger and Bank

editSubscribe (0) ShareShare
Posted on by 80
Hi Folks,
I have created an Idea if you guys think its really important for your customers as well, then please click on the below link and VOTE. or If you any other suggestions please do add your comments.
Below is the IDEA that is updated in Microsoft Idea:

Currently before posting we need to take the dump in an excel for General ledger main account or for Bank foreign currency revaluation, and a report extracted to excel during the Foreign currency revaluation process for vendor or customer, but this report gives the grouping of Currency and vendor/customer and not each for each open transaction specific. Also during simulation of Foreign currency revaluation process the report provides each open transaction specific but fails to provide the Voucher/Invoice number details. Suppose if user forgets to take the report dump or stores in a file location were the file gets deleted permanently, then this will be bigger concern during audit process.


After posting the Forex revaluation for Vendor, Customer, Bank or General ledger Main accounts, there is no way to trace back what transactions were considered or included to post the forex differences to Unrealized forex gain/loss or to the realized gain/loss account. This becomes a huge manual effort to identify the open invoice as on date and go to multiple reports or at sometime going to back end table to identify the REC ID's to join all these data to cross check the forex revaluation entries affected to Accounting currency and Reporting currency. At certain point it is even more complicated to trace if the open transactions are not settled and settled at later stages or if there are multiple partial payments to a Invoice etc. This will be a tedious process to reconcile.


So please provide a report where It shows data such as against which Invoice/Voucher number, what are all the Transactions that were settled against it as on date range, where it must show the opening balance, transactions within the date range and if there any future settlements exists. The report must include the columns such as Vendor/Customer/Bank/Main account ID Voucher/Invoice number, Date, Transaction currency, Accounting currency and Reporting currency, Exchange rate applied during the posting of Invoice and Exchange rate applied for Foreign currency revaluation process. and against these same information what are the settled transaction details with similar column structure data.

  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li on at
    Forex Revaluation history report for Vendor, Customer, Ledger and Bank
    The link you provided is not working, please provide a new one. 

    Best Regards,
    Dengliang Li

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans