Business rules: Account transformation
I am trying to populate my cash flow statement using the Account Transformation. E.g For the changes in my inventories: I want the difference between the closing balance of DEC (of the previous year) and the closing balance of the current month.
I thought I could use "Source Period" and "Source Year" in the account transformation. Any idea how they can be used? I want to use a property: u201CPrevious yearu201D to make the time dynamic. Is that possible?
Thanks for your help
Marcel Frey replied
You can do these calculations using the "Account Transformation" Business Rules Table.
You need to create two lines to calculate the difference between the closing and the last year closing (only certain columns of the Account Transformation are displayed in my example)
Src Account, Src Flow, Dest Acct, Dest Flow, Rev Sign, Src Year, Src Period
Building F_CLO CF001 F_CLO
Building F_CLO CF001 F_CLO Y -1 DEC
You can also use the current period opening flow instead of the last year closing, this should make the cash flow calculation a little bit easier.