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

Best way to change table schema?

(0) ShareShare
ReportReport
Posted on by 358

I have extended the sales line table with a new field that is type integer. Uploaded this extension to the customer's tenant and the customer has been testing it having a test company. Before the customer start's using the solution for an actual live company, this field that is extended needs to be made into a decimal. Business Central would not let me change the type.

Is the solution here is to just uninstall and unpublish this extension and create a new AL project with Sales Line having a decimal field and upload a new extension? I am assuming the Sales Line table will lose the values of my extended field? Since it is testing company it does not matter. Is this the approach I should take?

Thanks for the advice..

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,306 Super User 2026 Season 1 on at

    Did you upload this to production ? If you already upload this to production, there is no way to change the field.

    You need to mark that field as obsolete, and create a new field and use that new field in your extension.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 569 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 375 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 228 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans