gabyrdzlobaton
08/20/2021, 4:19 PMal3xicon
08/23/2021, 2:11 PMAB
08/23/2021, 3:45 PMRJMNS
08/23/2021, 11:00 PMNetsuite Tragic
08/24/2021, 12:52 AMCASE WHEN {systemnotes.field} = 'Printed Picking Ticket' AND {systemnotes.newvalue} = 'T' THEN '1' ELSE {systemnotes.field} END
which works for the most recent System Note. Once any other note goes onto the sales order then the above formula no longer provides the result. I feel it needs an ORDERBY {systemnotes.date}
in the formula but I cannot get that to work. Any SQL tips? (the Saved Search results option "When Ordered By Field" doesn't work for this.Josh_SatoriReporting
08/24/2021, 3:54 PMal3xicon
08/25/2021, 4:44 PMSEND EMAIL ALERTS WHEN RECORDS ARE CREATED/UPDATED
box checked, because the "update" isn't taking place on the expense report itself - the status is being updated by another processtexmc
08/25/2021, 7:41 PMtexmc
08/25/2021, 7:41 PMGregory Jones
08/26/2021, 8:38 PMKevinJ of Kansas
08/26/2021, 9:52 PMKevinJ of Kansas
08/26/2021, 9:52 PMKevinJ of Kansas
08/26/2021, 9:52 PMKevinJ of Kansas
08/26/2021, 9:53 PMKevinJ of Kansas
08/26/2021, 9:53 PMKevinJ of Kansas
08/26/2021, 9:53 PMGregory Jones
08/26/2021, 11:57 PMJ-Mack
08/27/2021, 1:22 PMDaniel Lloyd
08/30/2021, 5:26 AMDean Gardner
08/30/2021, 8:53 AMGregory Jones
08/31/2021, 3:48 PMSuitestallion
08/31/2021, 4:49 PMKnotKnick
08/31/2021, 7:47 PMThomas
09/01/2021, 11:59 AMBen Goligowski
09/01/2021, 10:33 PMREGEXP_INSTR({custrecord_acs_certificate_item}, '^115479$|^115479(?=\,)|(?<=\,)115479$|(?<=\,)115479(?=\,)')
Ahmed
09/02/2021, 11:52 AMLaura
09/03/2021, 8:42 PMAxel
09/06/2021, 8:43 AMGregory Jones
09/08/2021, 12:18 PMNetsuite solutions
09/09/2021, 12:16 PM