What’s the best practice for adding fields to my own custom table after the customization has been published?
Should I create an extension for my own table or can I generate a script to update the table as if the fields had always been there?
Answer
What is the way to add fields to my own custom table after publishing
Best answer by Naveen Boga
Hi
- If you have an access to the SQL Server, add your fields directly database to that particular table and then go to the customization project → Database Scripts → Click on the RELOAD FROM DATABASE action, so that newly added fields will be added to package.
- If you don’t have an access to SQL Server, then directly you can open the customization projects, and go to the File menu → Edit Project Items → Select the table → then add fields manually in source window and publish the package.
Since I’m a developer I always go with the 1st option.
+19Hi
- If you have an access to the SQL Server, add your fields directly database to that particular table and then go to the customization project → Database Scripts → Click on the RELOAD FROM DATABASE action, so that newly added fields will be added to package.
- If you don’t have an access to SQL Server, then directly you can open the customization projects, and go to the File menu → Edit Project Items → Select the table → then add fields manually in source window and publish the package.
Since I’m a developer I always go with the 1st option.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi
Are there any benefits to the first option that don’t come with the second?
Thanks,
Aleks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.