Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Consolidation Trial Ba...
Small and medium business | Business Central, N...
Suggested answer

Consolidation Trial Balance Report

(0) ShareShare
ReportReport
Posted on by Tymay 295

Hi,

We perform a test on BC Consolidation. We started with consolidating BU1 and BU2 from 1/1/2022 to 31/1/2022. Printed the BU Consolidated Trial Balance report with date range 1/1/2022 to 31/1/2022. The report was OK.

Then, we consolidate BU1 from 1/2/2022 to 28/2/2022 where the consolidation process added a new line dated 28/2/2022. When we try to print the BU Consolidated Trial Balance with similar date range 1/1/2022 to 31/1/2022, the consolidated report includes the amount dated 28/2/2022?

We are unable to print consolidated report only for those from 1/1/2022 to 31/1/2022.  Anything i had missed? Or the consolidated trial balance will include all values regardless of date range?

Appreciate all advise.

May Tang

  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Consolidation Trial Balance Report

    May,

    Not sure I'm following your question, but the key to getting an Account Schedule that shows by Business Unit is to create a column layout where you are using the Business Unit filter to split them out. Then add a total column to get the full results. You can run the report by period or multiple periods as any other Account Schedule.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,960 Super User 2024 Season 2 on at
    RE: Consolidation Trial Balance Report

    No, You should have only 1 consolidated company - no matter for how many periods. 

    Can You share how You are pulling in the data? In normal option You should have the NetChange for period posted with last date of the month.

  • Tymay Profile Picture
    Tymay 295 on at
    RE: Consolidation Trial Balance Report

    Hi Amanda,

    I tried both the Trial Balance reports above and both combined Period 1 and Period 2 together even though i only selected date range 01/01/2022 to 31/12/2022.

    If we were to design that via Account Schedule, means would be able to print by date range of 01/01/2022 to 31/12/2022 and the result from Account Schedule will not combine them together?

    Thanks Amanda,

    May

  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Consolidation Trial Balance Report

    May,

    Which Report are you running?

    pastedimage1676392079979v3.png

    That said, I prefer creating an Account Schedule (Financial Reporting) that gives me the data by Business Unit. Then it is dynamic and allows me to drill down into the numbers.

    pastedimage1676391953583v2.png

  • Tymay Profile Picture
    Tymay 295 on at
    RE: Consolidation Trial Balance Report

    Hi Kaspars,

    Thanks for your reply. Does it mean that i have 2 create 2 consolidate companies; 1 to consolidate for period 01/01/2022 to 31/01/2022 and create the 2nd consolidate company for period 01/02/2022 to 28/02/2022?

    Currently i only have 1 Consolidated Company which i had pulled the consolidated values from BU1 and BU2 month by month which created transaction lines dated 31/1/2022 and 28/2/2022 respectively.

    May Tang

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,960 Super User 2024 Season 2 on at
    RE: Consolidation Trial Balance Report

    Normally You would have a separate consolidation company, where You pull in the balances for period 01.01.22..31.01.2022 from BU1 and BU2 and post them with 31.01.2022.  (possible to split amounts on each GL also by dimensions)

    After that You pull in next month 01.02.2022..28.02.2022  and post them with 28.02.2022

    This way You can create reports in Consolidated company just like in each individual BU.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans