InsightsBuyer’s guides

Buyer’s guides

6 rules

The AutoCash rules Oracle Fusion Cloud Receivables documents for a receipt that names no invoice it can match, from oldest invoice first to a pair of invoices that add up to the payment. Read from Oracle's help on 31 October 2026.

An ERP applies a customer payment by the reference it carries. Test the payments that carry none.

Business Central and Oracle Fusion both document automatic cash application, and both match on the reference the customer sends with the money. The useful demonstration is the receipts that arrive without one.

· 5 min read

Can the ERP apply customer payments automatically, or do we need a cash application tool? Most pages that answer it are published by companies selling those tools, and their answer is predictable: the ERP holds the invoices and their product does the matching. The ERP vendors' own help pages describe matching too, and they agree on one point. The match is only as good as the reference the customer sends with the money.

What Business Central reads on a bank line

In Dynamics 365 Business Central, payments arrive in the Payment Reconciliation Journal from an imported bank file or a bank feed, and the Apply Automatically function proposes a match for each line. It first compares the related party fields on the bank line with the bank account, name or address of customers and vendors that have open entries. It then looks for the transaction text in the document number or external document number of open entries. Last, it compares the statement amount with open amounts. Text matching works only on text longer than four characters.

Each proposal carries a match confidence of High, Medium or Low, set by a table of rules the customer can edit. In Microsoft's standard table, a payment from a recognised party whose amount fits exactly one open entry reaches High with no document number at all. Whatever part of a payment cannot be applied stays in a Difference field, and someone settles it by hand, by mapping recurring text to an account, or by transferring the difference to an account.

What Oracle Fusion does when the receipt names nothing

Oracle Fusion Cloud Receivables searches a receipt for six kinds of number in a fixed order: transaction number, sales order number, purchase order number, balance forward billing number (lockbox only), shipping reference and contract number. If none matches, it passes the receipt to the AutoCash rule set on the customer's profile, or to the one in system options when the customer has none.

The set holds up to six rules, tried in the order the implementer entered them. Match Payment with Invoice applies a receipt to one item only when the amounts are exactly equal, choosing the earliest due date when several are. Clear the Account and Clear Past Due Invoices apply it only when it equals the customer's whole open or past due balance, and a sixth rule does the same for past due items grouped by payment terms. Apply to the Oldest Invoice First works down from the oldest due date. Combo Rule looks for two items that add up to the receipt exactly: in Oracle's own example a receipt of $572 against five open invoices lands on the ones for $200 and $372. Whatever no rule can place is left unapplied or on account, depending on a setting in the rule set.

Each of those rules is a guess about what the customer meant, ranked by whoever configured it. Oldest first suits a customer that pays its statement. For a customer that pays invoice by invoice and out of date order, it puts the money against an invoice the customer did not pay, and the one it did pay stays open.

Where the reference goes missing

Both designs reward a payment that names its invoice and fall back to amounts and dates when it does not. So the size of the job depends more on how your customers pay than on which ERP you choose. Four kinds of receipt decide it.

  • One transfer for many invoices. Business Central looks for document numbers in the bank line's own text, so the invoice numbers have to be there. Oracle's Combo Rule stops at two items, so a receipt covering twelve invoices needs their numbers on the receipt.
  • A remittance advice sent apart from the money. The Business Central journal reads the bank line, and Oracle's search reads the receipt record, lockbox data included. Neither help page describes reading a remittance advice that arrives as an email attachment, so ask who keys it, or which other tool extracts it.
  • A short payment. Business Central leaves the gap in the Difference field for a person. Oracle applies an underpaid lockbox receipt within a tolerance only when a Match Payment with Invoice rule is paired with a receipt application exception rule. Ask who sets that tolerance and where the shortfall is recorded.
  • A payer that is not the customer. Business Central's first test is whether the party on the bank line matches a customer's bank account, name or address. A parent company paying for its subsidiaries starts that test without a match.

A test for the demonstration

Bring receipts, not a question. Export a month of real bank lines with the text exactly as your bank sends it, and pick five: a payment quoting one invoice number, one transfer covering several invoices, a short payment, a payment with no reference at all, and a payment from a company other than the customer. Ask the vendor to load matching open invoices, run the automatic application, and show where each receipt landed, on which invoice, at what confidence, and what was left unapplied. Then ask who sets the rule order after go-live, and who may change it.

Before any of that, count your own file. The share of last month's receipts whose bank text carries an invoice number decides whether the ERP's matching is enough, or whether the gap is wide enough to justify a separate cash application tool. A demonstration file is built to match. Yours was not.

What the dataset records

Across every text field of the 55 systems Stackmark profiles, no record carries a line on how customer payments are matched to invoices, on remittance advice, or on lockbox. The profiles describe receivables at the level of the module, so this question has to go to each vendor directly, which is what the five receipts are for.

To put the five receipts to every shortlisted vendor in the same words, open the requirements builder, mark financial management as a must have, and describe each receipt in the notes step. The notes travel with the Markdown, CSV and Excel exports, so every vendor runs the same file.

Sources

  1. [1]https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-reconcile-payments-auto-application
  2. [2]https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-set-up-payment-application-rules
  3. [3]https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-reconcile-payments-cannot-apply-auto
  4. [4]https://docs.oracle.com/en/cloud/saas/financials/26d/fairp/receipt-application-using-the-match-receipts-by-rule.html
  5. [5]https://docs.oracle.com/en/cloud/saas/financials/26d/fairp/how-is-an-autocash-rule-set-selected-and-used.html
  6. [6]https://docs.oracle.com/en/cloud/saas/financials/26d/fairp/examples-of-using-each-autocash-rule.html

On this site

More notes

Keep reading.

All insights