Applies to Product - Dynamics 365 Finance
What’s happening?
The customer reported an error in bank reconciliation, specifically a "Query extended range failure: Syntax error near 112." This issue occurs during the reconciliation process when using matching rules.
Reason:
The error seems to occur after entering the payment reference in the reconciliation matching rules. Additionally, it was noted that the "Accounting Date" field has been included in the grouping conditions for the statement line, which may not be intentional, as the bank statements imported do not include values for "Accounting Date."
The error seems to occur after entering the payment reference in the reconciliation matching rules. Additionally, it was noted that the "Accounting Date" field has been included in the grouping conditions for the statement line, which may not be intentional, as the bank statements imported do not include values for "Accounting Date."
Resolution:
Remove the "Accounting Date" from the grouping conditions in the reconciliation matching rules (Cash and bank management> Setup> Advanced bank reconciliation setup).
More information at Set up bank reconciliation matching rules - Finance | Dynamics 365 | Microsoft Learn
Remove the "Accounting Date" from the grouping conditions in the reconciliation matching rules (Cash and bank management> Setup> Advanced bank reconciliation setup).
More information at Set up bank reconciliation matching rules - Finance | Dynamics 365 | Microsoft Learn