Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Data Migration from SQL 2008 to SQL 2008 with NAV 2009
Mammo
Member Posts: 107
Dears,
I have a scenario that a company was using NAV2009 since 2010 in a separate database and the other entity they were using Navision system since Jan 2013. Now they are looking to merge both the companies into a single company with having two business unit dimensions. More over they are looking to have transaction only from April 2013 and all previous transaction they need as opening balances from both the companies.
I will appreciate if you guys can suggest the best approach and procedure to fulfill this requirement.
Thanks & regards
I have a scenario that a company was using NAV2009 since 2010 in a separate database and the other entity they were using Navision system since Jan 2013. Now they are looking to merge both the companies into a single company with having two business unit dimensions. More over they are looking to have transaction only from April 2013 and all previous transaction they need as opening balances from both the companies.
I will appreciate if you guys can suggest the best approach and procedure to fulfill this requirement.
Thanks & regards
0
Comments
There are a couple of issues and approaches here. If it were my client, I might suggest bring the two COMPANIES into one database by backing up the first company using NAV backup and restoring it into the second company's database selecting the "Import company A only" option.
After that, depending on what you mean by "transactions", you could bring over GL transactions via an export and import into a journal (or series of journals). If you wanted A/P, A/R transactions also, that would be more complex, but you might just want to create a new "third" company and start with beginning balances and G/L only. The other companies' data would still be there in the same database for reference.
I'm not suggesting this is the only option - the reason for the database merge and company merge need to be understood, and legal and accounting issues need to be considered. but mechanically, it's reasonably straightforward.