Report for many GL beside each other

[Former Member]

hi all

i search for a report like this

GL accounts beside each other for all profit center in a particular date

coz i want to know the daily deposits for all profit center in a particular date

and i have many banks

and there is a GL for every bank

profit center - GL account no 1 | GL account no 2 | GL account no 3 | GL account no 4 TOTAL

M001 XXXX XXXXX XXXXX XXXXX XXXXX

M002 XXXX XXXXX XXXXX XXXXX XXXXX

M003 XXXX XXXXX XXXXX XXXXX XXXXX

M004 XXXX XXXXX XXXXX XXXXX XXXXX

M005 XXXX XXXXX XXXXX XXXXX XXXXX

M006 XXXX XXXXX XXXXX XXXXX XXXXX

M007 XXXX XXXXX XXXXX XXXXX XXXXX

M008 XXXX XXXXX XXXXX XXXXX XXXXX

Edited by: m.mahmod on May 30, 2011 11:36 PM

[former_member193511 · Accepted solution]

Hello,

Alternatively you can try the sAP standard report "KE5Z - Profit Center: Actual Line Items", which allows you to sum up total by profit center although the display format is a little bit different than requested. Try this report and let me know if there is any question.

Hope this helps.

Kind regards,

John Chin

[sanilbhandari]

Hi

The best way would be to create a report in Library 0FS, if you are on New GL or 8A2 if you are on classic GL through report painter. The T Code to create the report is GRR1. The following link may be useful to you

http://www.virtuosollc.com/PDF/Get_Reporter.pdf

regards

Sanil Bhandari

Edited by: Sanil K Bhandari on Jun 13, 2011 12:29 PM

[Former Member]

ke5z is good but is there any report by date?

[Former Member]

Hi,

If you wish by date or open key date, i will propose you to create a report by custom.

Hope helps

[Former Member]

I am not aware of such report. but you can use Report Painter for this.

Satish