Skip to Content
0
Jun 21, 2020 at 11:33 AM

Direct Cash Flow Expense in month of payment SAP ERP 6.0

77 Views

Dear community, I’m struggling with creating a direct cash flow for a client and hope to get some help here. I´m not an expert with report painter and would appreciate as well links to good tutorials.

I’ve started with the standard cash flow 0SAPRATIO-04 Cash Flow (Direct) provided by SAP but realized that it’s not getting me the results that I need as it is only based on accounts or financial statement items on a yearly basis. Ideally the user should be able to select either 1 period or an interval for both the current period and the previous period. E.g. compare 1-3/2020 with 10-12/2019.

My bigger problem is to determine the expenses at the time they are paid.
Example: Purchase order of goods.
January: Goods Receipt: Debit Expense, Credit GR/IR,
February: Invoice: Debit GR/IR, Credit Vendor,
March: Payment of Vendor Invoice: Debit Vendor, Credit Bank Sub Account Transfers,
Bank Statement: Debit Bank Sub Account Transfers, Credit Bank Main Account.

In this example the cash movement is in March and need to be recognized in this month, however I need it assigned to the underlying expense account from January.

I think that there must be a standard solution for that but I haven’t figured it out yet. I’m also unclear if I would need to configure the Cash Management Module for that and how to do that.

Is there a different standard cash flow template that provides the above result or any other tool?

I would really appreciate your help on that.
Thanks,
Evelyn