CribMaster 5cjRAu9Ue83hXc1sZwC3P8Nwc6Fie0uBQWFNrGNE4y/fbFMrxkqr9UV30YR3TLEjx3j5z8hqc6TxTqGY8QSsY8YS3cteXcP1clz92GNcJT/RamkJYhiT3X1u/ZjqBGVP48iJDNdZ+sVFTYTsaVxlKsJa+yncdfr5TRnNmE5U CribMaster DeadstockDetail CribBin,System.String Crib,System.Int16 Bin,System.String Item,System.String BinQuantity,System.Int32 Quantity,System.Int32 OnOrder,System.Int32 StopOrdering,System.Boolean OrderNowQuantity,System.Int32 ForceOrder,System.Int32 OrderPoint,System.Int32 OverrideOrderPoint,System.Int32 Maximum,System.Int32 OrderQuantity,System.Int32 OverrideOrderQuantity,System.Int32 AvgLeadTime,System.Int32 OverrideAvgLeadTime,System.Int32 MaxLeadTime,System.Int32 OverrideMaxLeadTime,System.Int32 MonthlyUsage,System.Int32 OverrideMonthlyUsage,System.Int32 SafetyStock,System.Int32 OverrideSafetyStock,System.Int32 UsageThisMonth,System.Int32 BinCapacity,System.Int32 MinOrder,System.Int32 StockFromCribBin,System.String DateLastCount,System.DateTime DateLastIssue,System.DateTime DateLastReceipt,System.DateTime CountType,System.Int32 PendingRework,System.Int32 OverrideDefaultQty,System.Int32 Consignment,System.Int32 OverrideIssuePrice,System.Decimal TotalValue,System.Decimal TotalPrice,System.Decimal StationAutoPurchase,System.Boolean CriticalPoint,System.Int32 IsSurplus,System.Boolean ExcessFloor,System.Int32 OverrideExcessFloor,System.Int32 ExcessQuantity,System.Int32 BinType,System.Byte StationCheckOutTimeLimit,System.Int16 Station_AddDate,System.DateTime Station_AddUID,System.String Station_UpdateDate,System.DateTime Station_UpdateUID,System.String StorageSpace,System.Int16 CribSpaceId,System.Int32 PrimaryCribBin,System.String AutoDelete,System.Boolean FIFOTrackingOption,System.Byte OvrAltVendorNo,System.Int32 TransfersIn,System.Int32 TransfersOut,System.Int32 ReservationAddQty,System.Int32 ReservationMinQty,System.Int32 StopIssue,System.Boolean OvrCycleCountClassNo,System.Int32 DateLastRecalculated,System.DateTime StationLotNo,System.Int32 UnitWeight,System.Decimal ConsignedQuantity,System.Int32 ConsignedPrice,System.Decimal BurnQuantity,System.Int32 ConsignmentOption,System.Byte UnitWeightQuantity,System.Int16 ScaleCapacity,System.Int16 UDFPriceUpdateFlag,System.String Station_x0020_Comments,System.String Description1,System.String Description2,System.String Price,System.Decimal MonthToDate,System.Decimal YearToDate,System.Decimal WeekToDate,System.Decimal MonthlyRedFlag,System.Decimal YearlyRedFlag,System.Decimal WeeklyRedFlag,System.Decimal LastYear,System.Decimal ShortDesc,System.String AccessCode,System.String VendorNumber,System.String ItemType,System.Int16 ItemClass,System.String ReworkedItemNumber,System.String UPCCode,System.String Serialized,System.Int32 Manufacturer,System.String MfrNumber,System.String DefaultQty,System.Int32 UseInPlantQuantity,System.Int32 IncludeReworked,System.Int32 Special,System.String Restricted,System.Int16 ReceiveNewAsRework,System.Int32 AllowMaintenance,System.Byte TrackUsage,System.Boolean ItemStatusCode,System.String CheckOutTimeLimit,System.Int16 AllowOvrTimeLimit,System.Byte TrackLotNumber,System.Boolean CINo,System.Int32 ClassNo,System.Int32 CIRevision,System.Int32 CINumber,System.String LinkCINumber,System.Boolean LinkCIDescription1,System.Boolean LinkCIDescription2,System.Boolean NoInterSiteTransfers,System.Boolean ItemStockFromCrib,System.Int16 UseCheckList,System.Boolean BuyerGroupID,System.String Inventry_AddDate,System.DateTime Inventry_AddUID,System.String Inventry_UpdateDate,System.DateTime Inventry_UpdateUID,System.String ItemFODControl,System.Byte AltVendorNo,System.Int32 RequiresInspection,System.Byte CertifiedSystem,System.Int16 CriticalItemOption,System.Byte Locked,System.Int16 InactiveItem,System.Boolean CycleCountClassNo,System.Int32 IssueUnitOfMeasure,System.String AutoScrapOption,System.Byte Inventry_x0020_Comments,System.String ItemNumber,System.String COST,System.Decimal AssemblyBin,System.String TransfersValue,System.Decimal PriceType,System.Int16 Name,System.String CribType,System.Int16 User1,System.Int32 User2,System.Int32 LabelPrinterName,System.String CribArea,System.String SiteID,System.String ReturnToCrib,System.Int16 AlertEMailAddress,System.String CribOrderType,System.Byte CribStockFromCrib,System.Int16 CribTelephone,System.String TransferInPackageSize,System.Boolean RequireWOForIssue,System.Boolean EnableSiteTransfers,System.Boolean CribCheckOutTimeLimit,System.Int16 OrderReviewOption,System.Byte TrackSpaceOption,System.Byte PrimaryCrib,System.Int32 ItemCentricOption,System.Byte BinTypeOption,System.Byte AutoDeleteOption,System.Byte CribVendorNumber,System.String CribVendorOption,System.Byte Crib_AddDate,System.DateTime Crib_AddUID,System.String Crib_UpdateDate,System.DateTime Crib_UpdateUID,System.String CribFODOption,System.Byte NextSeqBin,System.String DeviceComputerName,System.String Crib_x0020_Comments,System.String 30 DeadstockDetail CribMaster pLastIssue,_x0022_1_x002F_1_x002F_2014_x0022_,31,0 pSiteID,_x0022_DEFAULT_x0022_,23,0 SELECT STATION.*, STATION.Comments as 'Station Comments', INVENTRY.*, INVENTRY.Comments as 'Inventry Comments', VITEMCOSTWITHBOM.*, VASMBLYTFRADJVALUESBYBIN.*, Crib.*, Crib.Comments as 'Crib Comments' FROM ((STATION STATION LEFT OUTER JOIN INVENTRY INVENTRY ON STATION.ITEM=INVENTRY.ITEMNUMBER) LEFT OUTER JOIN VASMBLYTFRADJVALUESBYBIN VASMBLYTFRADJVALUESBYBIN ON STATION.CRIBBIN=VASMBLYTFRADJVALUESBYBIN.ASSEMBLYBIN) LEFT OUTER JOIN VITEMCOSTWITHBOM VITEMCOSTWITHBOM ON STATION.ITEM=VITEMCOSTWITHBOM.ITEMNUMBER INNER JOIN Crib on STATION.Crib = Crib.Crib WHERE (STATION.DATELASTISSUE IS NULL OR STATION.DATELASTISSUE<@pLastIssue) and SiteID = @pSiteID AND {vConsignment} ,Dates,Dates,Transaction_x0020_Date_x0020_Range,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031_0_x005F_x002F_1_x005F_x002F_2012_x005F_x0020_12:00:00_x005F_x0020_PM_x002C__x005F_x0034__x005F_x002F_1_x005F_x002F_2013_x005F_x0020_12:00:00_x005F_x0020_PM,False,False,False ,vConsignment,vConsignment,System.String,_x0028_1_x003D_1_x0020_or_x0020_Consignment_x0020__x003D__x0020_1_x0029_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,7.42,10.22,0.3 None;[65:65:65];1;Solid;False;4;Black Transparent True 9.4,0.08,0.8,0.2 Gray 50%_Page_Footer Arial,10 a0e98f61103a42958f065003c96d75c6 Right 0,0,0,0 Text37 {PageNofM} [0:0:0] Expression None;[65:65:65];1;Solid;False;4;Black Transparent 0,0.08,1.4,0.2 Gray 50%_Page_Footer Arial,10 0,0,0,0 Text39 {Time} [0:0:0] Expression PageFooterBand1 Transparent 0,0.2,10.22,0.6 None;[65:65:65];1;Solid;False;4;Black Transparent 0,0.3,8.4,0.2 Gray 50%_Report_Title1 Arial,14,Bold Center 0,0,0,0 Text38 Site ID: {DeadstockDetail.Parameters["pSiteID"].ParameterValue} | Last Issued: {DeadstockDetail.Parameters["pLastIssue"].ParameterValue} | Consignment: {Switch(vConsignment == "(1=1 or Consignment = 1)", "All Items",vConsignment == "(Consignment = 1)", "Consignment Only",vConsignment == "(Consignment is null or consignment = 0)", "Non Consignment Only")} [0:0:0] Expression None;[65:65:65];1;Solid;False;4;Black Transparent 0,0,8.4,0.3 Gray 50%_Report_Title1 Arial,14,Bold eeaefb61341a406895f97e44b7d7aa2c Center 0,0,0,0 ReportTitleText Deadstock by Site [0:0:0] Expression ReportTitle

