dynamicscpm: Currency translation for Microsoft Dynamics AX 2012 - Part 1: Setup (CU7 feature)

[Blog bot]

Источник: http://blogs.msdn.com/b/dynamicscpm/...7-feature.aspx
==============

Management Reporter CU7 announced support for currency translation for Dynamics AX 2012 customers. Customers on Dynamics AX 6.1 CU5 or AX 6.2 CU2 or later will have the fields required for users to be able to view their data in both functional and reporting currencies from the web viewer. Customers will have increased flexibility in viewing actual, budget, budget control and budget planning data in multiple currencies.

This blog is the first in a series of three blogs that showcase the functionality in Management Reporter and Dynamics AX 2012.

• Part 1 discusses the setup in Dynamics AX 2012 and the calculation methods for determining exchange rates
• Part 2 contains an overview of viewing the data in different currencies in the web viewer
• Part 3 describes the changes and options in Report Designer for alternative currency translation scenarios

The first step in preparing to view financial reports in multiple currencies it to understand how exchange rates are calculated. There are four options in Dynamics AX 2012 for calculating exchange rates in Management Reporter:

• Weighted average – used most often for profit and loss accounts, this method takes the (exchange rate * days in effect)/days in period
• Average – an alternative method for profit and loss accounts, this method takes the total of exchange rates/# of exchange rates
• Current – method used most often for balance sheet accounts, the exchange rate used is the rate on or before the date of the report or column in Management Reporter
• Transaction date – method used for fixed assets accounts, the exchange rate used is the rate on the day the asset was acquired. If a rate is not entered for that date, the rate used is the previously entered rate closest to the asset acquisition date

The second step in preparing to view your financial reports in multiple currencies is to complete the required setup in Dynamics AX 2012.

Two fields have been added to the Main Accounts and Main Account Templates in the Management Reporter fast tab:

• Exchange rate type – choose the exchange rate type that contains the currencies and exchange rates you want to apply to this account. This table of currencies and exchange rates will be applied to actual data in Management Reporter.
• Currency translation type – select the method for how the exchange rate is calculated for this account. This currency method is used for both actual and budget data in Management Reporter.

For budget, budget control and budget planning data, define the Exchange rate type in the Ledger.

Now that you understand how exchange rates are calculated and how to set up Dynamics AX 2012 for translation you are ready for reporting.







Источник: http://blogs.msdn.com/b/dynamicscpm/...7-feature.aspx

[Blog bot]

Источник: https://community.dynamics.com/ax/b/...12-part-2.aspx
==============

(Please visit the site to view this video) Changing reporting currencies in the web viewer (CU7 feature):Now that you understand how exchange rates are calculated and how to set up Dynamics AX 2012 to...(read more)

Источник: https://community.dynamics.com/ax/b/...12-part-2.aspx

[Blog bot]

Источник: http://blogs.msdn.com/b/dynamicscpm/...7-feature.aspx
==============

Now that you understand how exchange rates are calculated and how to set up Dynamics AX 2012 to enable reporting in multiple currencies, let's see how you can easily view the data in the web viewer. This blog is the second in a series of three that showcase the currency translation functionality in Management Reporter and AX 2012.

• Part 1 discusses the setup in Dynamics AX 2012 and the calculation methods for determining exchange rates
• Part 2 contains an overview of changing the reporting currency for a report using the web viewer
• Part 3 describes the changes and options in Report Designer for alternative currency translation scenarios

Business is global and in today's world we have employees and other stakeholders located in all corners of the globe, and they cannot get data fast enough. It's important for each of these users have data that is relevant to them in a currency that they are familiar with. It can be something as easy as reading your sales numbers in Euros to viewing your trial balance in Pesos so you can accurately make the right decisions. View the video below to learn more about how you can view any report, in any currency, at any time.

(Please visit the site to view this video)






Источник: http://blogs.msdn.com/b/dynamicscpm/...7-feature.aspx

[Blog bot]

Источник: http://www.youtube.com/watch?v=De8I-...=youtube_gdata
==============


Currency translation for Microsoft Dynamics AX 2012 - Part 2

Changing reporting currencies in the web viewer (CU7 feature):Now that you understand how exchange rates are calculated and how to set up Dynamics AX 2012 to enable reporting in multiple currencies, let's see how you can easily view the data in the web viewer.http://blogs.msdn.com/b/dynamicscpm/
From:Microsoft Dynamics
Views:7

1ratings
Time:02:58More inScience & Technology


Источник: http://www.youtube.com/watch?v=De8I-...=youtube_gdata