Skip to main content
Business Central forum
Suggested answer

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

editSubscribe (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

Attachments
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG 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 11,415 UG 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 33,131 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 32,714 Super User 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 33,131 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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans