2832486 - Cash - Open Items Report Still Shows Bank Statement Amounts

You have executed the Cash - Open Items report and noticed that some cash items still shows as open in the G/L Account for Cash Receipt - In Transit through a posted bank statements.

SAP Business ByDesign.

1. Go to Business Analytics work center.
2. Go to Design Reports view.
3. Open Cash - Open Items report.
4. Give the relevant selection for company and set of books.
5. For illustration purposes, give key date as 31.12.2018.
6. Execute the report.

You see some entries related to bank statement being shown in the report, even though the concerned payment allocation is posted.

The posting date of the invoice, bank statement and payment allocation differ.

The system behavior is correct. Once you execute the report on or after the posting date of the payment allocation, the items wont show as open.

You can cross-check the data as follows:

1. Go to Business Analytics work center.
2. Go to Design Reports view.
3. Open Cash - Open Items report.
4. Give the relevant selection for company and set of books.
5. For illustration purposes, give key date as 31.12.2018.
6. Execute the report. You see the concerned amount.
7. Add the Source Doc. Item characteristic.

By adding this characteristic, you see to which line items of the bank statement the amount refers to.

8. Take as example one of the line item ID XX-YYY. (XX represents the bank statement ID; YYY represents the line item ID in bank statement XX).
9. Click on the Journal Entry ID (posting date on 31.12.2018) in the report and open the corresponding bank statement XX.
10. Click View All.
11. Go to Transactions tab.
12. Filter by ID YYY.
13. Click on Not Required in the Postprocessing column. The payment allocation screen of that line item will open.
14. Click View All.

You see that the posting date of the payment allocation is on 15.03.2019. This payment allocation is what connects/clears the invoice with the bank statement posting.

15. Go to Payment Confirmations/Returns tab. You'll see the concerned payment/invoice.

You'll see that this payment/invoice has posting date as 14.03.2019.

Therefore considering a cash receipt case, you have:

• The bank statement journal entry posting on 31.12.2018 (credit the G/L Account for Cash Receipt - In Transit).
• The payment/invoice posting on 14.03.2019 (debit the G/L Account for Cash Receipt - In Transit).
• The payment allocation posting on 15.03.2019 (debit and credit the G/L Account for Cash Receipt - In Transit).

Having that said, once you run the report:

• with key date 31.12.2018 the credit amount is open.
• with key date 14.03.2019 the debit becomes open and the credit remains open.
• with key date 15.03.2019 the above items are cleared by the payment allocation posting and no longer shown in the report.

In the case of external payments, the customer invoice can be open via General Ledger -> Source Documents (Show All).

Incoming External Payment. Bank Statement. Payables. Liquidity Management. Cash Management. Reports. Source Document Item. , KBA , AP-PAY , Payment Processing , How To