Skip to main content

Hello,

     Previously, I’ve added a caculation field on shipment, and it is non-persisted.
Now, for reporting purpose, I’d like to make it as a DB persisted field.

      Is there an easy way to do it?


 

@ray20 Just delete the Unbound (NonPersisted field) from that DAC and new field with the same name as a DBTableColumn.

And also, add this field to a particular table in the Database Script section and publish it.


@Naveen B  
Hello, you are right. Just I have no need to add the database script of my own. Acumatica did it for me

below are what the exactly steps:

1, Delete the old “unbound” field and save

2, add a new field, make sure it is the same name as before

choose the DBtablecolumn

save it

 

3, publish the project

 

In this way, you don't have to deal with the screen controls and business logic codes

because the name is not changed.


Yes @ray20 Gald that you successfully changed the field type. 👍👍


Reply