The first bank statement posted after bank statement ID 0 (created via data migration) for bank account ID ABC presents incorrect opening balance (not equal to closing balance of statement ID 0).
ABC means the bank account ID.
SAP Business ByDesign
Reproducing the Issue
Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- Search for Bank Statement ID 0 for Bank Account ID ABC and notice there's a Closing Balance other than zero.
- Click New > Bank Statement.
- Enter respective Company ID and Bank Account ID ABC.
- Notice that system proposes Statement ID 1 and Opening Balance as zero.
The previous bank statement (ID 0) has a posting date in a year which is not the year of newly bank statement (ID 1) nor the previous year.
For example: Statement ID 0 has posting date in 2017 and Statement ID 1 has posting date in 2019.
The logic for the opening balance calculation of the next bank statement only takes into consideration bank statements posted in the year of the newly created bank statement or the previous year. Because of this logic, the opening balance of zero is allowed. The reason behind this is that there may be bank statements in between that need to be considered, and they might not be posted in chronological order.
In cases of a gap of 2 or more years between previous and newly bank statement, the opening balance in newly bank statement needs to be manually adjusted.
bank statement; bank account ID; opening balance; closing balance; statement ID 0; , KBA , AP-PAY-BS , Bank Statement , How To