Transparent 0,1.2,10.22,0.6 Top, Left;[65:65:65];1;Solid;False;4;Black;True [165:165:165] True 0,0,0.8,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 HeaderText1 CribBin [0:0:0] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 0.8,0,1.3,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text3 Item [0:0:0] Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 2.1,0,3.4,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text5 Description1 [0:0:0] Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 2.1,0.2,3.4,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text7 Description2 [0:0:0] Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 5.5,0,0.7,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text9 Last Receipt [0:0:0] Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 6.2,0,0.5,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text11 Last Issue [0:0:0] Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 6.7,0,0.4,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text13 Bin Qty [0:0:0] Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 7.1,0,0.7,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text15 Cost [0:0:0] Expression Center Left;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 0,0.2,2.1,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text17 VendorNumber [0:0:0] Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 5.5,0.2,0.7,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text19 Pending Rework [0:0:0] Expression Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 6.2,0.2,0.5,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text21 On Order [0:0:0] Expression Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 6.7,0.2,0.4,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text23 Qty [0:0:0] Expression Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 7.1,0.2,0.7,0.2 Gray 50%_Header1 Arial,8,Bold Right 0,0,0,0 Text25 Transfer Adj [0:0:0] Expression Center None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 7.8,0.2,0.6,0.2 Gray 50%_Header1 Arial,8,Bold 4cdf74cd39544ed5a711c7b25ccffb43 Right 0,0,0,0 Text27 Value [0:0:0] Expression Center Bottom;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 2.1,0.4,3.4,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text30 Station Comments [0:0:0] Center Left, Bottom;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 0,0.4,2.1,0.2 Gray 50%_Header1 Arial,8,Bold 84c68062dd6041f4831a5aa582e0a1cd 0,0,0,0 Text33 [0:0:0] Expression Center Top;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 7.8,0,0.6,0.2 Gray 50%_Header1 Arial,8,Bold 1a0559add99d4f70bbad91ad76568de1 0,0,0,0 Text34 [0:0:0] Expression Center Bottom;[65:65:65];1;Solid;False;4;Black;True [165:165:165] 5.5,0.4,2.9,0.2 Gray 50%_Header1 Arial,8,Bold 0,0,0,0 Text36 Inventry Comments [0:0:0] Center Header

