Step-by-step guide to Accounts Receivable foreign currency revaluation in D365 F&O

Accurate management of foreign currency balances is essential for organizations working across multiple currencies. Fluctuating exchange rates can affect customer balances, revenue recognition, and overall financial reporting. Ensuring that foreign currency assets and liabilities are accurately valued at period-end is a crucial aspect of maintaining compliance and financial accuracy.

Dynamics 365 Finance & Operations streamlines this process through its foreign currency revaluation functionality for Accounts Receivable (AR). By automating calculations, posting the required foreign currency revaluation accounting entries, and ensuring clear audit trails, D365 reduces manual work and mitigates currency-related risks.

Building on the concepts covered in our earlier discussion on Accounts Payable (AP) revaluation, this second blog in our series focuses on how Accounts Receivable foreign currency revaluation works in Dynamics 365 F&O – covering execution, posting logic, and reviewing the impact on customer accounts.

Steps to perform AR foreign currency revaluation in Dynamics 365 F&O

The foreign currency revaluation in D365FO process for Accounts Receivable follows a similar approach to Accounts Payable. The system revalues all open-minded customer transactions using the specified exchange rate, posting foreign currency revaluation accounting entries to reflect unrealized gains or losses.

Step 1: Run AR foreign currency revaluation

  • Go to Accounts Receivable > Periodic Task > Foreign Currency Revaluation
  • Select Foreign Currency Revaluation from the options.
  • Give relevant details such as method, considered date, date of rate, use posting profile from, posting profile, dimension, description, notes, etc.
  • After entering all details, click on Ok. The FCR will be posted.

Take control of your business operations

Discover how Confiz services can simplify your complex workflows and improve decision-making.

Step 2: Review the revaluation voucher

    • Select the relevant FCR transaction and click on Voucher to Vouchers.
    • Then, click on Voucher to open and review the posted entries.

Step 3: Understand the posted entries

At this stage, the system records unrealized gains or losses automatically:
    •  If there is Unrealized Gain, it will post the following transaction
Description DR CR
Trade Receivables a/c xxx
Unrealized Gain/Loss a/c xxx
If there is an Unrealized Loss, it will post the following transaction:
Description DR CR
Trade Receivables a/c xxx
Unrealized Gain/Loss a/c  xxx
Below is an image of actual vouchers posted at the foreign currency revaluation of trade receivable:

Accelerate growth at an unprecedented pace

Discover how Confiz can help you take control of your daily operations, increasing growth and revenue.

Step 4: View the impact on customer balances

    • Go to Accounts Receivable > All Customers > Select the Relevant Customer.
    • Click on Transactions to view how the foreign currency revaluation has affected the customer balance.
  •  Here are the FCR transactions that affected the customer.

Conclusion

Accurate foreign currency revaluation in Accounts Receivable is crucial for organizations that operate across multiple currencies. By automating the process, Dynamics 365 Finance & Operations ensures customer balances reflect current exchange rates, reduces manual effort, and maintains compliance with accounting standards. Through its robust functionality, foreign currency revaluation in D365FO delivers consistent reporting, precise foreign currency revaluation accounting entries, and full transparency for audit purposes. This enables finance teams to close periods with confidence and maintain accurate financial statements across all entities. Get started today. Contact us at marketing@confiz.com to discover how we can assist with your foreign currency revaluation journey.

About the author

Muhammad Ammar Ali

Ammar is a Microsoft Dynamics 365 Functional Consultant with a focus on Finance and Manufacturing. He brings hands-on experience in...
Ammar is a Microsoft Dynamics 365 Functional Consultant with a focus on Finance and Manufacturing. He brings hands-on experience in streamlining business processes, driving ERP implementations, and delivering solutions that add measurable value. His expertise lies in aligning system capabilities with operational needs to improve overall business performance.

New to implementation
guide?

Start here to understand how it’s reshaping the future of intelligent systems.

Subscribe

Get exclusive insights, curated resources and expert guidance.

Fill in the details.
We’ll get in touch.