Revenue types excluded from the Revenue/Application Details/Gift Aid/Gross Amount field query nodes
Certain revenue types appear to be excluded from the Revenue/Application Details/Gift Aid/Gross Amount fields.
This looks to be because the revenue application items are not in the REVENUESPLITGIFTAID table so they are not returning any information for any of the values (NULL values).
These appear to be the following types (which cannot have gift aid claimed against them):
Transaction Type Application
Matching gift claim Donation
Planned gift Donation
Payment Matching Gift
Matching gift claim Pledge
If this is the case then regardless of Application and Transaction type if there is no matching application id value within the REVENUESPLITGIFTAID table then it should return the relevant application amount, as no gift aid can be claimed on the revenue application.
At the moment these blank values will throw off any reporting that reports on the gross amount of a gift.