Skip to main content
Solved

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


Forum|alt.badge.img+5
  • Captain II
  • 398 replies

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?


 

Best answer by Naveen Boga

@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
Did this topic help you find an answer to your question?

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • May 6, 2021

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


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • May 8, 2021

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • May 8, 2021

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings