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?

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.

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.