web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

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... / Re: Make Custom fields...
Small and medium business | Business Central, N...
Suggested Answer

Re: Make Custom fields as editable through Edit in Excel function and Posting of Additions

(7) ShareShare
ReportReport
Posted on by D365 Business Centr... 164
I have two Custom Field in Fixed Asset List Page as Original Cost and Original Amount. I try to update the values using Edit in Excel function. But, BC shows as Error : 'Control 'OrginalAcquisitionAmount' is read-only.
 
How to make these two fields as editable using excel ?
 
I need to post Fixed Asset additions entries. By default I cant find FA Posting Type as addition.
 
Can any one guide me on these two ? 
Categories:
Microsoft Dynamics NAV
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,766 Super User 2026 Season 1 on at
    Hello,
     
    Your custom fields are read-only because they’re not marked editable in your AL code.
     
    In your page extension, set Editable = true; for those fields and republish.
     
    For FA additions, post through FA G/L Journal with FA Posting Type = Acquisition Cost.
     
    Regards,
    Oussama Sabbouh
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Dynamics 365 Business Central: How to add custom fields in Edit in Excel | Dynamics 365 Lab

    Best Regards
    Gerardo

  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,732 Super User 2026 Season 1 on at
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at
    Hi,
     
    Edit in Excel:
    The Excel add-in respects page metadata. If the fields are non‑editable on the Fixed Asset List page, they will be read‑only in Excel.
    Note: if the fields are calculated/derived, don’t edit them, post via journals instead.
    Fixed Asset additions:
    Use FA Journal or Fixed Asset G/L Journal with FA Posting Type = Acquisition (that’s the standard “addition”).
    For bulk loads, use Edit in Excel on the FA Journal or a Configuration Package, then post.
    Do not try to update “original cost/amount” directly if those are meant to be set by acquisition postings.
     
    Thanks
    Rishabh
  • Suggested answer
    Aman Kakkar Profile Picture
    Aman Kakkar 2,977 Super User 2026 Season 1 on at

    Hi,

    You may need to check with the developer(s) whether the fields that you’re trying to modify are marked as Editable = true in the custom code, or if there are any validations applied to those custom fields.

    Fields that are non-editable in Business Central cannot be updated through Edit in Excel, because Business Central enforces the same validations and field properties during the save process—just as it does within the application.

     

    Hope this helps.
    Aman K

  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 5,420 Super User 2026 Season 1 on at
     
    If the custom fields are not editable using edit - in - excel . Please verify below things 
     
    1) Set properties of Fields in Table - Editable = True 
    2) Set properties of Fields in Page - Editable = True
    3) Check you have proper rights in permission set for the table
    4) Can you edit in Page before editing in excel
    5) If you can edit in page then check once excel-addin permission set in your profile
    6) You can also ask a super user to verify by editing in excel
     
    This link will also help you . Please check my answer 
     
     
     
     
    Regards
    Pallavi Phade
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans