Is it possible via WF or Script on the Sales Order...
# general
t
Is it possible via WF or Script on the Sales Order - if Printed Picking Ticket field is changed from F to T to set a transaction body field checkbox? Not sure where that field is accessible - wondering if anyone had any insight?
m
Can you display the value in a saved search?
t
Need it as a stored value
e
But is the field available / visible in the UI of the Sales Order?
s
SuiteAnswers 70993
m
I was just saying if the field can be found/visible in a saved search then you can make a saved search with the criteria you want and use that as the condition to set another field value or trigger a transition. But probably that's what the articles Sam and Edgar are sharing say
s
Pick ticket is a referenced record of Sales order, so use a custom field in SO to and source the field value from the pick ticket - in theory 🤔
t
I just want to set this new field as a criteria in the print picking ticket list. We don't want picking tickets to be printed multiple times in the case of partial shipments.
@MGBC So if I set a scheduled workflow that runs 30 minutes after the Printed Picking ticket goes from F to T to set a custom field on the SO then I should be good?
m
Yes that would work
t
Does it have to be scheduled?
m
You could try to setup the action to work using the Print event type but I am doubtful that will work. I have not gotten the print event to properly trigger a WFA in the past and plus you are printing the pick ticket not the actual transaction so that may have different results too. But you could try it this way https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4103803818.html#bridgehead_4156684652
Otherwise, it would have to be scheduled since no edit/save event is happening