Customer account revaluation on different exchange rate

(0) Share

Report

Posted on by Ram Niwas

Dear Experts;

I have a requirement. Customer is having 2 different exchange rate types set in ledger form where accounting is AED and reporting exchange rate type is USD.

They want transactions should be recorded based on exchange rate type AED and revaluation on customer account should be based on USD.

My problem is, I can set exchange rate type in main account form for customer main account but when I am running the foreign currency revaluation in AR, it is revaluing based on exchange rate type AED and not USD whereas, in general ledger module it is revaluing based on USD exchange rate type as I set it in main account form.

Is there any way to find a solution on this or is it possible to do? Customer is using new version 10.0.5.

Thanks and regards,

Ram Niwas

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SouravDam 11,730 on at

Like (1)

Report

Hi Ram Niwas,

The subledger accounts will be revalued based on the accounting currency exchange rate type as set in the Ledger form which is AED in your case.

If you have selected the exchange rate type USD in customer controlling account and set the foreign currency revaluation check box enabled in main account form; that main account will be revalued based on USD only when you run the foreign currency revaluation in GL module. It will actually override the accounting currency exchange rate type (this is AED in your case) because you specify USD at main account level itself.

But when you run the revaluation in subledger account such as customer or vendor; it will be always revalued based on the accounting currency exchange rate type AED as there is no option to specify exchange rate type in subledger master forms. This is as per default design in D365 even though if you are using the latest upgraded version at client's place.

If you have any further query or concern, kindly share your comment.

Best regards,
Sourav Dam

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
Ram Niwas 15 on at

Like (0)

Report

Hi Sourav Dam,

Thanks for your answer.

That means; customer and vendor always will be revalued based on accounting currency exchange rate type. But their summary accounts will be revalued based on what exchange rate type I have selected in main account form.

This is clear and understood. Thanks again for help.

With best wishes,

Ram Niwas

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ram,

Sourav is correct here. I have never seen a requirement like this. The purpose of a revaluation is adjusting the value of customer or vendor balances in case of exchange rate fluctuations to be able to do correct reporting in your accounting currency. A reporting currency is used when you are part of an enterprise and needs to do reporting in another currency for the internal organization.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Customer account revaluation on different exchange rate

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Customer account revaluation on different exchange rate

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates