Solved

Is there a way to change customization field from "NonPersistedField" To "DBTableColumn"?


Userlevel 5
Badge +2

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?


 

icon

Best answer by Naveen B 6 May 2021, 13:54

@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.

View original

3 replies

Userlevel 6
Badge +4

@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.

Userlevel 5
Badge +2

@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.

Userlevel 6
Badge +4

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved