Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Consolidated financial reports:

Posted on by 421

I have two companies and one for consolidation.

I have done all setups ,consolidated l trial balance 4 showing data of both companies but in financial report showing data only in one company.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Consolidated financial reports:

    Are your Business Units actually the letters A and B? If not, then you need to put the actual Business Unit values in the column definition. Also, it might be helpful to show some general ledger entries with the business unit dimensions in a screenshot for better assistance here.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Consolidated financial reports:

    also recheck if the lines F100, F200 don't have some specific filters attached

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Consolidated financial reports:

    If theres only 2 business units, You can try to change the filters, in 1st column Business unit leave "A"

    and in second Business Unit change to "<>A"

    Retested in my consolidated company and it should work, but if You have some customizations, who knows what has gone wrong.

    When looking at the results, You can click in a cell where should be values, and You can check the filters and if system finds any entries. Maybe You have run a closing, and zeroed all company A transactions ?

  • RE: Consolidated financial reports:

    Yes in ledger entries both business units are showing .

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Consolidated financial reports:

    Check "General Ledger Entries" and filter by the "Business Unit Code" and see if any of the entries has the A or B code attached.

    Financial Reports are based on General Ledger Entries, so You can try to add the same filters to the page and see/recheck the results.

    In the Financial Report list You can see if You are using Analysis View. If it is used, open the list, and check if the used View is updated.

  • RE: Consolidated financial reports:

    pastedimage1683113508111v1.png

    In consolidated trial both companies showing.

    pastedimage1683113733733v2.png

  • RE: Consolidated financial reports:

    pastedimage1683113296277v1.png

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Consolidated financial reports:

    Then maybe You can add a screenshot of You Financial Report lines ?

  • RE: Consolidated financial reports:

    Yes I can see balance of both companies in chart of account.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Consolidated financial reports:

    if You see the amounts from both companies in Chart of Account, then You should see the amounts also in Financial reports. Might recheck the filters for lines/columns - for dimension values or other

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans