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... / Forgot to add dimensio...
Small and medium business | Business Central, N...
Answered

Forgot to add dimension to customer import

(0) ShareShare
ReportReport
Posted on by Wspares 12

We updated our customer list with about 640 new records using a configuration package. Unfortunately the default dimension codes where not included in this being:

pastedimage1682076666290v3.png

We need this for reporting, especially the mandatory Division dimension. 

I am looking for a quick way to update any customers records (+650 records) with the attached default dimensions? 

Thanks

I have the same question (0)
  • Verified answer
    Cynthia Priebe, MCT, MCP Profile Picture
    Cynthia Priebe, MCT... 203 on at

    It looks like you need to update all the customers with the same dimension information.

    If this is correct, go to the Customer List page

    1. Using filters and Select More, select all the customers missing the dimension information.
    2. Use ALT+Q to find Dimensions-Multiple.
    3. In the page that opens, assign the Dimension Codes, Values and Value Posting you need to add to the selected customers, click OK.

    This will update all the selected records with the default dimension information.,

  • Verified answer
    Earl98 Profile Picture
    Earl98 154 on at

    you can also use config pack to import default dimensions for all the customers (table 352)

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    If you have a developer available they can easily write a procedure that updates this for you at least as long as you want the same value fo all your customers. I would prefer that over the configuration package.

  • Wspares Profile Picture
    Wspares 12 on at

    thanks for the suggestion, the problem i am having with this, is for me to see which customers do not have the dimension information, I would need a separate list and manually select these one by one? I tried checking on the customer list page, additional fields how I could quickly identify those without the default dimensions, but no joy there.  

  • Suggested answer
    Wspares Profile Picture
    Wspares 12 on at

    thanks

  • Suggested answer
    Wspares Profile Picture
    Wspares 12 on at

    noted and thanks

  • Wspares Profile Picture
    Wspares 12 on at

    A question on this one: I have accessed the default dimension config package, and have managed to populate the necessary fields, but when I exported the template, there are 3 fields namely: ParentId, DimensionId, DimensionValueId. They had some sort of string information in them, so, when I add my new information into the dimension fields, can I leave these 3 fields blank and then import the config package?

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,811 Super User 2026 Season 1 on at

    Use this checkmark in configuration Package, that is available in BC.

    pastedimage1682319594009v1.png

  • Suggested answer
    Wspares Profile Picture
    Wspares 12 on at

    Thanks very much, I sorted by date last modified, so that I could see the batch of new customers added that did not have default dimensions, and then used your suggestion above and it seemed to have worked perfectly. Thanks very much!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,161 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,046 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 932 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans