Combine Multiple Companies in same database

Steve
Member Posts: 81
We have a client that wants to combine several companies data into one master company to continue business in. They want to retain past data in this master company and continue business within this 1 master company. Any ideas for an easy way to combine these (3) multiple companies into (1) master company? They have at least 1 year of past data in each company.
Any ideas would be appreciated.
Navi 2.6 database
Thanks
Steve #-o
Any ideas would be appreciated.
Navi 2.6 database
Thanks
Steve #-o
Steve
0
Comments
-
The only way I see it working is to migrate all data between the companies, into the new company.
You will have to handled duplicate Customer / Vendors / Items etc... could be tricky , especially if you use No Series, but it's the only way.
Then :
Migrate final master tables into 1 company.
Post G/L transaction (either in detail, or opening balance) - depending on detail required in new company.
Post Open Bank, Item , Vendor , Customer balances (Careful with control accounts in the G/L as they contain the detail for the Subledgers).
Good luck.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions