Managing the reporting currency

Posted by
Version Française disponible ici

In the 8.1 PU20 version of MSDyn365FO, a new functionality has been added : managing dual currency for reporting purposes. In previous versions, amount in reporting currency was calculated from the ledger currency and it was not possible at that time to use it in reports. Only the ledger account setup was used to calculate values to be displayed in financial reports.

So 8.1 version bring us a lot of positive changes. Ideas suggested can have an happy ending sometimes : let’s have a look

Setup

In each entity ledger setup, a exchange rate for the reporting currency have been added. Now the reporting currency is calculated from the transaction currency.

Journals and transactions

When writing a journal, you can now choose the exchange rate for the reporting currency. Thus, for a GBP transaction in a specific company which run the accounting in EUR and the reporting in USD, it’s now possible to define the rates from the company setup. It gives us more flexibility for data recovery and transactions.

When the journal is posted, the generated vouchers are the same as the one in previous MSDyn365FO version, but an amount is registered for the 3 currencies of the company.

Note : It’s not possible to post any journal with a rate setup to 0 for the accounting currency. If the rate for the reporting currency is setup to 0, MSDyn365FO will use the rate setup in the Ledger form (General Ledger > Setup > Ledger). It seems not possible to manually enter transaction without any impact on the 3 currencies (obvious but not for every customers).

Trial balance

The trial balance is now displayed with accounting and reporting currency.

Note : if the reporting currency is not setup for the current company, the columns for the reporting currency are not displayed.

Financial reports

You can also use the reporting currency in financial reports. You need to select the « reporting currency from ledger » in the Displayed currency field.

In previous MSDyn365FO versions, the ledger account setup was used to compute the amount when running the report. This setup has to be used only if we need to display another currency than the 3 already registered for the current transaction.

 

Revaluation

General ledger module

The foreign revaluation currency seems to work exactly the same than in the previous versions.

When running the preview before posting view, the recap array is still here. After posting, the ledger entries are the same than previously.

AR/AP module

In here the system doesn’t seem to have enhanced if you run the foreign currency revaluation.

You can run a simulation before posting and voucher entries seems equal to previous versions.

Reporting currency adjustment

A new menu item is available in the 8.1 MSDyn365FO version : the reporting currency adjustment journals from General Ledger > Journal entries > Reporting currency adjustment journals :

You need to create a new journal name to use it:

When done, you can use it and create a new journal to adjust an amount on a specific ledger account. Pay attention, every transaction has to be balanced correctly. You have to do it yourself as there is not offset account setup here.

There is few functionalities in that type of journal: only reason codes, approver and date. When posting, you can retrieve a voucher entry in the reporting currency.

The posting type is « Reporting currency adjustment » which could be usefull for filtering.

Limits

It still isn’t possible to apply the IFRS 21 rule because ledger accounts for registering profit and loss done are setup in a global way or only by currency. You still cannot setup them by ledger accounts. It’s not easy, even impossible to make any difference between the financial and physical currency revaluation.

Conclusion

  • The amount in reporting currency is calculated from the transactional currency
  • It’s now possible to view and analyse in standard and financial reports the amount in reporting currency
  • A new journal has been added and allow you to adjust amount in reporting currency
  • It’s still not possible to distinguish physical and financial currency reevaluation to respect IFRS rule

Guillaume FAGES & Yohann ROLLAND

3 comments

Leave a Reply

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *

Ce site utilise Akismet pour réduire les indésirables. En savoir plus sur comment les données de vos commentaires sont utilisées.