Use this function to manage manual matching, which pairs accounting entries to facilitate the analysis of an account balance on any given date.
Example: associating an invoice with a payment

The transactions recorded in the A/P-A/R Accounting module on customer and supplier accounts are the object of an automatic matching. The payments are posted directly to the invoices or journals to which they are linked.

The matching function in the Financials module is used for matching GL accounts. 

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Account matching is performed in a general tab where it is possible to select the account which needs to be matched, update the matching criteria and manually or automatically match the account.

Entry screen

Matching

Matching is carried out for the account and possibly the Business Partner, and for the site entered in the header. For large quantities, you can enter a start date and/or end date to limit the selection. Click Search to populate the grid.

Matched entries:  

These are marked with an uppercase letter code.

An automatic line in the journal entry is generated that displays the calculated currency variance when the invoice currency is different from the payment currency.

Unmatched, or partially matched entries:

These are or those entries having been subjected to a partial matching, marked by a lowercase letter code, are displayed.

An automatic line in the journal entry showing the calculated currency variance is not generated. However, if you set the LOWMTCGEN – Exch rate var / low matching parameter (CPT chapter, MTC group) to Yes, the currency variance is calculated and automatically generates a line in the journal entry. This only applies to partial matches after changing the parameter setting. So could have a situation where partial payments before the parameter change do not have a corresponding currency variance and those posted after the parameter change would have a corresponding line in the journal entry for the currency conversion calculation.

Manual matching

Possible matches display in the grid. For each line you have the following options:

  • View the original journal, the open item, or the invoice (BP, purchasing or sales)
  • Select the amount to be matched
  • Search for an amount if, for example, the value and sign suggested by default will close the match group in process
  • Search for an entry line using its entry number (possibly using a template)
  • Select the X amounts that equal the balance of an account and reverse the selection to match all the other entries together for the account
  • Start an automatic matching for the selected account

Automatic matching

You can define automatic matching criteria and the priority to apply these criteria as follows:

  • The maximum number of entries to reconcile for the matching method by amount analysis in accounting, local, and reporting currency
  • The number of identical characters to be paired for a match by description and/or reference analysis and specify if the partial matching is authorized
  • The maximum number of entries that can constitute the account balance within the framework of the balance search matching method.

For the balance search matching method, the process looks for one or more entries whose sum is equal to the account balance.

The posting amount matching method consists of a run through of the account and the matching of all the entries read whenever their balance is equal to zero.

The posting amount matching method or the balance search matching method are less accurate than the matching method by amount or description analogy. They are only recommended for accounts that are difficult to match or that have not been matched for a long time.

Finally, you can limit entries to be matched based on the entry date.

Criteria

This field mentions the site being the subject of the matching, since a matching can only be performed within the same site.

Enter the account to be matched. For an individual account, enter here the code or number of the concerned collective account.

A collective account has been selected, the code of the Business Partner to be matched needs to be entered.

Site (field FCY)
Ledger (field LEDTYP)

Select the ledger where the matching and unmatching operations will be carried out.

Account (field ACC)
field ACCDES
BP (field BPR)
Start date (field DATDEB)

Only those documents having an accounting date between the dates entered here will be matched.
If no date is specified, all the journals corresponding to the other criteria will be matched.
End date (field DATFIN)

Block number 2

Document

It is used to access the accounting entry of the displayed entry. Access to this function is provided in view mode but also in creation and modification modes.
Selection

Check the box in the column Sel. to pick the current line. The line becomes pink. When the selected entries are balanced, they turn green. When several lines have been selected and the button Matching is enabled, X3 performs a partial matching (lowercase) or complete matching (uppercase) on the selected lines.
Unmatching

It is used to select the current line and perform the group unmatching.
Account

Access to the account inquiry.
Open Items

Access to the open item inquiry.
Invoice

Access to the original purchase/sale/accounting invoice.

Specific Buttons

Sort

Use this button to sort the columns of the matching screen based on the mentioned criteria:

  • Accounting date,
  • Local currency amount,
  • Entry number,
  • Entry description,
  • Free reference

Specify your preferred sort type (ascending / descending order). You can save your sorting parameters by clicking Memo.

Search

Use this button to launch the entries search and populate the grid.

Matching

Use this button to validate the manual selection of the amounts to be matched for a matching code to be assigned by the software.

Matched

Use this button to view already matched entries, following an automatic matching process, for instance. If the case arises, a contextual menu makes it possible to unmatch a wrong group. This button also operates in combination with the Unmatchedbutton. They are used to successively view the matched and unmatched entries for a same account.

Not Matched

Use this button to view entries that are not matched or that were subject to a partial matching. This button also operates in combination with the Matched button. They are used to successively view the matched and unmatched entries for a same account.

Next

Use this button to display the next screen.

Return

Use this button to display the previous screen.

Use this button to launch the automatic matching of the queried account.

Use this option for recalling the matching criteria order of priority in automatic matching.

Use this option to perform a quick search of entries, by amount or by entry number.

Use this option to reverse the selection in process: selected elements are cleared and unselected elements are picked.

Limits

Matching in batch mode cannot be applied to a lot exceeded 100 open items. If the matching is performed on a lot exceeding 100 open items, a blocking control is applied.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

The Carryforward in currency option is activated for the account.

This blocking message appears when an account is set up with the carry-forward entries in currency being taken into account and when the matching of the lines in currency is requested.

Too many entry lines to be matched

This error message is displayed when the number of lines to match exceeds the maximum number of lines as defined in the Number of matching lines - MTC activity code.

Tables used

SEEREFERTTO Refer to documentation Implementation