Non Gifts do not Show in Data Grid Results using Gift Soft Credit Fields
  • 18 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

Non Gifts do not Show in Data Grid Results using Gift Soft Credit Fields

  • Dark
    Light
  • PDF

Article summary

When using a database table that includes gift soft credits, any gifts where the entire amount is a non-gift do not show in the results.

Answer:

This is addressed in FIMS 14.73. A 4th Table join was added for Gift History with giftsoftcredits that includes non-gifts.


Steps To Duplicate

1. Go to the Gift module, Gift History tab
2. Create a data grid using one of the giftsoftcredits database tables as shown below:

3. Add other functions such as fund amount and fund ID for column output: 

4. On the Selections tab use a gift date range in which the non gift falls and then click save and generate view: 

5. In the data grid results, search for the non gift and see that it is not in the results.
6. If however a data grid is created using this database table combination, the non-gift does appear in datagrid results: 



Was this article helpful?