Matching Cash Entries

If you are using Lightning, or custom input forms (CIF) and have enabled the Matching from Cash Entry feature in Feature Console, you can run the background matching process from the Cash Entry page to match an individual cash entry, regardless of the number of cash entry line items.

The following rules apply:

  • You can only match cash entries of the Receipt or Refund type.
  • You must post the cash entry before you can match it.
Warning:
You must have the Accounting - Background Matching and FDN AsyncApi - Process permission sets assigned. If you do no have the correct permissions, an error message displays

To match a cash entry in CIF:

  1. On the Cash Entries tab, click the cash entry that you want to match.
  2. Click Match.
  3. [Optional] Change the default values. Default values for some of the fields are defined in the Default Information fields on the Accounting Company. For more information, see Accounting Company Fields. Note that the order of the selected documents in Document Matching Sequence will determine the order in which documents will be matched. See Background Matching Fields for details.
  4. [Optional] If you are matching from the CIF page, click Next.
  5. Click Start Matching.

You are notified by email when the matching is complete. You can also view the Process Logs to view matching results.

On a single cash receipt line, in the Account Reference field, you can input multiple invoice numbers or multiple invoice Customer Reference values. The delimiter to use between inputs is the "pipe" character. '|'
For example, SIN000540|SIN000551|SIN000572.

When multiple invoice references are specified on the cash entry line Account Reference, the values are processed left to right during matching, so the left most record is matched first.

Notes:  
  • Matching of Cash entry receipt lines with multiple invoice references is not supported when using custom input forms (CIF) if the Matching from Cash Entry feature is not enabled.
  • Matching Cash Entry to Cash Entry by Document Number is not currently supported. You must select Customer Reference in First Match By to match Cash Entry to Cash Entry.

Lightning Edition

To match a cash entry manually:

  1. Select the "Complete" cash entry that you want to match.
  2. Click Manual Match.
  3. If the cash entry line items have the same account, the Select Currency window displays.
  4. Perform one of the following:
    • Select a cash entry account that you want to match. If the account does not belong to a cash matching account group, it will be also used as a transaction account.
    • Select an intercompany account. This option is displayed only if you have enabled Enable Matching to Intercompany Cash custom setting. For more information, see Cash Matching Settings.
  5. On the Select Filters window, select either of the following:
    • Account Currency
    • Document Currency
  6. Continue. This displays the Cash Matching page. If the cash entry line items have different accounts, a confirmation message appears. Click Proceed to display the Cash Matching page. For more information on Cash Matching, see Matching Cash

To match a cash entry in background:

  1. Select the "Complete" cash entry that you want to match.
  2. Click Background Match. The Background Cash Matching window displays.
  3. Complete the required details and click Start Matching. This starts the matching process in the background. For more information, see Running Background Matching.
Notes:
  • To post and match a cash entry manually, click Post and Manual Match. This posts the cash entry and opens the Cash Matching page. For more information on how to match the cash entry, see Matching Cash.
  • To post and match a cash entry in the background, click Post and Background Match. This posts the cash entry and displays the Background Cash Matching window.

To match a cash entry line in the background, you must assign relevant references or document numbers to the line. To do so, perform either of the following:

  • In the Account Reference field, either enter customer references or document number.
  • In the Documents to Match field, select relevant document numbers.
Note:

You can use either the Account Reference field or the Documents to Match field for a line in a cash entry. Both fields cannot be used for the same line.

To select the documents to match with a cash entry line:

  1. Click in the Documents to Match field of the line. This displays the Select Documents window.
  2. Select the documents to match with the cash entry line and click Confirm.
  3. Click Save on the cash entry page. The background matching process uses these selected documents to match with the cash entry line in the background.
Notes:
  • On the Select Documents window, you can select up to 1000 documents to match with the cash entry line. Selecting more will only match 1000 documents depending on the background matching criteria and leave the remaining ones.
  • The documents selected for the cash entry line are saved in the Documents to Match field on the Cash Entry Lines grid. To change the selected documents, click again.
  • The Documents to Match field must be blank before updating the cash entry type from the Details page or the Account field on the cash entry line.
  • You can change the delimiter used in the Account Reference and the Documents to Match fields by specifying your preferred delimiter in the Custom Delimiter custom setting field in the Background Matching Settings.