Different budget rates for different accounts/cost centers

(0) Share

Report

Posted on by Community Member

Hi all,

Hope you can help me with the below issue I'm dealing with.

We have two types of business in the same entity. We use specific accounts/cost centers for each of them.

The budget for one of business was only approved for the first quarter (at the beginning of the year) and now the rest was approved as well. The budget is done in EUR, while let's say the local currency is USD.

Problem is that for one of the two business, the exchange rate must remain the same for the full year, but for the other one the budgeted exchange rate has changed.

Can I set up different exchange rates for different accounts or cost centers - for the amounts in the budget?

If this can't be set up, can I work some calculations in Management Reporter so that for the last 3 quarters of the year it will use another exchange rate than the one budgeted?

I am happy to provide further details, really hope you can help me with this one.

Many thanks,

Oana

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

guk1964 10,888 on at

Like (0)

Report

You can create another currency code e.g.$CC1.

You need to take care which one is selected on which transaction and how you want each to be treated in reports and foreign currency revaluation - from an Ax perspective these are different currencies.

You can define currency exchange rates between currency pairs for the Budget exchange rate type

You can define budgets per annum, but also quarterly or even by period.

Exchange rate types are a grouping that allows different exchange rates for two currencies. Examples include Buy, Sell, Spot, and Budget.

Budget register entries can involve more than one currency.

Define exchange rates for the budget rate type before submitting budget register entries.

Management Reporter, uses the Exchange rate type assigned to the account. If For Budget, then it uses the Budget rate type associated in the Ledger.

community.dynamics.com/.../using-currency-translation-with-management-reporter-and-ax

blogs.msdn.microsoft.com/.../currency-translation-for-microsoft-dynamics-ax-2012-part-1-setup-cu7-feature

In MR it might be useful to have a column for each of the currency versions

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi O.G.,

I think that what you are looking for can be realized in the new cost accounting module. You can handle actual and budget data and define different rates. You can also work with different exchange rates and do not need to setup artificial exchange rates to handle those scenarios. Probably have a look at the following Websites to get an overview what this module can do for you.

docs.microsoft.com/.../terms-cost-accounting

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thank you all for your suggestions, I'll look into it and let you know if this was resolved somehow :)

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

[quote user="Ludwig Reinhard"]You can also work with different exchange rates and do not need to setup artificial exchange rates to handle those scenarios.[/quote]

Hi Ludwig ,

I'm curiosity to understand over the query raised by poster ,hence please share the path above highlighted point and screenshot in cost accounting module as her query is Problem is that for one of the two business, the exchange rate must remain the same for the full year, but for the other one the budgeted exchange rate has changed.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi lally,

In the new cost accounting module you can basically setup as many cost accounting ledgers as you like and select a different exchange rate type for each of them. Additional information are provided on the link that I shared before.

Best regards,

Ludwig

Was this reply helpful? Yes No