Cash Flow

[Former Member]

Hi,

I need to create the Cash Flow statement, I have created the Cash flow accounts as hierarchy in my Accounts dimension and understand that Account Transformation rules have to be configured to acheive it but could not find any help available on it.

Please suggest if any help file/how to guide is available on cash flow or else how to derive it using the rules.

The movements are captured in ECC and we have mapped it to our flow dim. What should be the next step...

Thanks

Abhi

[Former Member · Accepted solution]

Hi,

The actual rules are based on your requirements. You could define all your cash flow rules in the account transformation under group ID CF and then map you souce account/flow and speficy the destination there.

Next have a script logic and call the progam CALC_ACCOUNT there. sample logic is: There is a package to trigger this logic. Have it enabled. The BPC process chain is /CPMB/RUNCALCACCOUNT

*RUN_PROGRAM CALC_ACCOUNT 
    CATEGORY = %CATEGORY_SET%
    CURRENCY = LC
    TID_RA = %TIME_SET%
    CALC=CF
    OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM

Hope the above helps.

Thanks,

Sreeni

[Former Member · Accepted solution]

Hi Sreeni,

Thanks for the answer...but Account transformation rules are for reclassification from one account to another. In cash flow we need to know the difference between 2 flows to get the desired movement. How should I fit in Account transformation rules for deriving the Cash flow. It would be great if you could give some example or advice me any help available to understand this...

Regards,

Abhi

[Former Member · Accepted solution]

Hi Abinav,

To simplify things:

You need to have a destination flow. Please check with you business and create a hierarchy for cash flow related purpose.

Let say: you have 2 movements F_ADD and F_DIS for your additions and disposals during the year.

You could have these mapped to a destination cash flow related flows as FC_PUR and FC_DIS which could roll up into FC_INVEST (net cash flows from investing activities). The above example could be used for your FA accounts.

Hope the above helps.

Thanks,

Sreeni

[Former Member · Accepted solution]

Hi Abinav,

for accounts were you do not collect information on a flow basis, I would create a simply flow structure with an opening flow, a change flow, if you need it a CTA flow and a total flow.

You then set up a copy opening rule to fill the opening flow from last year, take the closing flow from this year's data and let the system calculate the change flow as the difference between the two.

So, let's say you have a balance sheet account with the ID 4711 and a cash flow account with the ID CF4711. Create a copy opening rule that copies last year's (closing) balance from 4711 to CF4177 opening flow. Use account transformation to take the current period balance from 4711 to CF4711 total flow and let BPC calculate the difference between the two on the change flow, for example with a dimension formula.

Maybe this helps you along a bit.

Arnold

[Former Member · Accepted solution]

Thanks Arnold, that is helpfull.