Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Business rules: Account transformation

Hi everyone.

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

Esther

Former Member
Former Member replied

Hi Esther,

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.

Regards,

Marcel Frey

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question