--04 Fee Transfer Paid Summary.sql -- SE rewrite of BO Fee Transfer Paid summary by invoice -- View: udv_transaction_detail_34 DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; DECLARE @PaidInvoices TABLE (InvoiceNo varchar(50) PRIMARY KEY); INSERT INTO @PaidInvoices (InvoiceNo) SELECT DISTINCT CAST(td.[Invoice Number] AS varchar(50)) FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE td.[Invoice Number] IS NOT NULL AND td.[Paid Amount] IS NOT NULL AND td.[Paid Amount] <> 0 AND td.[Transaction Date] >= @StartDate AND td.[Transaction Date] <= @EndDate; SELECT td.[Invoice Number] AS InvoiceNo, MIN(td.[Transaction Date]) AS PaidDate, SUM(ISNULL(td.[Paid Amount], 0)) AS NetFeeAmount, SUM(ISNULL(td.[Paid Amount], 0)) AS PaidInvoiceAmount, SUM(CAST(0.00 AS DECIMAL(18, 2))) AS CreditMemoAmount -- CM/CMHistory — unable to find FROM se_reports.dbo.[udv_transaction_detail_34] td INNER JOIN @PaidInvoices p ON p.InvoiceNo = CAST(td.[Invoice Number] AS varchar(50)) GROUP BY td.[Invoice Number] ORDER BY td.[Invoice Number];