Reconciliation Batch (Config Guide) -ProntoPlus
- Jhetah Mae Leornas
Process Automation Settings
Go to Setup > Process Automation > Process Automation Settings > Enable record locking and unlocking in Apex.
Note: Locking Reconciled Opportunities and BDE Items features are only applicable for custom Users (cloned system admin profile) and not for default System Admins.
Trigger Handlers
Trigger Handler Name = PPL_OpportunityRecItemAutomation_TDTM
Class = ProntoPlus.PPL_OpportunityRecItemAutomation_TDTM
Object = Opportunity
Trigger Action = BeforeInsert;BeforeUpdate
Load Order = (after all existing trigger handlers on Opportunity object)
Active = checked
Trigger Handler Name = PPL_Opportunity_AddToRecBatch_TDTM
Class = ProntoPlus.PPL_Opportunity_AddToRecBatch_TDTM
Object = Opportunity
Trigger Action = BeforeInsert;BeforeUpdate;BeforeDelete
Load Order = (after PPL_OpportunityRecItemAutomation_TDTM trigger handler)
Active = checked
Opportunity Layout
1. On the Opportunity list view, add the Add to Rec Item button. Go to Setup > Object Manager > Opportunity > Search Layouts for Salesforce Classic > List View > Edit > Add Add to Rec Item
2. Update the Opportunity page layout and add the following fields:
a. Create Rec Item
b. Related Rec Item
c. Reconciliation Batch Status
d. Transaction Fee
Bank Item Layout
1. On the Bank Item list view, add the Add to Rec Item button. Go to Setup > Object Manager > Bank Item > Search Layouts for Salesforce Classic > List View > Edit > Add Add to Rec Item.
2. Update the Bank Item page layout and this field:
a. Related Rec Item
Reconciliation Batch Layout
1. On the Reconciliation Batch page layout, add the Reconcile and Recalculate buttons.
a. Go to Setup > Object Manager > Reconciliation Batch (PPlus) > Page Layouts > Reconciliation Batch Layout
2. Add the following fields:
a. Reconciliation Batch Name
b. Total Amount
c. Total Related Bank Item Amount
d. Reconciliation Batch Fee
e. Total Transaction Fee
f. Posted Date
g. Batch Status
h. Difference Amount
3. Add Bank Items on the related list and Notes & Attachments
For the Reconciliation Batch object, add the following Batch Status picklist values.
o Unreconciled (Default = checked)
o Reconciled
Delete ‘Open’ and ‘Closed’ values and assigned existing ones based on below.
o Assign ‘Open’ to ‘Unreconciled’
o Assign ‘Closed’ to ‘Reconciled’
Go to Object Manager → Reconciliation Batch → Field Sets → List View Fields
o Reconciliation Batch Text Name
o Total Amount
o Total Related Bank Item Amount
o Reconciliation Batch Name
o Total Transaction Fee
ProntoPayments (if installed also)
Update the PP Payment Batch page layout and add the field.
o Create Rec Item (picklist)
ProntoGiving (if installed also)
Add the Create Rec Item button on the Batch Donation page layout
Update the Batch Donation Entry page layout and add the field.
o Create Rec Item (picklist)
Create Card Type (custom field)
On the Opportunity object create a new custom field with these following details:
Go to Setup > Object Manager > Opportunity > Fields and Relationships. Click the “New” button.
Data Type: Formula
Formula Return Type: Text
Field Label: Card Type
Field Name: (automatically populated by the Field Label)
On the Formula editor copy and paste this formula:
TEXT( ASPHPP Last_Payment_Transaction r.ASPHPP Card_Type c )
List View
Opportunity List Views :
Visa/Mastercard to Reconcile
o Filters:
All Opportunities
Card Type = Visa Card, Master Card, Tokenisation
Related Rec Item = BLANK
Won = True
Settlement Date = LAST WEEK
Cheque to Reconcile
o Filters:
All Opportunities
Payment Type = Cheque
Related Rec Item = BLANK
Won = True
Close Date = LAST WEEK
Cash to Reconcile
o Filters:
All Opportunities
Payment Type = Cash
Related Rec Item = BLANK
Won = True
CloseDate=LASTWEEK
AMEX to Reconcile
o Filters:
All Opportunities
Card Type = American Express Card
Related Rec Item = BLANK
Won = True
Settlement Date = LAST WEEK
Direct Debits to Reconcile
o Filters:
All Opportunities
Payment Type = "Bank"
Related Rec Item = BLANK
Won = True
Settlement Date = LAST WEEK
Direct Deposit
o Filters
All Opportunities
Stage = Closed Won
Created Date = Today
Payment Type = Direct Deposit
Reconciliation Batch List view:
Unreconciled Batches
o Filters:
All reconciliation batches (pplus)
Batch status = Unreconciled
Bank Item List view:
Unreconciled Bank Items
o Filters:
All bank items
Related Rec Item = BLANK
o Fields to Display
Bank Item ID
Amount
Related Rec Item
Bank Account Name
Date
Description
Page Components
Reconciliation Batches (PPlus)
A. Window Components
1. Open a Reconciliation Batch (PPlus) record and click Edit Page on the drop down gear icon.
2. Drag and drop the Highlights Panel Componenet to the upper center:
Assign Compact Layout
o Go to Setup | Reconciliation Batch | Compact Layouts → Clone the System
Default and labelled name as Reconciliation Layout Cloned
o Selected Fields
Reconciliation Batch Name
Total Amount
Total Related Bank Item Amount
Adjustment Field
Toltal Fee
Difference Amount
Drag and drop the Tabs Component below the Highlights Panel.
Add Tabs as follows;
o Details
o Related
o Unreconciled Bank Items
Tab Label → Custom
Custom Label → Unreconciled Bank Items
Default Tab → <First Tab>
Drag and drop the Record Detail Component to the Details section.
Drag and drop the Related Lists Component to the Related section.
Drag and drop the List View Component to the Unreconciled Bank Items section.
Setup the List View component to the following filters.
o Object → Bank Item
o Filter → Unreconciled Bank Items
o Number of records to display → 30
User Object Permissions
Give the user profile a limited permission to the following Objects Setup | Profile | User Profile | Object Settings
Objects | Access |
Opportunity | Read, View All |
Reconciliation Batch | Read, View All |
Bank Item | Read, View All |
Reconciliation Batch Settings
Always Enable Reconciliation with Bank Items
Also enable Retrieve Records from Opportunity.