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:
- Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- Click New - Bank Statement.
- Enter Company ID.
- Enter Bank Account ID.
Warning: 'Bank Statement ID XXX does not exist or has not been posted yet'.
Case 2:
- Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- Show All Bank Statements.
- 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