Add Invoice ID and Donation ID to Profile Payment Custom Report
In support of requests from our auditors, we need a report that combines all money-in -- both donations and invoice payments. However, we have not found a way to create that in Custom Reports. We are looking for a way to combine both donation details and invoice payment details.
Unfortunately, just the GL detail won't work for our auditors. They like to make their sample selections based on payment method and gift type - so we are looking for a way to pull this information or combine in the least painful way possible. Some of this information is obtainable from a custom Donations report, but it needs to be a complete population of gifts and that also includes some Invoices/Profile Payments too.
To facilitate this, we would like to have the Donation IDs and Invoice IDs in the Profile Payment Custom Report so that we can link to those records and/or export the report and combine it with donation and invoice reports to get everything we need.
Michelle Schneider
shared this idea
7/29/2024: Reports-Funds: Added Allow Additional Advisors field to the fund report. Nonprimary fund advisor address information will need to be populated on the Fund Advisor report. Added Parent Fund Name and Parent Funit ID. Added Need Primary Advisor Boolean Field to the Fund Reports.
Funds:
Reports-Profile Item Payment: Added invoice id and donation id fields.
Reports-Profile Org Role: Added org_prim field
Reports-Voucher & Voucher Item: Added reduce spendable boolean field, voucher id, Legacy code/ID and loan id fields.
Reports-Donation: Added Donation Address fields, receipt id, soft credit, and destination grant id.
Reports-Service Area: Added Assigned city & state (or null) fields
Reports-Campaign Profile Ticket: Added Number of seats "to assign", requests, and ticket note
Reports-Check Report: Added Vendor name and drillable check batch ID fields
Reports- Check Voucher: Added Vendor ID field.
Reports-Scholarship & Scholarship Payment: Added decision date to both reports.
Reports-Invoice: Added Loan ID field.
Reports-Recurring Donation: Added Fund Name.
Reports- Admin Fee: Added admin fee start date.
Reports-Grant & Grantee Default report: Add Charity Description from Charity Check Log
