Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Split company then consolidate in Dynamics NAV

Posted on by 160

Hi All,


Please let me know what's your best approach on splitting a company into multiple companies then consolidate afterwards in Dynamics NAV 2015. I think this is a very complicated query and it depends on the exact requirements but I just want to get an info for the best approach that you have done in the past (if any).

Any info would be much appreciated like how did you handle like this, what are the areas of concern, what are the recommendations, etc.

Thank you.

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Split company then consolidate in Dynamics NAV

    It depends on the legal process behind that split, in particular, where should the historical data stay and which part of that.

    If there is a normal legal extraction of one company from another, this might mean that a new company is established and some assets from the old company are being transferred to that. Thus, the historical data stays in one company, and the new company starts from scratch. Then, some assets are transferred from one company to another using standard financial NAV tools (like financial journals or invoices).

    Also, for the split, we have been practicing different approaches:

    - One option is to create two new companies, and enter the needed balancing figures at a date of the split; the financial managers would tell you which are the balancing figures you would need to use. In this case you would need to do a normal opening balances data transfer: master data, open balances (open documents), etc. for both companies. This approach is simple and straight-forward for the NAV users, as they do not need to ask for the help of consultants/developers and can perform most of the operations by themselves.

    - The second option is to make a copy of the company, use it for the 2nd company, and delete unneeded data in both of them; this would require interference with tables and data records, and will involve some consultant/developer support.

    - The third option is to export all the data from the company using RapidStart services, clean unneeded data in Excel and upload it back to the needed company - this would require some assistance of the advanced user or consultant, as normally users are not familiar with imports using RapidStart services.

    Overall, as Jonathan mentioned, it might require splitting the master data, references, and ending balances. You should consider which option is the most suitable for you under your circumstances.

    About consolidation: msdn.microsoft.com/.../hh169407(v=nav.80).aspx

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Split company then consolidate in Dynamics NAV

    in most cases that means split the customers, vendors, maybe items. best you start with 2 new companies, export the needed data from the original company for each new company using e.g. rapidstart, data export tool, xmports,... and then import the data to each new company. moving production data like orders, ledger entries can be tricky. so better let the historic data in the old company as historic data and start fresh with the new companies.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Split company then consolidate in Dynamics NAV

    1) Copy the entire company.

    2) Truncate the data from all the Ledger Entry Tables i.e. G/L, ILE, VLE, CLE, Vendor Ledger, Bank Ledger, FA Ledger etc.

    3) Remove the unwanted data (Filtered) from the documents / transactions tables i.e. Sales Header, Sales Invoice Header  etc. tables.

    4) Upload fresh Opening Balance for Item, G/L, Bank, FA, Item, Vendor, Customer etc.

    Repeat the steps for No. of companies, that you would like to create.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Split company then consolidate in Dynamics NAV

    Hi,

    What is exact requirement for splitting the company ?

    How data is going to split in two companies ?

    You need to create another company and import the opening balances or required transactions

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Split company then consolidate in Dynamics NAV

    copy the company, then delete in both companies the data, which is not needed in each company.

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,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans