Does anyone already customize ERPNext Cashflow Report in Indirect method? Since I will be customizing a report and I want to ask for guidance if it is possible or there is anything I should consider before I will be customizing.
Can you explain in details?
Hi @Mubasher here is the details of our customization of Cash Flow Indirect Method.
We know that there are 3 main categories of cash flows, which is Cash Flow from Operating, Investing and Financing, so in these categories, there will be Cash Inflow and Cash Outflow and their account groups.
I created a Doctype for Cash Flow Group where we added account groups for Cash Inflow and Cash Outflow in a purpose of mapping the data of main accounts.
Here is the example accounts column to be displayed in the report
|I. Cash Flow From Operations
|| 311 - Cash Inflow - Operations
|||31101 - Collection from External Customers
|||31102 - Collection from Internal Customers
|||31103 - Collection from Quarries
||||3110301 - Collection from Company
The collection is the Cash Flow Group accounts where we set the field in the main accounts in order to map the data
For example: If the “Account1” in Cash Inflow field have the cash flow group value “Collection from Company” then the entries of this account should be accumulated in the “Collection from Company”
In the report view
Collection from Company 100
Sorry for not explaining, I hope understand. Thank you