Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Entities and Dimensions

(0) ShareShare
ReportReport
Posted on by 95

I have 5 separate legal entities. Can I use Dimensions to account for Multi-Entities in a single data base, or do I need to set up separate environments? If so, what are the Pros and Cons in using Dimensions for a Multiple entity structure? --- gary

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entities and Dimensions

    who was your partner?

    Do they still have the same programming staff on-board?

  • GaryHuggins66 Profile Picture
    GaryHuggins66 95 on at
    RE: Entities and Dimensions

    Thank you Rob.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entities and Dimensions

    Hi Gary,

    For our NAV 2013 implementation we decided to use a single NAV company with Global Dim 1 as Company Code to segregate about 20 legal entities.  With our NAV partner we designed a set of customizations for it and overall it has worked quite well.  Some of the pros we based the decision on were:

    • Reduced data volume, less resources and effort needed from not having to maintain master data, configuration, etc. for 20+ separate NAV companies.
    • The G/L accounts, vendors, and customers are common to all companies, which makes reporting more efficient and streamlined.  And it's great for enabling centralized purchasing and payables.

    The major con would be just needing to customize NAV to get it to all work, which we did in a lot of areas of the system.  The key is building in posting rules which enforce the equality principal of double-entry accounting, so that each legal entity (Company Code) is always in balance.  Another challenge, depending on the business, is security - controlling who can see and post to which entities.  We use a really great NAV add-on for security that has helped us to manage access for a few hundred users.

    One final consideration, which is probably one of the biggest deciding factors between using a Dimension vs. NAV companies, is inventory.  We don't use inventory in NAV and don't plan on doing so in the future, and our Partner recognized that if we did, then a Dimension would probably not be the way to go.  Dimensions and inventory can get really complex even when used in a standard way (speaking from past experience).  So if you use inventory it's something to definitely consider when making your decision.

    Regards,

    Rob

  • GaryHuggins66 Profile Picture
    GaryHuggins66 95 on at
    RE: Entities and Dimensions

    Thank You Raokman

  • GaryHuggins66 Profile Picture
    GaryHuggins66 95 on at
    RE: Entities and Dimensions

    Thank you

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entities and Dimensions

    I asked the same question a while back, I got the following response:

    "In NAV there is the rule of Company = one legal entity. This can be a pain at times, for example when you need a balance (for tax reasons, for instance) by location / office. Most consultants would say "you can do this with dimensions", but that goes only so far. You don't have the balance checking and additional accounting rules with this. And this is where the problems really begin.

    Setting up one legal entity over several companies is even worse transaction-wise, since you need intercompany transactions then and those can't be posted automatically (intentionally). And you have the IC document overhead, mappings, master data problems and so on. Like I told: You can do it in NAV, but you change some base functionality with it, and you're adding complexity.

    And yes, there is no support for this in the base product, any version. AFAIK it is not on the list :(

    with best regards

    Jens (Jens Glathe)"

    More delving into this subject didn't make things look any more hopeful.  To do it right involves a LOT of customization.

    We have multiple companies, retail, distribution, and manufacturing. Should be getting some kind of demo after two years of programming from our 'partners' "soon".  Want to see how we can consolidate a range of companies, retail sector, manufacturing group, ... Haven't seen a lot of RANGE type filters in NAV, everything seems to be "IS", "add another filter?"... Nowhere have I seen selection criteria of the "FROM-TO, THIS" nature other than by adding filter after filter.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entities and Dimensions

    You can setup multiple companies in a single database to account for the legal entities.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans