Workflow Action Update fields

Question

I need assistance developing this workflow. 
 
 What I'm trying to accomplish: 
 When a customer return is created, I need the workflow to look at a TSICOD(1) and if it = 003, I need to update the lines of that return.

The trigger works, so I can assume that the data model I built to go with this workflow is also functioning. 
 The fields I'd like to update are on SRH1: 
 
 When the workflow runs, and the Product TSICOD(1) = 003, I'd like to Update the LOCTYPE to "QCH" and the Location to "QCH000001" 
 I know I need to probably use AWRKUPDFLD or AWRKUPDOBJ but the documentation is very limited out there about how to use them. I've tried using both action codes, as well as the triggering event (start/line/end of workflow) and I just can't seem to get this to update any field what so ever. 
 I could post a screenshot of my current action screen, but by the time someone reads this, I'm sure I've tried several more methods.

Julien Patureau · Accepted Answer

So If I understand the need right, you want to default the location type QCH and location QCH000001 for any products tied to the statistical group 2 TSICOD(1)=003. In that case, I suggest an entire different approach as you can do this with standard configuration: 
 1.Ensure you had a dedicated location category on the product category function (named &lsquo;Customer return for instance): - Create it on LM 2707 (function COMBOS) and don&rsquo;t forget to update - Log out / Log in again - Add it on the related record(s) in GESITG on Management tab 
 2. Then ensure the shipment return management rules use it (GESITG on Receipts tab): 3. Finally set the location type &lsquo;QCH&rsquo; and location &lsquo;QCH000001&rsquo; on the product-site records linked to a product using the 003 statistical group. 
 The result should be defaulting the location QCH00001 for any product-site applying such setup upon customer return. I hope this helps

GerkoT3T · Answer

Hi Nicholas. Using workflow might not be the best approach. You should rather look at a custom script that triggers on the quantity field, where it evaluates the product's statistical code and sets the location.

Nicholas Saint Cyr · Answer

I'll start the testing and implementation of this now, but this appears to be exactly what I need. I'll report back if I have any issues. Thank you for helping me through this.

Sage X3

Workflow Action Update fields

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING