RE: Custom Transaction Line Field to source Line Quantity on load
Hi, I’m trying to create a custom transaction field called “old quantity”. Basically I want to source this field from the line’s quantity upon Editing a transaction (before user makes any changes on the item lines). I tried to search for “quantity” in the Sourcing & Filtering tab of the custom field but I can’t see it. Is this possible to do without scripting? Thanks!
Hi,
Depending on exactly what you’re looking to achieve the following solution might work:
- Create the Custom Transaction Line Field.
- Untick “Store Value”.
- Navigate to “Validation & Defaulting”.
- In “Default Value” enter “{quantity}”.
- Tick “Formula.
- Save.
Thanks,
Chris
Thanks! This is what I hoped to achieve but somehow it’s not working. The Default Value field has a note which says:
Note: Formula references to item option fields are not supported.
Which is probably why?
