Vendor currency revaluation simulation report (VendExchRateAdjSimulation) [AX 2012]

Updated: July 13, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Use this report to view the predicted effect of revaluing foreign currency amounts. In the simulation, you can select values for the same parameters that are available for the revaluation process: Method, Considered date, and Date of rate.

The report lists the open vendor balances on the considered date in the vendor currency and the accounting currency. It also indicates the open balance that would result if currency amounts are revalued according to the entered criteria. The exchange rates that are used in the simulation are listed.

The vendor balances are summed for each foreign currency. This displays the effect of the revaluation on the value of unrealized accounts payable.

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.




Select the method to use for the revaluation simulation:

  • Standard – Adjustments for the foreign currency revaluation are posted regardless of whether the result is a profit or a loss.

  • Minimum – Adjustments for the foreign currency revaluation are posted only if the result is a loss.

  • Invoice date – Adjustments for the foreign currency revaluation use the original exchange rate of the transactions, which are revalued to their original value in the accounting currency. The effect of any prior revaluation is canceled.

Considered date

Select the date when Microsoft Dynamics AX finds all transactions that have open (not settled) amounts on that date. Foreign currency revaluations are made by using the exchange rates that are entered in the Currency exchange rates form for the considered date.


The foreign currency revaluation simulation does not create any adjustment transactions.

Date of rate

Select the date that determines the exchange rate that is used in the foreign currency revaluation simulation. If this field is blank, the exchange rate that applies to the date in the Considered date field is used in the revaluation.

The following topics explain how to print a report and how to filter and sort the data on a report.

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.



Name of report in the AOT


Location of report in the AOT

SSRS Reports\Reports\VendExchRateAdjSimulation

Menu item of the report


Navigation to the report

Click Accounts payable > Periodic > Foreign currency revaluation. Click Simulation.

The data on this report comes from the following sources:

  • VendExchRateAdjSimulationTmp table


To determine where the data in the temp tables comes from, view the cross-references for the VendExchRateAdjSimulationDP.processReport class.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).