<>b *33PLINVS - SIMPLE INVENTORY DAILY BALANCES 3CUSTID$ IS SET >3/customers/51/itemaliases?rql=AliasIdentifier.Sku==TESTALIAS1J3https://secure-wms.com/inventory?pgsiz=199&rql=CustomerIdentifier.Id==1093 " %  CID:c(1*=00)$@H109<@@A?$' pagetitle&DAILY INVENTORY REPORT - SIMPLE FORMATB$F$  H$N O'P<$4/customers?rql=ReadOnly.deactivated==false&pgsiz=199SE$1=/inventory?pgsiz=999&pgnum=1&rql=CustomerIdentifier.Id=={cid}Z*$E NEEDRATES1$EsA$td class="td" <>< nowrap>z$     $ 
v$<n, 6$$$ө@@8E]($4CID 4 $41090$D Ө;%Y-%Mz-%DzT01:01:01-$F%Daily Inventory Report - Basic Format 2$

F - Cust ID: 4

<$F
SKU6 Description6Received6On Hand6 Available6  3---------- get inventoryL$S$+1{cid}4"GET3PLC+GET23$5]$-U .ItemIdentifier.Sku, .ItemDescription, .ReceivedQty, .OnHandQty, .AvailableQty, "||"0$,'.ResourceList[۩(5] | -'6 G #SKU|DESC|Received|OnHand|Available|10JQ12,0$G0 . null0null0$GG",; /4/ /XXX1/1xx07/3SKIP ZZ IT TEST@I$өA@INd #$NN۩A@I۩A@JF@E$cdJ $OOܨ@KL $OOܨ@LN $OOܨ@M$55 $SS S d pgnum=۩(S+C$++pgnum=۩(S&pgnum=۩(S& PNd,$QNPdcRNPdEFT$7Q R ۩(OP ۩(OP ۩(OP 0 $7b*P$
3----- end of report4=3LET TEXT$=TEXT$+""- SENDEMAILYESN 3SEND EMAIL$T'DEBUG  3$ `e$YSet email list in /etc/aliases
Append &SENDEMAIL=YES to URL to test the email sending @3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#UE2V$3exit^%,{O_CREATE,O_TRUNC error.msgaE{h{,{ error.msgm1{ @oo{r#( 3OUTTA HERE&'310000 "functions'3string$, token$, delimiter$'$'.$'8 $ 'V'B&$ܨ$'L $'V 8'`]'j 't>$ - $'~ $'a$3IF LEN(Y1$) THEN IF Y1$(LEN(Y1$))="." THEN LET Y1$=Y1$(1,LEN(Y1$)-1); GOTO 10122' 8']' '0$] $ ''+$[ $-' 8']''3$<>  $('i$$ D$'3this check if we need the next seq of the element'$Ө'$( $($ө(8(])`3---- this function loads a template with fields names that macth the xml fragment that is sent) )  ) !$3SET TO UPPERCASE)$ ө ,)/ !N[۩( ]:c(32*)$! )" " ),$# @$"%@&)6"V@$"@$")^*")8)]N 3---------- SEND THE EMAMILN%"$' premailer FORCEMUTTN*$=3plinvs-4N/J$>+dmcguire@champlog.com, chuck@tssconnect.com>>, N4&$?Daily Inventory Report ۩ N6M 4106>$?/Daily Inventory Report - The Pokemon Company - ۩ N>"$3CLEANUP BAD CHARSNH$@AN,WHMAILTO=>?BC@/N1$

Email sent to: =, >N8U)3---- UPDATE THE DEFAULT PALLET AND RATESV,3CALL "3PLSKUPALLET",CID$,RR.ITEMID$,RESULT$W8P  ).Z&$)|:C(1*=.),n8x]'( $' ($(ܨ'8]Ũ Ų өżA$Ө$8]  )8 $) ) $9 )8*,$:)9:: :\8:f]  )W$))$)) WAREHOUSEWHSE)) TRANSACTIONTRANSP$.).,$..,|..|:C(1*),8..]8  )B0$*") *$)* BL0$*') *$)* LLj8)ǒ]DUMMYSEARCHWARNINGCRT RESTSERVICE TDELEMENTTDPLAIN TDNOWRAPTRTDDTDDHTROTDDRBRYYYYYYVCGIPTEXT ERRMESSAGEMESSAGEY1Y2Y3Y0Y1Y2YYYYYZ1TPLZ2Z1FCOUNTFLISTFLOOPFINFO FLIST.NTLEN FINFO.LLYYY1YYY2ZZZZZURIJFILTER JFILTER1ZZZ1RESULTWOUTREST2ITEMS1ITEMS2CIDIROWTHHLZZZZZ1ZZ1 DAYSBACKETABLESENDTOCCTOSUBJECT ATTACHFILEXLFILE SIGNATURE HTMLFILEDSINCE NEEDRATES REPTITLERR CGI.CID RR.SKU RR.DESC RR.RECEIVED RR.ONHAND RR.AVAILABLESKULSKUQISKUDESCPGNUMDEBUGCGIVALFI1SKUGETXFILLXCOUNTELEMENTSYMD2JSUBCLEANTPLMAKETPLGETRTXFILLXCOUNTELEMENTSYMD2JSUBCLEANTPLMAKETPLGETRS[FILLXCOUNTELEMENTSYMD2JSUBCLEANTPLMAKETPLGETRMERWROW JFILTER1ZZZ1RROWRESULTWMS2WOUTREST2YMDITEMS1ITEMS2CIDIROWTHHLZZZZZ1ZZ1 CUSTNAME DAYSBACKETABLESENDTOCCTOSUBJECT ATTACHFILEXLFILE SIGNATURE HTMLFILEDSINCE NEEDRATES REPTITLERR RR.PALTYPE RR.HASRATES RR.ITEMIDONHANDREC1REC2 RR.RECDATE RR.QTYREC RR.CREATED RR.SKUCGIVALFI1SKUGETXFILLXCOUNTELEMENTSYMD2JSUBCLEANTPLMAKETPLGETRm