web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Copy Dimensions from M...
Small and medium business | Business Central, N...
Answered

Copy Dimensions from Master Company

(0) ShareShare
ReportReport
Posted on by Hinnack 69

Hello, 

our Company is using a self made Master-Data-Management System.

Now  we want to Copy the Dimension Values from the Master Company to  the receiving Companys. 

There are some Issues with the Dimensions ID. 

Have anyone experience with that Topic ?

Best Regards

  • Suggested answer
    Guy McKenzie Profile Picture
    Guy McKenzie 1,340 on at

    Do you mean Dimension Set ID?

    These are created dynamically by BC each time it recognises a new combination of dimension values.

    I think you may struggle to define these yourself in a second company.

    But then you should be able to build your requirement around this. What you need to copy into the receiving company are the dimension values. I would focus on copying those and letting the ID assignment sort itself out using the standard functionality. 

  • Suggested answer
    Hinnack Profile Picture
    Hinnack 69 on at

    Thanks for you Answer.

    The Dimension Set ID is one of Fields we want Copy.

    Is it not possible to copy them 1-to-1 to the receiving Company ?

  • Suggested answer
    Guy McKenzie Profile Picture
    Guy McKenzie 1,340 on at

    I wouldn’t like to say it’s impossible but it won’t be simple.

    The Dimension Set ID functionality is designed to massively reduce the data footprint of dimension data and thereby improve system performance.

    The dimension sets are managed on the fly by BC and you will run the risk of messing up how it functions which is why it is not easily messed with.

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    You can copy the dimensions and the dimension values. You should not copy the dimension set ID's as they would be unique per company depending on what dimension combinations is in use.

    For copying dimensions and dimension values you can use a configuration package or use edit in excel. I prefer edit in Excel.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,741 Super User 2026 Season 2 on at

    Hi, just adding some info.

    A dimension set is a unique combination of dimension values. So It wouldn't make sense  if you only copy the Dimension Set ID, because those combinations didn't exist in the system.

    More details: 

    https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-dimension-set-entries-overview

    There is no problem with Dimension, Dimension Value, and Default Dimension.

    Hope this helps as well.

    Thanks.

    ZHU

  • Hinnack Profile Picture
    Hinnack 69 on at

    Thanks for you help.

    We dont wanne use the configuration packages. Our MDM have Master Company and all Data like Customer, Vendor, or Bank Accounts should be replicated to the receiving Company.

  • Verified answer
    Hinnack Profile Picture
    Hinnack 69 on at

    Thanks for you Answer. I will have a look at this articel.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 727 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 512 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 321 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans