Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Multiple companies + multiple localisations?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are on our way expanding to first country abroad (a new company there). Naturally follows the question how to set up NAV.

Same database and multiple companies would seem reasonable for three reasons:

  1. No need for licenses, or only need for smaller number of new licenses
  2. Same changes to NAV would work straight away in all companies (ok, not probably that much of benefit, but small)
  3. Ease for users: in back office employees could easily change between companies within NAV when doing the same tasks in all companies or whole company group.

Now we have been discussing with different NAV software vendors - many of them seem to think that it can require much work to set up multiple localisations. Instead they are suggesting a new clean install - into a newer version.

Out of accounting perspective this seems odd - shouldn't NAV check the country code of the company and automatically fetch the right setup or definitions. So only import new localisation tables etc and start running the business? Ok, few new reports may be required?

???

*This post is locked for comments

  • PhilDOakley Profile Picture
    PhilDOakley 222 on at
    RE: Multiple companies + multiple localisations?

    BC looks the same as Nav in the regard of multiple localisations. I have seen that the mappings for the overlapping code units etc can be performed but given the scale of work and the issues with upgrades it looks like it is not financially viable. The only option is to install multiple BC systems on separate servers. One installation/localisation for each country. Then the consolidation is a mine field in SaaS but might be better in on prem. The whole concept of companies requiring an ERP solutions that will be rolled out for all their office around the world seems to have escaped MS in the BC context. BC is a hindrance to this concept rather than a solution. If anyone has successfully merged two or more localisations into one installation I would like to know how and what happens with upgrades and patches.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple companies + multiple localisations?

    Noticed this old thread of a topic currently in my interest:

    Is this case the same with the MS Business Central?

    So there should be separate DB's for different localization packages?

    Looking for a solution which is planned to have one DB, but separate Companies for different countries.

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Multiple companies + multiple localisations?

    Hi,

    as a rule of the thumb any country specific localization requires a separate database. I understand what you're saying about system 'knowing' which localization to use, but the truth is that localisations are developed separately and might clash if you try to apply two different country localisations to the same DB.

    If the localization is the same (for example UK and Ireland, or Belgium and Luxembourg) then there is no problem in running the same DB and different companies, where the difference is only in setup (for example VAT). Otherwise it is still technically possible but depends on the amount of localisations for the country(ies), for example, merging French and Portuguese localisations might be very tricky from the development point of view.

    Also, if there are any special characters in the language, you need to consider that as well as there is a compatibility issue in displaying foreign characters (some work fine, again depends on the countries you're talking about).

    Robertas

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Multiple companies + multiple localisations?

    It's better different DB.  If you are planning to customize one db to fit all localizations, you may end up in a mess.  Moreover, if you are planning to upgrade in future, it would be nearly impossible.

    The upgrade toolkit differs on localization.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Multiple companies + multiple localisations?

    May be you need to study the localizations and based on that need to take decision.

    Posting routines will be same with required/different conditions according to localizations need and it is not just VAT as it may have other taxes also which is built in localized DB with required parameters.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple companies + multiple localisations?

    Thank you for fast reply!

    I am just wondering that both countries follow very similar regulations and eg. posting routine should be very similar - of course VAT codes or VAT percents are different but otherwise. Still huge customization needed?

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Multiple companies + multiple localisations?

    Each country has different localizations and based on that MS provides different database for those country . Accommodating localizations in one DB means it requires huge customization and it is not easy to import the objects as it uses common posting routine

    So It is always good to have localized DB for the country you are going to work.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans