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

Editable fields in edit in Excel

(0) Share

Report

Posted on by Philj

Hi,

After a recent update of Dynamics Business Central there are a couple of fields in the edit in excel form that are now read only while the field in the card is actually and editable field.

This is in relation to Pricing and Sales in the Item cards. Below is an image showing that the fields are editable:

But when trying to bulk edit in edit in excel the Profit % field becomes Ready Only, error below:

We have also inspected the fields in Excel and not the field is not marked as Read Only as per below:

8321.MicrosoftTeams_2D00_image-_2800_6_2900_.png

Any ideas are much appreciated as we have been able to edit this field in excel for some time.

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (0)

Report

RE: Editable fields in edit in Excel

Hi, when "Price/Profit Calculation" is "Profit=Price-Cost", Profit % can not be edited. Because this value is calculated automatically.

So if you really want to change Profit %, please set "Price/Profit Calculation" to "Price=Cost+Profit" or "No Relationship" first. This is the same on the screen as it is in Excel.

Hope this helps.

Thanks

ZHU
Suggested answer

Vinita_Kas 325 on at

Like (0)

Report

RE: Editable fields in edit in Excel

HI

I checked and Profit % is a calculated field and is read only from the UI as well

So the error you are seeing is correct

Regards

Vinita
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Editable fields in edit in Excel

Moved the question to the Dynamics 365 Business Central forum.
Suggested answer

huijij 19,811 on at

Like (0)

Report

RE: Editable fields in edit in Excel

Hi Philj14,

Suggest you post on Dynamics 365 Business Central Forum for more professional help.

Or you can check the following link to see if it helps:

https://community.dynamics.com/business/f/dynamics-365-business-central-forum/418063/edit-in-excel-data-source-is-read-only