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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How can I edit data in...
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 hkusulja 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

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 123 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.

  • 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,045 Moderator 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.

  • Suggested answer
    JAngle Profile Picture
    JAngle 123 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
    Dallefeld Profile Picture
    Dallefeld 193 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)

  • 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 193 User Group Leader on at
    RE: How can I edit data in Item - Dimension using Edit in Excel

    The easiest is the config pack.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans