Hi All,
This is basically just a curiosity. We noticed that Acumatica automatically pads the InventoryCD field out to the maximum length in the database. We have the standard nvarchar(30) datatype for this key, so we typically have 15-20 characters of trailing whitespace.
Is there a reason that this is the default functionality? It isn’t a really big deal since I can clean strings downstream, but it seems like an odd choice to me for a key field.
Since it’s so easy to “fix” this, it seems like there must be a reason why they haven’t. Does anyone know if this feeds other functionality?
Thanks,
Aaron