<>M 933PLSKUBAL - GET SKU BALANCE AND RECEIVE DATES BY ITEM ID3"3 [.ResourceList[].OnHand] | add* " $!56223589!2356@@($3565U$9TRANSID|CUSTID|WHSETRANSTYPE|PEREND|QTY|SKU|ITEMID|NOTES| .09P@@$13^1000 "------------ main logic4\$"#/inventory/stockdetails?customerid=!%&facilityid=1&rql=itemidentifier.id==2H$0skulist3$#FILENAMEGET3PLC"GET#$$0skurec $d<+$+[.ResourceList[].OnHand] | addU $3, `)$+.ResourceList[].ReceivedDateU j$4," t 4 $54 ~> 4 /$64Ө 466 <3done#(@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#V$" YE2^ ERRORPAGE3-------- EMAIL ERROR MESSAGE+$'WFDIRtmp/000_last_error.txt,O_CREATE,O_TRUNC=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩# LE$$' error_email(JBMAILTO@ }$ q
Order is not valid. Click and fix the problem(s).#(U39000 OUTTA HERE#<$3TEXT$=TEXT$+"
"+DEBUG$+"
"&UV$'`=$('WFDIRtmp/0_۩(Өө.jsonj $)& > ( 2>&1t(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)~$*$,*(3^1001*B?'3^100*n8 U3--------$,A3LET J=UNT; OPEN (J)"&1"*3READ RECORD(J,SIZ=99999)JQOUT$; CLOSE (J)($&cat # | jq -c '+' U$,'*8P  -Z&$ |:C(1*=-),n8x]ô  þ$/$/ 8(/] !$  $+$< width="۩(">8"], 6! $ @8J]T ^,$ $
h8r]| Ć ĚĐ/$//Ě8Ĥ]Į ĸ$"",8]( $, ۩5$۩ ۩ 8]  $   ($   ܨ 8] $$ $ ө8 &]D  N# $ŞS$./X(  M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($/// @ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ]Ũ< // Ų  ż$  ' 8 ] ? #pH   W$  $  WAREHOUSEWHSE  TRANSACTIONTRANSP$- .,$--,|--|:C(1*),8--]  *)$Ө4$ %Ml %YH8R]˄  ˎ,$  "  '˘$  \ˢ8 ˬ] 5$ ӨM$ $ %Y%Mz Ө  $ %Y%Mz%Dz8 ]`3SCAN THRU CUSTOMER %Z/STARTING CUST ID: %( 3PLSKUINFO(%<*%TPLCGI TDELEMENTYYY1YYY2YYYYYCYYSYYZYYYVTEXTYYY1YYY2YYY ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1OUT3OUTFILEAC DOFILTERJQOUTZZZ1 CH3PLSKUZZZ FILTERNAMEDOPAGEITEMIDONHANDRECSREC1REC2CW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT@i.]  *)$Ө4$ %Ml %YH8R]˄  ˎ,$  "  '˘$  \ˢ8 ˬ] 5$ ӨM$ $ %Y%Mz Ө  $ %Y%Mz%Dz8 ]`3SCAN THRU CUSTOMER %Z/STARTING CUST ID: %( 3PLSKUINFO(%<*%TPLCGI TDELEMENTYYY1YYY2YYYYYCYYSYYZYYYVTEXTYYY1YYY2YYY ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEAC DOFILTERJQOUTZZZ1RROWSTABLEXIDLIST CH3PLSKUCOLS2SCOLSFIXZZZRLIST FILTERNAME RROW.ITEMIDDOPAGEITEMIDONHANDRECSREC1REC2CW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT:IŞS$./X(  M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($/// @ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ]Ũ< // Ų #ż$##' 8#] ? #pH  #W$##$## WAREHOUSEWHSE## TRANSACTIONTRANSP$2#.,$22,|22|:C(1*),822]  *)$"Ө4$ "%Ml %YH8R]˄  #ˎ,$##"##'˘$##\ˢ8#ˬ] 5$ӨM$$ %Y%MzӨ  $ %Y%Mz%Dz8 ]`3SCAN THRU CUSTOMER (Z/STARTING CUST ID: (( 3PLSKUINFO((<*(FTPLCGI TDELEMENTYYY1YYY2YYYYYCYYSYYZYYYVTEXTYYY1YYY2YYYDOYEAR ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTDEBUGYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGYJULZZZDOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEACRFILTER DOFILTERJQOUTZZZ1RROWVIFCOUNTFLISTVALS FLIST.NQTDSQLSTABLESQLFUNCFTYPEDOTID RROW.QTY RROW.ITEMIDENTIFIERSKU VI.TRANSIDXIDLIST CH3PLSKUDOTTYPE CH3PLSKU.SKU CH3PLSKU.QTYSQLOUT1 CH3PLSKU.PERENDSKULIST CH3PLSKU.ITEMID RROW.ITEMIDENTIFIERIDCOLS2S S.ITEMID S.SKU RROW.SKU S.UPC RROW.UPC S.DESCRIPTION RROW.DESCRIPTION S.CUSTIDCOLSFIX RROW.CLASSIDNAME S.WEIGHT S.HEIGHT S.LENGTH S.WIDTH S.PALLET_TYPE RROW.OPTPKWEIGHT RROW.OPTPKHEIGHT RROW.OPTPKLENGTH RROW.OPTPKWIDTH RROW.OPTPALLETSTYPEIDNAME VI.ITEMIDZZZ CH3PLSKU.WHSETRANSTYPE CH3PLSKU.NOTES RROW.NOTES S.CLASSNAMESQLOUT2DOSQLRLIST FILTERNAME RROW.ITEMIDDOPAGE RROW.READONLYDEACTIVATEDITEMIDONHANDREC1REC2CW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT ONTHCLEANTPLMAKEINT