DECLARE @DayOfMonth integer
	DECLARE @MinDate datetime

	SET @ClientCode = (SELECT ClientCode FROM dbo.[User] WHERE UserLogin = @ReportUser)
	SET @ClientName = (SELECT ClientName FROM dbo.Client WHERE ClientCode = @ClientCode)
	SET @DayOfMonth = DAY(GETDATE())

begin
		SELECT MASTID, Acct AS [Client Name], BTSINV AS [Fund Req #], BTSINVLN AS [Fund Line #], 
			BTSINVDT AS [Fund Req'd'], BTSFEE AS [TBL Fees], 
			BTSINVDTPD AS [Funds Rec'd'], 
			BTSCKDT AS [Check Cut], 
			BTSCKNO AS [Check #], 
			BN AS Batch, PK AS Rec, ACCT AS Client, ODIV AS Division, RCDT AS [Frt Bill Rec'd'], 
			SHDT AS Shipped, PERSH AS [Per Ship], PERPY AS [Per Paid], SCAC, SCX AS SCACX, CANM AS Carrier, 
			PRNO AS Pro, PRNOSEQ AS ProSeq, BLNO AS BOL, SHNM AS Shipper, OCI AS [Org City], OST AS [Org ST], OZP AS [Org Zip], 
			CONM AS Consignee, DCI AS [Dest City], DST AS [Dest ST], DZP AS [Dest Zip], IO AS Dir, PC AS Terms, LCT AS [FB Lines], 
			WTTTL AS Wgt, CL1, WT1 AS Wgt1, CL2, WT2 AS Wgt2, CL3, WT3 AS Wgt3, CL4, WT4 AS Wgt4, CL5, WT5 AS Wgt5, TPL AS Plt, 
			EXTTL AS [Billed Extended], DIPCT AS [Billed Disc Pct], DIAMT AS [Billed Disc Amt], LHAMT AS [Billed Linehaul], 
			FSPCT AS [Billed Fuel  Pct], FSAMT AS [Billed Fuel Charge], ACAMT AS [Billed Acc Total], FBTTL AS [Billed Total], 
			I_EXTTL AS Extended, I_DIPCT AS [Disc Pct], I_DIAMT AS [Disc Amt], I_LHAMT AS Linehaul, I_FSPCT AS [Fuel Pct], 
			I_FSAMT AS [Fuel Charge], I_ACAMT AS [Acc Total], I_FBTTL AS Total, ACCD1 AS Acc1, ACAMT1 AS [Acc1 Amt], 
			ACCD2 AS Acc2, ACAMT2 AS [Acc2 Amt], ACCD3 AS Acc3, ACAMT3 AS [Acc3 Amt], ACCD4 AS Acc4, ACAMT4 AS [Acc4 Amt], 
			ACNM AS [Your Name], ACCI AS [Your City], ACST AS [Your ST], ACZP AS [Your Zip], OPNM AS [Other Name], OPCI AS [Other City], 
			OPST AS [Other ST], OPZP AS [Other Zip], ORNO AS [Order], PONO AS PO, ACNO AS [GL Code], CASES AS Cs, PCS AS Pc, 
			M4 AS [Order mult], CASE bts WHEN 1 THEN 'Y' ELSE 'N' END AS TBL,WgtBrk as [Wgt Brks], CASE WHEN BTSInvDt > DATEADD(YEAR,-1,GETDATE()) THEN 'CURRENT' ELSE 'PREVIOUS' END AS [REP PER]
		FROM dbo.FreightPayment
		WHERE (BTSINVLN > 0) and
			(BTSInvDt >= DATEADD(MONTH,-(@months),DATEADD(DAY,-@DayOfMonth,GETDATE())) AND BTSInvDt < DATEADD(DAY,-@DayOfMonth,GETDATE()))
	end