Vendor currency revaluation simulation report (VendExchRateAdjSimulation)

  • Article

Important

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 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.

How to filter the data on this report

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.

Field

Description

Method

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.

Note

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.

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.

Detail

Description

Name of report in the AOT

VendExchRateAdjSimulation

Location of report in the AOT

SSRS Reports\Reports\VendExchRateAdjSimulation

Menu item of the report

VendExchRateAdjSimulation

Navigation to the report

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

Where the data in this report comes from

The data on this report comes from the following sources:

  • VendExchRateAdjSimulationTmp table

Note

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).

See also

About foreign currency revaluations for open vendor transactions