Transaction Matching Settings
In MYOB Acumatica, you can tailor the settings of the automatic matching process to suit your company's needs.
The automatic matching process uses the available information about imported transactions for searching matching documents and for calculating the relevance rate, which is a measure of how closely a document matches the selected transaction.
The default settings that the system uses for relevance calculation are specified on the Bank Statements tab of the Cash Management Preferences (CA101000) form. However, you can specify matching settings that apply to a particular cash account by using the Transaction Match[1]insert2020/11/1912:43:47+03:00ing Settings dialog box, which opens when you select the cash account and click [2]To fix in UI: -->> MatchING Settings2020/02/2012:21:30+03:00Match Settings on the form toolbar of the Process Bank Transactions (CA306000) form. These settings are applied when the cash account is selected on the form, regardless of the user working on the form.
During the matching process, the system uses the first two sections of the matching settings—Disbursement Matching and Receipt Matching[3]insert2020/08/2114:12:37+03:00 on the Matching Settings tab—to filter [4]insert2020/08/2618:31:05+03:00payments and expense receipts documents in the system [5]documents in the system 2020/08/2618:31:27+03:00by date. The documents whose dates fall into the specified range are considered candidates for calculating the match relevance rate. You can also select the Allow Matching to Credit Memo check box to make the system match receipt bank transactions to AR credit memos prior to matching them to AP bills.[6]insert2020/08/2618:32:50+03:00 The system uses the Invoice Matching section to filter invoices based on their due date or discount date or by cash account.
Then the system uses the [7]insert2020/08/2114:22:52+03:00settings specified on the Relevance Calculation tabnext two sections of the matching settings[8]next two sections of the matching settings2020/08/2114:23:26+03:00—[9]insert2020/08/2114:23:43+03:00Payment and Expense Receipt RelevanceWeights for Relevance Calculation[10]Weights for Relevance Calculation2020/08/2114:24:16+03:00 and [11]insert2020/08/2114:26:11+03:00Invoice Date Range for [12]Date Range for 2020/08/2114:26:16+03:00Relevance Calculation[13] Calculation2020/08/2114:26:20+03:00—to calculate the match[14]insert2020/08/2114:29:43+03:00ing relevance date [15]date 2020/08/2618:33:40+03:00for [16]insert2020/08/2618:33:45+03:00allthe[17]the2020/08/2618:33:46+03:00 documents filtered by date[18] filtered by date2020/08/2618:33:52+03:00. You can select the Consider Empty Ref. Nbr. as Matching check box to make the system automatically match bank transactions to cash transactions with empty reference numbers.
For each matching document, the system displays the calculated rate in the[19]insert2020/08/2114:51:12+03:00 right column on the Relevance Calculation tab <uicontrol>Match Relevance</uicontrol> column on the <uicontrol>Match to Payments</uicontrol>, <uicontrol>Match to Invoices</uicontrol>, or <uicontrol>Match to Expense Receipts</uicontrol> tab of the right pane[20] <uicontrol>Match Relevance</uicontrol> column on.. 2020/08/2114:51:39+03:00. The match relevance rate is between 0[21]insert2020/08/2114:52:19+03:00.00 and 1[22]insert2020/08/2114:51:59+03:0000.00. The best match is the cash transaction with the highest rate or a significantly high rate (see the details in[23]insert2020/04/2411:17:02+03:00 Bank Reconciliation: Additional Information).[24]insert2020/08/2618:32:23+03:00 The system uses the settings specified in the Auto-Match Thresholds section for automatically matching invoices and payments. The cash transactions with a rate of 0 do not appear on the tabs.[25] The cash transactions with a rate of 0 do not ap.. 2020/08/2618:32:32+03:00