Monthly Gift Query Not Picking Up Every Gift

Ron Morelli

Here's the query:


Gift GL Post Date Between 9/1/2018 AND 9/28/2018

AND Gift Type not one of Write Off, MG Write Off


The purpose is that when this query is run at month end it'll pick up every gift we've received during the month with a general ledger date between the 1st and the last of the month.  However, this query doesn't seem to pick up all the gifts.  For instance a gift of $13 wasn't picked up, and I double checked and it has a GL Post Date between 9/1 and today.


SO, my question is what should I try to add to make this report more conclusive?  I tried adding gift amount greater than $.01 but it's not picking up this $13 gift.


Gift date is 9/21/2018.  Gift GL Post is 9/21/2018.

JoAnn Strommen

It would seem it should pull.

You have no other criteria? Pay method / Fund / Campaign/Post status?


Does it pull if you use gift date instead of GL post date? Does it pull if you don't have the not one of write off? Sometimes using not can mess things up. Query likes affirmative better. 


By any chance is the gift post date 9/21/19 instead of 9/21/18? I've mis-typed year before. 

Larry Wheeler

I have had queries where I changed the "Not One of" to "One of" with appropriate Type changes,  and ended up with different results.  I would try it at least to see if the gift shows up.


Apologies for the duplicated answer.  I had not seen JoAnn's post.

Ron Morelli

By changing it to "one of" and adding everything BUT the two write offs, it indeed pulled the item I wanted pulled.


One less thing to worry about for my month-end pulls!