web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    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... 14,050 Super User 2025 Season 2 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... 14,050 Super User 2025 Season 2 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,710

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,675 Super User 2025 Season 2

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans