If we change the length of a standard Acumatica field, is there a risk that the field length will be reverted back on the database with an upgrade? Causing the extra characters to be truncated?
Answer
Is there a risk in extending field lengths?
Best answer by ErickLasimin
Based on my experience, there will be no issue when upgrading to later version. However, one thing that you will need to take note is during the restoration of the snapshot to your own test environment.
Since your snapshot contains elongated fields, it will trigger an error during the restoration of the snapshot. This can be easily addressed by running a simple SQL script to elongate the field itself in the DB, or by publishing the customization before restoring the snapshot (never tried this method, but theoretically it should work).
Based on my experience, there will be no issue when upgrading to later version. However, one thing that you will need to take note is during the restoration of the snapshot to your own test environment.
Since your snapshot contains elongated fields, it will trigger an error during the restoration of the snapshot. This can be easily addressed by running a simple SQL script to elongate the field itself in the DB, or by publishing the customization before restoring the snapshot (never tried this method, but theoretically it should work).
I have encountered issues when publishing customisations prior to restoring snapshots.
However, it might work if you publish changes only to the DB.
Aleks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.