...
Result: This SOQL statement returned 0 when executed, hence there’s no record to update or process manually. No manual record update or record creation done.
Flow - AQC Donor Contact Type Auto-Updater - DISABLED
The flow is triggered when a Gift/Pledge is updated, with not defined entry criteria. The flow logic is defined into two parts:
Set Gift Driver Derivation (Usyd_Gift_Driver_Derivation__c) to TRUE when the record’s account changes.
Set the primary/secondary type to Donor if not yet Donor.
First Part: Set Gift Driver Derivation (Usyd_Gift_Driver_Derivation__c) to TRUE when the record’s account changes
To check if there were data that needs to be manually updated, the following SOQL statement were executed:
| Code Block |
|---|
|
SELECT COUNT()
FROM AQB__Gift__History
WHERE Field='AQB__Account__c'
AND DAY_ONLY(CreatedDate)=2023-07-07
AND ParentId IN (
SELECT AQB__Gift__c
FROM AQB__Transaction__c
WHERE DAY_ONLY(AQB__Receipt__r.CreatedDate) = 2023-07-07
) |
Result: This SOQL statement returned 0 when executed, hence there’s no record to update or process manually. No manual record update or record creation done.
Second Part: Set the primary/secondary type to Donor if not yet Donor
In the Receipting process, contact types are not expected to move. No manual record update or record creation done.
Update Gift Designation - Disabled
This is a managed package (Affinaquest) flow which has a known issue. So it was recommended to for this to be turned-OFF. No manual record update or record creation done.
| Expand |
|---|
| title | Restored Receipts: From Voided to Unvoided |
|---|
|
Receipt Id | Receipt Number | Voided Date (OLD) | Voided (OLD) | Void Note (OLD) | Voided Date (NEW) | Voided (NEW) | Void Note (NEW) | a2J8v0000004bhNEAQ | 13312 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004bhPEAQ | 13314 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004iU9EAI | 13385 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004iUvEAI | 13424 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004shBEAQ | 13585 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yDYEAY | 13726 | 06/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000009lEAA | 2570 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000000AVvEAM | 9760 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v00000046DEEAY | 12839 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v00000046DGEAY | 12841 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000492VEAQ | 12872 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004ST6EAM | 13189 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004bhSEAQ | 13317 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004jszEAA | 13455 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004jt7EAA | 13463 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004o5tEAA | 13545 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004o5zEAA | 13551 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004o61EAA | 13553 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004shWEAQ | 13602 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004shcEAA | 13608 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004uASEAY | 13649 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yDhEAI | 13735 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yEIEAY | 13772 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yESEAY | 13782 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yEaEAI | 13790 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yEeEAI | 13794 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yFjEAI | 13814 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000005HgAEAU | 17285 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000005J16EAE | 17291 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000005QdtEAE | 17303 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000006S15EAE | 17377 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000007FdNEAU | 17794 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000007LHBEA2 | 17822 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000CQKCEA4 | 18537 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000CaVgEAK | 19098 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000Ct4MEAS | 19180 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000DBaXEAW | 19230 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000DD5vEAG | 19269 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000FInzEAG | 19395 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000FIoBEAW | 19407 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000FMHFEA4 | 19419 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000FXomEAG | 19499 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000G1UFEA0 | 19545 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000Id8qEAC | 19680 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000JObQEAW | 19748 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000JUTgEAO | 19776 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000JanDEAS | 19786 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000MLQTEA4 | 19809 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000MLQdEAO | 19810 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000MolfEAC | 19869 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000N38LEAS | 19899 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000cXOrEAM | 20322 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v00000000ZVEAY | 4023 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000000VPaEAM | 10267 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yDnEAI | 13741 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v0000004yECEAY | 13766 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000DBa8EAG | 19222 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000DBaAEAW | 19224 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000OeWvEAK | 20042 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000knu9EAA | 20460 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000sTxOEAU | 20779 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL | a2J8v000000sW0CEAU | 20842 | 07/07/2023 | TRUE | The Transactions on this Receipt were Voided. | NULL | FALSE | NULL |
|