...
Note: once receipting is done, we need to create the task manually . Use this query to get those gifts that needs to have the task created (check with Andy)
SELECT ID, NAME, createddate, AQB__GIFT__R.USyd_Pledge_Status__c, AQB__GIFT__R.Name FROM AQB__Transaction__c WHERE DAY_ONLY(CREATEDDATE)>=2022-07-01 AND DAY_ONLY(CREATEDDATE)<=2023-06-30 and AQB__Voided__c=FALSE AND AQB__Receipt__c='' AND AQB__GIFT__R.USyd_Pledge_Status__c='Pending Review'
...