Split company then consolidate in Dynamics NAV

(0) Share

Report

Posted on by algeloca

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

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

Was this reply helpful? Yes No