SAP BPC 10 NW: Cash Flow Planning
I am now in the process of doing Cash Flow Planning and I seek some help from you.
The requirement is to show the direct- cash flow method with showing Inflow and outflow for all three operating, financing and investment activities.
Could somebody help me understanding and doing the configuration part in BPC 10 for this.
I have done the PL and BS. I have used periodic type of input for this where i use BCF to calculate opening balances for each period and script logic to calculate closing balances of each period. How should I integrate the Cash flow in such scenario.
I have created a separate account hierarchy for cash flow, taking the cash flow items and using them as parents of corresponding GL accounts as per the mapping given by business. I am trying to figure out what should be the account type of parent members in such accounts, for now I am made INC for all Inflow and EXP for all Out flow nodes so that if i directly show parents, it will calculate the difference in the report automatically. Is this the right approach for doing it or I must be using account reclassification business rule (if yes, why).
I am also required to provide feature to input amount for bonds and borrowings, and then calculation of interest will come into the picture. what is the best approach to calculate this in the application.
It will be great help if someone can share any document with real world scenario.