<>d )33PLSKUINFO - GET ALL SKUS FOR A CUSTOMER3 " $$56$k@@5U$9TRANSID|CUSTID|WHSETRANSTYPE|PEREND|QTY|SKU|ITEMID|NOTES| D09P@@$o3^1000 "------------ main logic$oop(o4Y$% /customers/$/items?pgsiz=10&pgnum=p &rql=readOnly.deactivated==falseH$mskulist3$&FILENAMEGET3PLC%GET&'$mskurec 'd<$l 3loop through  $ll `y j$/o l Aө3< t @n@nnull   3done 3next page<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$+"
"#F $ C&u013--------- GET RECEIVERS DETAIL FOR A TRANSACTIONu293https://secure-wms.com/inventory/receivers/6639?detail=1u3,3https://secure-wms.com/orders/6523?detail=1uX8$< DELETE FROM ; WHERE TRANSID = '?';ubBMSSQL1SQLPROD.CHAMPLOG.COM WMSReportsDELETE<&ug7MYSQL1 10.1.1.28 wmsreportsDELETE<&u.$%/inventory/receivers/? ?detail=1u. E2!$%/orders/? ?detail=1u3$&FILENAMEGET3PLC%GET&'u$(v#$/.ReceiveItems[۩((]v. E2!$/ .OrderItems[۩((]v $0/U$'1v ' xvR:$*2.ItemIdentifier.Sku,.ItemIdentifier.Id,.Qty,.NotesvW 3*v\6$0/| *U$31" w$3w)$@eEw.$@Iw $@F@A@G@@@K@L@f@gw" 4 D$4D@B?@w7 ө@K|J$JJ۩@K|xP3----- end of cloopx$((vx3----y8y#3---------- get ITEMID and store ity"3.ItemId,.Sku,.Upc,.Description,.ClassificationIdentifier.Name,.Options.PackageUnit.Imperial.Weight,.Options.PackageUnit.Imperial.Length,.Options.PackageUnit.Imperial.Width,.Options.PackageUnit.Imperial.Height,.Options.Pallets.TypeIdentifier.Namey6$;SKUINFOy$(z:$* .ItemId,.Sku,.Upc,.Description,.ClassificationIdentifier.Name,.Options.PackageUnit.Imperial.Weight,.Options.PackageUnit.Imperial.Length,.Options.PackageUnit.Imperial.Width,.Options.PackageUnit.Imperial.Height,.Options.Pallets.TypeIdentifier.Name,.ReadOnly.Deactivatedz;I$W*ClassificationClassWW IdentifierIdz<Z$MRITEMID,CUSTID,SKU,UPC,DESCRIPTION,CLASSNAME,WEIGHT,LENGTH,WIDTH,HEIGHT,PALLET_TYPEz=^$WWOptionsOptWW PackageUnitPkWWImperialz? 3WNMzDN$0.ResourceList[۩(l] | *U$31" zN$33nullzX @n@nnull8{ 3{  @qtrue|8{p $@O@n@P@Q@R@S@T@U{z$@V${$@h@X{$@Y@^@Z@_{$@[@`@\@a{$@]@b{ 4 N$4N@|83----- end of cloop|3----|8UV$+`=$,'WFDIRtmp/m_۩(Өө.jsonj $-) > , 2>&1t(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)~$.$,.,3^1001.B?+3^100.n8 U3--------$1A3LET J=UNT; OPEN (J)"&1"*3READ RECORD(J,SIZ=99999)JQOUT$; CLOSE (J)($)cat & | jq -c '0' U$1+*8@/340000 " TURN TEMPLATED VAR INTO COLUMNS VALUESJ&$ 45,T/ 6N[۩(5]:c(32*)$6 4^$*7h 5r$> 4@8|O$9' >/$9V4@8(Өө4@8A$**@8,779۫ө4@89,*V ;SKUINFOC$: DELETE FROM ; WHERE ITEMID = '۩@c'; X$< INSERT INTO ; (** ) VALUES (77); $j:<1MYSQL1 10.1.1.28 wmsreports=ji#$< H i E28P #2Z&$#|:C(1*=2),n8x]ô #þ$d$d#8(d] !$  $+$< 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$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.CLASSNAMESQLOUT2DOSQLILISTRLIST FILTERNAME RROW.ITEMIDDOPAGEDOPAGE RROW.READONLYDEACTIVATEDCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTgICSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINTϭ12OHEADTRCTRNM13 BACKBUTTONM64TDDC TRCIMAGE ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTM92NBWFDIRDEBUGM10M7 TDDR_GRAYXLFILEYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGJSBFI2JSBFI2STICKYCCNVZYJULZZZTMETATMETADOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEACRFILTER DOFILTERJQOUTZZZ1RROWVIFCOUNTFLISTVALS FLIST.NQTDSQLSTABLESQLFUNCFTYPEDOTID RROW.QTY RROW.ITEMIDENTIFIERSKU VI.TRANSID VI.WHSETRANSPRICECALCIDXIDLISTP CH3PLSKUDOTTYPE CH3PLSKU.SKU CH3PLSKU.QTYSQLOUT1 CH3PLSKU.PERENDSKULISTSKU CH3PLSKU.ITEMID RROW.ITEMIDENTIFIERIDCOLS2S S.ITEMID S.SKU RROW.SKU S.UPC RROW.UPC S.DESCRIPTION RROW.DESCRIPTION S.CUSTID S.CLASSIDCOLSFIX RROW.CLASSIDID 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.CLASSNAMESQLOUT2DOSQLCUSTIDILISTCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT)PLLASTDAYOFMONTHCLEANTPLMAKEINT.OPTPKWIDTH RROW.OPTPALLETSTYPEIDNAME VI.ITEMIDZZZ CH3PLSKU.WHSETRANSTYPE CH3PLSKU.NOTES RROW.NOTES S.CLASSNAMESQLOUT2DOSQLCW1EMPTYBRD1XLCSZCGIVALSUB OUTTAHEREY2MNOWRAPMDYSAVEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT$*<$&$' R F$+ $$!8@3-------- CLEAR CHARGES FROM CH3PL AFTER CLEARING FROM SQL CH3PL"?3----- MAY NEED TO UNBIND INVOICE, REMOVE ROWS FROM SQL CH3PL,,3----- USE BELOW HERE TO REMOVE FROM CH3PL.@3----- THEN USE 3PLC CHARGES SCREEN TO CAPTURE AGAIN. CHECK AXLR$$CH3PLV,.tpl1, W|$?V1VW @i16|( @j  2020-04-30|/@h @i @|FFTPLSUBFUNCCGI ERRORIMAGE TDELEMENTTDPLAIN TDNOWRAPTRTDDTDDHTROTDDRBRYYY1YYY2YYYYYCYYSYYZYYYVTEXTWFCGI FORMNAMEWFPGMTEXT1YYY1YYY2YYYWFCGI1DOYEAR FORMSTARTFORMENDM11 NOSUBMITM12PHEIGHTPWIDTHOHEADTRCTRNM13 DOSOURCEWFDOCYCLE BACKBUTTONM64TDDC TRCIMAGE ERRMESSAGE LASTERRORXLFILESENDTOSUBJECTCCTOMESSAGE SIGNATURERESULTM92NB NOBACKBUTTONWFDIRKDEBUGM10M7 TDDR_GRAYXLFILEDUMMYYYMDYMDY.YJMDYMDY.MMDY.DFFFGGGJSBFI2JSBFI2STICKYCCNVZYJULZZZTMETATMETACH3PLCH3PLDOCUSTURIOUT1OUT2I MYSCALL1COLSOUT3OUTFILEACRFILTER DOFILTERJQOUTZZZ1RROW CH3PL.TRANSID CH3PL.CUSTID CH3PL.CONFIRMEDDATEVIFCOUNTFLISTVALS FLIST.NQTDSQLSTABLESQLFUNCFTYPEDOTID RROW.QTY RROW.ITEMIDENTIFIERSKU VI.TRANSID VI.WHSETRANSPRICECALCIDXIDLISTP CH3PLSKUDOTTYPE CH3PLSKU.SKU CH3PLSKU.QTYSQLOUT1 CH3PLSKU.PERENDSKULISTSKU CH3PLSKU.ITEMID RROW.ITEMIDENTIFIERIDCOLS2S S.ITEMID S.SKU RROW.SKU S.UPC RROW.UPC S.DESCRIPTION RROW.DESCRIPTION S.CUSTID S.CLASSIDCOLSFIX RROW.CLASSIDID 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.CLASSNAME CH3PL.WHSETRANSPRICECALCIDSQLOUT2DOSQLCW1EMPTYBRD1XLCSZCGIVALSUBFORMEND OUTTAHEREY2MNOWRAP REMOVELINKSMDYSAVETITLEPERENDSUBJDOSCALLSPANGETJSONTPLLASTDAYOFMONTHCLEANTPLMAKEINT@o,  $ $  #$$$77,8@/340000 " TURN TEMPLATED VAR INTO COLUMNS VALUESJ&$ ,T/ N[۩(]:c(32*)$ ^$h ٜr$ @|O$' /$V@(Өө@A$@,۫ө@,* dbo.CH3PLq$ DELETE FROM  WHERE TRANSID = '۩@' AND WHSETRANSPRICECALCID = '۩@'; Z dbo.SKUINFOC$ DELETE FROM  WHERE ITEMID = '۩A'; X$ INSERT INTO  ( ) VALUES ();@MSSQL1SQLPROD.CHAMPLOG.COM WMSReportsO$dbo.MYSQL1 10.1.1.28 wmsreports#$GG   89U3^1000 "----- PARAMETERS TO START AUTO ORDER PROCESS$D: 8pt;$ reportparamK$2@
 K$AC $A]$ RO3LET DOCUST$="17"; LET CUSTNOTE$="3PLC Account forced to '17' until production"WL$%f3RESULT1$=""; GOTO 43210 $+8 , utsub.wbb+> SELECTED>#$ $$E$ &$' 9 :$) $B
CustomerC Year+MonthCAssign/BIND Invoice? 

		 + $
8P Z&$|:C(1*=),n8x]ô þ$$8(] !$  $+$< width="۩(">8"], 6! $ @8J]T ^,$ $
h8r]| Ć ĚĐ/$//Ě8Ĥ]Į ĸ$"",8]( $, ۩5$۩ ۩ 8] $ ($ܨ8] $$$ө8&]D N# $TŞS$./X( U M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($U/// @V $@V@Vg$W@V@X@YŔl$T W%Y%Mz%DzŔŀŞŔ $TŞ8Tţ]Ũ< // Ų ż$' 8] ? #pH W$$ WAREHOUSEWHSE TRANSACTIONTRANSP$.,$,||:C(1*),8]8  B3$?L3$?V$ ǜ^$ǜǰn$
SHOWING  B$Excelǰ`$f$ONCLICK ?$)"@$ө'thcolor $#FFFFFFc$