/* Fee Transfer Open — detail (DatawarehouseNCM) Crystal: FeeTransferOpen.rpt Fact: dbo.FactFeeTransferOpen Filter InvoiceDate (invoice DOCDATE) like Crystal Pm-StartDate / Pm-EndDate. */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; SELECT InvoiceNo, InvoiceDate, OpenFeeAmount FROM dbo.FactFeeTransferOpen WHERE InvoiceDate >= @StartDate AND InvoiceDate <= @EndDate ORDER BY InvoiceDate, InvoiceNo;