Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans