Navision Upgrade, Merger of Database

(0) Share

Report

Posted on by Community Member 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

All responses (5)

Answers (0)

Suggested answer

Roberto Stefanetti 12,998 on at

Like (1)

Report

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 6,071 on at

Like (1)

Report

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 6,578 on at

Like (1)

Report

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 3,765 on at

Like (1)

Report

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 18,694 on at

Like (1)

Report

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