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?
Answer
Is there a way to change customization field from "NonPersistedField" To "DBTableColumn"?
Best answer by Naveen Boga
And also, add this field to a particular table in the Database Script section and publish it.
+19And also, add this field to a particular table in the Database Script section and publish it.
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.
+19Yes
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.