You are here: netFORUM Pro Modules > Reports and Queries > List of Baseline Queries > Donations by Fund and Date Range Query

Donations by Fund and Date Range Query

This query returns a list of donations by fund by date range.

Query Parameters

Parameter Description
Product Code Begins With Enter a product code for the query.
Invoice Date Greater Than or Equal To Enter a date, or select a date from the drop down calendar, for the query.
Invoice Date Less Than or Equal To Enter a date, or select a date from the drop down calendar, for the query.

Query (Default) Fields

Field Description
Query Header Displays the query name, number of records returned, and the total number of pages for the query.
Product Product Code Lists the product code.
Product Product Name Lists the product name.
Donor Customer Type Lists the donor customer type: Individual or Organization.
Donor Full Name Lists the donor full name.
Fund Notes Lists any notes associated with the fund.
trx Amount Lists the transaction dollar amount.
Invoice Invoice Code Lists the associated invoice code.
Invoice Invoice Date Lists the associated invoice date.