Symptom
You create a first bank statement in a calendar year either manually, per upload or web service integration.
You notice that not only is the bank statement number not an increment of the previous statement or at least 1. Also the Opening Balance of this statement does not equal the Closing Balance of the last processed statement for this bank account.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- Search for affected Bank Statement ID for relevant Company, Bank and Bank Account ID.
Cause
The strong Bank Statement Logic as to sequential processing:
Opening Balance Statement X+1 = Closing Balance Statement X
Statement Number = Previous Statement + 1
Does apply per calendar year. It is entirely possible to load and process a next statement in the next calendar year violating these criteria.
Resolution
This is the expected system behaviour.
We would expect warnings to appear of type:
Bank statement ID 1 does not exist or has not been posted yet
Opening balance XYZ Euro does not match closing balance ABC Euro of last bank statement in the previous year. Check whether a bank statement is missing.
Bank statement numbering does not begin with 1 or bank statement 1 not released yet. Check whether this is correct.
Keywords
KBA , SRD-FIN-MOP , Payment Management , Problem