I had a customer who started a bank reconciliation and then deleted it to start over. The second time going through the bank reconciliation they were unable to match transactions that were previously matching. They got an error when trying to match the transactions.
The error was:
We tried deleting the bank reconciliation again, but that did not fix the issue. I am not sure if this is the correct way to resolve the issue, but I came from a SQL background where we were able to update SQL tables directly. The fact that Microsoft Dynamics 365 BC being in the cloud we are not able to update the tables, but right or wrong you can still make changes to tables sometimes to fix issues.
What I did to fix this issue was to create a configuration package on the table 272 Checker Ledger Entry and exported the table to Excel.
I then updated the lines that we were trying match because they said that the Bank Acc. Entry Applied when in fact they should have been Open and the Statement Line No. should have been a 0. After updating these fields we imported the Excel file and applied the package.
We were then able to match the records and post the bank reconciliation.