Use Matching Rules to filter for and match the values of any field from the imported statement to any relevant table in Business Central and find the relevant subledger or ledger account to which the statement entry will be applied and journaled.
Use Matching Rules to filter for and match the values of any field from the imported statement to any relevant table in Business Central and find the relevant subledger or ledger account to which the statement entry will be applied and journaled.
There are pre-loaded rules, which can be changed, removed and added to. Here we see the Automatic Matching Rules page
We will transform a reference entered as the letter C and letter O rather than the number 0 (zero).
We will now make a rule to match the Package Tracking Number of a Sales Shipment to a Customer account if that has been used as a reference on the payment.
Text mappings can be configured for fixed bank statement reconciliation lines received periodically with fixed references or text values.
The following steps demonstrate how to map various references using the Add Mapped Text action.
Now we will map text from a line to define the required matching outcome. We will do this for two similar transactions that need to have different Dimension Codes defined.
Now the filters you defined are on the Mapped Text page
//