How to extend Attribute field length

Hi @woodyg84  By default, Acumatica will allow us to enter 255 characters and if we wanted to make the field to allow unlimited characters we need to make the changes at the code level and database level to increase the field length. Please find the code and SQL script for the same.

  public class InventoryItemMaint_Extension : PXGraphExtension<PX.Objects.IN.InventoryItemMaint>
  {

[PXAttributeValue]
      [PXUIField(DisplayName = "Value")]
      //[CSAttributeValueValidation(typeof(CSAnswers.attributeID))]
      [PXPersonalDataFieldAttribute.Value]
      public void CSAnswers_Value_CacheAttached(PXCache sender)
      {
      }
      #endregion
      internal class PXAttributeValueAttribute : PXDBStringAttribute
      {
          public PXAttributeValueAttribute() : base()
          {
              IsUnicode = true;
          }
          public override void FieldUpdating(PXCache sender, PXFieldUpdatingEventArgs e)
          {
              if (e.NewValue is DateTime)
                  e.NewValue = Convert.ToString(e.NewValue, CultureInfo.InvariantCulture);
              base.FieldUpdating(sender, e);
          }
      }

}

ALTER TABLE CSAnswers ALTER COLUMN Value [nvarchar](Max) ;