TAPSS- 2302 https://sydneyuni.atlassian.net/browse/TAPSS-2302

AQ 26: Smart Batch 2.0 Field & Report Types Configuration

Verify that the following new items are added to Batch item object

Object - Batch Item (AQB__Batch_Item__c)

• New Fields

  • Initial Amount Pledged

    • AQB__InitialAmountPledged__c

    • Currency(10, 2)

    • This is the Initial Amount of the Pledge. Voids, write-offs and adding additional transactions to this gift do not change this value.  It is calculated at the time of Batch processing from the total of the Amounts on the Batch Item Transactions with a Type of Pledge.  It can be manual edited after processing but is never updated by the software after processing.

GA-PASS

TAPSS- 2302 https://sydneyuni.atlassian.net/browse/TAPSS-2302 Custom Fields on Batch Item Transactions

Verify tha the following new items are added to Batch item transactions object

• Appraiser's Address

  • AQB__AppraiserAddress__c

  • Text(255)

  • Copied from Batch Item

  • Future use for configurable screens for Personal/Real Property Gifts

• Appraiser's Name

  • AQB__AppraiserName__c

  • Text(200)

  • Copied from Batch Item

  • Future use for configurable screens for Personal/Real Property Gifts

GA-PASS

Defect Fixes

TAPSS-2373 - https://sydneyuni.atlassian.net/browse/TAPSS-2373

Error reported V26:

Source of Data= Modification

Batch Type = Gift Batch

Method = Void

Void and Correction.

Void and add correction - Got an error saying “failed to load opportunities” and the screen is stuck on loading. My gift has not saved yet. Also gift date and gift credit date not appearing at smart batch entry level.

1. Error message was not displayed for below "Void Notation" options:

   Check dishonoured

   Entity incorrect

   Allocation account changed

   Suspense batch error fix

   Anonymity status incorrect

   Entity merge connection

   Chargeback

   Proposal update

2.When I selected "Allocation code incorrect" value and all other values in "Void notation" field, an error message is displayed

Below error message must NOT be displayed

Open

Open

@rommel.ngo to explore this functionality and provide recommendations to Ana

GA-PASS

TAPSS-2379 : https://sydneyuni.atlassian.net/browse/TAPSS-2379

As a Gift Administrator, I want to make gift/pledge correction in a bulk, so that I do not need to manually correct each batch.

Please refer to Jira for steps to reproduce

GA-PASS

Confirming that Bulk Corrections does not update the linked soft credit on a gift.

TAPSS-2387 - https://sydneyuni.atlassian.net/browse/TAPSS-2387

AQV29:Confirm Available Methods in Smart Batch 2.0

Josh Berg (Affinaquest Help Desk (Advancement RM))

Nov 5, 2024, 9:42 AM EST

Senoah,
 
Thanks for the question.
 
The Method dropdown in SmartBatch 2.0 is hard-coded and does not reach from the field values as they did in SmartBatch 1.0. At this time, values cannot be removed in SmartBatch 2.0. Inactivating values will not remove them from the Method dropdown in SmartBatch 2.0 and it may create problems down the road, particularly if inactive values are selected. 
 
As a rule, we do not recommend changing the Method picklists on any of the objects. You will get the best gift processing results if you use them as provided, which we are constantly evaluating. 
 
Thanks,
Josh

@Sushma Ramachandrappa to update the list of methods on 2.0

GA-PASS

I have added the order we would like the methods to be in, in the Jira ticket - TAPSS-2387

ACH

Add transaction to Existing Gift

Cash

Check

Consolidated Gift

Convert Gift to Pledge Payment

Credit Card

Crypto

DAF Gift

Grant

Matching Gift

Matching Gift Payment

Paypal

Payroll Deduction

Personal Property

Planned Gift

Pledge

Pledge Write Off

Real Property

Securities

Service

Soft Credit - Other Account

Soft Credit - This Account

Transfer

