I have been writing some customizations, and I have tried adding new columns to database tables in two different ways.
The first way involves creating UDFs inside the Customization Project editor.
The second involves direct modification of the database table at the SQL Server level.
In either case, we seem to be able to create a PXCache extension that can properly reference the field by its name, as long as we are working with the DAC attached to that table.
The obvious downside of method #2 is that there is no mechanism to keep track of these database modifications, unless some sort of patch file apparatus is created by the developer to ensure those columns are created when a new instance is installed or possibly upgraded. There is also the possibility of a naming collision if the developer uses a name for the column that Acumatica subsequently creates in a future release (future column collision).
I vastly prefer method number 2 due to its simplicity. However, as I am currently using it, it is hard to keep track of these changes over time as more column additions are made.
Does anyone have any suggestions on adding and tracking column changes to the database? I find UDF’s to be annoying, because of the forced usrxxxx naming convention and also because I find it annoying to manage these fields through the Customization Project editor, versus through SSMS and Visual Studio.
Does anyone have any suggestions for a future proof way to manage these database changes without having to use the Customization Project editor and UDF’s? It would be good/fine if the database changes were apparent in the Customization Project editor, I would just prefer not to have to manage them there.
