Hello Everyone,
We have specific requirement to increase the TaxZoneID length from size 10 to 30 from TaxZone table.
Since, this field is having dependency with many table fields, unable to modify the length and giving SQL error is ALTER TABLE ALTER COLUMN taxzoneid failed because one or more objects access this column..
I know that we can drop the Foreign Key relationships and make it work but I don’t think this proper way of doing in Acumatica database. Hence posting this question here and seeking for help.
Can you please help me with this?