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

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.

Field descriptions

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

Account balance (field SOLCPT)

field SOLDEV

field SOLSNS

Matching balance (field SOLDE)

field CURCPY

Currency balance (field SOLDLET)

field CURLET

Grid Details

Select (field FLGMTC)

Double-click on the "Sel" column " to select the current line. A check mark appears and the line turns pink. When the selected entries are balanced, they turn green. If other lines are selected and the "Matching" button is activated, X3 will perform a partial (lowercase) or full (uppercase) matching of the selected lines.

Date (field ACCDAT)

This date represents the accounting date of the original transaction.
The accounting date makes it possible to determine the posting period of the accounting entries. It is initialized by default to the current date and it can be changed depending on the value of the PIHACCDAT - Accounting date modification parameter (ACH chapter, INV group).
This date is systematically controlled in order to verify that it belongs to an open and existing fiscal year.
If a problem occurs during the control, the user will need to enter a new date, irrespective of the parameter value.

Type (field TYP)

Document no. (field NUM)

Journal number of the recording.
It defines the journal on which the modification is performed.

Match letter (field MTCAFF)

Debit (field DEBIT)

Credit (field CREDIT)

Status (field STA)

This field indicates the product status (A, Q, R).

When the status changes from A to Q, the stock keeps the same location (no stock movement to be controlled).

Description (field DES)

Journal (field JOU)

Here, indicate the journal code comprised of one to five alphanumeric characters.
Upon creation, the journal is automatically open for all the specified periods.
The journal selected here must be of the same type as the journal linked to the journal type kept in the previous selection criteria.

Warning It is mandatory to enter this field if the box 'All journals' is not checked.

Reference (field REF)

It refers to the setup reference.

Due date (field DUDDAT)

Curr. (field CUR)

This code is used to identify the currency for a site, BP, etc. It is managed in the currency table.
The currency proposed by default is that of the budget.
The exchange rate type applied is based on the BUDTYPCUR - Budget conversion rate type (BUD chapter, CMM group) parameter setting.

It is recommended to use the ISO coding during the creation of a new currency.

Debit (field DEBCUR)

If the selection currency has been entered, this field displays the total of the debtor movements in the selected currency for all periods viewed.

Credit (field CRECUR)

If the selection currency has been entered, this field displays the total of the creditor movements in the selected currency for all periods viewed.

Free reference (field FREREF)

Specific Buttons

Error messages

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

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.

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.

Manual Matching