Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

1:1 Bank Stmt Lines are not auto reconciling for payments

edited Sep 3, 2024 3:20PM in Receivables & Collections 2 comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!