Others

How to Exclude a Currency from Dynamics 365 Foreign Currency Revaluation

Nimra Malik Sep 29, 2026 868 views

Question details

The user needs to exclude a specific foreign currency from the foreign currency revaluation process in Dynamics 365 Finance.

How to Exclude a Currency from Dynamics 365 Foreign Currency Revaluation

Product: Dynamics 365 Finance
Device & OS: not provided
Scenario: Running the foreign currency revaluation batch job in Dynamics 365 Finance but needing to omit one or more specific currencies from the calculation.
Observed behavior: Without specific filters or exclusions configured, the system processes and revalues all active foreign currencies associated with the ledger accounts.

Before you start

Ensure you have the necessary Administrator or Financial Controller permissions in Dynamics 365 Finance to modify revaluation batch job parameters and access the General Ledger main accounts.

Solution 1Recommended

Use the Currency Filter in the Revaluation Parameters

Apply a direct exclusion filter for the specific currency when setting up the foreign currency revaluation job.

Dynamics 365 Finance allows users to filter the specific records included in a batch job. This is the most efficient way to exclude a currency without altering your master account settings.

Open the Revaluation Tool

Navigate to General Ledger or Cash and Bank Management, then select 'Foreign currency revaluation'.

Access Filter Settings

Before running the process, click on 'Records to include' or the 'Filter' button in the parameter dialog box.

Add Currency Criteria

Add a new row for the 'Currency' field. In the criteria column, use the exclusion operator (an exclamation mark '!') followed by the currency code you want to exclude (e.g., type '!EUR' to exclude Euros).

Apply and Run

Click 'OK' to save the filter criteria, verify your parameters, and proceed with running the revaluation job.

Use the Currency Filter in the Revaluation Parameters

Filter Validation: You can use this same filter method for both Bank foreign currency revaluation and General ledger foreign currency revaluation processes.

Solution 2

Exclude Specific Main Accounts from Revaluation

Turn off foreign currency revaluation on specific main accounts if currency filtering at the job level does not fit your workflow.

Free Microsoft Office alternative

Manage and Analyze Your Financial Reports with WPS Office

While Dynamics 365 Finance handles complex ERP tasks like currency revaluation, financial professionals rely heavily on office suites to analyze exported ledger data, audit reports, and share insights. WPS Office is a highly compatible, free alternative to Microsoft Office that easily handles complex financial spreadsheets.

1. Export Financial Data: Export your foreign currency revaluation journals or trial balance from Dynamics 365 to an Excel format.
2. Open with WPS Spreadsheet: Launch WPS Office and open your exported XLSX file to review the currency balances.
3. Analyze and Report: Use WPS Spreadsheet's built-in data analysis tools and pivot charts to create comprehensive financial reports.

Seamlessly open, edit, and analyze Excel (XLSX) files exported directly from Dynamics 365 Finance.High compatibility with all major Microsoft Office formats including XLSX, DOCX, and PPTX.Free, lightweight design ensures smooth processing of large financial data sets without lagging.Familiar spreadsheet interface makes utilizing VLOOKUPs and PivotTables for currency audits effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Can I exclude a currency from bank foreign currency revaluation but keep it for general ledger?

Yes, the Bank foreign currency revaluation process operates independently from the General Ledger process. You can apply specific currency exclusion filters directly within the Cash and Bank Management revaluation parameters without affecting the General Ledger.

What happens if I leave the currency filter blank in Dynamics 365?

If no filters are applied in the 'Records to include' section, Dynamics 365 Finance will by default process and revalue all active foreign currencies that have transactions in the selected accounts.

Why is my excluded currency still generating a revaluation voucher?

This typically occurs if the currency filter criteria were typed incorrectly (e.g., missing the '!' exclusion operator), or if the voucher was generated from a previous batch job run before the filter was applied. Verify your filter syntax in the batch job history.

Office Quick Solutions