Transparent 0,2.2,10.22,0.2 Top, Left, Bottom;[65:65:65];1;Solid;False;4;Black Transparent 0,0,8.4,0.2 Gray 50%_Group_Header1 Arial,13,Bold 0,0,0,0 Text40 Item Group: {DeadstockDetail.ItemClass} [15:15:15] Expression {DeadstockDetail.ItemClass} GroupHeaderBand1 Transparent 0,2.8,10.22,0.6 Top, Left;[65:65:65];1;Solid;False;4;Black;True Transparent 0,0,0.8,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text1 {DeadstockDetail.CribBin} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 0.8,0,1.3,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text2 {DeadstockDetail.ItemNumber} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 2.1,0,3.4,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text4 {DeadstockDetail.Description1} [0:0:0] DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 2.1,0.2,3.4,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text6 {DeadstockDetail.Description2} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 5.5,0,0.7,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text8 {DeadstockDetail.DateLastReceipt} [0:0:0] Expression Top;[65:65:65];1;Solid;False;4;Black;True Transparent 6.2,0,0.5,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text10 {DeadstockDetail.DateLastIssue} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 6.7,0,0.4,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text12 {DeadstockDetail.BinQuantity} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 7.1,0,0.7,0.2 Gray 50%_Data1 Arial,8 Right 0,0,0,0 Text14 {DeadstockDetail.COST} [0:0:0] , 0 0 False DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 5.5,0.2,0.7,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text18 {DeadstockDetail.PendingRework} [0:0:0] DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 6.2,0.2,0.5,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text20 {DeadstockDetail.OnOrder} [0:0:0] DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 6.7,0.2,0.4,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text22 {DeadstockDetail.Quantity} [0:0:0] DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 7.1,0.2,0.7,0.2 Gray 50%_Data1 Arial,8 Right 0,0,0,0 Text24 {DeadstockDetail.TransfersValue} [0:0:0] DataColumn None;[65:65:65];1;Solid;False;4;Black;True Transparent 7.8,0.2,0.6,0.2 Gray 50%_Data1 Arial,8 8f0058c57bf341bcbe73fbeadd132765 Right 0,0,0,0 Text26 {DeadstockDetail.TransfersValue == null ? DeadstockDetail.Quantity * DeadstockDetail.COST : DeadstockDetail.Quantity * DeadstockDetail.COST + DeadstockDetail.TransfersValue} [0:0:0] , 0 0 False Expression Bottom;[65:65:65];1;Solid;False;4;Black;True Transparent 2.1,0.4,3.4,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text29 {DeadstockDetail.Station_Comments} [0:0:0] DataColumn Left;[65:65:65];1;Solid;False;4;Black;True Transparent 0,0.2,2.1,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text16 {DeadstockDetail.VendorNumber} [0:0:0] DataColumn Top;[65:65:65];1;Solid;False;4;Black;True Transparent 7.8,0,0.6,0.2 Gray 50%_Data1 Arial,8 5d85e29ea71f41b9966d4e1f1d55c05b Right 0,0,0,0 Text32 [0:0:0] , 0 0 False Expression Bottom;[65:65:65];1;Solid;False;4;Black;True Transparent 5.5,0.4,2.9,0.2 Gray 50%_Data1 Arial,8 0,0,0,0 Text35 {DeadstockDetail.Inventry_Comments} [0:0:0] DataColumn Left, Bottom;[65:65:65];1;Solid;False;4;Black;True Transparent 0,0.4,2.1,0.2 Gray 50%_Data1 Arial,8 d93259e8b47a4e78b9e7dd9d22d5fddd Right 0,0,0,0 Text31 [0:0:0] , 0 0 False Expression Top, Right, Bottom;[65:65:65];1;Solid;False;4;Black;True Transparent 8.4,0,1.82,0.6 Gray 50%_Data1 Arial,8 0,0,0,0 Text44 [0:0:0] Expression DeadstockDetail Gray 50%_Data1_Even Style Data Gray 50%_Data1_Odd Style ASC CRIBBIN Transparent 0,3.8,10.22,0.3 Top;[65:65:65];1;Solid;False;4;Black Transparent 7.8,0,0.6,0.2 Gray 50%_Group_Footer1 Arial,13,Bold 9daaffb9fff6441c8782b86ec7e87bbe Right 0,0,0,0 Text41 {Sum(DeadstockDetail.TransfersValue == null ? DeadstockDetail.Quantity * DeadstockDetail.COST : DeadstockDetail.Quantity * DeadstockDetail.COST + DeadstockDetail.TransfersValue)} [15:15:15] , 0 0 False Expression Top, Left;[65:65:65];1;Solid;False;4;Black Transparent 0,0,7.8,0.2 Gray 50%_Group_Footer1 Arial,13,Bold 0dbcba181ce143fbb6f66c3f98c131eb Right 0,0,0,0 Text42 {DeadstockDetail.ItemClass} Total: [15:15:15] Expression GroupFooterBand1 7d4cac70639c4f028517ec752ce9b23b 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 2/27/2014 10:39:42 AM 1/24/2014 2:04:31 PM C:\_CorporateProjects\Main\Web\Main\CMWeb\CMWeb\Content\Reports\DeadstockBySite.mrt 060e76eb36324e7188bd784affad92a3 Report Inches 2014.1.1810 CSharp None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox ReportTitle ComponentType, Placement, PlacementNestedLevel Arial,14,Bold Gray 50%_Report_Title1 [0:0:0] None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox GreaterThanOrEqualTo ReportTitle 2 ComponentType, Placement, PlacementNestedLevel Arial,10,Bold Gray 50%_Report_Title2 [0:0:0] None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox ReportSummary ComponentType, Placement, PlacementNestedLevel Arial,12,Bold Gray 50%_Report_Summary1 [0:0:0] None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox GreaterThanOrEqualTo ReportSummary 2 ComponentType, Placement, PlacementNestedLevel Arial,10,Bold Gray 50%_Report_Summary2 [0:0:0] None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox PageHeader ComponentType, Placement Arial,10 Gray 50%_Page_Header [0:0:0] None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox PageFooter ComponentType, Placement Arial,10 Gray 50%_Page_Footer [0:0:0] True None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox GreaterThanOrEqualTo GroupHeader ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Gray 50%_Group_Header1 [15:15:15] True None;[65:65:65];1;Solid;False;4;Black Transparent Gray 50% Text, Primitive, Image, CheckBox GroupFooter ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Gray 50%_Group_Footer1 [15:15:15] True None;[65:65:65];1;Solid;False;4;Black;True [165:165:165] Gray 50% Text, Primitive, Image, CheckBox GreaterThanOrEqualTo Header ComponentType, Placement, PlacementNestedLevel Arial,8,Bold Gray 50%_Header1 [0:0:0] True None;[65:65:65];1;Solid;False;4;Black;True Transparent Gray 50% Text, Primitive, Image, CheckBox GreaterThanOrEqualTo Data ComponentType, Placement, PlacementNestedLevel Arial,8 Gray 50%_Data1 [0:0:0] True None;[65:65:65];1;Solid;False;4;Black;True [255:255:255] Gray 50% GreaterThanOrEqualTo DataOddStyle Placement, PlacementNestedLevel Arial,8 Gray 50%_Data1_Odd Style [0:0:0] True None;[65:65:65];1;Solid;False;4;Black;True [240:240:240] Gray 50% GreaterThanOrEqualTo DataEvenStyle Placement, PlacementNestedLevel Arial,8 Gray 50%_Data1_Even Style [0:0:0] True None;[65:65:65];1;Solid;False;4;Black;True [185:185:185] Gray 50% Text, Primitive, Image, CheckBox Footer ComponentType, Placement, PlacementNestedLevel Arial,8 Gray 50%_Footer1 [0:0:0]