Symptom
Errors in Bank Statement:
- ID XX: Opening balance A must match closing balance of the previous bank statement B.
(XX represents bank statement ID. A represents the opening balance. B represents closing balance of previous bank statement) - Bank Statement XX: Date of current bank statement must be before or equal to date DD.MM.YY of the next bank statement ZZ with validity year YY.
(DD.MM.YY represents the date. ZZ represents the next bank statement. YY represents the year)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management Work Center.
- Go to Bank Statement Sub View.
- Apply advanced filter for Bank Account ID and Company. Click Go.
- Click on Statement ID XX.
Cause
The bank statement ID of the errored bank statement is lower than the previously processed bank statement ID, resulting in a sequence inconsistency.
Resolution
- Delete the bank statement ID that is currently in "In Preparation" status.
- Edit the file “BS.xml” and assign a new Bank Statement ID greater than the previously processed ID. (BS.xml represents the file name)
- Upload the corrected file again.
See Also
KBA 3672772 - Error when Creating New Bank Statement: Date of current bank statement must be after or equal to the date of previous bank statement with validity year
Keywords
bank statement error, sequence inconsistency, opening balance mismatch, closing balance mismatch, liquidity management, cash management, statement ID error, upload error, SWD Bank Statement, financial management, SAP Business ByDesign. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To
SAP Knowledge Base Article - Public