Finance | Project Operations, Human Resources, ...

General Ledger Foreign Currency revaluation

(0) Share

Report

Posted on by katz.gee

I am trying to run a preview of foreign currency revaluation in General Ledger in D365 F&O.
I am just not sure of how the functionality works.

I am trying to run the foreign currency revaluation for a specific Main account for GBP currency.
Which transactions should the system revaluate? I have read blogs and a Microsoft article that it will try to revalue outstanding transactions/main account balances - which transactions are considered outstanding? Should the revaluation include reversed transactions?

When I try to change the From Date and To Date fields, the transaction amount will change but it will just show one transaction - I was expecting that it will show multiple outstanding transactions to be revaluated.

If I filter the dates from 07/01/2020 to 07/20/2020, it will show a transaction amount of -31,546.52.

If I change the dates to 7/01/2020 - 07/22/2020, it will show a transaction amount of -22,775.84.

Hopefully someone can explain how this works?

Appreciate your help, thanks in advance!

Regards,

katz.gee

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report
Copy link

Link copied!

Hi katz.gee,

The parameters you selected as per your screen print, System will check and revaluate all balance accounts transactions which are posted in GBP currency and revalue them based on the exchange rate for this date 11/6/2020 found in currency exchange rate screen.

Transaction amount will be obviously changed based of your date selection. Let's say from 1st July to 20th July "100" transactions were posted and from 1st to 30th July in total "200" transactions were posted.

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (1)

Report
Copy link

Link copied!

All of your posting within the Date Range to Main Accounts with Transaction currency other than your Accounting Currency will be revalued based on the Date Rate you have specified.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello katz.gee,

What GL accounts do you want to have revalued?

What amounts do you record and track on those accounts?

If you are sure that you want to revalue your GL accounts then have a look at this docs site that provides you a description on this functionality.

docs.microsoft.com/.../foreign-currency-revaluation-general-ledger

Best regards,

Ludwig

Was this reply helpful? Yes No
katz.gee 35 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Thanks for the link provided, I have already read this article but I am still a bit confused regarding the amounts being displayed during the foreign currency revaluation preview.

I am trying to revaluate transaction from a Balance sheet account type, liability account category.

I am just not sure of the amounts being displayed. I tried to check all the transactions under the main account.

The amount I am getting (GBP 22,775.84) during the foreign currency revaluation is a reversed transaction - is it expected to revalue reversed transactions?

This transaction was posted in the previous fiscal year and reversed in the next fiscal year.

Appreciate your response to this.

Thanks,

katz.gee

Was this reply helpful? Yes No
katz.gee 35 on at

Like (0)

Report
Copy link

Link copied!

Hi Junaid,

Thanks for the answer appreciate it.

Your example scenario implies that more transactions will be revaluated if the date range coverage is higher.

It is just a bit confusing for me that when I added 2 more days on the date range, the transaction amount actually decreased.

Does this mean that I can only revaluate some transactions within specific dates?

Best regards,

katz.gee

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report
Copy link

Link copied!

Hi katz.gee,

That's correct, it will only consider transactions between the date range you have specified. It can decreased/increased based on the amount of transaction, it could be +ve or -ve.

Was this reply helpful? Yes No