--02 Imprest Account Daily Balance.sql -- SE rewrite of BO Imprest daily activity + balances -- View: udv_transaction_detail_34 -- Note: FactImprestAccountBalance / InOut / beginning posted balance — unable to find DECLARE @CorpCode varchar(15) = NULL; -- set corp when filtering DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @DivisionName varchar(30) = NULL; SELECT CAST(NULL AS money) AS BeginningBalance; -- FactImprestAccountBalance — unable to find -- Daily activity SELECT CAST(td.[Transaction Date] AS date) AS TrxDate, SUM(CAST(0.00 AS DECIMAL(18, 2))) AS CashIn, -- InOut — unable to find SUM(CAST(0.00 AS DECIMAL(18, 2))) AS CashOut, -- InOut — unable to find SUM(ISNULL(td.[Transaction Amount], 0)) AS NetAmount, COUNT(*) AS LineCount FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE (@CorpCode IS NULL OR @CorpCode = '' OR td.[Corp Code] = @CorpCode) AND td.[Transaction Date] BETWEEN @StartDate AND @EndDate AND ( @DivisionName IS NULL OR @DivisionName = '' OR @DivisionName = '(All Divisions)' OR td.[Division] = @DivisionName ) GROUP BY CAST(td.[Transaction Date] AS date) ORDER BY TrxDate; -- Ending balance (period net only; no posted beg balance in SEViews) SELECT CAST(NULL AS money) AS BeginningBalance, -- unable to find ISNULL(SUM(td.[Transaction Amount]), 0) AS PeriodNetAmount, ISNULL(SUM(td.[Transaction Amount]), 0) AS EndingBalance -- beg unknown FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE (@CorpCode IS NULL OR @CorpCode = '' OR td.[Corp Code] = @CorpCode) AND td.[Transaction Date] BETWEEN @StartDate AND @EndDate AND ( @DivisionName IS NULL OR @DivisionName = '' OR @DivisionName = '(All Divisions)' OR td.[Division] = @DivisionName ); -- Posted balances sample — unable to find in SEViews SELECT CAST(NULL AS varchar(15)) AS CorpCode, -- FactImprestAccountBalance — unable to find CAST(NULL AS datetime) AS BalanceDate, CAST(NULL AS money) AS Balance, CAST(NULL AS varchar(50)) AS PONumber WHERE 1 = 0;