1:1 Bank Stmt Lines are not auto reconciling for payments
Summary:
Recently appended the bank stmt field customer_reference to prefix "APJ" with the check number (APJ123456). Since then the payments are not reconciling automatically. Example: customer_reference = APJ123456; check/payment number = 123456. The 1:1 matching rule is based on amount and advanced criteria:
statement line.customer_reference = transaction.reconciliation_reference
Have added a new rule but its still not auto reconciling:
statement line.customer_reference CONTAINS transaction.reconciliation_reference OR
transaction.reconciliation_reference CONTAINS statement line.customer_reference
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
24C
Code Snippet (add any code snippets that support your topic, if applicable):