Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Financial consolidatio...
Small and medium business | Business Central, N...
Answered

Financial consolidation and Inter company Elimination

(0) ShareShare
ReportReport
Posted on by Don01 40

Hi There,

New on Dynamic. our situation is that we have acquired multiple companies which are all on different Generate Ledger system, parent company is using Dynamic Nav based customized ledger system, we are looking for ways to easily consolidate acquired company financial into Dynamic Nav based on Leger system, could you provide some guidance, document, links on ways to do this?

Thanks

  • Don01 Profile Picture
    Don01 40 on at
    RE: Financial consolidation and Inter company Elimination

    Steve,

    Thanks so much for quick reply as always! Maybe they are referring to Jet Analytic cube, I know it is not from ISV, could you provide some more information on jet analytics and its cube if you don't mind.

    really appreciate your help on this

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Financial consolidation and Inter company Elimination

    Hello,

    I have not heard of NAV Cube but it could have been from an ISV. You can use Jet Reports in NAV to perform consolidation as well. If you like Cubes, Jet Analytics has a cube.

    Thanks,

    Steve

  • Don01 Profile Picture
    Don01 40 on at
    RE: Financial consolidation and Inter company Elimination

    Hi Steve,

    Is there tool call something like Microsoft Dynamic Nav Cube which can also do consolidation? one of our controller mentioned about this.

    Thanks

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Financial consolidation and Inter company Elimination

    Don,

    Not if you are trying to pull data from a table. If you asked me to look at the Chart of Accounts and filter to a specific Period Ending Date I can export to Excel the Page. If you asked me to run an Analysis by Dimensions or Accounts Schedule with Budget vs. Actual I can add my Date Filter and Export to Excel. Overall I can run many pages or reports that include my Balance Sheet or P&L period amounts and export to Excel easily.

    You could also create a Jet Report to pull the data easily into a B/S or P&L for what you want. If you do not have Jet, ODATA can help too.

    Thanks,

    Steve

  • Don01 Profile Picture
    Don01 40 on at
    RE: Financial consolidation and Inter company Elimination

    Steve,

    Thanks again for quick response! so ending balance is not stored and is calculated on the fly, then there is no way we can export the balance data out of Nav, we have external budget and planning system, which we need to load actual of P&L and Balance sheet into it, I know that we can use table 17 to load P&L by period, but not sure about balance sheet data.

    Dong

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Financial consolidation and Inter company Elimination

    Don,

    The actual balance is a flow field calculated on a page or report. Your Date Filters drive the values for the Posting Date. Think of filtering on a Posting Date for a period or year-to-date and it will calculate the period ending balance.

    Thanks,

    Steve

  • Don01 Profile Picture
    Don01 40 on at
    RE: Financial consolidation and Inter company Elimination

    Steve,

    One more question, do you know what table in Nav holds period ending balance data, if any.

    Thanks again

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Financial consolidation and Inter company Elimination

    Hello,

    General Ledger Entries are in Table 17.

    Thanks,

    Steve

  • Don01 Profile Picture
    Don01 40 on at
    RE: Financial consolidation and Inter company Elimination

    Thanks again, Steve!

    what about table to store Journal entries to make up for P&L and Balance Sheet

    wondering if there is cheat sheet for the table name and its respective data stored.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Financial consolidation and Inter company Elimination

    Hello,

    Table 15 holds the Chart of Accounts.

    Thanks,

    Steve

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 691

#2
YUN ZHU Profile Picture

YUN ZHU 682 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 529

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans