Configuring Payment CSV Matching Scope

← Payments in Billing & Invoice Management

JustOn Billing & Invoice Management allows for tracking collections for invoices. To this end, you can import payment entries from CSV files. Imported payment entries are then matched to invoices and dunnings, and, optionally, to opportunities and accounts.

The custom setting Payment Matching Fields determines which fields of which objects to consider, controlling the matching scope.

Payment Matching Fields Information

The custom setting Payment Matching Fields includes the following information:

Field	Description	Example Values
Name	A unique name for the custom setting record.	Account Number Invoice Number
Active	Determines whether the current field is used for the matching.	true false
Field	Specifies the API name (or relationship name) of the field to be used for matching the object to payment entries.	Account__r.AccountNumber Name
Reference Match Expression	Defines a regular expression used to find matching strings in the Reference field of the payment entry.	See Adjusting Reference Matching
Source	Specifies the API name of the object to which the payment entry is to be matched.	Invoice__c

Info

JustOn ships pre-defined matching settings for the invoice number, the IBAN and the account number.

Name	Source	Field	Reference Match Expression
Invoice Number	Invoice__c	Name
Invoice IBAN	Invoice__c	BankAccount__c	[A-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30}
Account Number	Invoice__c	Account__r.AccountNumber

Defining Payment Matching Fields

Depending on your organization's requirements, you must customize the scope for the payment data matching process. Create a dedicated Payment Matching Fields record for each matching target (target object and field).

1. Click to enter Setup, then open Custom Settings.

   In Salesforce Lightning, navigate to Custom Code > Custom Settings.

   In Salesforce Classic, navigate to Develop > Custom Settings.

2. Click Manage in the row of Payment Matching Fields.

3. Click New.

4. Specify the details as necessary.

   The mandatory information include the name and the field.

   See Payment Matching Fields Information.

5. Click Save.

To directly match payment entries to accounts, opportunities or dunnings, you can define the following payment matching settings:

Name	Field	Active	Source
Account No	AccountNumber		Account
Opportunity Name	Name		Opportunity
Dunning	Name		Dunning__c

Adjusting Reference Matching

The basic matching behavior is to compare all words (strings separated by spaces) that are contained in the Reference field of the payment entry with the specified matching fields. However, the relevant strings may not always be separated by spaces, which may prevent them from being matched.

To facilitate the matching, you can use a regular expression that decomposes a complex string, enabling JustOn to detect the relevant part. Provide the expression that works for your Reference field values in the field Reference Match Expression of the custom setting Payment Matching Fields.

Info

For details about the regular expression syntax, refer, for example, to the Pattern overview in the Java Documentation.

Example: Matching Specific Invoice Numbers

The following examples show regular expressions for some invoice number formats that may be defined using counters settings.

Counter	Example Value	Regular Expression
[Year]-{00000}	2017-00021	20\d{2}-\d{5}
XYZ.[Year]99{000000}	XYZ.201799000101 xyz.201799000101	(?i)XYZ\.20\d{2}99\d{6}
A[YearShort]B{000000}	A17B123456	A\d{2}B\d{6}

Example: Matching Invoices With Customer Number

Suppose you have a customer number field CustomerNumber__c on the account. The values are six-digit numbers, for example: 001000, 201000, 991889.

To match invoices to payment entry references that contain such numbers, the Payment Matching Fields configuration would be:

Name	Source	Field	Reference Match Expression
Customer Number	Invoice__c	Account__r.CustomerNumber__c	\d{6}