Customer foreign currency revaluation simulation report (CustExchRateAdjSimulation)


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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 that to view the predicted effect of revaluing the amounts of transactions that use currencies other than the accounting currency. In the simulation, you can select values for the same parameters that are available for the revaluation: Method, Considered date, and Date of rate. For information about these fields, see Customer foreign currency revaluation (form).

The report lists the open customer balances on the considered date in the customer currency and the accounting currency. The report also lists the open balance that would result if a foreign currency revaluation is run according to the criteria that is entered. The exchange rates that are used in the simulation are also listed.

The report displays the total of the customer balances for each foreign currency. The balances show the effect of the revaluation of the value of unrealized accounts receivable.

How to work with reports

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

Details of this 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\CustExchRateAdjSimulation

Menu item of the report


Navigation to the report

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

Where the data in this report comes from

The data on this report comes from the following sources:

  • CustExchRateAdjSimulationTmp table

  • DimensionAttributeValueCombination table

  • VendExchRateAdjustmentTmp table


To determine where the data in the temp tables comes from, view the cross-references for the CustExchRateAdjSimulationDP.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).

See also

About foreign currency revaluations for open customer transactions