Background Matching Fields

This topic describes the fields on the Background Matching page.

Note:
If you have enabled the Matching from Cash Entry feature in Feature Console, the default values for some of these fields can be changed in the Default Information section on the Accounting Company object. For more information, see Accounting Company Fields.
Background Matching Fields
Field Description
Account Name The account whose transactions you want to match. Leave this field blank to match transactions for all accounts.
Add Matching Condition Allows you to define additional matching conditions to automatically match any available outstanding balance to other documents for the same account.
Allow Partial Payment Select to allow documents being matched to be part-paid if the source or target document outstanding values do not match. If not selected, any remaining document values are held on account.
Currency Mode

Defines whether matching takes place in the Account currency or the Document currency.

Defaults to the mode set on the companyClosed A self-balancing accounting unit within your organization. details.
Custom First Match By

If you select "Custom" in the First Match By field, you can enter the API Name of the sales invoice field that you want to use to match cash entries to sales invoices.

Matching using a custom field is only supported for matching cash receipts to invoices.

For more information, see About Document Matching Sequence in Background Matching.
Document Matching Sequence

Selects the documents to include in the matching process. The order in which these items are selected determines the order in which the specified document types will be matched. The source documents are the documents being matched, and are sorted first by Account, and then by Due Date. The target documents are the documents that the source documents are being matched to. For example, in the Cash Refund to Credit Note matching process, the source document is the cash entry refund and the target document is the credit note.

Note:

You cannot select Invoice to Credit Note as a Document Matching Sequence if you have selected Cash Entry Date as the Matching Date mode.

For more information, see About Document Matching Sequence in Background Matching
First Match By

Choose one of the following methods to match items to document:

  • Customer Reference
  • Document Number
  • Custom

If you select "Custom" you can enter the API Name of the sales invoice field that you want to use for matching in the Custom First Match By field. Matching using a custom field is only supported for matching cash receipts to invoices.

Cash Entry to Cash Entry matching by Document Number is not currently supported.

For more information, see About Document Matching Sequence in Background Matching.
Match Up To

Choose whether to match up to a specific date or period. Pick the date or period as appropriate. Any documents with a document date later than this date or period will not be matched.

Note:
If you select multiple companies when running background matching from the Accounting Task Launcher, you cannot select a period. The period option is only available if you select a single company.
Matching Currency

Defines the currencies used to retrieve and match documents. You can select one of the following:

  • All Currencies. All eligible documents are retrieved by currency and matched according to the selected Currency Mode.
  • A specific currency. Only documents where the currency is the same as the selected matching currency are retrieved and matched.
Matching Date Mode

The date on which matching is performed. This will be used as the document date on any journals created by the background matching process, such as discount journals.
You can select either:

  • Cash Entry Date
  • Custom Date

If you select a custom date, the matching date cannot be earlier than the document date.
Then Match Remaining By This field becomes available when you click Add Matching Condition. Choose how any available outstanding balance on the source document should be automatically matched to the target document for the same account:
  • Outstanding Value - Highest First or Lowest First. The source document being matched, will be matched to the target documents based on the outstanding value of the target documents. For example when matching invoices on Highest First, an invoice with an outstanding value of 300.00 will be matched before an invoice with an outstanding value of 150.00.
  • Date - Oldest First or Newest First. The source document being matched, will be matched to the target documents based on the document date of the target documents. For example when matching invoices on Oldest First, an invoice with a date of May 30 2015 will be matched before an invoice with a date of June 1 2015.
  • Document Number - Oldest First or Newest First. The source document being matched, will be matched to the target documents based on the document number of the target documents. For example when matching invoices on Newest First, an invoice with the number SIN000100 will be matched before an invoice with the number SIN000067.
Note:

Invoice means both Sales Invoice and Billing Document Invoice. Credit Note means both Sales Credit Note and Billing Document Credit Note.

Buttons

Background Matching Buttons
Button Description
Next (Visualforce) Starts the background matching process.
Start Matching Process (Lightning) Starts the background matching process.