cancel
Showing results for 
Search instead for 
Did you mean: 

P&L statement accounts required to show in cashflow using secondary hierarchy

Prince_121083
Explorer
0 Kudos

I have P&L statement wherein few GL accounts are part of cashflow statements , but in cashflow I don't want to show all P&L accounts so for that purpose I have created two hierarchy 1)P&L 2) Cashflow, so the problem here is net profit is part of P&L statement and net profit is not appearing in cashflow  as an item

P&L.jpgCashflow.jpgHierarchy.jpg

but in data action advance formula also its not allowing to select cashflow node.I want to assign in cashflow ,due to secondry hierarchy childs are not showing

View Entire Topic
N1kh1l
Active Contributor

@Prince_121083 

In DA if you need to access cashflow Accounts, you need to set the Account to the second hierarchy.

CONFIG.HIERARCHY =[d/Account].[h/HierarchyName2]

For reporting you could just create a calculated Account for NET profit by assigning it the top PL Account node and use this in CF hierarchy.

 

Br.

Nikhil