SAP Knowledge Base Article - Public

3032651 - Issue With Bank Statement ID Sequence

Symptom

Case 1:

When a Bank Statement is created with ID XXX+1 there is a warning:

'Bank Statement ID XXX does not exist or has not been posted yet'.

Case 2:

When a Bank Statement is uploaded with Opening Balance different from Closing Balance from previous bank statement system does not give an error message.

XXX and XXX-1 - Reference to the Bank Statement ID.

Environment

SAP Business ByDesign

Reproducing the Issue

Case 1:

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Click New - Bank Statement.
  4. Enter Company ID.
  5. Enter Bank Account ID.

Warning: 'Bank Statement ID XXX does not exist or has not been posted yet'.

Case 2:

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Show All Bank Statements.
  4. Search for relevant Company and Bank Account ID.

The Bank Statement ID XXX+1 has Opening Balance different from Closing Balance of XXX.

Cause

This occurs because the system considers the numbering ID separated for each Fiscal Year.

And the system will not give an error when the Closing Balance from Fiscal Year 2019 (for example) is different from the Opening Balance from Fiscal Year 2020 (for example).

Resolution

System behavior is correct.

Keywords

Bank Statement, does not exist or has not been posted yet, opening balance, closing balance, Fiscal Year , KBA , bank statement , does not exist or has not been posted ye , opening balance , closing balance , fiscal year , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions