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... / Property editable for ...
Small and medium business | Business Central, N...
Suggested Answer

Property editable for field is invalid on Excel

(0) ShareShare
ReportReport
Posted on by SantiagoM 38

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)
  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,310 Moderator on at

    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

  • SantiagoM Profile Picture
    SantiagoM 38 on at

    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.

    pastedimage1682606640925v1.png

    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 Profile Picture
    Govinda Kumar 2,310 Moderator on at

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

    pastedimage1682609068858v1.png

    Regards

  • SantiagoM Profile Picture
    SantiagoM 38 on at

    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 Profile Picture
    Govinda Kumar 2,310 Moderator on at

    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

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 649 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 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans