Skip to Content
0
Former Member
Mar 10, 2011 at 07:38 AM

P&L Report-Account Group Hierarchy -Position of lower nodes above

128 Views

I define P&L Statement hierarchy in ERP using T Code: KDH2 (account group). The reason why I don't use standard financial statement version is because it can't include cost object /cost element in the hierarchy.

Then I designed a query using Bex Query designer. In row item "account number", I tagged the accoung group as hierarchy and select "position of Lower-level Nodes": above

However, in crystal report, when I recall the database, it is displayed as "higher nodes above." e.g. cost of sales include lower nodes of Material cost and labor cost, it display in Crystal report as:

Cost of Sales 5000

Material Cost 3000

Labor Cost 2000

I want it to display as "lower nodes above":

Material Cost 3000

Labor Cost 2000

Cost of Sales 5000

I have tried in crystal report desinger- -change group option- sort in original order, in asending, in desending , it doesn't work as "lower node above". (i have to group the account ID)

I don't want to use "sort in specific order" in group option because if it is hard coded, it doesnt faciliate future changes if user changes account group hierarchy in SAP ERP KDH2 (account group).

To sum up, is there anyone can tell me how to show the hierarchy in Crystal Report as "lower node above"?

Regards,

Frances