Simulating Exchange Adjustments in Dynamics AX 2009
Posted Wednesday, August 11th, 2010
Simulating Exchange Adjustments is just one way that Dynamics AX 2009 can make life easier for you and your company. Dynamics AX 2009 offers a variety of simulation and forecasting tools as well as reports. These features filter complex data into a clear form that can be used in decision making. A quick Exchange Adjustment Simulation will illustrate how a business issue is solved easily using Dynamics AX 2009.
What if you want to see the effects of an exchange adjustment on open customer transactions before you actually make the adjustment?
That is when you would want to use a Simulation provided by Dynamics AX 2009.
-You can access the Exchange Adjustment Simulation from either Accounts Receivable or Accounts Payable by clicking Periodic followed by clicking Exchange  Adjustment.
-Click the Simulation button on the right side of the form.
-This brings up the Exchange Adjustment Simulation form pictured:
 
-If you click on the drop down arrow for Method you will see three options:
- Standard, which makes adjustments based on the exchange rate used on the date specified in the Date of Rate field.
- Minimum, which only makes and adjustment if a loss occurs but does not if there is a profit.
- Invoice Date, which offsets any exchange adjustment that is not already offset. This causes the transaction to be valued at the original value.
-Next, select the Considered date to find all the transactions that are open on that date and an exchange adjustment will be made automatically if necessary. For transactions that are open on this date, but are settled before the exchange adjustment date, adjust in the periodic job.
-Enter the date of rate in the Date of rate field. This determines the exchange rate used in the adjustment.
-Click the Select button on the right side to choose the data you want in the report.
-You can use the Options button on the right side to choose how to print or save the report.
-Finally, simply click OK to view the report. The simulation report shows all the open balances in the originating currency as well as the company currency. The report also lists the exchange rates that were used in the simulation.
This was just a simple example of Dynamics AX 2009’s capability to get valuable results in an efficient manner.
Tags: Adjustment, Currency, Exchange, Simulation
Posted in Dynamics AX, Financial
Alex Hunt
Consultant in Dynamics AX for I.B.I.S., Inc.
Need Expert Help With Dynamics AX?
Get the support you need to effectively manage your business.
Learn more about our Dynamics AX support options
sir i need exchange rate master coding for sale order mgmt in vb.net with sqlserver..