Skip to main content

Notifications

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... / Unsupported field chan...
Small and medium business | Business Central, N...
Answered

Unsupported field change error in Business central

(0) ShareShare
ReportReport
Posted on by Lissa 120

Hello Expert,

I have changed data type for one of the field in few tables in Business central SaaS ( Integer to Decimal). When i try to deploy the new extension it gives me error:

Deployment failed. Errors: App ID : 969d2be9-b824-4fd1-8bf5-681c5f2ebe04 Message : { TableExtension Item Ledger Entry Ext :: Unsupported field change. 
TableExtension Item Ledger Entry Ext :: Unsupported field change. 
TableExtension Sales Line Ext :: Unsupported field change. 
TableExtension Sales Line Ext :: Unsupported field change. 
TableExtension Sales Invoice Line Ext :: Unsupported field change. 
TableExtension Sales Invoice Line Ext :: Unsupported field change. 

I have tried with  "schemaUpdateMode":"Recreate" but still its same.

Any suggestion would be highly appreciated.

Thanks.

  • Suggested answer
    RobbyG Profile Picture
    RobbyG 5 on at
    RE: Unsupported field change error in Business central

    Note: for Sandbox only, as this will delete your table extension data.

    Just had the same issue. This worked for me.  Ensure you can install / debug your solution successfully so it shows up as an installed extension (ie revert to original data type in your code). Once deployed, navigate to installed extensions, Uninstall your extension, when the "Uninstall Extension" window pops, ensure you select "Delete Extension Data" click Uninstall. Then Unpublish. You should now be able to make changes to the data type and redeploy to that environment.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Unsupported field change error in Business central

    When you publish from VSCode with schemaUpdateMode Synchronize then it does not run your upgrade code.

    If you don't care about the data entered into your new table(extension)s then you can change it to recreate and publish again.

    If you do want to keep your data, then you need to use the Powershell command for doing an upgrade as specified in the documentation you linked to.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,637 Moderator on at
    RE: Unsupported field change error in Business central

    Is it a brand new sandbox or do you copy it from production ? Have you published the previous version of the app to production ?

  • Lissa Profile Picture
    Lissa 120 on at
    RE: Unsupported field change error in Business central

    Its Sandbox.. Do we have anything for Sandbox??

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,637 Moderator on at
    RE: Unsupported field change error in Business central

    As of now, there is no way to change the data type once you published the extension to production.

    You will need to create a new field, transfer the old field value to the new field, and tag the old field as obsolete.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 628 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 495

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 395

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans