The reference field on the inventory transfer is limited to 30 characters and it is part of a data view. How can I extend the length that this field allows? The underlying field in the PartTran table is an X1000 so it shouldn’t be a problem that I can see.
Yeah, you would think this would be simple but… I remember running into this on another form once. In that case, even when I was able to change the underlying dataview - there was still program logic that would throw an error when I exceeded the format indicated. (Ugh, collections… one of my biggest pet peeves in general).
FWIW… one idea off the top of my head…
- Add a textbox to the form & bind to a callClientBpmData field.
- Then via a BPM, TBD if possible to copy the callClientBpmData value to the PartTran.TranReference?
Thanks for the idea. I just love it when simple problems turn into big hassles…
Yeah…
I’ve often thought it would be interesting to have a “top 10 pet peeve” topic.
The little things we run into over and over… just so I’d have an idea if “it’s just me” or something common to all users.
Anyway, collection constraints are definitely on my list.
@rfarnsworth @bordway I know this is an older post but our users are now asking for the Inventory Transfer Reference field size to be increased. With Kinetic layers I see that I can change the size of the TranReference column on the InvTrans view. I can also update the Max Length of the Reference field Text Box or change the Reference field to a Text Area. I am just wondering what issues I will run into down the road. @rfarnsworth did you end up increasing the size of this field?
I believe we just ended up living with the 30 character limit. Sorry.