Venmo

Void

Wire

TAPSS-2395 - https://sydneyuni.atlassian.net/browse/TAPSS-2395

AQ 29 Smart Batch: Gift Date and Credited Year

As a Gift Administrator, I want to see Gift Date and Credited Year Override Date in Smart Batch 2.0, so I can process the batch with the information accordingly.

1.Create a batch with Smart Batch 2.0 checkbox ticked

2.Check ‘Gift Date’ and ‘Gift Credit Date' checkbox in batch and click ‘Batch Item’ button

GA-PASS

TAPSS-2397- https://sydneyuni.atlassian.net/browse/TAPSS-2397

AQV29: Confirm the defaulted batch 2.0 when batches are auto-created for credit card, recurring gifts and iModules (Zendesk #12477)

Other auto created batches = new recurring gifts in a pledge batch and refunds of credit cards gifts via blackthorn.

@rommel.ngo Tested credit card, recurring gift, new recurring pledge and refund - still need to check a new imodules batch.

16/01/2025 - iModules data is now ready for testing

Jan 20, 2025 Tested imodules Gift with Monica GA PASS

TAPSS-2399 - https://sydneyuni.atlassian.net/browse/TAPSS-2399

AQV29 Smart Batch 2.0: Adding multiple soft credits to the gift

As a gift administrator, I want to add multiple soft credits to the gift so I can process the batch accordingly.

Multiple Soft Credits Added at time of Data Entry

Multiple soft credits can now be entered at the time of data entry in Smart Batch 2.0.

After entering a gift, choose  Save and Add Soft Credit

There is no limit to the number of soft credits that can be added.

Soft Credits can also be added after the Batch Item is created by clicking on the C dot

Choose Add Soft Credit to add another Soft Credit

it also gives you the option to add the soft credit even after you have saved the Batch Item

@rommel.ngo Limitations noted:
Single gifts - GA PASS able to add and remove multiple soft credits

Pledges - able to add multiple soft credits but unable to edit or remove them. This is an issue because we have many pledges that require the editing of soft credit amount and we sometimes need to remove a soft credit that was added by mistake.

Jan 20, 2025 deletion and edit of “Pledge Soft Credit Transaction” is not allowed. checking if this is a permission issue.

TAPSS - 2400 - https://sydneyuni.atlassian.net/browse/TAPSS-2400

AQV29: Update Batch Approval Report Soft Credit columns

As a GA user, I want to make adjustments to the Batch Proof report so that when I enter batch using smart batch 2.0, I am seeing the information as it was and can distinguish the soft credit vs hard credit.

• When I use Smart Batch 2.0, soft credits are shown and distinguished with their respective information (anonimity of gift, anonimity of soft credit, pledge being paid down and the number of pledge payments)

• When I use Smart Batch 2.0, ‘Date' ‘Amount' ‘Designation’ ‘Designation Number’ columns are added into ‘Batch Item Automated Soft Credits’ table

• when I use Smart Batch 1.0, it is showing as it is. (this is transitionary, once we are fully on board with Smartbatch 2.0, this information can go)

‘Date' ‘Amount' ‘Designation’ ‘Designation Number’ columns must be added into ‘Batch Item Automated Soft Credits’ table

@Ana Simic Please wait until confirmed

16/01 - Fields are added and are available for testing.

Jan 20, 2025 Rommel’s Test PASS

1. SB1.0 Payment soft credit pay pledge soft credit

    

2. SB 1.0 Soft Credit this Account and soft credit other account

Pledge correction batch issue when there are two payments against one pledge

We modified this gift from the holding designation to the new designation using a pledge correction batch and now one of the EFT's is paying down the wrong pledge instalment - https://sydneyuni-adv.lightning.force.com/lightning/r/AQB__Gift__c/a0sOn000000ZnFZIA0/view
Steps: 
Create a new pledge correction batch.
Choose the account and pledge that you wish to modify.
Change the pledge and payment rows designation from holding to the new designation.
Close batch.

 Actual Behaviour

The payment row is now paying down the wrong pledge instalment (Select Item 20 003145448) 

Expected: 

The payments should still pay down the pledge rows they were paying down before the modification batch was completed. 

Business Impact: 

The donor has made a new payment and we cannot process it or receipt them until the pledge is fixed. Not sure why the pledge correction batch modification would behave this way and would like to know how to avoid it in future gift/pledge modifications .

1. Demo video: AQv29 Batch Correction Multiple payment on a schedule.webm

This Issue that was reported in AQ 26 by Ana is not fixed in AQ29. This has been raised with AQ and below is the response

”I was able to recreate your scenario in our version 26 and 27 test orgs and will get this bug over to QA. Workaround is to do a void and correct as needed.

Thanks for bringing this is our attention.”

1.@rommel.ngo In my test case the unpaid pledge installments have somehow been deleted (UAT Batch 0078889) -

2. Pledge correction batch is not working in v29
   
   Issue 1 and 2 are tracked under this Jira ticket https://sydneyuni.atlassian.net/browse/TAPSS-2491
   
   

Jan 20, 2025 disscuess this with Monica, and business accepts the temporary work around of using void and correct until version 30

GA PASS with workaround

@rommel.ngo Pledge correction batch is not working, it is voiding the rows and not correcting them.

Tracking under Jira - https://sydneyuni.atlassian.net/browse/TAPSS-2491
GA PASS with workaround

TAPSS-2393 - https://sydneyuni.atlassian.net/browse/TAPSS-2393

[BAT] Batch Validation not working (Peoplesoft integration)

This issue is observed due to the integration between Salesforce UAT and Peoplesoft being down., AQ versions do not have any impact on this integration.

We have raised this with John from peoplesoft team. This can be tested once the integrations are up and running successfully

GA-PASS

Regression

TAPSS-2016-001

Soft credits are created as Batch Item Automated Soft Credits

Batch proof report shows in its separate section with information about the anonimity of the gift as well as the credit, and it also shows the pledge being played.

Jan 20, 2025 Tested with Monica GA PASS

TAPSS-2304-001

Create a batch with “Gift date” and “Gift credit date” fields checked on the batch

“Gift date” and “Gift credit date” fields must be displayed while adding a batch item

GA-PASS

TAPSS-2037-003

AC4

Pledge Soft Credits Written Off when Pledges are Written Off in Contact Utilities

• create pledge from a household account with pledge soft credit to an organization account

• decease contact and write off open pledges
  
  

Pledge Soft Credit has been written off

GA-PASS

TAPSS-2037-004

AC5

Primary and Secondary Contact checkboxes throw component errors when toggled

• decease a contact

This error message do not appear

GA-PASS

TAPSS-2037-005

AC6

Receipting Utility Date fields work as expected for orgs in Australian timezone

• find an transaction that is not voided and that has not been receipted and is created before 10am

  in backend the creation date is in previous day

• Run receitping utility for that date

receipting utility should pick up the transaction as transaction for that day rather than yesterday

Jan 20, 2025 Tested with Monica GA PASS

Smart Batch 2.0 testing (Complex Scenarios)

TAPSS-2037-006

AC2 (GA process remains the same and unaffected by the upgrade)

Gift from a foundation with soft credit to a multi contact household with 50/50 LC

• create/prepare the household account

• Create/prepare the foundation account

   

• create the gift with soft credit

gift and soft credit are created

Soft Credit has GRC

Legal credit should be 0

GA-PASS

Gift has a soft credit, soft credit has GRC and soft credit has $0 legal credit.

TAPSS-2037-007

Accidentally discovered as having been fixed in v25

Indirect Contact Auto Gift Recognition

• create an indirect relationship with Award Credit set to true

• Enter a gift on the Account

• Same scenario for Org with indirect contact
  
  

GRC credit awarded without error

for Org with indirect contact GRC

for reference, in v24 it would give this error icon and cannot close the batch

Jan 21, 2025 Tested with Monica GA PASS

TAPSS-2037-008

AC2 (GA process remains the same and unaffected by the upgrade)

Transferring an Org Gift or an fully paid pledge from holding to a new designation with soft credit to a household account

• create a Pledge with full payment on Org that has been soft credited to a household account whose contact is indirectly linked to the org account with auto award soft credit
  
  

   

   

• create the pledge
  
  

   

•  

Pledge

Soft Credit

As mentioned this scenario resulted to two GRC on the contact

Jan 21, 2025 Tested with Monica GA PASS

TAPSS-2037-009

AC2 (GA process remains the same and unaffected by the upgrade)

Continuation from previous test

• Pay the pledge
  
  

Pledge is paid

Soft Credit also paid

Jan 21, 2025 Tested with Monica GA PASS

TAPSS-2037-0010

AC2 (GA process remains the same and unaffected by the upgrade)

Continuation from previous test

• Void and correct the Gift/Pledge, as paid down pledge (or any pledge with payment) does not offer Void Transaction and Add Correction, do a void of the payment first, then can use a Batch Correction to correct an unpaid pledge (note that Void and Add Correction is not available even after payment has been cancelled) then enter the payment again with the new designation.

• void payment first

• note “Void and add Correction is still not available, so one has to do Batch Correction instead

  use Batch Correction instead

• add back the payment

Payment and Soft Credit Pledge are Voided

After Batch Correction, both Pledge and Soft Credit Pledge are corrected

After entering the new payment on new Designation

Jan 21, 2025 Tested with Monica GA PASS

Without using Batch Correction the process would be

1. void the payment (if there is SC, that would also be voided)

2. void the pledge (the whole pledge) (if there is PSC, that would also be voided)

3. recreated the pledge with the new designation (don’t forget if there’s a soft credit)

4. reapply the payment with the new designation

5. Please consider receipts issued and relink receipt to new pledge.

TAPSS-2037-0011

AC2 (GA process remains the same and unaffected by the upgrade)

Convert a gift to pledge payment

• Enter a pledge

• Enter a payment

• convert gift to pledge payment

Gift has been voided

payment has been applied to pledge

GA-PASS

TAPSS-2037-0012

AC2 (GA process remains the same and unaffected by the upgrade)

ASOP recurring gift payment Batch

Captured 4 cards due next month and a batch was auto created. All batch items are linked to the recurring gift and pledge.

GA-PASS

Smart Batch 2.0 testing (Simple Scenarios)

TAPSS-2037-0013

AC2 (GA process remains the same and unaffected by the upgrade)

PeopleSoft Integration, Validation
- set Batch Review Status to Ready for Validation

Batch Should be either Validated Successfully or Not

GA-PASS

TAPSS-2037-0014

Establishing a new recurring gift.

1. Create draft payment schedule

2. Generate payment schedule which will auto create a BT transaction, recurring gift and pledge batch.

3. Close the pledge batch to create the pledge in the donors account.

4. Check next due dates on BT transaction and recurring gift align and BT transaction is ready to capture.

New recurring continuity pledge has been created and linked to the recurring gift object.

The payment schedule is active and linked to the recurring gift object.

The BT transaction due date and recurring gift due date match.

GA-PASS

TAPSS-2037-0015

Auto creation of a credit card batch

1. Authorise transaction via the virtual terminal

2. Capture the transaction via the BT Transaction list view.

3. Check the auto created batch and batch items.

New transaction would authorise successfully.

New transaction would capture successfully.

Batch will auto create with batch item and batch item transaction.

Batch is auto assigned to the user who captured the transaction.

Batch item is linked to the BT transaction that was captured.

GA-PASS

TAPSS-2037-0016

Create and modify from holding a 3rd party pledge payment.

1. Pay down a pledge by a 3rd party. E.g. the pledge is in the foundation name but an individual is making the payment.

2. Close the batch and the payment will appear as a soft credit row in the pledge.

    

3. Modify the pledge and payments from holding to a new account in 3 modification batches. a) void the 3rd party payment.

   b) modify the pledge.

   c) re-enter the 3rd party payment.

