In my organization, when reporting on the total amount raised for a year, it is our policy to include pledges and cash (NOT pay-cash). This gets tricky with pledges that have been written-off. I have figured out how to exclude pledges in which the FULL amount has been written off by creating a gift subtype...

Need Help I want to take out information for all those pledges againt which nothing is received. Could not found under gift query although it worked if I use constituent query, but it skip if any donor has two pledges and one of them is paid off. AKD

Further to another post regarding Table Entry Definitions, a colleague and I had couple other ideas that we thought could be beneficial. - TABLE DEFINITIONS - At a higher level than the table entry definitions, have a synopsys of what the purpose of the table entries in a particular table should...

Hi all, I want to make a query that will pull constituents who've made a gift total of $1000 this calaneder year (2009). Im having trouble with 'pledges and installment payments'. basically if i have a constituent who made a monthly pledge for a total of $12,000 every month in November 2008...

Hi all, I ran a query for a constituent and under output i have from Summary Information -> Summary for Gifts ->Total Amount of Gifts. Under Fliters for that output i have nothing. It displays $33,000 for total gift amount I double click that number and I am taken to the constiuent, When I go to...