web
You’re offline. This is a read only version of the page.
close
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.

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    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.

  • Lissa Profile Picture
    Lissa 120 on at

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

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

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

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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
    RobbyG Profile Picture
    RobbyG 5 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans