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).
-
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.
-
Click Manage in the row of Payment Matching Fields.
- Click New.
-
Specify the details as necessary.
The mandatory information include the name and the field.
-
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} |