3rd party payment would successfully pay down the instalment on the pledge.

3rd party payment and pledge would successfully transfer to the new designation.

Jan 22, 2025 Tested with Monica GA PASS

issue of lingering soft credit on the pledge soft credit which is not voided when we voided the 3rd party payment though the soft credit was voided on the original pledge. @rommel.ngo to raise this with AQ via zendesk

Receipting was ok.

TAPSS-2037-0017

Creating a Bequest budget and make the deceased contact the signator

1. Create a planned gift pledge on the Estate account.

2. Save the gift. Go into the batch item and edit the signator to the deceased person.

No longer able to give 0% legal credit and 100% GRC to a deceased contact if they are a direct contact of the Estate but you can make them a signator after saving the batch.

Waiting until we can use the signator relationship type to have a signator appear in smartbatch.

GA-PASS

TAPSS-2037-0018

Create a Multi designation pledge and add a payment.

1. Create a batch item with multiple schedules. One schedule for each designation.

2. Create a gift batch and make a payment against the pledge with the payment to be split between the designations.

Pledge is successfully created with multiple designations.

Pledge is successfully paid down with one payment splitting into the two designations.

GA-PASS

TAPSS-2037-0019

Run reports from smartbatch e.g batch approval report, imodules batch proof, credit card batch proof.

