Finance | Project Operations, Human Resources, ...

Online Consolidation in D365 F&O

(4) Share

Report

Posted on by Manik246

Hi everyone! I'm doing online consolidation starting from FY 2017. During Consolidation, Only operating transactions are picked up, so I performed year-end activities and rolled forward the closing balances successfully.

Now, in FY 2018, I'm trying to convert opening balances in the consolidation legal entity using the closing exchange rate from year-end 2018. However, the system is using an earlier exchange rate, and it's causing variances in balance sheet accounts in source and consolidation LE's

How can I ensure that the opening balances in the consolidation entity match the source legal entities using the 2018 closing exchange rate? Any advice would be appreciated!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

What's the date of the earlier exhange rate it's using?

Was this reply helpful? Yes No
Suggested answer

Manik246 45 on at

Like (0)

Report

December 31st 2017,

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

Thinking further about this, why do you need to convert anything in the Consolidation company? Did you run your FX revaluation in the Operating entities prior to running consolidation?

Was this reply helpful? Yes No
Suggested answer

Yng Lih 1,560 on at

Like (4)

Report

Hi Manik,

In setup, under “Currency translation”, specify that opening balances use the Closing exchange rate from FY 2018.

If this information was helpful, kindly mark it as 'Verified'. Thank you. :)

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 746 on at

Like (2)

Report

Hi Manik,

It looks like some parameters may be missing in your consolidation setup. Please check the currency translation in the Online consolidation parameters form and make sure the exchange rate type is set to Closing for balance sheet accounts (Screenshot below). Also, verify that the correct rate exists for the consolidation date. If the rate is missing, the system will use an earlier one, which can cause variances.

If needed, you can use the User-defined rate option in the online consolidation form and manually enter the desired exchange rate. This will ensure that the opening balances are translated with the correct FY2018 closing rate and align the consolidated balances with the source entities.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No