GL Report listing all lines from the documents used

[Former Member]

Hi Experts

The standard GL Report is printed from SAP only GL level transactions.

I would like to produce a printed report by inputting a GL Code and a date range. Output should be all transactions that have been posted to that account during the specified time period. The important requirement of this report is that transactions should actually contain details from the source documents ie a figure from an AP invoice should go on to list the lines on that AP invoice that are relevant to this account. Same applies to AR Invoices, Inventory transactions, etc, etc. Any GL Account specified and details of all

Is there a report in SAP that can achive this or is there a query that can be run to achieve above

Thank you

Regards

Apsara

[Former Member]

Hi Apsara,

If you want to get the detail lines for each document posted to the account, you can only design your query one by one because the base tables are different.

Thanks,

Gordon

[Former Member]

Hi Apsara Senaratna,

I believe that the General Ledger report in SAP can cater your need. (Go to Financials > Financials Reports > Accounting > General Ledger.)

But you just have to uncheck BP, then mark (x) to what GL accounts you want to show details. Then you could also set parameters for Posting, Due, and Document Dates.

Hope this helps!

Thanks!