16 Overview to Reports and Inquiries

This chapter contains these topics:

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 follows
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 follows
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 follows
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.

See Also: