Manual Matching
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
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
Presentation
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.
Close
Fields
The following fields are present on this tab :
Criteria
| This field mentions the site being the subject of the matching, since a matching can only be performed within the same site. |
| Select the ledger where the matching and unmatching operations will be carried out. |
| 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. |
| Only those documents having an accounting date between the dates entered here will be matched. |
|
|
Block number 2
Balances
|
|
|
|
|
|
|
|
|
|
|
Grid Details
| 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. |
| This date represents the accounting date of the original transaction. |
|
|
| Journal number of the recording. |
|
|
|
|
|
|
| This field indicates the product status (A, Q, R).
|
|
|
| Here, indicate the journal code comprised of one to five alphanumeric characters.
|
| It refers to the setup reference. |
|
|
| This code is used to identify the currency for a site, BP, etc. It is managed in the currency table.
|
| If the selection currency has been entered, this field displays the total of the debtor movements in the selected currency for all periods viewed. |
| If the selection currency has been entered, this field displays the total of the creditor movements in the selected currency for all periods viewed. |
|
|
Close
Action icon
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.
Close
Specific Buttons
Use this button to launch the entries search and populate the grid. |
Use this button to validate the manual selection of the amounts to be matched for a matching code to be assigned by the software. |
Use this button to display the next screen. |
Use this button to display the previous screen. |
Menu Bar
Automatic Matching
Use this button to launch the automatic matching of the queried account.
Criteria
Use this option for recalling the matching criteria order of priority in automatic matching.
Search by amount
Use this option to perform a quick search of entries, by amount or by entry number.
Inversion
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.