Journal Ledger Report

You use the journal ledger report to show movement, and activities of detailed accounts in a specified period. As an accountant, you use journal ledger report to check accounting posting history of a detailed account, especially at month-end closing. The journal ledger report is a legal requirement in the Chinese generally accepted accounting principles (GAAP), which needs to be printed out at the end of month.

The journal ledger report can be applied in different ledgers.

Prerequisites

You have the following authorizations:

Company code (for both accounting documents and general ledger accounts)
Business area
Segment
Profit center

Features

The journal ledger report has the following attributes:

Lists all historical posting and movements in a specified period
An accountant has a general idea of all activities concerning detailed accounts.
The document list is at line level
The journal ledger report can display the posting date, document number, and detail information to support the accountant’s understanding of the purpose and related activities of all documents.
Debited and credit amounts are displayed different columns to support the accountant’s understanding of the movements of a detailed account more transparently
Opening and closing balances are displayed for each period selected
You can also perform the following tasks:
- Drill down in the report to detailed postings (display accounting document)
- Export the report to Excel
- Modify the report layout by showing and hiding fields
- Print out the journal ledger report either directly or asynchronously in the background

Display Report

The displayed report contains all historical posts that fit your selection criteria. Each line of the report describes one document and contains the following default fields:

Account code and name
Posting date
Document number
Description
Debit (document currency)
Credit (document currency)
Document currency
Debit (local currency)
Credit (local currency)
Direction
Balance

The report also shows the beginning and closing balance for the selected period.

Choose Settings to show additional fields in the displayed report or to hide fields.

Display as SAP Crystal Reports

Journal Ledger SAP Crystal Reports provides an alternative way to display the same information.

Print Report

Using a predefined template, you can print a report directly or in the background:

If you print the report directly, you can print as an SAP Crystal Reports report or as an Adobe form
You can preview the report before printing it.
If you choose the background printing option, you can print as an Adobe form
You can specify that the background print job starts immediately or at a scheduled time.

You can also export your report to Microsoft Excel for further manipulation.

Activities

Choose Start of the navigation path G/L Accountant Next navigation step Reports Journal Ledger Report End of the navigation path

The following selection criteria are mandatory:

Company code
The default is the currently-selected favorite.
Fiscal year
The default is the current year.
Ledger
The default is 0L (leading ledger).

You can also choose from the following selection criteria:

Period
The default is the current period.
G/L account number
This can be the number of a general ledger account or the number of a general ledger account level in a level hierarchy. Leave blank for a report on all general ledger accounts.
Business area
Profit center group
Profit center
Segment
Hide accounts without postings
This checkbox indicates whether the accounts that do not have postings and beginning balance in a given period are displayed in the report. This option is selected by default.
Include documents to be verified
This checkbox indicates whether the documents to be verified are displayed and taken into the balance and cumulative amount calculations in the report.
Run report in background
This checkbox indicates whether the report should run in the background. If it is selected, the result of the report is not displayed after executing the search but runs asynchronously in a separate task. The status for reports running in the background can be viewed in the task monitor and the report result can be displayed by choosing Display Report in the task monitor. When the volume of the data to be searched is large and executing the search needs to take a long time, consider selecting this checkbox so that the report runs in the background and returns the result asynchronously.
Process large volumes of data
This checkbox indicates that the report splits the task of search execution into many subtasks and distributes these between multiple server processes for execution. Use this option when the selection criteria imply many general ledger accounts (not account levels) or many periods. The maximum number of processes used to run the report in this way is set in reports customizing.

The larger the number of the maximum processes, the faster the search runs.
Account currency
You can use this field to select a currency in which the report displays the accounts. The following options are available:
- Leave the field blank: this causes all accounts that satisfy the selection criteria to display in the local currency
- Specify the local currency: this causes all local currency accounts that satisfy the selection criteria to display in the local currency
  Figures for foreign currency transactions on these accounts are converted to the local currency before display.
- Specify a foreign currency: this causes all accounts in the specified foreign currency that satisfy the selection criteria to display
  Transaction figures for these accounts are displayed in the foreign currency.

For entering the selection criteria, you can also use the F4 help for a list of options. The account number is displayed as a hierarchy to allow for rapid selection; selecting a parent account also selects all the associated subaccounts.

Not all selection criteria are displayed by default. You can use the (Insert ling) and (Delete line) controls to add or remove lines of selection criteria.

You can save your selection criteria as a variant for reuse.

Document Status

If you have selected the Include Documents to be Verified checkbox, the report also shows the status of each posting accounting document:

A green symbol indicates a posted document
A yellow symbol indicates a document that is to be verified

Drill Down to Posting Document

You can drill down from the journal ledger report to source documents that were used to create the report:

Select a line in the journal report and choose Display Document
The detailed accounting document is displayed in a new window. If you select a line that is not a real posting (such as the beginning balance or the accumulated amount, Display Document is grayed out.