Microsoft Dynamics AX (Archived)

Problem with Foreign Currency Revaluation in Cash & Bank Module

(0) Share

Report

Posted on by Community Member

Dear all AX Experts,

Does anyone know how AX 2012 R3 (CU9) actually calculate Unrealized gain & loss for Cash & Bank Module ?

We're facing an issue, somehow the amount ax calculate is different form our manual calculation.

Our voucher consist of 3 combination ledger account, but only 1 ledger account that's different

this is our manual calculation :

this is AX calculation :

Thanks,

Christoper

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Hello christoper,

The standard application does not include a foreign currency revaluation functionality for each and every country.

Do you know whether the country-specific standard functionality was made available for you or has something been developed for you?

Where has the foreign currency revaluation been initiated?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Hi Ludwig,

Sorry for late reply, Thanks for your response

Yes I'm not using standard functionally of application, I'm using custom the foreign currency revaluation in cash and bank module based on your information on your blog, I'm adding the CountryRegionCodes = ID (for Indonesia)

I'm initiated the foreign currency revaluation from cash and bank module :

https://dynamicsax-fico.com//?s=cash+and+bank+foreign+currency+revaluation&search=Go

Thanks,

Christoper

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Hello Christoper,

Many thanks for your information.

Can you help us and explain a bit more on the calculations that you attached above?

I can identify your manual calculation and what you call 'AX calculation'.

Can you explain how and where you got those data from?

Can you also let us know how you did your summary?

I currently have a bit trouble when I try to bring those data together.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Dear Ludwig,

Thanks for your response,

This is my manual calculation (I calculate it one by one per transaction using report ledger transaction list in general ledger module), in this screenshoot i write the formula for you how to calculate my manual calculation: I reval from USD to IDR, my reval rate is 13.321

And this is AX calculation (I got it from posted voucher in trial balance, i copying all data in voucher FCR-000002037 that the voucher come from Foreign Currency Revaluation which i have done before :

AX Calculate the revaluation about (157.72) which should be (418) which means different (260.28) that take effects my Trial Balance different about (260.28)

What do you think?

Thanks,

Christoper

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Hi Christoper,

I am still not sure about the calculations that you made because your first screenprint shows GL voucher numbers that I cannot identify in your second screenprint.

I have a question:

Can you run the GL-bank reconciliation report in the GL module?

Does this report show the same difference that you calculated manually?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Dear Ludwig,

Thanks for your responses,

my first screenprint is all the transactions that have occured for that bank account, because i want to calculate it manual 1 by 1 per transaction for the reval so i delete the foreign currency revaluation that you can't find in the first screenprint before,

this is the screenshoot i attach for you that maybe will adding the information from the first screenprint before (this data i got from ledger transaction list in GL module)

Ok, i will try to run GL-bank reconcilliation in our testing server environment because i can't do it in the production server and i will tell you the result soon,

Thanks,

Christoper

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Problem with Foreign Currency Revaluation in Cash & Bank Module

Dear Ludwig,

I've tried Foreign Currency Revaluation in GL module using my testing environment and the amount according to the manual calculation so i decided to initiate foreign currency revaluation using GL module

Thanks,

Christoper

Was this reply helpful? Yes No