This chapter contains these topics:
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
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
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
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
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.
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.
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.
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
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.
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:
Chapter 15, "Print General Journals" for information about general journal reports,
Chapter 22, "Financial Reports" for information about income statements and balance sheets,
Chapter 70, "Understand General Accounting User Defined Codes," for information about statutory report setup.