Consolidation company

(0) Share

Report

Posted on by Natalia Aquarius

Hi all,

Could you help me with these questions:

i have created consolidation company and imported transactions from the base company according this manual https://www.grouppangea.com/consolidation-microsoft-dynamics-365-finance-operations/. Everything is ok. I have GL transactions there.

1. But how i can get link from these GL transactions of consolidation company to GL transactions of base company. ( audit trail)?

2. I have read here https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/financial-consolidations-currency-translation that consolidation company provides such feature "Complete audit capabilities – All dimensions, accounts, and transactional detail are maintained for analysis and audit. In addition, Financial reporting provides full drill-back to the original transaction in any of the legal entities that are consolidated."

2.1 is it correct that All dimensions, accounts, and transactional detail are maintained for analysis and audit in consolidation company? how i can see subledger transactions in consolidation company?

2.2 is it correct for consolidation company "Financial reporting provides full drill-back to the original transaction in any of the legal entities that are consolidated."? or it means if i consolidate with Financial reporting but without consolidation company i get full drill-back to the original transaction of the base company.

thanks in advance

All responses (3)

Answers (1)

Natalia Aquarius 71 on at

Like (0)

Report

RE: Consolidation company

thanks a lot, Ludwig , for your quick assistance
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidation company

Hello Anna,

Have your questions been answered for this thread or is there something left open / not answered?

Best regards,

Ludwig
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Consolidation company

Hello Anna,

Below some comments:

For 1: I don't think that this backward linkage is possible if you make us of the online consolidation in AX. If you use the Management Reporter then you can always drill back to the originating voucher. To my knowledge this is not possible if you make use of the online consolidation. Yet, I don't see this as a major audit issue because many companies use 3rd party tools for consolidation and thus do not have this backward / drilldown linkage available anyway. Imagine that you have to consolidate data from SAP, D365FO, AX and NAV systems. How would you realize such a drill back especially against the background that many legacy systems such usually provide consolidation data on a high level - that are often uploaded with the help of Excel templates.

For 2.1. You can't see the subledger transactions. Why would you need to? You are at the consolidation level ;-) If you need to see subledger transactions, go to the individual company where the data originate. Note that this company / transaction must not necessarily originate from AX/D365FO but can also originate from other systems (SAP, NAV, etc.)

For 2.2. I think that is the same / an identical question that you raise again. Please see 1 and 2.1.

Best regards,

Ludwig