ࡱ> GRoot Entry/} `W/ReportHeaderSnapshotHeader vSnapshotData ! M$%&'()*+,-./0123456789:;<=>?@ABCDEFIJKLHRoot Entry/} )!W/ReportHeaderSnapshotHeader vSnapshotData ! "MN$%&'()*+,-./0123456789:;<=>?@ABCDEFIJKLHOPQRSTUVWXYZ[\]^_`abcdefghijklmnContents\/SummaryInformation(#FDocumentSummaryInformation8ArmfaaaaAaaaaadaAaaaaaaaGc8x ReportPreview dEAtRepFrAtPattrnAtBorder AtPowerQueryAtQColc1AtExpr Item Number4) AtDbCol Mim ItemnoCOMMPUBLICMINVMAST MIM_ITEMNO Item NumberBv8P(BN c2 Description 14] Mim Desc1COMMPUBLICMINV6.0.334.19d>[P:\Installation and Training\VMMS VIEW for Web\VMMS INVENTORY COST AND QTY REPORT v 1.5.IMR"P:\VIEW 1.5.0 Catalogs\Vmms150.cat%..\..\VIEW 1.5.0 Catalogs\Vmms150.cat4Contact COGNOS Customer Support;VMMS INVENTORY COST AND QTY REPORT v 1.5.IMR;,VMMS INVENTORY COST AND QTY REPORT v 1.5.IMRm MIM_ITEMNO MIM_DESCMAST MIM_DESC15 Description 1Bv80(~t c3 Quantity On Hand4E<ifnull-numericp Mim QtyohCOMMPUBLICMINVMAST MIM_QTYOHQuantity On Handr0qBv8л(!P c4  Conversion Factor43 Mim ConvfactCOMMPUBLICMINVMAST MIM_CONVFACT Conversion FactorBv8(`_ c5$$ Unit of Measure4_ Mim UmCOMMPUBLICMINVMASTMIM_UM7Unit of MeasureBv8@(T c6&&(( Product Category4- Mim ProdcatCOMMPUBLICMINVMAST MIM_PRODCATProduct CategoryBv8(pY, c7** Store Number4 Msl StorenoCOMMPUBLICMSTORE MSL_STORENO Store NumberDKz8@*% c80088 Average Cost4e<ifnull-numericp Mis AvgcostCOMMPUBLIC MINVSTORE MIS_AVGCOST Average Costr0qGKz8`;+& c9@@HH Last Cost4d<ifnull-numericp Mis LastcostCOMMPUBLIC MINVSTORE MIS_LASTCOST Last Costr0qGKz84+(Q c10JJPP if ( Unit of Measure = '1'-&p AtQRef4_1q'pEAq(&p )4_2q'pLFTq(&p )4_10q'pCASEq(&p )4_7q'pBDLq(Lz8@)Jt c11XX`` Extended Inventory Value )4e! )4EMz8+` c12hhpp &Total (Extended Inventory Value) No.3*p ).qPz8 ,,L c13xx &Total (Extended Inventory Value) No.2*p ).qPz8, c14 Stocking U/M Value Extensionp )4E )43q )4e!80h) c15  Bin Location 14 Mis Binloc1COMMPUBLIC MINVSTORE MIS_BINLOC15Bin Location 1 8`*G ; New Expression )4E0 )4e!0 AtFormObjAtFormFr Page HeaderFCAtTextFrText Frame 2 2K AtTextTxtDate: AtTextSysGeneralArial"!CAtRect Rectangle 1&TCJTitleXN4Inventory Cost & Quantity Report by Product CategoryTimes New Roman"!-ReportQColMediatorCE Page Footer_CS Rectangle&cCJText Frame 3 15gNPage PArial "!:/\vCE Report BodynCAtListFr List Frames AtDetailJ Item Numberx AtTextVal\ &Arial " Item Number vJ Description 1{\&Arial "  Description 1 vJQuantity On Hand{\)*))()00Arial "!Quantity On Hand vJBin Location 1{\=&Arial "!Bin Location 1 vJConversion Factor{\ )  ) - ) 0Arial "!Conversion Factor vJ Text Frame 2M{\'&Arial "! U/M vJ Last Cost{\$ ) *$) ) ($) *$)Arial "! Last Cost vJ Text Frame 1{\. ) *$) ) ($) *$)Arial "!Inventory Value Extended vJ Text Frame {\8 ) *$) ) ($) *$)Arial "! Stocking U/M Value Extension vJ Average Cost{\! ) *$) ) ($) *$)Arial "!Average Cost EProduct Category HeaderdCJ Text Frame 3:NProduct CategoryArial "0CJProduct CategoryC{\&Arial "!X\EProduct Category FooterdCJText Frame 2 1/NSubtotal for Product Category {\&Arial "0y CJ&Total (Extended Inventory Value) No.30{\2 ) *$) ) ($) *$)Arial "" \E List FooterdCJ&Total (Extended Inventory Value) No.20{\5 ) *$) ) ($) *$)Arial ""y\AtColumnTitles Column titles AtTitleFr Item Number 1AtTextColTitlewArial "wDescription 1 1~Arial "~Quantity On Hand 1怄Arial "Bin Location 1 1怊Arial "Conversion Factor 1怐Arial "if ( Unit of Measure = '1'M怖Arial " Last Cost 1怜Arial "Extended Inventory Value怢Arial "Stocking U/M Value Extension 怨Arial "Average Cost 1怮Arial "\\\ds==F_nBMPLibCObListo `􌐂d;LE(d;$E1Quantity On Hand  MIM_CONVFACTMIM_UM MIM_PRODCAT MSL_STORENO Average Cost Last Costif ( Unit of Measure = '1'Extended Inventory Value&Total (Extended Inventory Value) No.3&Total (Extended Inventory Value) No.2Stocking U/M Value Extension  Oh+'0F ( 4@0@@V/@ Jack BlovitsGPEPE(d;$E  !"#$%&'()*+,-./0123456789:;<=>?@A6.0.334.19d> \P:\Installation and Training\VMMS VIEW for Web\VMMS INVENTORY COST AND QTY REPORT v 1.5.IMR#P:\VIEW 1.5.0 Catalogs\Vmms150.cat&..\..\VIEW 1.5.0 Catalogs\Vmms150.cat@qs\P:\Installation and Training\VMMS VIEW for Web\VMMS INVENTORY COST AND QTY REPORT v 1.5.IMR  Contact COGNOS Customer Support A 2290 15 1940 Bin Location 1 3 0 Stocking U/M Value Extension 2 0 Total (Extended Inventory Value) No.2 2 0 Total (Extended Inventory Value) No.3 2 0 Extended Inventory Value 2 0 if ( Unit of Measure = '1' 3 1892 Last Cost 2 1893 Average Cost 2 1951 Store Number 2 1837 Product Category 2 1887 Unit of Measure 3 1843 Conversion Factor 2 1861 Quantity On Hand 2 1885 Description 1 3 1833 Item Number 3 MIS_BINLOC1 ՜.+,D՜.+,l(  4 $,   F0H `0C8@@AHBp |!&D