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!

Rookie Asked on September 2, 2020 in SuiteScript.
Add Comment
2 Answer(s)

Hi,

Depending on exactly what you’re looking to achieve the following solution might work:

  1. Create the Custom Transaction Line Field.
  2. Untick “Store Value”.
  3. Navigate to “Validation & Defaulting”.
  4. In “Default Value” enter “{quantity}”.
  5. Tick “Formula.
  6. Save.

Thanks,

 

Chris

Intermediate Answered on September 2, 2020.

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?

on September 3, 2020.
Add Comment

If you’re looking for Sourcing it is not how it works. You can try scripting or with workflow.

Rookie Answered on September 2, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor