Microsoft Dynamics AX (Archived)

Parallel currency conversion, EUR>PLN and EUR>HUF possible in Dynamics AX?

(0) Share

Report

Posted on by Community Member

Hi,

I was wondering, but wasn't really able to find any answer on that. Is Dynamics AX supporting the below case scenario:

- local currency - PLN

- foreign currency (customer's) - HUF

- order/invoice currency - EUR

We basically get the orders in EUR, but we post the amount in our ledger in PLN. We want to show HUF amount on the invoice, but rather of converting EUR -> PLN -> HUF, we would like to present two parallel conversions, ie. EUR -> PLN and EUR -> HUF respectfully.

Is it supported in Dynamics, please (if yes, which version?)

Thanks,

Jozef

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jozef,

When you setup a new sales order, Dynamics AX suggests and/or defaults the currency of your customer - in your case HUF - but you can change this when creating the sales order or subsequently in the sales order header to e.g. EUR. AX is then doing the currency conversion for you given that all exchange rates have been setup.

If you need to create financial statements in PLN only, there is no issue. If you want, however, also create financial statements based let's say in GBP currency, then it would be smart setting up the GBP as your reporting currency in the ledger form in GL as AX would allow you tracking the order in several currencies (PLN, EUR and GBP) and create financial statements in PLN and GBP ou of the box.

I found a Brief example that illustrates this here: mcaconnect.com/.../handling-foreign-currencies-in-microsoft-dynamics-ax

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hallo Ludwig,

Thanks for your prompt reply!

Would it be possible after setting the reporting currency to HUF (or GBP) to automatically show it on the invoices as well (out of the box or after some programming)? If I understood it correctly, setting it so would maintain an exchange rate table for new currency, yes?

My scenario incorporates all 3 currencies on the documents and in the system, ie.:

Ordering currency EUR (set as default for the customer) and then:

- EUR->PLN conversion and booking on respective EUR and PLN accounts,

- EUR->HUF conversion and showing both EUR and HUF amounts on the invoice printout.

Our current solution makes something undesirable by converting EUR to PLN first, and then PLN to HUF, while the Hungarian authorities need a direct EUR to HUF conversion. For the time being, our system renders wrong HUF amount due to double conversion and we need to amend the amount in HUF manually before creating and publishing the invoice.

The perfect solution would be to make a parallel and direct conversion 1-EUR->PLN, 2-EUR->HUF at the time an invoice is created in Dynamics, but is it possible to achieve?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jozef,

The accounts receivable module has a form setup window that allows specifying to print the amount in EUR on your documents such as e.g. sales invoices (please see the General tab of this form). Whether you can use this Feature or not depends on whether and to what extend your sales documents such as sales invoice, free text invoice, etc. have been modified to meet your company's requirements.

The second second Feature that might help is the totals button/form available from your sales order. If you open that form, you will be able to see the currency on the upper right-Hand corner and change it to see all amounts e.g. in EUR, GBP, USD, ...

The third question is not very clear to me. Can you explain a bit more what you want to see from an accounting perspective posted on your ledger accounts that you can then use for reporting & analyzing. A concrete example with some PLN/HUF values would help a lot.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jozef,

What I understand is that your accounting currency is PLN. The customers currency is HUF, but wants to get the invoices in EUR. If this customer will always be invoiced in EUR, the currency at the customer should usually be set to EUR. AX doesn't care if the customer lives in another country.

Now you want to please the customer by also providing the HUF currency amounts on the invoice. I assume you don't need this for your own financial reporting. In that case you should create a customization where you can setup a secondary currency for the customer (HUF) . The sales invoice can then be adjusted to show other amounts as well. Within the customization you can decide how to do the currency conversion, so also EUR > HUF.

Was this reply helpful? Yes No