RE: How use a Workflow to update an existing line item when some value

What I need: In a Sales Order, the location of every line item must match the location of the main form. I have already created a Workflow that grabs the main value and add it to th line item when a new line item is added.

BUT I also need to update the line item when  the main value is changed AFTER the line item is already there.

edgarvaldes Beginner Asked on January 7, 2021 in SuiteFlow.
Add Comment
2 Answers

Hi There,

I have a solution based on a scheduled workflow.

  1. Create a saved transaction search that will generate a list of the sales orders that you want to have the line item locations match the main location (master location)
  2. Create a transaction (sales order) workflow that is scheduled – every 30 minutes with the condition being the saved search you created.
  3. Leave your start state blank
  4. Add a second state
  5. Drag a transition arrow from start state (blank) to second state
  6. Click the transition arrow and make the condition the saved search
  7. Click your second state
  8. Add a new sublist group and choose items as the sublist under parameters.  Make sure this action triggers on entry
  9. Create a new action within your sublist action group that sets the field value to location(line) and from field – record (join field) current record then field below that to location (main)

RE: How use a Workflow to update an existing line item when some value

 

RE: How use a Workflow to update an existing line item when some value

 

Every 30 minutes this workflow will reference your saved search list of sales orders and will update the line item location on each sales order to match the master location.

Rookie Answered on November 10, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.