Skip to main content

Notifications

Announcements

No record found.

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

Property editable for field is invalid on Excel

Posted on by 17

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

  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    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 Profile Picture
    SantiagoM 17 on at
    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 Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    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..

    pastedimage1682609068858v1.png

    Regards

  • SantiagoM Profile Picture
    SantiagoM 17 on at
    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.

    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,203 Super User 2024 Season 1 on at
    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans