Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Forgot to add dimension to customer import

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

  • Suggested answer
    Wspares Profile Picture
    Wspares 12 on at
    RE: Forgot to add dimension to customer import

    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!

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    RE: Forgot to add dimension to customer import

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

    pastedimage1682319594009v1.png

  • Wspares Profile Picture
    Wspares 12 on at
    RE: Forgot to add dimension to customer import

    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
    Wspares Profile Picture
    Wspares 12 on at
    RE: Forgot to add dimension to customer import

    noted and thanks

  • Suggested answer
    Wspares Profile Picture
    Wspares 12 on at
    RE: Forgot to add dimension to customer import

    thanks

  • Wspares Profile Picture
    Wspares 12 on at
    RE: Forgot to add dimension to customer import

    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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Forgot to add dimension to customer import

    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.

  • Verified answer
    Earl W Profile Picture
    Earl W 117 on at
    RE: Forgot to add dimension to customer import

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

  • Verified answer
    RE: Forgot to add dimension to customer import

    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.,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans