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

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

(0) Share

Report

Posted on by DinB

3,944

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.

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ramiz 597 on at

Like (0)

Report
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.

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; } } }

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
DinB 3,944 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No