<>>6 ;3WHREP22 - Inventory Inquiry -- Report - W/ITEM FILTER - JL %3--- CLEANUPS 3/2016 RCC (WAS WHREP2)$SOL007 SOL001 SOL008 S$7$$8JCUSTL7,78.tpl17)7,78 M)$S$7$$8JITEMN7,78.tpl17)7,78 O)%W$7$$8 JITEMSUPPz7,78.tpl17)7,78 {)&S$7$$8JILOTf7,78.tpl17)7,78 g)'W$7$$8 PSDISPLAYp7,78.tpl17)7,78 q)(S$7$$8JIACT7,78.tpl17)7,78 )<@@A.$Tn T$T&CUST1BZ1LJ1TM\N$~ SOL0T2$~##/CtnTotal Eachesb" TSAMPLE/GOC001/.nJ$ 100 100100100   sA$td class="td" <>< nowrap>z$  {H$5
$5

Inventory Inquiry: T - @]

 $'TRHILITE$> 
&$e$?@ItemDesc Comm
CodeLoteBooke On
HandeCom'deAvaileDamageeHoldeDamage
Com'deExpected
ReceiptseSKU  [ TK$?@ItemDesc Comm
CodeLoteBooke On
HandeCom'deAvaileDamageeHoldeDamage
Com'deExpected
Receiptse)Average Usage
per Month
Last 12 MoneSKU  $@%
58
 YH?:$A
 H? !$  $+$< width="۩(">8] ! $ 8]  M$9
 9)$9 98] ,$ $
