SAP Knowledge Base Article - Public

3723085 - Error in Bank Statement: ID: Opening balance must match closing balance of the previous bank statement

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

  1. Go to Liquidity Management Work Center.
  2. Go to Bank Statement Sub View.
  3. Apply advanced filter for Bank Account ID and Company. Click Go.
  4. 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

  1. Delete the bank statement ID that is currently in "In Preparation" status.
  2. Edit the file “BS.xml” and assign a new Bank Statement ID greater than the previously processed ID. (BS.xml represents the file name)
  3. 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

Product

SAP Business ByDesign all versions