Symptom
When posting a bank statement the following error message appears
ID ABC: Opening balance X must match closing balance of the previous bank statement Y. (ABC represents the Statemen ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Select the view Bank Statements.
- Select the dropdown: All Bank Statements.
- Select the Advance Filter.
- Enter Bank Account ID: 123 (123 represents the Bank Account ID).
- Select Statement ID ABC (This is the Bank Statement that you are trying to post).
- Select View All
- Select Next until Step 5 Review
Error :
ID ABC: Opening balance X must match closing balance of the previous bank statement Y.
Cause
The error messages received while posting bank statements is correct.
The opening balance of a bank statement must match the closing balance of the previous bank statement. You need to check the balances with your bank to provide the correct values in the file.
Resolution
When posting a Bank Statement there is a field titled Validity Year.
- Go to the Liquidity Management work center.
- Select the view Bank Statements.
- Select the dropdown: All Bank Statements.
- Select the Bank Statement that you are trying to post.
- Select View All.
- Check the Validity Year
Now look at the last Bank statement posted for that Year. Check the closing balance of that statement. This closing balance should match the opening balance of the new Statement.
Keywords
Bank Statement, Opening Balance, Closing Balance, must match , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem