Loading ...

Acumatica Modification Existing Tables With Prefix Usr

Hello everybody,

today just a short hint. In case if you want to add some column in Acumatica DB, you should start field from usr prefix. For exaple if you want to add field Payrollcat, you should name it UsrPayrollcat. If you'll not use this advice, next update of Acumatica will remove your field, and you'll be very sad.

For example you can use following template of code:

IF EXISTS (SELECT * FROM SYS.columns WHERE name = N'UsrPayrollcat' 
and object_id = OBJECT_ID(N'PRPayrollDetails')) BEGIN PRINT 'EXISTS' END ELSE BEGIN Alter table PRPayrollDetails ADD UsrPayrollcat nvarchar(1) NULL PRINT 'Column UsrPayrollcat was created' END GO

Enjoy

 

Ready to take your Acumatica customization to the next level? Whether you need to add custom fields like UsrPayrollcat or implement more advanced features, our team is here to help! Don’t let your customizations get lost in an update—let’s build solutions that are both effective and future-proof.

📩 Leave us a customization request today and let’s tailor Acumatica to fit your unique business needs. Your perfect solution is just a click away!