Need help with workflow formula please, Related W/...
# manufacturinga
Adam K
08/20/2020, 2:34 AMNeed help with workflow formula please, Related W/O from Sales Order, backward scheduled and want to set the W/O end date = S/O shipdate -14, i.e. W/O enddate to be set to 14 days prior than the S/O ship date. all attempted formulas getting the error 'You have entered an Invalid Field Value ERROR: Invalid Expression for the following field: enddate'
d
daniel_w
08/20/2020, 8:02 PMwhat formula are you currently using?
a
Adam K
08/20/2020, 10:38 PMtried everything from to_char to nlapi type of formulas, all still had same error
d
daniel_w
08/21/2020, 4:42 PMcreatedfrom field does not appear to be an accessible join from the W/O -- there's your issue
daniel_w
08/21/2020, 4:42 PMYou could try creating a workflow that is applied to both S/O and W/O, storing the S/O Ship Date in a Workflow defined field to be accessed in a later state for the W/O
daniel_w
08/21/2020, 4:42 PMbut probably less complicated to script it
a
Adam K
08/23/2020, 11:28 PMthanks Daniel will give it a go.