Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Navision Upgrade, Merger of Database

Posted on by Microsoft Employee

Hello, 

We are currently upgrading from Navision 2013 to Navision 2016. We are going to go live soon and want to merge our two database to have a combined holistic report. They have different localization (US, Dubai/India). We are now paying a global tax.

According to our vendor, doing this is complicated, they will have to make a lot of configurations and treat it as an implementation project. 

I want to understand what problems we will face if we combine two database with different localization. Also, what challenges are our vendors talking about? They are really apprehensive to merge the two database, I want to know why? 

What are the pros and cons of combining both the database? 

*This post is locked for comments

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Navision Upgrade, Merger of Database

    hi,

    keep localized db separate like suggested by all people in this post.

    Many updates about fiscal requirements in some contries manahed by cumulative updated, different logic and posting structures. different fiscal reports.

    use consolidation ore use Power BI to build reports.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Navision Upgrade, Merger of Database

    Hi Varun,

    Your NAV Vendor is right. It is not recommended, and will cost a lot for merging different localizations including Application Code and Data Structure. Consolidation Data as Amol, Ahmed and Manish mentioned is a good solution.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Navision Upgrade, Merger of Database

    Merging multiple localization in one database is not recommended casue it will take a lot more effort and its very time consuming.

    Do as other member suggest.

  • Rashed Profile Picture
    Rashed 3,765 on at
    RE: Navision Upgrade, Merger of Database

    I suggest to do consolidation instead. You can run your reports based on consolidated company

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Navision Upgrade, Merger of Database

    Every country has different localizations and merging those localizations is always complicated .. It is always recommended to keep localized DB separate.

    For consolidation you can create another DB and consolidate the values

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