16 Overview to Reports and Inquiries

This chapter contains these topics:

Section 16.1, "Objectives,"
Section 16.2, "Overview."

16.1 Objectives

To understand the differences among the various JD Edwards World general ledger reports
To understand which types of general ledger information are available for review online

16.2 Overview

You can access the most current general ledger information available in your system using both hard-copy reports and online inquiries. Reports and inquiries consist of:

Printing trial balance reports
Printing general ledger reports
Printing the transaction journal
Reviewing trial balances online
Reviewing account ledgers and balances online

16.2.1 What Are the Sources for Report Information?

The following tables are the sources for report information:

Report	Source
Trial balances	Account Balances table (F0902)
General ledger	Account Ledger table (F0911)
Transaction journal	Account Ledger table

This graphic shows the tables and the corresponding reports.

Figure 16-1 Tables and Corresponding Report Information

Description of "Figure 16-1 Tables and Corresponding Report Information"

16.2.2 What Are the Sources for Inquiry Information?

The following tables are the sources for inquiry information:

Inquiry	Source
Trial balances	Account Balances table (F0902)
Account balances	Account Balances table
Account ledger	Account Ledger table (F0911)

This graphic shows the tables and the corresponding inquiries.

Figure 16-2 Tables and Corresponding Inquiries

Description of "Figure 16-2 Tables and Corresponding Inquiries"

16.2.3 Are Balances Available as of a Specific Date?

Many of the trial balances, account balance reports, and inquiries have a Thru Date field. These reports read the Account Ledger table (F0911) along with the Account Balances table (F0902) to give you a balance as of a specific date.

16.2.4 Which AAIs Determine Reporting Breaks?

Two automatic accounting instructions (AAIs) identify income statement accounts:

GLG6 - Beginning Revenue Account
GLG12 - Ending Income Statement Account

These AAI accounts are also used to calculate the cumulative balance for a trial balance. Accounts outside this range (GLG6-GLG12) are considered balance sheet accounts.

16.2.5 Do Reports and Inquiries Show Multi-Currency?

You can store your account balances for both domestic (AA) and foreign (CA) ledger types by transaction currency code. Reports and inquiries show information that helps you analyze your balances for multi-currency information. For example, you can analyze currency fluctuations and detailed bank account activity by the originating currency.

16.2.6 Can You Vary Report Detail for Management?

You can summarize accounting information at different levels of detail, depending on your needs. The management information pyramid below will help you work with and interpret many of the JD Edwards World reports and online inquiries.

Figure 16-3 Management Information Pyramid

Description of "Figure 16-3 Management Information Pyramid"

You can summarize information at multiple levels using the level-of-detail code that is assigned to each general ledger account number.

The information at the top of the pyramid summarizes the supporting detail from the lower levels.

As you descend the pyramid, the information becomes more detailed.

At the lowest level of detail are business transactions, such as journal entries, payroll entries, invoices, vouchers, and so on. A manager's access to summary information (at the top of the pyramid) depends on an accurate compilation of detailed information at the bottom of the pyramid.

16.2.7 Does the System Provide Statutory Reports?

European governments have guidelines dictating the account numbers that businesses must use. To accommodate this requirement, you can assign one or more alternate account numbers to category codes 21 - 23. These category codes are used because the code value (in this case, the statutory account number) allows up to 10 characters. You can assign the same category code to multiple accounts, if necessary.

You can use the following reports to provide statutory information:

General Ledger by Category Code
Debit/Credit Trial Balance by Category Code

On these reports, the category code indicates your statutory account number and the category code description indicates the account description. You can summarize several accounts with the same statutory value and list the statutory number and description.

Other reports, produced through the Financial Reporting feature, use the alternate object and subsidiary accounts you can set up for accounts to provide statutory reports.