Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Consolidation company

Posted on by 71

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

  • Natalia Aquarius Profile Picture
    Natalia Aquarius 71 on at
    RE: Consolidation company

    thanks a lot, Ludwig , for your quick assistance

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans