Filtering on Summary Information, Summary for Gift, Total Receipt Amount double counts split gifts.

Filtering on Summary Information, Summary for Gift, Total Receipt Amount double counts split gifts.
Download and install the latest version and patch, if applicable. 

Alternative Solution:

1. Save the query created.
2. Create an Annual Statement Report and include the query.
3. Filter on the same dates used in the report.
4. Filter on the needed funds.
5. Run the report.
6. Export from the report.

If additional information is needed use these steps:

1. Save the query created.
2. Create an Annual Statement Report and include the query.
3. Mark the option to create a constituent output query on the General tab.
4. Filter on the needed funds.
5. Run the report.
6. Save the query.
7. Go to query and open the query created by the Annual Statement Report.
8. On the Output tab of the query Constituent name, and total receipt amount and filter on the date range used in the original query
report.
9. Click Run Now.

Environment

 Duplicated in version 7.85.5026.1.
 7.92.5508

Was this article helpful?