Update field datatype after publishing DAC Extension

Question

I have created a customization which contains DAC extension. There are few extra fields added to Stock Item screen (InventoryItem table). After publishing, the customer had a requirements for one of the field to change its datatype from string to bool. I did updated in customization and published it. However, it did not updated in database. As a result it was throwing an error. Is there anything I am missing here? Please suggest.

if you open the XML of your customization, what is the column type in your Sql tag for the field you are referring to? Does your column name start with "Usr"? — Brendan

Patrick Chen Patrick Chen · Accepted Answer · 2016-09-21T17:17:35

Acumatica doesn't delete columns out of the database as a result of a change in your customization. You have two options here, you can drop the column via SQL command and publish, or more realistically, you can just create a new UDF with a different name and change your code.

Update field datatype after publishing DAC Extension

1 Answers