[jmacdonald]

Hello all,

I am trying to execute some code once a sales order’s status has changed to ‘Billed’. My attempt to do this involved adding the following code to the After Submit function of a User Event script that runs on Sales Orders.

​​​​​​if(scriptContext.oldRecord.getValue({fieldId : ‘status’}) != “SalesOrd:G” && scriptContext.newRecord.getValue({fieldId: ‘status’}) == “SalesOrd:G”){

log.debug(‘Changed’, ‘The Sales Order is now set to Billed’);

}

However after adding some logging it appears that when the sales order is fulfilled and invoiced that the script doesn’t run, I thought the UE script would run any time that the Sales Order was changed/updated but this does not appear to be the case.

So I guess I would like to know if there is a way to fix my current attempt at doing this or if there is perhaps a better way that I could try?
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

The SO will not trigger upon its status change. This is common throughout NS object status changes. Scripting only triggers on the record where the action actually occured, not on any secondary record updates.

You need to put your scripting on the record/event that causes the status change – in this case, the Invoice or Cash Sale creation. You can swim back to the SO if needed by looking at Created From on the Invoice/Cash Sale.

[Author]

Posts