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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Editable fields in edi...
Small and medium business | Business Central, N...
Suggested Answer

Editable fields in edit in Excel

(0) ShareShare
ReportReport
Posted on by Philj 4

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:

 0334.png

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

78206.png

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.

I have the same question (0)
  • Suggested answer
    huijij Profile Picture
    huijij 19,813 on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

    Moved the question to the Dynamics 365 Business Central forum.

  • Suggested answer
    Vinita_Kas Profile Picture
    Vinita_Kas 336 on at

    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

    pastedimage1652914554659v1.png

    Regards

    Vinita

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 102,361 Super User 2026 Season 1 on at

    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.

    pastedimage1652921777610v1.png

    pastedimage1652921796726v2.png

    pastedimage1652921849580v4.png

    pastedimage1652921860671v5.png

    pastedimage1652921962871v6.png

    Hope this helps.

    Thanks

    ZHU

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 647 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans