Hi, Get a cup of coffee, we will discuss one more SAP FI Standard Report!
To read the first part of this series please follow:
SAP FI Standard Reports, Your Reporting Requirements Fulfilled!
SAP FI Standard Reports, Document Journal
Menu path: Accounting → Financial Accounting → General Ledger → Information System → General Ledger Reports → Document → General -→ Document Journal → Document Journal
What is our requirement?
To see the journal entry:
- In the regular Debit & Credit format
- With GL Account Code
- With GL Account Description
- Currency and Amount
Two Step Process
First step, finding the document number and second step create another session and run the report with document number & without GL Account code.
First Step, Get the Document Number
- Company code
- Fiscal Year
- Ledger (oL, the leading ledger)
- Posting date interval say from 01.01.2004 to 30.06.2004
- GL Account, say 416100 – Electricity (Fixed)
and hit F8.
What we get is a list of Journals or Documents. From the list let us note down the Document Number.
Second Step, Get the Document Journal
Now we need for a specific document in Debit Credit Format with GL Account Code and GL Account Description. This we can get by inputting one more field, the Document Number to the parameters already entered. Let us select say, 1900006225 document which we want to see in regular Debit Credit Format. Parameter selections will be:
- Company Code 1000
- Document Number 1900006225
- Fiscal Year 2004
- Leger 0L
- Posting date 01.01.2004 to 30.06.2004
- DELETE GL Account 416100
In Output Control:
- Check ‘Line items only’
- Choose your layout
Note, when we give the Document number we should not give GL Account Code. Why? Because if we give GL Account Code as one of the parameters, we will not get both Debit and Credit entries. The output will be only the Debit or Credit pertaining to the given GL Account Code.
Run the report to get the regular Journal Format:
When we run the report for two or more documents, we will get the Debit and Credit totals information end of the list.
Have you enjoyed your coffee and reading the post? Did you find this blog post useful? Please leave your comments in the Comments Section …
Thanks for your time!