90fd1046-a3bd-4ce9-be27-5e3f067ee654 DEVSERVER 7faa6865-5cca-48bb-8b44-bdbcafe39df5 DotNetNuke 8.5in Boolean portaladmin true Integer true Report_Parameter_7 true Integer UserId true DateTime =Today() StartDate DateTime =DateAdd("s",-1,DateAdd("d",1,Today)) EndDate String DSStoreTemp Store_Id StoreId DSStoreTemp Store_Id Store_Id true true String true StoreId DSStores store_id description true true 11in true 0.1in 3b39bb7c-fb61-44f0-a96d-f9b6086621d3 11in Store_ID System.String DotNetNuke StoredProcedure GetStoreAssignedForUser =Parameters!PortalAdmin.Value =Parameters!UserId.Value =Parameters!PortalID.Value true Store_Id System.String StoreName System.String DateTime System.String CA_Amount System.Decimal CH_Amount System.Decimal FS_Amount System.Decimal CC_Amount System.Decimal DC_Amount System.Decimal OA_Amount System.Decimal Total_Price System.Decimal Total_Tax1 System.Decimal Total_tax2 System.Decimal Total_Tax3 System.Decimal PayOutAmount System.Decimal PickupAmount System.Decimal EODActual_Cash System.Decimal Grand_Total System.Decimal TransCT System.Int32 TotARPayment System.Decimal CashARPayment System.Decimal CheckARPayment System.Decimal NetSalestaxed System.Decimal NetSalesNonTaxed System.Decimal TaxExemptSales System.Decimal Discounts System.Double VendorPayment System.Decimal Total_GC_Sold System.Decimal TotalLiability System.Decimal =Fields!CA_Amount.Value + Fields!CH_Amount.Value - Fields!VendorPayment.Value + Fields!CashARPayment.Value + Fields!CheckARPayment.Value =Fields!CA_Amount.Value + Fields!CH_Amount.Value + Fields!FS_Amount.Value + Fields!CC_Amount.Value + Fields!DC_Amount.Value + Fields!OA_Amount.Value - Fields!Total_GC_Sold.Value - Fields!TotalLiability.Value =(Fields!EODActual_Cash.Value)-(Fields!CA_Amount.Value + Fields!CH_Amount.Value+Fields!CashARPayment.Value+Fields!CheckARPayment.Value-Fields!PayOutAmount.Value) DEVSERVER SELECT Payouts.Store_Id, '' StoreName, CONVERT(Varchar,End_Of_Day.EndDateTime,1) DateTime, 0 CA_Amount, 0 CH_Amount, 0 FS_Amount, 0 CC_Amount, 0 DC_Amount, 0 OA_Amount, 0 Total_Price, 0 Total_Tax1, 0 Total_tax2, 0 Total_Tax3, CASE WHEN [Type] = 0 THEN SUM(Amount) ELSE 0 END PayOutAmount, CASE WHEN [Type] = 1 THEN SUM(Amount) ELSE 0 END PickupAmount, 0 EODActual_Cash, 0 Grand_Total, 0 TransCT, 0 TotARPayment, 0 CashARPayment, 0 CheckARPayment, 0 NetSalestaxed, 0 NetSalesNonTaxed, 0 TaxExemptSales, 0 Discounts, SUM(PayOuts.Amount) VendorPayment, 0 Total_GC_Sold, 0 TotalLiability FROM Payouts INNER JOIN Setup ON Payouts.Store_Id = Setup.Store_Id INNER JOIN Shifts ON Shifts.Store_ID = PayOuts.Store_Id AND PayOuts.DateTime BETWEEN Shifts.StartDateTime AND Shifts.EndDateTime INNER JOIN End_Of_Day ON End_Of_Day.Close_Out_Index = Shifts.Close_Out_Index AND End_Of_Day.Store_Id = Shifts.Store_Id WHERE PayOuts.Store_ID in (@StoreId) AND End_Of_Day.EndDateTime between @StartDate AND @EndDate AND PayOuts.[Type]=0 --AND Cashier_Id IN (@CashierId) AND (CASE WHEN Setup.Shift_Assignment = 0 THEN Payouts.Cashier_ID ELSE Payouts.Station_ID END = Shifts.IDUsed) GROUP BY Payouts.Store_Id,CONVERT(Varchar,End_Of_Day.EndDateTime,1), [Type] UNION SELECT Invoice_Totals.Store_Id, MAX(Setup.Company_Info_1) StoreName, CONVERT(Varchar,End_Of_Day.EndDateTime,1) DateTime, SUM(Invoice_Totals.CA_Amount) CA_Amount, SUM(Invoice_Totals.CH_Amount) CH_Amount, SUM(Invoice_Totals.FS_Amount) FS_Amount, SUM(Invoice_Totals.CC_Amount) CC_Amount, SUM(Invoice_Totals.DC_Amount) DC_Amount, SUM(Invoice_Totals.OA_Amount) OA_Amount, SUM(Invoice_Totals.Total_Price) Total_Price, SUM(Invoice_Totals.Total_Tax1) Total_Tax1, SUM(Invoice_Totals.Total_tax2) Total_tax2, SUM(Invoice_Totals.Total_Tax3) Total_Tax3, 0 PayOutAmount, 0 PickupAmount, 0 EODActual_Cash, SUM(Invoice_Totals.Grand_Total) Grand_Total, COUNT(*) TransCT, 0 TotARPayment, 0 CashARPayment, 0 CheckARPayment, SUM(Invoice_Totals.Taxed_Sales) NetSalestaxed, SUM(Invoice_Totals.NonTaxed_Sales) NetSalesNonTaxed, SUM(Invoice_Totals.Tax_Exempt_Sales) TaxExemptSales, 0 Discounts, 0 VendorPayment, SUM(Total_GC_Sold) Total_GC_Sold, SUM(TotalLiability) TotalLiability FROM View_Invoice_Totals AS Invoice_Totals INNER JOIN Setup ON Invoice_Totals.Store_Id = Setup.Store_Id INNER JOIN Shifts ON Shifts.Store_ID = Invoice_Totals.Store_Id AND Invoice_Totals.DateTime BETWEEN Shifts.StartDateTime AND Shifts.EndDateTime INNER JOIN End_Of_Day ON End_Of_Day.Close_Out_Index = Shifts.Close_Out_Index AND End_Of_Day.Store_Id = Shifts.Store_Id WHERE Invoice_Totals.Store_ID in (@StoreId) AND End_Of_Day.EndDateTime between @StartDate AND @EndDate AND Invoice_Totals.Status = 'C' AND (Shifts.EndDateTime >= End_Of_Day.StartDateTime AND Shifts.EndDateTime < End_Of_Day.EndDateTime) AND (CASE WHEN Setup.Shift_Assignment = 0 THEN Invoice_Totals.Cashier_ID ELSE Invoice_Totals.Station_ID END = Shifts.IDUsed) GROUP BY Invoice_Totals.Store_Id,CONVERT(Varchar,End_Of_Day.EndDateTime,1) --ORDER BY -- Invoice_Totals.Store_Id,CONVERT(Varchar,Invoice_Totals.DateTime,101) UNION SELECT Store_Id, MAX(StoreName) StoreName, DateTime, 0 CA_Amount, 0 CH_Amount, 0 FS_Amount, 0 CC_Amount, 0 DC_Amount, 0 OA_Amount, 0 Total_Price, 0 Total_Tax1, 0 Total_tax2, 0 Total_Tax3, 0 PayOutAmount, 0 PickupAmount, 0 EODActual_Cash, 0 Grand_Total, 0 TransCT, SUM(TotalARPayment) TotARPayment, SUM(CashARPayment) CashARPayment, SUM(CheckARPayment) CheckARPayment, 0 NetSalestaxed, 0 NetSalesNonTaxed, 0 TaxExemptSales, 0 Discounts, 0 VendorPayment, 0 Total_GC_Sold, 0 TotalLiability FROM( SELECT AR_Transactions.Store_Id, Setup.Company_Info_1 StoreName, CONVERT(Varchar,End_Of_Day.EndDateTime,1) DateTime, 0 CA_Amount, 0 CH_Amount, 0 FS_Amount, 0 CC_Amount, 0 DC_Amount, 0 Total_Price, 0 Total_Tax1, 0 Total_tax2, 0 Total_Tax3, 0 PayOutAmount, 0 PickupAmount, 0 EODActual_Cash, 0 Grand_Total, 0 TransCT, CASE AR_Transactions.Payment_Method WHEN 'CA' THEN AR_Trans_Details.Amount ELSE 0 END CashARPayment, CASE AR_Transactions.Payment_Method WHEN 'CH' THEN AR_Trans_Details.Amount ELSE 0 END CheckARPayment, AR_Trans_Details.Amount TotalARPayment, 0 NetSalestaxed, 0 NetSalesNonTaxed, 0 TaxExemptSales, 0 Discounts, AR_Transactions.DateTime Date, 0 VendorPayment FROM AR_Trans_Details INNER JOIN AR_Transactions ON AR_Transactions.Trans_ID = AR_Trans_Details.Trans_ID AND AR_Transactions.Store_ID = AR_Trans_Details.Store_ID INNER JOIN Setup ON AR_Transactions.Store_Id = Setup.Store_Id INNER JOIN Shifts ON Shifts.Store_ID = AR_Transactions.Store_Id AND AR_Transactions.DateTime BETWEEN Shifts.StartDateTime AND Shifts.EndDateTime INNER JOIN End_Of_Day ON End_Of_Day.Close_Out_Index = Shifts.Close_Out_Index AND End_Of_Day.Store_Id = Shifts.Store_Id WHERE AR_Transactions.Store_ID in (@StoreId) AND End_Of_Day.EndDateTime between @StartDate AND @EndDate AND (CASE WHEN Setup.Shift_Assignment = 0 THEN AR_Transactions.Cashier_ID ELSE AR_Transactions.Station_ID END = Shifts.IDUsed) )ResultTable GROUP BY Store_Id,dateTime --ORDER BY -- Store_Id,CONVERT(Varchar,date,101) UNION SELECT Invoice_Totals.Store_Id, MAX(Setup.Company_Info_1) StoreName, CONVERT(Varchar,End_Of_Day.EndDateTime,1) DateTime, 0 CA_Amount, 0 CH_Amount, 0 FS_Amount, 0 CC_Amount, 0 DC_Amount, 0 OA_Amount, 0 Total_Price, 0 Total_Tax1, 0 Total_tax2, 0 Total_Tax3, 0 PayOutAmount, 0 PickupAmount, 0 EODActual_Cash, 0 Grand_Total, 0 TransCT, 0 TotARPayment, 0 CashARPayment, 0 CheckARPayment, 0 NetSalestaxed, 0 NetSalesNonTaxed, 0 TaxExemptSales, SUM((Invoice_Itemized.OrigPricePer - Invoice_Itemized.PricePer) * Invoice_Itemized.Quantity) Discounts, 0 VendorPayment, 0 Total_GC_Sold, 0 TotalLiability FROM Invoice_Totals INNER JOIN Setup ON Invoice_Totals.Store_Id = Setup.Store_Id INNER JOIN View_Invoice_Itemized AS Invoice_Itemized ON Invoice_Totals.Invoice_Number = Invoice_Itemized.Invoice_Number AND Invoice_Totals.Store_Id = Invoice_Itemized. Store_Id INNER JOIN Shifts ON Shifts.Store_ID = Invoice_Totals.Store_Id AND Invoice_Totals.DateTime BETWEEN Shifts.StartDateTime AND Shifts.EndDateTime INNER JOIN End_Of_Day ON End_Of_Day.Close_Out_Index = Shifts.Close_Out_Index AND End_Of_Day.Store_Id = Shifts.Store_Id WHERE Invoice_Totals.Store_Id in (@StoreId) AND End_Of_Day.EndDateTime BETWEEN @StartDate AND @EndDate AND Invoice_Totals.Status = 'C' --AND Invoice_Totals.Cashier_Id in(@CashierId) GROUP BY Invoice_Totals.Store_Id,CONVERT(Varchar,End_Of_Day.EndDateTime,1) --ORDER BY -- Invoice_Totals.Store_Id,CONVERT(Varchar,Invoice_Totals.DateTime,101) UNION SELECT Store_Id, '' StoreName, CONVERT(Varchar,End_Of_Day.EndDateTime,1) DateTime, 0 CA_Amount, 0 CH_Amount, 0 FS_Amount, 0 CC_Amount, 0 DC_Amount, 0 OA_Amount, 0 Total_Price, 0 Total_Tax1, 0 Total_tax2, 0 Total_Tax3, 0 PayOutAmount, 0 PickupAmount, SUM(End_Of_Day.Actual_Cash) EODActual_Cash, 0 Grand_Total, 0 TransCT, 0 TotARPayment, 0 CashARPayment, 0 CheckARPayment, 0 NetSalestaxed, 0 NetSalesNonTaxed, 0 TaxExemptSales, 0 Discounts, 0 VendorPayment, 0 Total_GC_Sold, 0 TotalLiability FROM End_Of_Day WHERE End_Of_Day.Store_Id in (@StoreId) AND End_Of_Day.EndDateTime BETWEEN @StartDate AND @EndDate --AND End_Of_Day.Cashier_Id in(@CashierId) GROUP BY End_Of_Day.Store_Id,CONVERT(Varchar,End_Of_Day.EndDateTime,1) ORDER BY Store_Id,DateTime =Parameters!StoreId.Value =Parameters!StartDate.Value =Parameters!EndDate.Value true store_id System.String company_info_1 System.String description System.String DEVSERVER Select store_id,company_info_1,store_id + ' : ' + LEFT(company_info_1,16) description from setup Where Store_id in (@StoreIdTemp) =Parameters!StoreIdTemp.Value true Cashier_ID System.String EmpName System.String Combination System.String DEVSERVER SELECT Distinct Employee.Cashier_ID,EmpName,Employee.Cashier_ID + ' : ' + EmpName Combination FROM Employee INNER JOIN EmployeeStores ON Employee.Cashier_ID = EmployeeStores.Cashier_ID WHERE EmployeeStores.Store_Id in (@StoreId) =Parameters!StoreId.Value true 10.875in 3 DSMain0.0625in =Fields!Store_Id.Value
9 textbox8 91 true ="STORE : " + Fields!Store_Id.Value + " " + Fields!StoreName.Value textbox45 90 true textbox9 89 true textbox17 88 true textbox74 87 true textbox50 86 true textbox55 85 true textbox41 84 true textbox51 83 true textbox61 82 true textbox60 81 true textbox65 80 true 0.25in
textbox15 59 true ="Total-" + Fields!Store_Id.Value Deposit_1 58 true =FormatCurrency(Sum(Fields!Deposit.Value),2,,false,false) FS_Amount_1 57 true =FormatCurrency(Sum(Fields!FS_Amount.Value),2,,false,false) CC_Amount_1 56 true =FormatCurrency(Sum(Fields!CC_Amount.Value) + Sum(Fields!DC_Amount.Value),2,,false,false) textbox71 55 true =FormatCurrency(Sum(Fields!OA_Amount.Value),2,,false,false) Total_1 54 true =FormatCurrency(Sum(Fields!Total.Value),2,,false,false) Total_Tax1_1 53 true =FormatCurrency(Sum(Fields!Total_Tax1.Value),2,,false,false) Total_tax2_1 52 true =FormatCurrency(Sum(Fields!Total_tax2.Value),2,,false,false) Total_Tax3_1 51 true =FormatCurrency(Sum(Fields!Total_Tax3.Value),2,,false,false) PayOutAmount_1 50 true =FormatCurrency(Sum(Fields!PayOutAmount.Value),2,,false,false) textbox13 49 true =FormatCurrency(SUM(Fields!TotARPayment.Value),2,,false,false) textbox22 48 true =FormatCurrency(SUM(Fields!CashARPayment.Value),2,,false,false) textbox77 47 true =FormatCurrency(SUM(Fields!CheckARPayment.Value),2,,false,false) EODActual_Cash_1 46 true =FormatCurrency(Sum(Fields!CashOverShort.Value),2,,false,false) Total_Price_1 45 true =FormatCurrency(Sum(Fields!Total_Price.Value),2,,false,false) textbox46 44 true =FormatCurrency(SUM(Fields!NetSalestaxed.Value),2,,false,false) textbox56 43 true =FormatCurrency(SUM(Fields!NetSalesNonTaxed.Value + Fields!TaxExemptSales.Value),2,,false,false) textbox66 42 true =FormatCurrency(SUM(Fields!Discounts.Value),2,,false,false) TransCT_1 41 true =Sum(Fields!TransCT.Value) Grand_Total_1 40 true =FormatCurrency(Sum(Fields!Grand_Total.Value),2,,false,false) 0.25in
=Fields!DateTime.Value
textbox5 39 true =Format(cdate(Fields!DateTime.Value),"MM/dd/yy") 38 true =FormatCurrency(Sum(Fields!Deposit.Value),2,,false,false) 37 true =FormatCurrency(Sum(Fields!FS_Amount.Value),2,,false,false) 36 true =FormatCurrency(Sum(Fields!CC_Amount.Value) + Sum(Fields!DC_Amount.Value),2,,false,false) textbox70 35 true =FormatCurrency(Sum(Fields!OA_Amount.Value),2,,false,false) 34 true =FormatCurrency(Sum(Fields!Total.Value),2,,false,false) 33 true =FormatCurrency(Sum(Fields!Total_Tax1.Value),2,,false,false) 32 true =FormatCurrency(Sum(Fields!Total_tax2.Value),2,,false,false) 31 true =FormatCurrency(Sum(Fields!Total_Tax3.Value),2,,false,false) 30 true =FormatCurrency(Sum(Fields!PayOutAmount.Value),2,,false,false) textbox12 29 true =FormatCurrency(SUM(Fields!TotARPayment.Value),2,,false,false) textbox21 28 true =FormatCurrency(SUM(Fields!CashARPayment.Value),2,,false,false) textbox76 27 true =FormatCurrency(SUM(Fields!CheckARPayment.Value),2,,false,false) 26 true =FormatCurrency(Sum(Fields!CashOverShort.Value),2,,false,false) 25 true =FormatCurrency(Sum(Fields!Total_Price.Value),2,,false,false) textbox43 24 true =FormatCurrency(SUM(Fields!NetSalestaxed.Value),2,,false,false) textbox53 23 true =FormatCurrency(SUM(Fields!NetSalesNonTaxed.Value + Fields!TaxExemptSales.Value),2,,false,false) textbox63 22 true =FormatCurrency(SUM(Fields!Discounts.Value),2,,false,false) 21 true =Sum(Fields!TransCT.Value) 20 true =FormatCurrency(Sum(Fields!Grand_Total.Value),2,,false,false) 0.25in
true DateTime 19 true =Fields!DateTime.Value Deposit 18 true =FormatCurrency(Fields!Deposit.Value,2,,false,false) FS_Amount 17 true =FormatCurrency(Fields!FS_Amount.Value,2,,false,false) CC_Amount 16 true =FormatCurrency(Fields!CC_Amount.Value,2,,false,false) textbox69 15 true Total 14 true =FormatCurrency(Fields!Total.Value,2,,false,false) Total_Tax1 13 true =FormatCurrency(Fields!Total_Tax1.Value,2,,false,false) Total_tax2 12 true =FormatCurrency(Fields!Total_tax2.Value,2,,false,false) Total_Tax3 11 true =FormatCurrency(Fields!Total_Tax3.Value,2,,false,false) PayOutAmount 10 true =FormatCurrency(Fields!PayOutAmount.Value,2,,false,false) textbox11 9 true =FormatCurrency(Fields!TotARPayment.Value,2,,false,false) textbox20 8 true =FormatCurrency(Fields!CashARPayment.Value,2,,false,false) textbox75 7 true EODActual_Cash 6 true =FormatCurrency(Fields!CashOverShort.Value,2,,false,false) Total_Price 5 true =FormatCurrency(Fields!Total_Price.Value,2,,false,false) textbox42 4 true textbox52 3 true textbox62 2 true TransCT 1 true =Fields!TransCT.Value Grand_Total true =FormatCurrency(Fields!Grand_Total.Value,2,,false,false) 0.125in =Fields!Store_Id.Value Ascending =Fields!DateTime.Value Ascending
textbox4 111 true Date textbox18 110 true Deposit CA/Chk textbox6 109 true EBT textbox19 108 true CC / DC textbox68 107 true OA Amt textbox24 106 true TOTAL textbox29 105 true Tax1 textbox34 104 true Tax2 textbox39 103 true Tax3 textbox44 102 true Vendor Payouts textbox7 101 true Tot AR Pay textbox16 100 true CA AR Pay textbox73 99 true Chk AR Pay textbox49 98 true CASH Shrt/Ovr textbox54 97 true NET Sales textbox40 96 true Net Sales Taxed textbox48 95 true Net Sales Non Taxed + Tax Exempt textbox58 94 true Disc textbox59 93 true Tran # textbox64 92 true Gross Sales 0.25in true
0.5in 0.6in 0.53in 0.575in 0.5in 0.625in 0.475in 0.45in 0.45in 0.54in 0.55in 0.55in 0.55in 0.575in 0.625in 0.625in 0.625in 0.55in 0.325in 0.65in
textbox10 79 true Grand Total Deposit_2 78 true =FormatCurrency(Sum(Fields!Deposit.Value),2,,false,false) FS_Amount_2 77 true =FormatCurrency(Sum(Fields!FS_Amount.Value),2,,false,false) CC_Amount_2 76 true =FormatCurrency(Sum(Fields!CC_Amount.Value) + Sum(Fields!DC_Amount.Value),2,,false,false) textbox72 75 true =FormatCurrency(Sum(Fields!OA_Amount.Value),2,,false,false) Total_2 74 true =FormatCurrency(Sum(Fields!Total.Value),2,,false,false) Total_Tax1_2 73 true =FormatCurrency(Sum(Fields!Total_Tax1.Value),2,,false,false) Total_tax2_2 72 true =FormatCurrency(Sum(Fields!Total_tax2.Value),2,,false,false) Total_Tax3_2 71 true =FormatCurrency(Sum(Fields!Total_Tax3.Value),2,,false,false) PayOutAmount_2 70 true =FormatCurrency(Sum(Fields!PayOutAmount.Value),2,,false,false) textbox14 69 true =FormatCurrency(SUM(Fields!TotARPayment.Value),2,,false,false) textbox23 68 true =FormatCurrency(SUM(Fields!CashARPayment.Value),2,,false,false) textbox78 67 true =FormatCurrency(SUM(Fields!CheckARPayment.Value),2,,false,false) EODActual_Cash_2 66 true =FormatCurrency(Sum(Fields!CashOverShort.Value),2,,false,false) Total_Price_2 65 true =FormatCurrency(Sum(Fields!Total_Price.Value),2,,false,false) textbox47 64 true =FormatCurrency(SUM(Fields!NetSalestaxed.Value),2,,false,false) textbox57 63 true =FormatCurrency(SUM(Fields!NetSalesNonTaxed.Value + Fields!TaxExemptSales.Value),2,,false,false) textbox67 62 true =FormatCurrency(SUM(Fields!Discounts.Value),2,,false,false) TransCT_2 61 true =Sum(Fields!TransCT.Value) Grand_Total_2 60 true =FormatCurrency(Sum(Fields!Grand_Total.Value),2,,false,false) 0.25in
0.76041in textbox3 0.50001in 8.35417in 2 true 0.02083in 0.25in ="Date Range: " + Parameters!StartDate.Value + " - " + Parameters!EndDate.Value textbox2 0.25001in 2.47917in 1 true 0.02083in 0.25in ="Print date: " + FormatDateTime(Now,2) textbox1 10.75in true 0.25in Controllers Sales Report 2.19791in en-US true true 9in ="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString() 0.25in true 0.1in 8.5in