Cash Flow Statement (Direct Method) - Problem

[#1]

The Cash Flow Statement (Direct Method) is not reflecting supplier payment transactions, even though the postings exist in the system.

Supplier payments have been correctly created using the Post Outgoing Payments app, and the corresponding accounting documents are posted successfully. However, these transactions are not being displayed in the Cash Flow report, and the report values remain at zero.

All relevant configuration has been checked, including G/L account assignment and reconciliation account mapping. The issue persists even after adjustments to the account setup.

Please find attached a screenshot showing that the Cash Flow Statement remains at zero despite existing accounting entries. 

[Chris1973]

Good day @6-Mar 

Thank you for contacting via mail on this topic. Here is my addition to the links provided earlier by @HenrikeGroetecke.

I think the first you should note is that a supplier payment posted successfully through Post Outgoing Payments is not automatically guaranteed to appear in the direct method Cash Flow Statement.                                              

The report classifies the payment only when the payment’s cash account and the determined offsetting or invoice account match the account combination maintained for the Supplier payments reporting item. Note that debit or credit transaction items require at least one cash account and one offsetting account in the cash flow statement version. Therefore, maintaining only the supplier reconciliation account is not sufficient in this case.

This also explains why @ HenrikeGroetecke forwarded those links to you.

See Example of Cash Flow Statement Version Settings for more details.

You should perform the following checks:

1. In Manage Journal Entries, check the company code, posting date, ledger, supplier reconciliation account, bank or bank clearing account and the cleared supplier invoice. Make sure the posting date falls within the report period and the document is not reversed.    
2. Open Manage Cash Flow Statement Version, select the exact version entered in the statutory report and choose the Supplier payments item. Confirm that your configuration contains the following:
   1. Cash Account: the bank, cash or clearing account used in the payment
   2. Offsetting Account: the account determined against the cash line
   3. Invoice Account: the original expense or asset account, where invoice account logic is used
3. Verify that online offsetting account determination is active. For supported countries and regions. If your documents were posted before activation, process them using Determine Offsetting Accounts for Unprocessed Journal Entries. See KBA 3198141 for more details.
4. Then regenerate the report in Run Statutory Reports with the same company code, ledger, period and cash flow statement version. See Generic Cash Flow Statements for more insights.

Let me know if you have further questions.

Best regards

Chris

[HenrikeGroetecke]

Hello,

Thank you very much for your question.

Have you already referred to the SAP Help Portal documentationß

Cash Flow Statement - Overview 

Cash Flow Statement - Indirect Method

Assign Semantic Tags for Cash Flow Statement

Kind regards,

Henrike

[6-Mar]

I have already checked all the configuration in the SAP Help for Portugal regarding cash flow, and it is correct. The indirect method works, but the direct method does not show any values even though supplier payments are properly posted. I suspect something may be missing, such as a scope item or a less obvious configuration  that is preventing the direct method from working. Is there any additional prerequisite or commonly missed setting?