Symptom
You are trying to create the Bank Statement with a Statement Date as of 31.01.9999, but when you are trying to mark all the payments to be posted within that date range transactions, you see that Posting Date of 01.02.9999 was showing up. Here you are expecting to see the transactions that were processed and have Posting dates on or before the Bank statement date.
Please note: Above mentioned dates are for example.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the New bank statement sub view.
- Try to create a new bank statement by giving the mandatory details under step:1 - General data.
- Now go to the step:2 - Select Items.
- Here you see that certain number of document ID's(Payments) are not selected.
The issue is that the given statement date was 31.01.9999, but the payment with the posting date 01.02.9999 was showing up.
Cause
While creating the Bank Statement during the step: 2 - Select items, the payments with the posting date 01.02.9999 are showing up because the Issue date and the Posting date was not synching.
If you check under the Advices, number of documents ID's have not been checked because the Issue date and Posting date was not synching. So system is not selecting those particular payments which was having Posting date after the given Statement state.
Apart from this all the other payments within the time frame of Statement date 31.01.9999 for both Issue date and Posting date will be selected.
Resolution
Here the system is behaving as expected.
System only consider the payments which is having the time frame within or exact date of the given Statement date. When the Posting dates getting exceeded than the Statement date then it won't be selected for the confirmation.
Also these not selected payments which was supposed to be get posted on the next month of the Statement date will also be visible under Select Items but won't be checked because if you check the Issue date it will be coming under the time frame of Statement date 31.01.9999.
Keywords
Bank Statement, Outgoing Bank Transfer, Posting Date, Issue Date, Statement Date, Liquidity Management , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem