/* Fee Transfer — Open Crystal: FeeTransferOpen.rpt BO: frmCashReceiptsPosting — Open option (no GetFees preload) Source: dbo.vwFeeTransferOpen Invoice DOCDATE as POSTEDDT; FEE* lines only; remaining balance <> 0 (current RM20101 + history RM30101 fully unpaid CURTRXAM=ORTRXAMT) Filter: POSTEDDT between @StartDate and @EndDate (same as Crystal Pm-StartDate/Pm-EndDate) Run on RAC. */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; -- Detail: one row per invoice (view already aggregates FEE lines per SOP/date) SELECT SOPNUMBE AS InvoiceNo, POSTEDDT AS InvoiceDate, AMOUNT AS OpenFeeAmount FROM dbo.vwFeeTransferOpen WHERE POSTEDDT >= @StartDate AND POSTEDDT <= @EndDate ORDER BY POSTEDDT, SOPNUMBE; -- Totals SELECT COUNT(*) AS InvoiceCount, SUM(AMOUNT) AS TotalOpenFeeAmount FROM dbo.vwFeeTransferOpen WHERE POSTEDDT >= @StartDate AND POSTEDDT <= @EndDate;