This article explains the NPSP-for-PaymentHub Opportunity Installment Field Mapper.
FinDock does not and cannot guarantee that every possible configuration of the NPSP Opportunity Installment Field Mapper leads to a working system. Sub-optimal or wrong configurations can slow performance, breaking recursions or standard functionality. Every change to the field mapping configuration must follow standard test procedures.
What is the NPSP Opportunity Installment Field Mapper?
The NPSP Opportunity Installment Field Mapper enables detailed customization of how Installment and Opportunity records are synced at field level. This eliminates the need for custom triggers or process builders to sync fields between Installment and Opportunity.
Enabling the Field Mapper
The new field mapper is auto-enabled for new orgs and cannot be disabled by a customer. This section applies only to existing orgs.
To enable the Opportunity Installment Field Mapper for existing orgs:
- Launch the FinDock app, and on the Setup tab, scroll down to the Source Connectors section and click on PaymentHub-for-NPSP.
- Click on the Opportunity Installment Field Mapping tab and click the toggle to enable.
After enabling, the toggle disappears. In the unlikely case that this feature needs to be disabled, please contact FinDock Support. Enabling this feature changed the behavior of the following fields:
Synchronization is triggered bidirectionally instead of only on opportunity changes. This change may impact customizations, so we advise performing regression testing after enabling.
Create custom mappings
Below is a sample screenshot of the Field Mapper. The numbers correspond to the steps in the following procedure.
To add a custom Installment - Opportunity mapping:
- On the Opportunity Installment Field Mapping tab, add a custom mapping by clicking the Add Record button.
- Select the Opportunity field to map. All fields can be selected, except formula fields and the Managed by FinDock fields (see below).
- Select the sync direction:
- ←: Only sync on Installment changes.
- →: Only sync on Opportunity changes.
- ⇆: Sync both on Installment and Opportunity changes.
- Select the Installment field to map to the selected Opportunity field. All fields can be selected, except formula fields and the Managed by FinDock fields (see below).
- Select the type:
- Always: Sync both on inserts and updates.
- Only On Insert: Sync only on insert.
- Click Save to save new custom mappings or changes to existing custom mappings.
- Use the Delete button to delete a custom mapping.
- Use the Back button to navigate back to FinDock setup.
Opportunity Record Type
Also the Opportunity Record Type can be set using the field mapper, by:
- Under Opportunity Field, select Record Type Id
- Under Installment Field select any text field. This text field must contain either the Id (“0123O0000005qtx”) or the Name (e.g. “NPSP_Default”) of the Opportunity Record Type. Only Direction ← (Installment to Opportunity) and Type “Only On Insert” are supported.
Managed by FinDock
Some fields are managed by FinDock, meaning these mappings are included in the FinDock solution and cannot be further customized.
|Opportunity Field||Direction||Installment Field||Remarks|
|Payment Method||<=>||Payment Method|
|Payment Profile||<=>||Payment Profile|
|Payment Processor||<=>||Payment Processor|
|Campaign Id||<=>||Originating Campaign|
|Generated Payment Reference||<=>||Generated Payment Reference|
|Custom Payment Reference||<=>||Custom Payment Reference|
|Recurring Payment Reference||<=>||Recurring Payment Reference|
|StageName||<=||See remarks||If the installment is created with status Collected, then the NPSP default closed status is used. For all other installment status options, NPSP status Pledged is used. With installment update changes, the FinDock status mapping is used.|
|CloseDate||<=||See remarks||If the installment status is Collected, then the last collection date from the installment is used. In all other cases, the installment due date is used.|
|Opportunity Name||<=||See remarks||Donation + Opportunity CloseDate|
|See remarks||=>||Status||When an installment is created from an opportunity and the opportunity is closed, then the mapping between Installment status and Opportunity stage is used. Otherwise, the status is New. With opportunity updates, the FinDock status mapping is used.|
|See remarks||=>||Source||Always PaymentHub-for-NPSP|
|See remarks||Record Type||Always Receivable|
|Close date||=>||Original Due Date||Only on insert of Opportunity|
|Close Date||=>||Due Date||Only when opportunity stage not closed|
|ID||=>||Opportunity Id||Only on insert of Opportunity|