Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How can I edit data in Item - Dimension using Edit in Excel

(0) ShareShare
ReportReport
Posted on by 50

Hello,

I am using Dynamics 365 Business Central, v19.3 SaaS and Edit in Excel functionality when need to read or modify lot of data in a table.

I need to put Dimension and Dimension value, on each Item in BC, how can I achieve this using Edit in Excel?

We need to put "Product Group" dimension for all our BC Items, using edit in Excel , as a tool, since lot of products and easier to manage.

Also, is it possible somehow force, when creating a new BC Item, that it requires that Dimension is set, for all our BC Items?

Thank you,

Kind regards

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    The easiest is the config pack.

  • hkusulja Profile Picture
    hkusulja 50 on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    Ok, so you suggest to create a new configuration package and then export to excel, put all data / entries and then import it?

    Is there any other way? maybe somehow force Excel Addon to work with mentioned table directly?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    You use a configuration package to the Default Dimensions table. Even large amounts of data import quickly because there are few fields in the table and even less to import (table id = 27, dimension code, item number, dimension value)

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    Avoiding other means is understandable when it comes to a steep learning curve or extra cost. The initial load of data could also be with a configuration package, which is Excel based and easy to learn. For the automation requirement you will have to look beyond edit in excel.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 995 Super User 2024 Season 1 on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    As Josh Said,

    The only real option you have with out code is edit in excel from the Items standard dimension page.

    But doing it in code will probably be both more efficient and more safe.

  • hkusulja Profile Picture
    hkusulja 50 on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    I have one dimension that is created and it has all dimension values ready.

    Global dimension are not used here, just a regular dimension.

    I need to update, lot of Items, but using excel, not using API or code development. Power Apps is also API :) which i try to avoid

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    Assuming you want to do this for more than just the global dimensions. You will need to use edit in excel for the default dimension page. Depending on your volume of items you might consider doing this through the api instead of edit in excel as you may find the standard page doesn’t expose enough fields to make this practical. This concept could be adjusted so it works on a large cross section of items: joshanglesea.wordpress.com/.../

    The blog as it is written will aid the concept of new items requiring dimensions once created based on pre-existing data from the item record.

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…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans