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

Property editable for field is invalid on Excel

(0) Share

Report

Posted on by SantiagoM

Hi,

when I try to edit the amount of a line of a general journal in excel and I publish it, an error message appears saying:

"A row created in the General_Journals_Excel dataset was not updated. Error message: "Property "Editable" for amount is invalid. [( not px70377860px70377860CoreVisibility ) or ( px70377860px70377860SelectedValue )]"

We have extended the General Journal page in code and added a condition to the editable property for the amount field, which is "Editable = (not X) or (Y);". (X = CoreVisibility and Y = Selected Value)

In Business Central, this field is editable, but when editing in Excel and publishing, the error occurs. I have assigned false to X and true to Y variables throughout the code to ensure that it is always true and editable, but it still does not work.

however, the problem seems to be another one, since I have even tried the following expressions

"Editable = (true) or (true)"

"Editable = (true)"

and it doesn't work either.

but if I set "Editable = true", it works.

could someone help me? thank you

All responses (5)

Answers (0)

Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (1)

Report

RE: Property editable for field is invalid on Excel

I think you can submit your issues or any ideas for Business Central on the Dynamics 365 Application Ideas Portal, it's a platform designed for providing feedback and suggestions. I assume Microsoft reviews these submissions regularly and takes them into consideration.. here's the link

https://experience.dynamics.com/ideas/categories/list/?view=Hot&viewId=39dc31bb-34a9-e911-a991-000d3a4f3343&forum=e288ef32-82ed-e611-8101-5065f38b21f1&category=4e96aa66-ad39-e911-a978-000d3a4f3343&mf=#tabHot
Regards
SantiagoM 17 on at

Like (0)

Report

RE: Property editable for field is invalid on Excel

Let me ask you one more thing, this is my first time in this forum.

I understand that this would be an error. Do you know if there is a way to contact someone from microsoft or where to post this so it can be resolved?

thanks
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Property editable for field is invalid on Excel

Hi Santiago,

You are right, I have also tested with multiple possibilities and boolean conditions, but its not working in Excel..the only only expression work in excel is 'Editable=true' however, all the other expression are working fine in the user interface on the page level but throwing error when publishing with excel.. Out of curiosity, I have even checked it for my custom table and page, but still, it's not working. I don't know what could be the reason, but it's okay, and thank you for helping me learn something new, at least..

Regards
SantiagoM 17 on at

Like (1)

Report
RE: Property editable for field is invalid on Excel

Hi, thank you for your reply

just to clarify that this happens in OnCloud environments and I am using the following option from the general journals in Business Central.

you can replicate this same situation with this simple code:

pageextension 50100 "Ext General Journal" extends "General Journal" { layout { modify(Amount) { Editable = (true) or (true); } } }

it is not necessarily important, but organizing the whole team and programming these expressions always keeping in mind that an error can "happen" when editing in excel without the code itself being incorrect is something maybe "annoying" or "inefficient". I don't know what word to use.

Thanks again
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: Property editable for field is invalid on Excel

The boolean expression for editable property works in the user interface you're right, but I have never checked it in Excel, if you are unable to edit and publish through Excel even after trying multiple different conditions like you said above, then it may be the better option to simply set the Editable property to 'true', however if its important for you to put the boolean conditions for your field then you can provide me with the specific page ID and field sc, I can quickly double check it in my environment

Regards