1959405 - Warning Message When Bank Statement Upload Leads to Gap in Continuous Numbering.

A MT940 format bank statement has been uploaded with an opening balance of XXXX, which does not match the closing balance YYYY of the previous MT940 bank statement. It is expected that the system will perform a veto check, preventing the upload and posting of a bank statement where the opening balance does not equal the closing balance of the previously uploaded statement.

SAP Business ByDesign

1. Go to the Liquidity Management work center, and select the Bank Statements view.
2. Select the Newly created bank statement.
3. View Opening Balance.
4. Select the Preceding bank statement ID.
5. View Closing Balance.

Previously uploaded MT940 bank statement closing balance is not matching with the opening balance of the newly uploaded bank statement.

When uploading the next statement you receive a warning:

'Previous bank statement XYZ does not exist or not posted yet.'

This behavior is correct in the event that a bank statement is uploaded with a number that does not follow the ID of the last posted bank statement. In this case, the system displays a warning message. Additionally, another bank statement may be entered with an opening balance that deviates from the closing balance of the previous bank statement.

For example:

Previous bank statement number is 1. The subsequent bank statement ID as derived from the statement header is 3 for the same Bank Account ID.

In order to guarantee a continuity of bank statement numbering and coherence of opening - and closing balances please make sure to add the missing statement or get in touch with your house-bank for clarification.

Bank Statement, Upload, sequence number, posting, Balance. , KBA , mt940 format bank statement , previous bank statement does not exits , AP-ACC , Business ByDesign: Financial Accounting , How To