8]   1$//20 8 ] $"",8]"!"##( "$", ۩"$5$!۩" ۩# %8&]'  (F$9  9,$9
9()8*], 6$$($(ө&@@8(E]J  JK" J$J NL$$JJ۩J20JM/$JJ/J/JN8JO]TO^3IF FIELD(CGI$,"CUSTCODE",ERR=0350)<>"" THEN GOTO 0400; REM test if existsY#(3on step1^I &FILTER+$&FILTER3test if existsh 3GOTO 0400#(*$Von 0OFF@ $VoffD &show0off $Voff @on $Von? &WFDIR"$'WFDIR&WFDIR? &WFURL"$'WFURL&WFURL? &WFCGI"$'WFCGI&WFCGIY$$$ tmp/item_list۩(Өө.xls,O_CREATE,O_TRUNC$Ө/clg$@  LA$%%>i$;<=*+,-.p\$ !

Item Report by Cust: T
K

 z$QJ1T1NQ 3LOOP HEREL1NlOQ1 % ө@RV OQljf PDT001' WEBSECUREl< *۩O *' WEBSECUREt@$ $@&$ (۩(@ $###,###.00) 3DO SELECTION! Voff@W@X" utencode.wbb@Rod$^ @R  *$i @hY$i   =$r q q1pA@R q$r@s.$@t@R$@u@S@vA@wCLpq$y@u$y@S3 PER RANTER 9/25/08/$|qSKU SKU@H0$A@R0p$( ###,###,##0 1zO۩ {" @}$|@}@$ ~/$۩(@۩(@W@ ###,###,##0 TU$^yr ۩(@W@X@i۩(@Wi۩(@Yi۩(@W@Yi۩(@Xi۩(@i۩(Ө@Zii|  T$^yr ۩(@W@Xi۩(@Wi۩(@Yi۩(@W@Yi۩(@Xi۩(@۩(Ө@Zi۩( ####.00##|  $x$x.$bb@W@X@cc@Wdd@Y,$__@W@Y``@Xaaܨ@Z( $@-$ l2 @hYxnLx&3^100 "------ handle the JILOT display}$i1fO-1fg gO0$g 0p$( ###,###,###* Voff @j@k@) utencode.wbbg z$ g  %$ ~$ii%$ T $i$۩(@j@ki۩(@ji۩(@li۩(@j@li۩(@ki۩(@i۩(Ө@mi  $[^yrg  ۩(@j@ki۩(@ji۩(@li۩(@j@li۩(@ki۩(@i۩(Ө@mi  8%3^100 "----------- DUMP LINE TO FILES$$GG [$[ x@hY L>۫[$[8 U 3------ 13A@1 46$
5P
@2 $&8l3DONE $
$$GG  L $6
F \on #(UC$  Total۩( $*8 $3------ handle the display of orders ($2Report Totals ۩(b۩(c۩(d۩(_۩(۩(`۩(a $$GG *3F CSVCHAN THEN WRITE (CSVCHAN)FNNOBR$(L$)  ELE$DD  DCLEB$D 8 H3^1000 "---------- dump the htm version for display with horizontal menu $ Von $Voff$Von 3LET TEXT$=""+HMENU$+"
Toggle Zeroes "+SHOW0$+"
"+$0A$ 3$ n XXX_CNA001$


~$m
 $/ * - O3TEXT$=TEXT$+""+$0A$ V3TEXT$=TEXT$+""+$0A$ V3TEXT$=TEXT$+""+$0A$ V3TEXT$=TEXT$+""+$0A$ L$; $
Item FilterToggle Zeroes V(   Excel Export
 0$ 3DONE #($I"8H$/     z8@3T=$ ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE#_  ccalamari'$sesrec#7$ 

۩
۩"
 &'U'$'/ DOLOT$AӫDOLOT '!$J1T@R'$1'%'.1*'8 *'B @SA'.'L3$@$ 'VA$ %Yz%Mz%Dz$(Ө00'W3 DUMP ; RELEASE '` '.'j $@'t'.*U8.)3---- GET TENTATIVE RECEIPT ITEM/LOT TOTS.S$7$$8JTRDE7,78.tpl17)7,78 ).$/D10 /N @M/D/$A@ ۩A@ /<$ $۩ //.$ @/!$ Aө( /1 @$@/3GATHERITEM TOTS0/D0 3DONE0 0f80p3GET TENTATIVE VALUE0z($$ 00$0$ 08N N*E ө/$//N48N>]y y"*$9 9 $99 y,)$093SET TO "9" OR ":"y68yr]y| y0$9lܨ Ө0y8(9y]y y $y/$//y8z]$: reportparamD$
 p$d
D3CALL "POPUPINPUT",FORMNAME$,"fromdate",JUL(0,0,0)-14,"",RESULTFROM$ B3 CALL "POPUPINPUT",FORMNAME$,"thrudate",JUL(0,0,0),"",RESULTTHRU$*i3LET TEXT$=TEXT$+TRPLAIN$+"Ship Dates
If Shipped Selected:"+TDD$+RESULTFROM$+" Thru "+RESULTTHRU$+TRO$/K3CALL "JBSELECTOPTIONS","JBPLAN_STATUS","JBPLAN_STATUS","","","",0,RESULT1$4#$>Status:/ >p$> Customer:3 ] &hmenuon>$- F$' Q$>1$ 
Select Report Parameters
~83 STEP 2 SELECT BRANDSO$Brand Family: @0 
 #$'3CALL "JBSELECTOPTIONS","JBBRANDS","BRANDS","CAT","DESC","*FILTERMASK(R.FAMILY$,"""+CGI.BRANDFAMILY$+""")*MULTIPLE*NOTOPVALUE*SELECTALL*AUTH",0,RESULT1$ $/N$ /F$' I$1
$ f8  $9 9($99ܨ8]8 B$ L$ V$  ǜ^$9999ǜǰn$9
SHOWING  9B$Excel999ǰ`$9999f$9ONCLICK 9?$)"999U3LET YYY=POS(STBL("thcolor")=YYY$); IF YYY THEN LET YYY$(YYY,7)="#FFFFFF"; GOTO 51160}$9#003300 9]$9#FFFFFF3" Hardedcoded because 51160 was getting ERR 49 - J.L. 5/23/2011c$9