<>Ck '3JBINVRP6 - Storage Analysis Report -- "I$6$,6 JBBRANDS.tpl16,6,6JBBRANDS 7,+$R1:C(7),R2:C(10),R3:C(1),R4:C(30),R5:C(30),R6:C(30),R7:C(30),R8:C(25),R9:C(2),R10:C(10),R11:C(6),R12:C(3),R13:C(7),R14:C(1),R15:C(30),R16:C(15),R17:C(3),R18:C(4),R19:C(20),r20:c(7)<@@FE " 7$ $$,JBPLANnnJ$ 100 100 100 100   sA$td class="td" <>< nowrap>z$!  0$;'TRHILITE"
$< Period Ending!Brand! Description! Rate Type! Locations!Percent of Total4$:
$:

۩' pagetitle

$=%
۩' REPORTINTRO :5
<E$>
 <$?%
:۩' REPORTINTRO
۩' REPORTINTRO :
 =<5$@
 ?A'Bo$*gT7 ) BRANDFAMILY^h3test if exists^#(3on step1h#(b$deCfD INVPROGRAM WJBREPORT3DECFG L=  L> C LC?XV3----------generate the report into the JBOPIN file with "000000" as the period ending2JBOPIN3JSLOTJ1JIM001000000Y!3OPEN THE JBOPIN FILE AND PROCESSS$R$SRTJBOPIN,RT.tpl1R,R U,,RT/1SJ1JIM001000000---001U$Z@X$31SJ1JIM001000000---002U$ZZ@X)1S*/0 Z%$YYTotal Pallets=0 lL 3LOOP HERE`1SlUj% UJ1JIM001000000l& 7 716A@V 7 @V--- $@5Total$[$[@XZd$\([####.00%F$] @W001$]Normal @W002$]Oversize@;$Current@V@5]۩(@X\L$  L;! CLC;$BB BALC@$B#$-./01L U 3------ 16A@4 77$
Select Report Parameters
۩@5L$&  L;(" BALC@$B0! CLC;$BB58: U 3------?18I9D-$I - ۩@JN!L $X L ;Z" BALC@$Bb) C!LC ;$BBg8l3DONEv$
{L$}  L C LCC JBREPSUMMARY$H~Reports Menu
?$ H
E
Exceptions:
Y
#(UC$ Total۩($*8 ,U 3--------------- PRINT THE PROGRAM TOTALS  L ^$LTotals۩(M۩(N۩(O۩(P۩(Q L$   L; ! CLC;$BB  BALC@$B 1L $ - %L  9 C1LC $BB  BALC@$B #$MNOPQ 8 T-3^100 "end of brands reached go back for more 8@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE&N N!E ө/$//N"8N#]N  N!$ $N+$< width="۩(">N8N]N N! $ O8O]O O,$ $
O8O#]O$ O& O,O(1$//20O,8O-]O8 O:$"",O<8O>]OB#$%OC( $$$, ۩$OD5$#۩$ ۩% OE8OF]OL OV$$+$+ө)@O`8+Oe]O  KO3$ colspan="۩(K">O8O]4$ 
 #$ * H3CALL "JBSELECTOPTIONS","BRANDFAMILY","BRANDFAMILY","","1","",0,RESULT1$%A$29This report shows the current warehouse usage statistics.* $ 2E$  &$ [ - K$ 3
$ ~8%3 STEP 2 SELECT BRANDS and DivisionsO$ Brand Family: @3 
 o$*g?$**3#$ *
Select Report Parameters
Brand(s)
JBSELECTOPTIONSJBBRANDSBRANDSCATDESC*FILTERMASK(R.FAMILY$,"@3%")*MULTIPLE*NOTOPVALUE*SELECTALL*AUTH2 $ 20f3CALL "JBSELECTOPTIONS","JBDIVS","DIVS","DIV","RNAME","*MULTIPLE*NOTOPVALUE*SELECTALL*AUTH",0,RESULT1$:3LET TEXT$=TEXT$+RESULT1$E$  &N$  /$ ' - I$ 1$ 
f8TPLHJBPLANJBITEMTRTDDTROCDATETEXT1 ERRMESSAGECW1CW2CW3CW4YYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRDQTYIDENT1OCOUNTDCOUNTRQTYLCSVCHANCSVLINKCSVFILEOUTCHANOUTLINKOUTFILETEXTTDDHBRYYCYYSYYZWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLTATCTBTSTVRESULT1 CGI.BRANDFAMILY JBITEM.RICBRAND JBBRANDS.DESC JBBRANDS JBBRANDSJBDIVSJBDIVSH2BFTRPLAIN COLHEADTR REPHEADHTML REPHEADXL REPHEADPDF REPBREAKPDFPDFLEN PDFCOUNTPDFCHANSDESCENDMENUPDFLINKPDFFILESUBMENUDIVS1 JBDIVS.RNAMEYYY LASTPROGRAMPALLOCPSHTOTPCOMDPBOPZZTOTCJBOPINFJBOPIN JBOPIN.BRAND JBOPIN.SHTABLEJBOPIN.PALLETS RESULTS1PTOTPERCPERC RATEDESCCW1BREMPTYD1 DEALERTOTALSXLCSZCGIVALDD1 BRANDHEADER DIVHEADER TRCOLSPANPROGRAMTOTALS-vput type="submit" name="SUBMITREC" value="GO">$'' f8TPLHHJBPLANJBITEMTTTQCCCQIQCOUNTTRTDDTROCDATETEXT1 ERRMESSAGECW1CW2CW3CW4YYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRDQTYIDENT1OCOUNTDCOUNTRQTYLCSVCHANCSVLINKCSVFILEOUTCHANOUTLINKOUTFILETEXTTDDHBRYYCYYSYYZWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLTATCTBTSTVSHIRESULT1 CGI.BRANDFAMILYJBITEM CGI.BRANDS JBITEM.RIC JBITEM.RICBRAND JBITEM.RICDESC JBITEM.QTYORDALLOCBO JBITEM.RICPACKD1D2 ORDERLISTOHDRCVADJRDATE1 LSHIPDATESHIDIVSHITER SHIORDERFILTERQTYORD LASTBRAND JBBRANDS.DESC JBBRANDS JBBRANDSJBDIVSJBDIVSH2BFTRPLAIN COLHEADTR REPHEADHTML REPHEADXL REPHEADPDF REPBREAKPDFPDFLEN PDFCOUNTPDFCHANSDESCENDMENUPDFLINKPDFFILESUBMENUZZTOTSHTOTSHRAPIDBRANDSDIVS1USEKNUM LASTDIVS1 JBDIVS.RNAMEYYYCOMDSHDROP JBITEM.STATUSCMT INPROCESS LASTPROGRAM JBITEM.RICPROGRAMPALLOCPSHTOTPCOMDPBOPZZTOTCW1BREMPTYD1 DEALERTOTALSXLCSZCGIVALDD1 BRANDHEADER DIVHEADER TRCOLSPANPROGRAMTOTALS