Skip Headers
JD Edwards World General Accounting I Guide
Release A9.3.x

E21540-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

18 Print General Ledger Reports

This chapter contains these topics:

General ledger reports provide detailed information about account transactions. Use these reports when you need to review transactions within individual accounts, to research problems, or to verify account accuracy.

The general ledger reports use AAIs (items GLG6 and GLG12) to determine the beginning and ending account ranges for income statement accounts.

The general ledger reports are DREAM Writer reports.

Before You Begin

18.1 Which Report Should You Choose?

These general ledger reports provide a choice among year-to-date, current period, and inception-to-date totals. You can also include specific document types, such as vouchers or journal entries, on these reports.

Choosing a report depends on how you want to review the information, as follows:

Report Description
General Ledger by Business Unit Lists transactions by object account within a specific business unit.
General Ledger by Object Account Lists transactions by account. Use this report to review specific accounts across all or several business units and to obtain account totals for each group.
General Ledger with Subledger Totals Lists transaction totals by subledger. This report includes the same information you view online on Trial Balance with Subledger or Account Balances by Subledger.
General Ledger by Category Code As an alternative to chart of accounts reporting, lists transactions by any one of the 23 account category codes. Use this report for your statutory reporting requirements.

18.1.1 What You Should Know About

Topic Description
Inception-to-date totals General ledger reports with inception-to-date totals print all detail for all periods with records that have not been purged. The totals may not be accurate if the detail for any prior year has been purged.
Abbreviated column headings The report contains the following abbreviated column headings:
  • Do Ty - Document Type

  • LT - Ledger Type

  • PC - Posted Code


See Also:

18.2 Printing a General Ledger by Business Unit Report (P09420)

Navigation

From General Accounting (G09), choose Reports & Inquiries

From Accounting Reports & Inquiries (G0912), choose G/L by Business

To review transactions by business unit, print the General Ledger by Business Unit report. This report lists information from the Account Ledger (F0911) and Account Balances (F0902) tables. It summarizes totals by period, account, business unit, and company.

You can use the Import/Export function in this program. See the JD Edwards World Technical Tools Guide for more information.

Figure 18-1 General Ledger by Business Unit report

Description of Figure 18-1 follows
Description of "Figure 18-1 General Ledger by Business Unit report"

18.2.1 Processing Options

See Section 84.5, "G/L by Business Unit - (P09420)."

18.3 Printing a General Ledger by Object Account Report (P09421)

Navigation

From General Accounting (G09), choose Reports & Inquiries

From Accounting Reports & Inquiries (G0912), choose G/L by Object Account

To review transactions across all or several business units, run the General Ledger by Object Account report. This report lists information from the Account Ledger (F0911) and Account Balances (F0902) tables.

Choosing online inquiry on Account Ledger Inquiry provides a quicker, more flexible review of the same information.

You can use the Import/Export function in this program. See the JD Edwards World Technical Tools Guide for more information.

Figure 18-2 Period General Ledger by Object Account report

Description of Figure 18-2 follows
Description of "Figure 18-2 Period General Ledger by Object Account report"

18.3.1 Processing Options

See Section 84.6, "G/L by Object Account (P09421)."

18.4 Printing a General Ledger with Subledger Totals Report

Navigation

From General Accounting (G09), choose Reports & Inquiries

From Accounting Reports & Inquiries (G0912), choose G/L with Subledger

To review transaction totals by subledger, run the General Ledger with Subledger Totals report. This report lists information from the Account Ledger (F0911) and Account Balances (F0902) tables. It prints information in business unit, object, and subsidiary sequence and calculates totals by G/L period, subledger, G/L account, business unit, and company.

Figure 18-3 General Ledger with Subledger Totals report

Description of Figure 18-3 follows
Description of "Figure 18-3 General Ledger with Subledger Totals report"

18.5 Printing a General Ledger by Category Code Report

Navigation

From General Accounting (G09), choose Reports & Inquiries

From Accounting Reports & Inquiries (G0912), choose G/L by Category Code

To use a statutory account number instead of business.object.subsidiary, print the General Ledger by Category Code report. The category code indicates the account number and the category code description indicates the account description.

This report provides balance information useful for statutory accounting. It lists information from the Financial Report Master (F1011) and the Account Ledger (F0911) tables.

Printing this report creates a worktable to process and sequence records from the Account Ledger table. The system automatically clears the worktable whenever you change a category code for a business unit. Because the worktable takes time to process, JD Edwards World recommends that you run this report after normal working hours.

Figure 18-4 General Ledger by Category Code report

Description of Figure 18-4 follows
Description of "Figure 18-4 General Ledger by Category Code report"

18.5.1 Processing Options

See Section 84.8, "G/L by Category Code (P09470)."