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
The easiest is the config pack.
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?
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)
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.
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.
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
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.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156