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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
SantiagoM 38 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
SantiagoM 38 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No