Our development dept. are trying to keep a closer eye on the budget and are wanting more information available in one of their reports.
I have been trying to add a column to the Fund Activity report which replicates the numbers produced by the Pledge Billing report.
I have been looking at t_pledge_bill2, t_schedule and t_transaction in many combinations to try and find the sum figure we can expect in for each fund within a given date range. I've not had much luck!
Has anyone done this already and could let me in on the secret? I'd be very grateful.
Many thanks.