Process Diagram
Prerequisite to generate the Receipt
There must be a Contact that is directly linked to the account (Account is NOT Orphaned) for the receipt to be created.
Gift Date is not in the future
Transaction has not already been receipted
Transaction’s Do Not Receipt is not ticked
Direct Linked contact scenarios
The following scenarios are for which receipt cannot be created because there was no directly linked contact when Gift was created (except for household, which presumably always created with direct linked contact).
Test Scenario | Contact is selected on the receipt | Transaction Signator |
---|---|---|
Organization Account no direct linked contacts Gift created directly link a contact (do not mark as primary) | ||
Organization Account no direct linked contacts Gift created directly link 2 contacts (do not mark as primay) | ||
Organization Account no direct linked contacts Gift created directly link 2 contacts (mark one a primary) | primary contact | |
Organization Account no direct linked contacts Gift created directly link a contact (do not mark as primary) manually add a different contact to transaction signatore | signator |
manually added |
Household Account (assume always created with direct contact) no primary contact selected on account Gift Created | signator | forced to select in batch creation |
Household Account (assume always created with direct contact) multiple contacts set as primary and secondary Gift Created - signator is secondary contact | signator (secondary) | forced to select in batch creation |
AQ Receipting Utility - Generating Receipt Records
when you have loaded the utility, and something has changed (i.e. new transactions created or update happened to transactions), any changes would not reflect in the utility unless you refresh the utility page. That means, the find transaction to receipt button may not pickup newly created transactions so make sure you refreshed the page.
Apsona MSR - Data Derivation for receipting General Template/Mapping
Some logic were built into the Merge doc template itself. Please see below where the values are being picked from (merge field from document template are mapped to Apsona MSR field). This is technical field mapping.
Merge Document (Doc template) | Jarvis (Apsona) - Field Mapping | |
---|---|---|
Date | «ReceiptDate» | |
Heading | «IF CareOf»«AccountName» «ELSE IF AccrecordType !="Household"» «AccountName»«ENDIF» «IF CareOf»Care Of: «CareOf» «ELSE IF Deceased»Sir/Madam «ELSE IF LegalCreditCheckLess100Greater0» «IF PSalutation»«PSalutation»«ENDIF» «PFirstName» «PLastName»«IF PSuffix»«PSuffix»«ENDIF» and «IFSSalutation»«SSalutation»«ENDIF» «SFirstName» «SLastName»«IF SSuffix» «SSuffix»«ENDIF» «ELSE IF LegalCreditCheck100» «IF LegalCreditSalutation»«LegalCreditSalutation»«ENDIF» «LegalCreditFirstName» «LegalCreditLastName» «IF LegalCreditSuffix» «LegalCreditSuffix»«ENDIF»«ENDIF» «IF MailingLine1»«MailingLine1»«ENDIF» «IF MailingLine2»«MailingLine2»«ENDIF» «IF MailingLine3»«MailingLine3»«ENDIF» «IF City»«City»«ENDIF» «State» «PostCode» «Country» |
|
Salutation | «SalutationJava» | (function () { // define all merge fields to be used as variables for shorter reference var accountType = {!Account.Account.Account Type}; var grclc = {!Gift Recognition Credit.Gift Recognition Credit.Legal Credit %}; var PLastName = {!Account.Primary Contact.Last Name} ? {!Account.Primary Contact.Last Name} : ""; var PFirstName = {!Account.Primary Contact.First Name} ? {!Account.Primary Contact.First Name} : ""; var SLastName = {!Account.Secondary Contact.Last Name} ? {!Account.Secondary Contact.Last Name} : ""; var SFirstName = {!Account.Secondary Contact.First Name} ? {!Account.Secondary Contact.First Name} : ""; var salutation1 = {!Account.Primary Contact.Salutation} ? {!Account.Primary Contact.Salutation} : ""; var salutation2 = {!Account.Secondary Contact.Salutation} ? {!Account.Secondary Contact.Salutation} : ""; var careof = {!Receipt.Account.Receipting Care of}; var method = 0; var PstandaloneSal = {!Contact Primary.Salutation Link.Standalone Salutation}; var SstandaloneSal = {!Contact Secondary.Salutation Link.Standalone Salutation}; // if standalone salutation, don't print the names if (PstandaloneSal) { PLastName = ""; PFirstName = ""; } // if standalone salutation, don't print the names if (SstandaloneSal) { SLastName = ""; SFirstName = ""; } if (grclc == 100) { // only one contact gets legal credit, we get the first GRC record and the credit contact of that GRC Record PLastName = {!Gift Recognition Credit.Contact Credited.Last Name} ? {!Gift Recognition Credit.Contact Credited.Last Name} : ""; PFirstName = {!Gift Recognition Credit.Contact Credited.First Name} ? {!Gift Recognition Credit.Contact Credited.First Name} : ""; // if standalone salutation, don't print the names if (PstandaloneSal) { PLastName = ""; PFirstName = ""; } salutation1 = {!Gift Recognition Credit.Contact Credited.Salutation} ? {!Gift Recognition Credit.Contact Credited.Salutation} : ""; // second contact is blank salutation2 = ""; SLastName = ""; SFirstName = ""; } // set the Method if no salutation to either of the two contacts, use first name or Supporter if ((PLastName != "" && salutation1 == "") || (SLastName != "" && salutation2 == "")){ if (PFirstName != "" && PFirstName.length > 1 && SFirstName == ""){ // one contact, first name is not one character, method = 1; // use first name } else if (PFirstName != "" && PFirstName.length > 1 && SFirstName != "" && SFirstName.length > 1){ // two contacts, first name is not one character method = 1; // use first name for both contacts } else { method = 2; // no salutation and no first name, use Dear Supporter } } // Household and two contact same surname - Dear Mr Ryan and Mrs Francesca Bryant if ((accountType == 'Household') && (grclc < 100) && (PLastName == SLastName)) { switch(method){ case 1: // Dear Ryan and Francesca Bryant return (PFirstName + " " + "and" + " " + SFirstName + " " + SLastName); break; case 2: // Dear Supporter return ("Supporter"); break; default: // Dear Mr and Mrs Bryant or Dear Chancellor and Mrs Bryant return (salutation1 + " " + "and" + " " + salutation2 + " " + SLastName); } // Household and two contact different surname - Dear Mr Ryan Bryant and Mrs Francesca Parkes } else if ((accountType == 'Household') && (grclc < 100) && (PLastName != SLastName)) { switch(method){ case 1: // Dear Ryan and Francesca return (PFirstName + " " + "and" + " " + SFirstName); break; case 2: // Dear Supporter return ("Supporter"); break; default: // Dear Mr Bryant and Mrs Parkes or Dear Chancellor and Mrs Parkes return (salutation1 + " " + PLastName + " " + "and" + " " + salutation2 + " " + SLastName); } // Not Household with careof } else if ((accountType != 'Household') && (careof)){ return ({!Receipt.Account.Receipting Care of}); } else if ((accountType != 'Household')){ return ("Sir/ Madam"); } else if ((grclc == 100)){ // Household and only one LC switch(method){ case 1: // Dear Ryan return (PFirstName); break; case 2: // Dear Supporter return ("Supporter"); break; default: // Dear Mr Bryant or Dear Chancellor return (salutation1 + " " + PLastName); } } else { return ""; } })() |
Body | ||
Date | «IF Pledge»«LastPaymentDate»«ELSE»«GiftDate»«ENDIF» |
|
Received from | «GiftRecognitionCredit» |
Flow: Gift Pledge Update - V6 Trigger: Gift/Pledge Created or Edited If GRC exist: concatenate contacts’: Contact.Receipt Name or Contact.FirstName Contact.LastName else: Account.Account Name Gift Pledge Update - V6 |
Amount | «GiftAmount» |
|
Receipt | «ReceiptNum» |
|
«COADesignation» |
|
List of Apsona MSR for Generating Receipt Document
Apsona items in UAT is not currently synced with Production. remove this warning once they are both synced.
The following are the reports used in generating Receipt Documents
Apsona Multi Step Report | Merge Action | Template Field Map | Document Template | Email Template | Salutation Calculation field | Change History / Comments |
---|---|---|---|---|---|---|
Receipt - Email | Generate Email and Attach to Record | "AccountName":"Receipt____AQB__AccountId__c___Name", "AccrecordType":"Account____RecordTypeId", "COADesignation":"Receipt____USYD_Transaction_COA_Acc_Num_Roll_Up__c", "CareOf":"Receipt____AQB__AccountId__c___USYD_Receipting_Care_of__c", "City":"Receipt____AQB__AccountId__c___BillingCity", "Country":"Receipt____AQB__AccountId__c___BillingCountry", "DFN1":"Receipt____USYD_Transaction_1_DFN__c", "DFN2":"Receipt____USYD_Transaction_2_DFN__c", "DFN3":"Receipt____USYD_Transaction_3_DFN__c", "DFN4":"Receipt____USYD_Transaction_4_DFN__c", "DFN5":"Receipt____USYD_Transaction_5_DFN__c", "Deceased":"Receipt____AQB__ContactId__c___AQB__Deceased__c", "GiftAmount":"Receipt____AQB__Amount__c", "GiftDate":"Receipt__value__AQB__GiftDate__c", "GiftRecognitionCredit":"Receipt____AQB__GiftId__c___GRC_roll_up__c", "LastPaymentDate":"Receipt__value__USYD_Gift_Date__c", "LegalCreditCheck100":"Calculated_Steps____100%", "LegalCreditCheckLess100Greater0":"Calculated_Steps____>0<100", "LegalCreditFirstName":"Gift_Recognition_Credit____AQB__ContactId__c___FirstName", "LegalCreditLastName":"Gift_Recognition_Credit____AQB__ContactId__c___LastName", "LegalCreditSalutation":"Gift_Recognition_Credit____AQB__ContactId__c___Salutation", "LegalCreditSuffix":"Gift_Recognition_Credit____AQB__ContactId__c___Suffix", "MailingLine1":"Receipt____AQB__AccountId__c___AQB__AccountMailingStreetLineOne__c", "MailingLine2":"Receipt____AQB__AccountId__c___AQB__AccountMailingStreetLineTwo__c", "MailingLine3":"Receipt____AQB__AccountId__c___AQB__AccountMailingStreetLineThree__c", "PFirstName":"Account____AQB__PrimaryContact__c___FirstName", "PLastName":"Account____AQB__PrimaryContact__c___LastName", "PSalutation":"Account____AQB__PrimaryContact__c___Salutation", "PSuffix":"Account____AQB__PrimaryContact__c___Suffix", "Pledge":"Receipt____AQB__GiftId__c___RecordTypeId", "PostCode":"Receipt____AQB__AccountId__c___BillingPostalCode", "ReceiptDate":"Receipt__value__AQB__ReceiptDate__c", "ReceiptNum":"Receipt____Name", "SFirstName":"Account____AQB__SecondaryContact__c___FirstName", "SLastName":"Account____AQB__SecondaryContact__c___LastName", "SSalutation":"Account____AQB__SecondaryContact__c___Salutation", "SSuffix":"Account____AQB__SecondaryContact__c___Suffix", "SalutationJava":"Calculated_Steps____Salutation - Java", "SpecialWording":"Receipt____USYD_Campaign_Special_Wording__c", "State":"Receipt____AQB__AccountId__c___BillingState", "Today":"Receipt__value__AQB__ReceiptDate__c" | USYD_New Standard Receipt Template - Aug 26th _ 2022.docx If Receipt.Acknowledgement type Research Grant or Non Research Grant | Yes | - AVE-176Getting issue details... STATUS
| |
Receipt - Non Email | Generate Document and Attach to Record | N/A | Yes | |||
Reprint Receipt | Reprint Receipts | "AccountName":"Receipt____AQB__AccountId__c___Name", "COADesignation":"Receipt____USYD_Transaction_COA_Acc_Num_Roll_Up__c", "CareOf":"Receipt____AQB__AccountId__c___USYD_Receipting_Care_of__c", "City":"Receipt____AQB__AccountId__c___BillingCity", "Country":"Receipt____AQB__AccountId__c___BillingCountry", "DFN1":"Receipt____USYD_Transaction_1_DFN__c", "DFN2":"Receipt____USYD_Transaction_2_DFN__c", "DFN3":"Receipt____USYD_Transaction_3_DFN__c", "DFN4":"Receipt____USYD_Transaction_4_DFN__c", "DFN5":"Receipt____USYD_Transaction_5_DFN__c", "Deceased":"Receipt____AQB__ContactId__c___AQB__Deceased__c", "GiftAmount":"Receipt____AQB__Amount__c", "GiftRecognitionCredit":"Receipt____AQB__GiftId__c___GRC_roll_up__c", "LastNameDifferent":"Calculated_Steps____>0<100LastNameDiff", "LastNameSame":"Calculated_Steps____>0<100LastNameSame", "LegalCreditCheck100":"Calculated_Steps____100%", "LegalCreditCheckLess100Greater0":"Calculated_Steps____>0<100", "LegalCreditFirstName":"Gift_Recognition_Credit____AQB__ContactId__c___FirstName", "LegalCreditLastName":"Gift_Recognition_Credit____AQB__ContactId__c___LastName", "LegalCreditSalutation":"Gift_Recognition_Credit____AQB__ContactId__c___Salutation", "LegalCreditSuffix":"Gift_Recognition_Credit____AQB__ContactId__c___Suffix", "MailingLine1":"Receipt____USYD_Address_Street__c", "PFirstName":"Account____AQB__PrimaryContact__c___FirstName", "PLastName":"Account____AQB__PrimaryContact__c___LastName", "PSalutation":"Account____AQB__PrimaryContact__c___Salutation", "PSuffix":"Account____AQB__PrimaryContact__c___Suffix", "PostCode":"Receipt____AQB__AccountId__c___BillingPostalCode", "Receipt Gift Date ":"Receipt__value__USYD_Gift_Date__c", "ReceiptDate":"Receipt__value__AQB__ReceiptDate__c", "ReceiptNum":"Receipt____Name", "SFirstName":"Account____AQB__SecondaryContact__c___FirstName", "SLastName":"Account____AQB__SecondaryContact__c___LastName", "SSalutation":"Account____AQB__SecondaryContact__c___Salutation", "SSuffix":"Account____AQB__SecondaryContact__c___Suffix", "SpecialWording":"Receipt____USYD_Campaign_Special_Wording__c", "State":"Receipt____AQB__AccountId__c___BillingState" | USYD_New Standard Receipt Template_Reprint - Edited - BP.docx | N/A | No | |
Consolidated Receipts - Email | Email Consolidated Receipts | "City":"Account____BillingCity", "Country":"Account____BillingCountry", "Different":"Calculate_Step____LC Both Different Last Name", "Gift/Pledge Number":"Gifts_Pledges____Name", "MailingLine1":"Account____BillingStreet", "PFirstName":"Account____AQB__PrimaryContact__c___FirstName", "PLastName":"Account____AQB__PrimaryContact__c___LastName", "PSalutation":"Account____AQB__PrimaryContact__c___Salutation", "PUSYDContactID":"Account____AQB__PrimaryContact__c___USyd_Contact_ID__c", "PostCode":"Account____BillingPostalCode", "Primary":"Calculate_Step____LC-P", "SFirstName":"Account____AQB__SecondaryContact__c___FirstName", "SLastName":"Account____AQB__SecondaryContact__c___LastName", "SSalutation":"Account____AQB__SecondaryContact__c___Salutation", "SUSYDContactID":"Account____AQB__SecondaryContact__c___USyd_Contact_ID__c", "Same":"Calculate_Step____LC Both Same Last Name", "Secondary":"Calculate_Step____LC-S", "State":"Account____BillingState", "TodaysDate":"systemFields::today" | USYD_Consolidated Receipt Template_Updated.docx | Yes | ||
Non Email Consolidated Receipts | No Email Consolidated Receipts | N/A | No | |||
Reprint Consolidated Receipts | Consolidated Receipts - Reprint | USYD_Consolidated Receipt Template_Reprint.docx | N/A | No | ||
Dues | ||||||
Receipt records without Sent Receipts |
Receipt Related Jira Tickets
References:
Link | |
---|---|
AQ Receipting Utility | https://affinaquest.zendesk.com/hc/en-us/articles/360050694211-Receipting |
Zoom Recording - Apsona Receipt walkthrough with Trevor - 15.10.20 | Zoom Recording - Apsona Receipt walkthrough with Trevor - 15.10.20.mp4 |
Change History
Version | Date | Comment |
---|---|---|
Current Version (v. 58) | May 26, 2023 19:17 | rommel.ngo |
v. 74 | Sept 13, 2023 23:48 | rommel.ngo |
v. 73 | Aug 31, 2023 01:06 | rommel.ngo |
v. 72 | Aug 30, 2023 06:20 | rommel.ngo |
v. 71 | Aug 29, 2023 06:07 | rommel.ngo |
v. 70 | Aug 29, 2023 05:31 | rommel.ngo |
v. 69 | Aug 24, 2023 06:40 | rommel.ngo |
v. 68 | Jun 28, 2023 03:26 | rommel.ngo |
v. 67 | Jun 28, 2023 00:55 | rommel.ngo |
v. 66 | Jun 18, 2023 23:02 | rommel.ngo |
v. 65 | Jun 16, 2023 06:38 | rommel.ngo |
v. 64 | Jun 16, 2023 06:30 | rommel.ngo |
v. 63 | Jun 16, 2023 03:21 | rommel.ngo |
v. 62 | Jun 01, 2023 20:01 | rommel.ngo |
v. 61 | Jun 01, 2023 07:48 | rommel.ngo |
v. 60 | May 26, 2023 20:16 | rommel.ngo |
v. 59 | May 26, 2023 20:11 | rommel.ngo |
v. 58 | May 26, 2023 19:17 | rommel.ngo |
v. 57 | May 03, 2023 06:21 | rommel.ngo |
v. 56 | Apr 27, 2023 20:01 | rommel.ngo |
v. 55 | Apr 27, 2023 20:00 | rommel.ngo |
v. 54 | Apr 27, 2023 04:51 | rommel.ngo |
v. 53 | Apr 27, 2023 04:48 | rommel.ngo |
v. 52 | Apr 27, 2023 04:45 | rommel.ngo |
v. 51 | Apr 27, 2023 04:44 | rommel.ngo |
v. 50 | Apr 20, 2023 00:55 |
rommel.ngo
draw.io diagram "Jarvis Receipting Process" edited |
v. 49 | Apr 20, 2023 00:55 | rommel.ngo |
v. 48 | Apr 19, 2023 23:10 | rommel.ngo |
v. 47 | Apr 19, 2023 07:55 |
rommel.ngo
draw.io diagram "Jarvis Receipting Process" edited |
v. 46 | Apr 19, 2023 07:55 | rommel.ngo |
v. 45 | Apr 19, 2023 07:38 |
rommel.ngo
draw.io diagram "Jarvis Receipting Process" edited |
v. 44 | Apr 19, 2023 07:38 | rommel.ngo |
v. 43 | Apr 19, 2023 07:16 |
rommel.ngo
draw.io diagram "Jarvis Receipting Process" edited |
v. 42 | Apr 19, 2023 07:16 | rommel.ngo |
v. 41 | Apr 19, 2023 06:57 | rommel.ngo |
v. 40 | Apr 19, 2023 06:57 | rommel.ngo |
v. 39 | Apr 17, 2023 11:12 | rommel.ngo |
v. 38 | Apr 17, 2023 11:09 | rommel.ngo |
v. 37 | Apr 17, 2023 05:09 | rommel.ngo |
v. 36 | Apr 17, 2023 04:27 | rommel.ngo |
v. 35 | Apr 14, 2023 00:59 | rommel.ngo |
v. 34 | Apr 12, 2023 07:37 | rommel.ngo |
v. 33 | Mar 31, 2023 07:34 | rommel.ngo |
v. 32 | Mar 31, 2023 07:28 | rommel.ngo |
v. 31 | Mar 31, 2023 06:03 | rommel.ngo |
v. 30 | Mar 31, 2023 05:56 | rommel.ngo |
v. 29 | Mar 31, 2023 05:30 | rommel.ngo |
v. 28 | Mar 31, 2023 05:26 | rommel.ngo |
v. 27 | Mar 31, 2023 05:10 | rommel.ngo |
v. 26 | Mar 31, 2023 05:09 | rommel.ngo |
v. 25 | Dec 19, 2022 23:17 | rommel.ngo |
v. 24 | Dec 19, 2022 23:09 | rommel.ngo |
v. 23 | Dec 07, 2022 01:09 | rommel.ngo |
v. 22 | Dec 07, 2022 01:08 | rommel.ngo |
v. 21 | Dec 07, 2022 01:08 | rommel.ngo |
v. 20 | Dec 07, 2022 00:46 | rommel.ngo |
v. 19 | Dec 07, 2022 00:41 | rommel.ngo |
v. 18 | Dec 07, 2022 00:04 | rommel.ngo |
v. 17 | Dec 07, 2022 00:00 | rommel.ngo |
v. 16 | Dec 04, 2022 20:13 | rommel.ngo |
v. 15 | Dec 03, 2022 20:25 | rommel.ngo |
v. 14 | Dec 03, 2022 19:06 | rommel.ngo |
v. 13 | Dec 02, 2022 20:12 | rommel.ngo |
v. 12 | Dec 02, 2022 19:56 | rommel.ngo |
v. 11 | Dec 02, 2022 19:30 | rommel.ngo |
v. 10 | Dec 02, 2022 19:04 | rommel.ngo |
v. 9 | Dec 02, 2022 05:07 | rommel.ngo |
v. 8 | Dec 02, 2022 05:07 | rommel.ngo |
v. 7 | Dec 02, 2022 04:50 | rommel.ngo |
v. 6 | Dec 02, 2022 03:37 | rommel.ngo |
v. 5 | Dec 02, 2022 03:34 | rommel.ngo |
v. 4 | Dec 02, 2022 03:06 | rommel.ngo |
v. 3 | Dec 02, 2022 03:05 | rommel.ngo |
v. 2 | Dec 02, 2022 02:09 | rommel.ngo |
v. 1 | Dec 02, 2022 01:56 | rommel.ngo |