Skip to main content

Notifications

Announcements

No record found.

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... / Edit in Excel - Change...
Small and medium business | Business Central, N...
Suggested answer

Edit in Excel - Changes made to read-only fields will be reverted

(0) ShareShare
ReportReport
Posted on by DinB 3,812

I opened a General Journal Batch with 4 rows using "Edit in Excel" function. I added two rows in between by copying them from the first 2 rows. I changed the Line number. When I click on Publish, I get following warning message "Changes made to read-only fields will be reverted, Continue?". I clicked on "Yes" and it does add the new rows in General Journal Batch in BC. What is the meaning of that error. Also, how can I see the "Line No" column in the General Journals Page in BC? it is not available in Personalization --> "+Fields" List.

pastedimage1684020719934v1.png

Thanks in advance.

  • Suggested answer
    Ramiz Profile Picture
    Ramiz 507 on at
    RE: Edit in Excel - Changes made to read-only fields will be reverted

    Hi,

    "Changes made to read-only fields will be reverted, Continue?" means there are some fields that are read only. The Editable property is false for those field like EU 3-Party Trade, so you cant modify that.

    If you change the value in excel for a read only field, it wont be updated. That's why the warning appears.
    pastedimage1684149743090v1.png

    In order to add Line No on General Journal Page, you need to create a page extension.

    layout
    {
        addafter("Posting Date")
        {
            field("Line No."; Rec."Line No.")
            {
                ApplicationArea = All;
            }
        }
    }

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Edit in Excel - Changes made to read-only fields will be reverted

    Here it works even if I enter the data manually.

    I do not have to drag the like you do.

  • DinB Profile Picture
    DinB 3,812 on at
    RE: Edit in Excel - Changes made to read-only fields will be reverted

    Thanks, when I add new rows at the bottom it does not update in BC when I click on "Publish". The update works however if I drag the blue corner handle to the bottom shown in screenshot below. But I get that same warning about Read Only fields.

    pastedimage1684081846646v1.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Edit in Excel - Changes made to read-only fields will be reverted

    When you want to insert lines using edit in excel you should not insert them in between existing lines in your worksheet.

    Put them in the bottom of your excel sheet even though you use primary keys that would place them in the middel of existing rows.

    After you publish and refresh your data they will be sorted correctly.

    You can can see the line numbers using page inspection CTRL+ALT+F1.  If you want them to permanently show in the Business Central page. You will either needs to wait a couple of months until Microsoft release an announced change where all fields will be available through personalization or you will have to do it in AL Code.

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans