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?
If you’re looking for Sourcing it is not how it works. You can try scripting or with workflow.
