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

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

(0) Share

Report

Posted on by hkusulja

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)

All responses (7)

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
hkusulja 52 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 225 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
hkusulja 52 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Dallefeld 225 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

The easiest is the config pack.

Was this reply helpful? Yes No