1. Batch approval report located on all batches.

2. Credit card batch proof report located on credit card batches only,

3. Imodules batch report located on imodules batches only

Successfully run all reports from the batch.

Rommel PASS

TAPSS-2037-0020

Cheque batch - (check custom fields) add cheque details in description field and check that they appear in the corresponding fields in the batch item.

Change cheque dates using the 'Usyd Batch date' option on the batch details screen.

Add a bequest intention task to a cheque gift from the batch item transaction screen.

Check details transfer automatically from the description field into the batch item bank, BSB and drawer fields.

New bequest task is created successfully from the batch item transaction screen.

Batch dates, batch item dates and batch transaction dates are all updated to the date entered into the Usyd Bank date change function.

@rommel.ngo as discussed, custom fields - not populating from description - Tracking under - https://sydneyuni.atlassian.net/browse/TAPSS-2492

Usyd batch date - GA PASS

bequest task - GA PASS

TAPSS-2037-0021

Receipting

1. Run receipting utility

2. Generate and attach receipt via Apsona.

3. Check that the pdf is attached to the receipt object.

4. Check that the email template is correct.

Receipt object is successfully created.

Apsona report generated a reciept, attaches the PDF receipt to the receipt object and emails the donor using the email receipt template.

@Sushma Ramachandrappa to successfully test this I will need emails turned on in UAT. I have already raised this as part of MA testing.

Post receipt - PASS

Email receipt - GA PASS Tested with Monica

Entry Methods

Cheque - Cheque details are not populating from the description into the batch item and into the custom bank, bsb and drawer fields. - Tracing under Jira - https://sydneyuni.atlassian.net/browse/TAPSS-2492

Credit card - GA PASS

ACH - GA PASS

Pledge - GA PASS
Grant - GA PASS

Recurring gift - GA PASS

Planned gift - GA PASS

Add Soft Credit - GA PASS

Pledge Payment - GA PASS

Void - GA PASS

Multi contact household - GA PASS

3rd party pledge payment - GA PASS

convert gift to pledge payment - GA PASS test with Monica

Add transaction to existing gift - GA PASS test with Monica

Soft credit this account - GA PASS test with Monica

Soft credit other account - GA PASS test with Monica

Personal property - GA PASS test with Monica