G JD Edwards EnterpriseOne General Accounting Reports

This appendix contains the following topics:

G.1 Types of General Accounting Reports

This section provides overviews of these types of General Accounting reports:

  • General journal reports

  • Trial balance reports

  • Category code reports

  • General ledger reports

Most of the JD Edwards EnterpriseOne General Accounting reports can be grouped into one of these types of reports.

G.1.1 General Journal Reports

Normally, you review the general journal online. However, to perform a detailed analysis, a printed general journal might provide a more workable format. Printed reports are especially helpful when you are resolving out-of-balance conditions. You can print a general journal that shows unposted journal entries or both posted and unposted entries. All the general journals print transactions from the F0911 table.

If you are using multiple currencies, both the CA foreign amounts and the AA domestic amounts print for foreign transactions.

The processing time for these reports is related to the number of F0911 records in your system.

G.1.2 Trial Balance Reports

Trial balance reports are useful to verify the accuracy of individual ledger account balances and your overall ledger. If a balancing problem occurs, you can review these reports to locate the problem. For example, you can use a trial balance report to locate which period is out of balance. You can also use the report to analyze the debit and credit totals that make up your trial balance. Trial balance reports use information from the F0902 table.

You can use the trial balance reports to review cumulative balance information. You can use the debit/credit trial balance to review totals for debits and credits. All of the reports provide information through the current period or any previous period or fiscal year that has been retained in your Account Balances table.

G.2 JD Edwards EnterpriseOne General Accounting Reports: A to Z

This table includes a summary of the JD Edwards EnterpriseOne General Accounting reports:

Report ID and Report Name Description Navigation
R00650

Data by Business Unit

Prints the supplemental data that is set up for the business units. Business Unit Supplemental Data (G09312), Data by Business Unit
R09205P

Account Master Report Cat. Code 01–23

Prints the accounts in your chart of accounts that are associated with category codes 01–23. Financial Reports (G75C09), Account Master Report Cat. Code 01–23
R09206

Account Master Report Cat. Code 24–33

Prints the accounts in your chart of accounts that are associated with category codes 24–33. Financial Reports (G75C09), Account Master Report Cat. Code 24–33
R09207

Account Master Report Cat. Code 34–43

Prints the accounts in your chart of accounts that are associated with category codes 34–43. Financial Reports (G75C09), Account Master Report Cat. Code 34-43
R09301

Unposted General Journal

Unposted Cash Basis Report

Prints unposted transactions. Journal Entry, Reports, & Inquiries (G0911), Unposted General Journal

Cash Basis Accounting (G09314), Unposted Cash Basis Report (R09301)

R09301

General Journal by Batch

Prints posted and unposted journal entries in batch number sequence. Journal Entry, Reports, & Inquiries (G0911), General Journal by Batch
R09311

General Journal by Account

Prints posted and unposted transactions by account. The report provides totals by account number. Journal Entry, Reports, & Inquiries (G0911), General Journal by Account
R09321

Transaction Journal

Prints transactions within a general ledger date range. This report prints the debit and credit amounts that comprise balanced entries for invoices and vouchers. Accounting Reports (G0912), Transaction Journal
R09410

Trial Balance Report

Prints account balances by business unit. Use this report to analyze account balances by business unit and to obtain business unit totals. This report includes a processing option for level-of-detail summarization. Accounting Reports (G0912), Trial Balance Report
R094121

Trial Balance by Object Report

Prints account balances across all business units. Use this report to review similar object accounts, such as all cash accounts, and to obtain account totals for each group of accounts. Accounting Reports (G0912), Trial Balance By Object Report.
R09420

G/L by Business Unit

Prints transactions by object account within a specific business unit. Accounting Reports (G0912), G/L by Business Unit
R09421

G/L by Object Account

Prints transactions across all or several business units.

This report 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.

Accounting Reports (G0912), G/L by Object Account
R09422

G/L with Subledger Totals

Prints transaction totals by subledger. This report includes the same information that you can view online with the T/B by Subledger program. Accounting Reports (G0912), G/L with Subledger Totals
R09423

Transaction by Object

Prints the account balances and posted transactions for each object account of a specified company over the period selected. Accounting Reports (G0912), Transactions by Object
R09424

Transactions by Subsidiary

Prints the account balances and posted transactions for every object account and subsidiary over the period that you select. Accounting Reports (G0912), Transactions by Subsidiary
R09451

Account Totals by Supplier/Customer

Prints the balance for each customer and supplier by object account. Accounting Reports (G0912), Account Totals by Supplier/Customer
R09470

G/L by Category Code

Prints account balances for accounts assigned to category codes 21–43. Accounting Reports (G0912), G/L by Category Code
R09472

Debit/Credit T/B by Category Code

Prints a trial balance that includes the account balances for accounts assigned to category codes 21–43. Use this report to obtain debit and credit totals, and to supplement your chart of accounts reporting for multinational companies and for statutory accounting. Accounting Reports (G0912), Debit/Credit T/B by Category Code
R09473

Debit/Credit T/B by Object

Prints the total debit and credit amounts for each account in any given ledger.

Current balances for income statement accounts do not include the prior-year balance. To calculate an inception-to-date total for income statement accounts, add the year-end balances for all prior years to the current balance.

Accounting Reports (G0912), Debit/Credit T/B by Object
R11C750

Cash Basis Integrity Test

Prints the cash basis entries for a specified time period. This program produces an exception report that shows the accounts that are out of balance. Only cash accounts can be expected to balance between the two ledgers (AA and AZ). Cash Basis Accounting (G09314), Cash Basis Integrity Test
R11C760

Cash Basis Audit Report

Prints information about the cash basis entries at the transaction level. This report is a powerful research tool that allows you to quickly determine which documents are balanced, as well as which documents are posted. Cash basis entries that do not balance are identified by the message Document Not Balanced. Cash Basis Accounting (G09314), Cash Basis Audit Report

G.3 JD Edwards EnterpriseOne General Accounting Reports: Selected Reports

Some reports include a more detailed descriptions, as well as information about processing options. These reports are listed alphanumerically by report ID in this appendix.

G.3.1 R00650 - Data by Business Unit

This report prints the supplemental data that is set up for business units.

G.3.2 Processing Options for Data by Business Unit (R00650)

Processing options enable you to specify the default processing for reports.

G.3.2.1 Generic Text

Generic Text Option

Specify whether to print generic text on the report. Values are:

Blank: Print the text.

1: Do not print the text.

G.3.2.2 SDB Code

Supplemental Database Code

Enter the supplemental database code in which to print records. If you leave this processing option blank, the system prints records for BU (business unit).

G.3.3 R09205P, R09206, R09207- Account Master Reports

Use these reports to determine if the appropriate accounts are associated with the appropriate category reporting codes:

  • R09205P - Account Master Report Cat. Code 01–23

  • R09206 - Account Master Report Cat. Code 24–33

  • R09207 - Account Master Report Cat. Code 34–43

G.3.4 Processing Options for the Account Master Reports (R09205P, R09206, R09207)

The processing options are the same for Account Master Report Cat. Code 01-23 (R09205P), Account Master Report Cat. Code 24-33 (R09206), and Account Master Report Cat. Code 34-43 (R09207).

G.3.4.1 Print

These processing options specify how information prints on the report.

1. Unstructured Account Number

Specify whether the system prints the 3rd account number (data item ANS) on the report. Values are:

Blank: Do not print the 3rd account number (unstructured account number).

1: Print the 3rd account number.

2. Business Unit Description

Specify whether the system prints the description of the business unit associated with the accounts when the system changes from printing the accounts for one business unit to printing the accounts for another business unit. Values are:

Blank: Do not print the business unit description.

1: Print the business unit description.

G.3.5 R09301 - Unposted General Journal, General Journal by Batch, Unposted Cash Basis

The Unposted General Journal, General Journal by Batch, and Unposted Cash Basis reports print a general journal report to analyze journal entry transactions before you post them to the general ledger. You can print both posted and unposted transactions by batch. The totals printed on this report are by document number and document type within each batch.

G.3.5.1 Unposted Cash Basis Report

Run the DEMO version General Journal: Cash Basis Entries. This version has the data selection set for ledger type equal to AZ and general ledger posted code equal to Blank.

The processing time for the Unposted Cash Basis Report depends on the number of unposted batches in the system. Alternatively, you can review cash basis transactions online. Reviewing transactions online provides a quicker, more flexible review. However, if you require an audit trail for proofing or if a balancing problem exists, the report is more useful for detailed analysis.

G.3.5.2 Data Selection and Sequence for the Unposted Cash Basis Report

You can enter additional data selection, but you should not change the data sequence. The report calculates totals, and changing the data sequence produces unpredictable totaling results.

G.3.6 Processing Options for Unposted General Journal and Unposted Cash Basis Report (R09301)

Processing options enable you to specify the default processing for reports.

G.3.6.1 Account Mode

Account

Specify the format in which to print accounts. Values are:

1: Account number

2: Short account ID

3: Unstructured account

4: Number entered

G.3.6.2 Units

Units

Specify whether to print units. Values are:

Blank: Do not print units.

1: Print units.

G.3.7 R09311 - General Journal by Account

You can print both posted and unposted transactions by account. The General Journal by Account provides totals by account number.

G.3.8 Processing Options for General Journal by Account (R09311)

The processing options for the General Journal by Account are the same as those for the Unposted General Journal.

See Processing Options for Unposted General Journal and Unposted Cash Basis Report (R09301).

G.3.9 R09321 - Transaction Journal

To review transactions within a general ledger date range, print the Transaction Journal. This report prints the debit and credit amounts that make up balanced entries for invoices and vouchers. It uses the logic in the post program to print the original journal entry and the corresponding offsets for the JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Accounts Payable systems, and for taxes.

Multiple offsets for a single journal entry appear on the Transaction Journal as a single amount, as if you were using offset method S (Summary) in the accounts receivable and accounts payable constants. This report includes only the AA ledger amounts and does not include intercompany settlements.

G.3.10 Processing Options for Transaction Journal (R09321)

Processing options enable you to specify the default processing for reports.

G.3.10.1 Display

1. Date From and 2. Date Thru

Specify a beginning and an ending general ledger date in a range of dates for the system to use when selecting records from the F0911 to print on the report.

G.3.10.2 Print

1. GLR3 Reference Number

Specify whether the system prints the Reference 3 (GLR3) field on the report. The GLR3 field contains either the reconciliation number that is assigned during the manual bank reconciliation process or the bank statement number that is assigned during the bank statement process. Values are:

Blank: Do not print the GLR3 field on the report.

1: Print the GLR3 field on the report.

2. Category Code 21-23

Specify which alternate chart of accounts to use to print account numbers. Values are:

Blank: Print the BU.Object.Subsidiary account format.

21: Print the alternate chart of accounts using Category Code 21.

22: Print the alternate chart of accounts using Category Code 22.

23: Print the alternate chart of accounts using Category Code 23.

G.3.11 R09410 - Trial Balance Report

To review balances for business units, print the Trial Balance Report. You can specify summarization at any level of detail without printing lower levels. This report provides subtotals at all higher levels, and a grand total and report for the company.

Note:

This report page breaks on each company. Do not remove the company page break because the report becomes difficult to read.

G.3.12 Processing Options for Trial Balance Report (R09410)

Processing options enable you to specify the default processing for reports.

G.3.12.1 Period

Fiscal Year and Period Number

Specify the last two digits of the fiscal year and the period for which the trial balance is printed. For example, enter 07 for 2007.

If you complete one of these processing options, you must also complete the other. If you leave these processing options blank, the program uses the fiscal year and current period defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the F0010 table.

G.3.12.2 Print

1. Account Number Format

Specify the format for printed account numbers. Values are:

Blank: Standard account number.

1: Standard account number. The default is business unit.object.subsidiary.

2: Short account ID. The system assigns this number.

3: Third G/L number. You assign this number during account setup.

2. Accounts with Zero Balances

Specify whether the system includes or omits accounts with zero balances for the specified period. Values are:

Blank: Include accounts with zero balances.

1: Omit accounts with zero balances.

Note:

Accounts that are assigned a posting edit code N print even if you set this processing option to 1. Accounts that are assigned a posting edit code N are header accounts, which do not have balances.
3. Page Breaks

Enter 1 to skip to a new page when the business unit number changes. Leave this processing option blank if you do not want page breaks.

G.3.12.3 LOD

For rollup from one level of detail to the next to occur accurately, you cannot skip levels of detail when you set up the chart of accounts. Skipping a level of detail produces unpredictable results.

1. Lowest Level of Detail

Specify the lowest level of detail to print on the report. You can enter a value between 3 and 9. For example, if you specify level 7 as the lowest level and the chart of accounts includes levels 8 and 9, level 7 includes the totals for accounts with level 8 and 9 amounts, but the system does not print the detail for levels 8 and 9.

If you leave this processing option blank, the system prints all levels of detail on the report.

G.3.12.4 Ledger

1. Ledger Type

Specify the type of ledger that the report uses. The value that you specify must exist in UDC table 09/LT. If you leave this processing option, the system prints amounts for the AA (actual amounts) ledger type.

Note:

If you specify the CA (foreign currency) ledger type, and the CA ledger type includes amounts for multiple currencies, the totals are meaningless.

G.3.12.5 Subledger

1. Subledger

Specify whether to print amounts for accounts with subledgers. Values are:

Enter a specific subledger number. If you enter a value in this processing option, you must also enter a value in the Subledger Type processing option.

Enter * to include all subledgers

Leave this processing option blank to include only accounts without subledgers.

2. Subledger Type

Specify a code in UDC table 00/ ST that specifies the table containing the subledger numbers. For example, subledger type A for address book subledgers identifies the F0101 table.

If you enter a value in this processing option, you must also enter a value for the Subledger processing option.

G.3.12.6 Currency

This processing option applies only if you post account balances by currency.

1. Currency Code

Specify the currency that the system includes in the report to limit the report to amounts for a specific currency code. The code that you enter must exist in the F0013 table. To include amounts for all currencies, enter *. Leave this processing option blank if you do not post balances by currency.

Note:

If you specify ledger type CA in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals are meaningless unless you enter a specific currency code for this processing option.

G.3.13 R094121 - Trial Balance by Object Report

To review balances by object account across all business units, print the Trial Balance By Object report. You can review totals by object account, company, or both. The report includes a grand total.

G.3.14 Processing Options for Trial Balance By Object Report (R094121)

Processing options enable you to specify the default processing for reports.

G.3.14.1 Select

1. Fiscal Year and 2. Period

Specify the fiscal year and fiscal period for the system to use when printing the report. If you leave these processing options blank, the system uses the reporting year specified in the Company Names & Numbers program (P0010).

3. Ledger Type

Specify the ledger type for the system to use when printing the report. Enter a valid ledger type from the Ledger Type Master Setup program (P0025). If you leave this processing option blank, the system uses ledger type AA.

4. Subledger

Specify a subledger for the system to use when printing the report. Enter * for all subledgers.

5. Subledger Type

Specify a subledger type for the system to use when printing the report. If you entered a subledger in the Subledger processing option, you must enter a value in this processing option.

6. Non Posting Account

Specify whether the system includes non-posting accounts from the F0902 table on the report. Values are:

Blank: Do not include non-posting accounts.

1: Include non-posting accounts. If you changed an account from posting to non-posting and the account still has a balance, the balance is included on the report.

G.3.14.2 Print

1. Zero Balances

Specify whether the system prints accounts with zero balances. Values are:

Blank: The system prints accounts with zero balances.

1: The system does not print accounts with zero balances.

2. Account Number Format

Specify the format in which the system prints the account number. Values are:

1: Print the account number in business unit.object.subsidiary format.

2: Print the short account ID.

3: Print the third (unstructured) account number.

G.3.14.3 Currency

1. Currency Code

Specify the currency code that the system uses to select records for processing. Enter * to include all currency codes.

G.3.14.4 Summarize

1. Beginning Range Object Account Summarization and 2. Ending Range Object Account Summarization

Enter the beginning object and ending object account in a range of accounts for the system to use when selecting records for this report. In a summarized report, detailed transactions appear as a single, summarized balance for each account in the range that you specify. If you leave these processing options blank, the program prints a detailed report for all accounts in the chart of accounts.

G.3.15 R09421 - G/L by Object Account

To review transactions across all or several business units, run the G/L by Object Account report. This report lists information from the F0911 and F0902 tables.

The Account Inquiry by Object Account program (P09201) provides a quicker, more flexible review of the same information.

G.3.16 Processing Options for G/L by Object Account (R09421)

Processing options enable you to specify the default processing for reports.

G.3.16.1 Select

1. From Period

Specify the balances that the system includes in the report. Values are:

0: Use the first period of the current fiscal year as the beginning period. This is the default. The report prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

1: Use the current period as the beginning period. The report prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit-and-loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2: Use the first period of the first fiscal year (when you first used the JD Edwards EnterpriseOne General Accounting system) as the beginning period. The report prints transaction information from the date when you began processing for General Accounting through the current period. This report can be lengthy, depending on the amount of data that you have.

2. From Date

Specify a beginning date in a range of dates for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

3. Thru Fiscal Year

Specify the ending fiscal year in a range of years that the system uses to select records for this report. Enter the last two digits of the fiscal year. For example, enter 07 for the year 2007.

If you enter 0 (for year-to-date balances) for the From Period processing option and you enter a year for this processing option, the year must be the same as the year specified in the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). Otherwise, the report does not include a line item for balance forward amounts.

4. Period Number

Specify a period number for the system to use when selecting records for this report.

5. Thru Date

Specify an ending date in a range of dates for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

6. Subledger

Specify a subledger that the system uses to select records for this report. Enter the subledger or one of these values:

Blank: Process records without subledgers.

*: Process records for all subledgers, including blank subledgers.

7. Subledger Type

Specify a subledger type for the system to use when selecting records for this report. Enter a valid subledger type from UDC table 00/ST. If you specify a value in the Subledger processing option, you must enter a subledger type for this processing option.

8. Ledger Type

Specify the ledger type that the system uses to select records for this report. Enter a code from UDC table 09/LT. If you leave this processing option blank, the system uses ledger type AA.

9. Document Type

Use this processing option with the Ledger Type processing option to specify a document type that the system uses to select records for this report. Enter a document type code from UDC table 00/DT. If you leave this processing option blank, the system selects all document types.

If you do not specify a ledger type for the Ledger Type processing option, the system ignores the value in this processing option.

G.3.16.2 Print

1. Account Number Format

Specify the format in which the system prints the account number. Values are:

1: Print the account number in business unit.object.subsidiary format.

2: Print the short account ID.

3: Print the third (unstructured) account number

2. Units

Specify whether the system prints amounts only or amounts and units. Values are:

Blank: Print amounts only.

1: Print units.

3. Accounts with zero balance

Specify whether the system prints accounts with zero balances. Values are:

Blank: Print accounts with zero balances.

1: Print accounts with zero balances.

4. Posted Transactions

Specify whether the system prints both posted and unposted transactions on the report. Values are:

Blank: Print posted transactions only.

1: Print both posted and unposted transactions

G.3.16.3 Summarize

Beginning and Ending

Enter the beginning object and ending object account in a range of accounts for the system to use when selecting records for this report. In a summarized report, detailed transactions appear as a single, summarized balance for each account in the range that you specify. If you leave these processing options blank, the program prints a detailed report for all accounts in the chart of accounts.

You cannot enter * to summarize all object accounts. Instead, enter the first and last object accounts from your chart of accounts in these processing options, respectively.

G.3.16.4 Currency

1. Currency Code

Specify the currency code that the system uses to process this report. Enter a specific currency code or * for all currency codes.

2. Currency Code From

Specify a currency code for as if reporting. This processing option allows amounts to print in a currency other than the currency in which they are originally entered. Enter a valid currency F0013 table. If you leave this processing option blank, the system prints amounts in the currency in which they were originally entered.

3. As-of-date

Specify the as of date that the system uses when processing the current exchange rate for the as if currency. If you leave this processing option blank, the system uses the value specified in the Thru Date processing option.

G.3.17 R09422 - G/L with Subledger Totals

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

G.3.18 Processing Options for G/L with Subledger Totals (R09422)

Processing options enable you to specify the default processing for reports.

G.3.18.1 Display

1. Report Content

Specify the balances that the system includes in the report. Values are:

0: Use specify the first period of the current fiscal year as the beginning period. This is the default. The report prints current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

1: Use the current period as the beginning period. The report prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit-and-loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2: Use the first period of the first fiscal year (when you began JD Edwards EnterpriseOne General Accounting processing) as the beginning period. The report prints transaction information from the date when you began JD Edwards EnterpriseOne General Accounting processing through the current period. This report can be lengthy, depending on the amount of data that you have.

2. Fiscal Year

Enter the fiscal year in which the system processes the report.

If you enter 0 for the Report Content processing option (for year-to-date balances) and you enter a year in this processing option, the year that you specify must be the same as the year that is specified in the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). Otherwise, the report does not include a line item amount for the balance forward.

3. Period

Enter the period in which the system processes the report. If you leave this processing option blank, the system uses the financial reporting period.

4. Ledger Type

Specify the ledger type that the system uses to select records for this report. Enter a l code from UDC table 09/LT. If you leave this processing option blank, the system uses ledger type AA.

5. Document Type

Use this processing option, with the Ledger Type processing option, to specify a document type that the system uses to select records for this report. Enter a code from UDC table 00/DT. If you leave this processing option blank, the system selects records for all document types.

If you do not enter a value for the Ledger Type processing option, the system ignores the value entered for this processing option.

6. Transaction Status

Specify whether the system prints both posted and unposted transactions. Values are:

Blank: Print only posted transactions.

1: Print both posted and unposted transactions.

G.3.18.2 Print

1. Account Number Format

Specify the format in which the system prints account numbers. Values are:

Blank or 1: Standard account number (business unit.object.subsidiary).

2: Short account ID.

3: Third general ledger number.

2. Print Units

Specify whether the system prints amounts only or amounts and units. Values are:

Blank: Print amounts only.

1: Print amounts and units.

3. Zero Balances

Specify whether the system prints accounts with zero balances. Values are:

Blank: Print accounts with zero balances.

1: Omit accounts with zero balances.

G.3.18.3 Summarization

1. Business Unit Type

Specify a business unit type for subledger summarization. Enter a specific business unit type or one of these values:

+: Include all types

*: Include all non-blank types.

2. Subledger Summarization Beginning Object and 3. Subledger Summarization Ending Object

Specify the beginning and ending object accounts in a range of object accounts for subledger summarization.

G.3.18.4 Currency

1. Currency Code

Specify a currency code to use when printing the report. Enter a valid currency code from the F0013 table or * for all currency codes.

G.3.19 R09423 - Transactions by Object

The Transactions by Object report shows the account balances and posted transactions for each object account of a specified company over the period selected. It displays all of the posted transactions and account balances for each account in the debit/credit format.

All posted transactions for the period and object account selected are printed in the debit, credit, and total columns. If no transactions were posted for an account during the period selected, only the totals for the account appear.

This list describes each of the total amounts that appear at the end of the Transaction by Object report:

  • Total Transactions: Sum of all transactions for the current period.

  • Prior Period Transaction Total: Sum of all transactions from previous periods in the fiscal year up to the current period.

  • Column Total: Sum of the Total Transactions plus the Prior Period Transaction Total.

  • Prior Year End Balance: Balance of the object account from the previous year.

  • Prior Period End Balance. Sum of all prior period transactions and the prior year end balance.

  • Ending Balance: Sum of the Prior Year End Balance and the Column Total balance.

    Note:

    If you use the CA ledger type, the subtotals and totals might be meaningless because of mixed currencies. If so, the totals indicate N/A.

G.3.20 Data Selection for the Transactions by Object

The system ignores data selection for a specific business unit for this report.

G.3.21 Processing Options for Transactions by Object (R09423) and Transactions by Subsidiary (R09424)

Processing options enable you to specify the default processing for reports.

G.3.21.1 Period

1. Period From and 2. Period To

Specify the first and last periods from which the system retrieves transactions for the report.

If you leave the Period From processing option blank, the system uses the current period of the company that is specified in the data selection.

If you leave the Period To processing option blank, the system uses the period specified in the Period From field.

3. Fiscal Year

Enter the last two digits of the fiscal year for which you want the report to print. For example, enter 07 to print the report for the year 2007.

G.3.21.2 Ledger

1. Ledger Type

Specify the ledger type for the report. If you leave this processing option blank, the system uses ledger type AA.

Note:

If you enter CA for the ledger type, subtotals and totals may be meaningless.

G.3.21.3 Print

1. Suppress Zero Amounts

Specify whether to suppress printing transactions with zero amounts. Values are:

Blank: Print transactions with zero amounts.

1: Do not print transactions with zero amounts.

2. Suppress Print Total

Specify whether to suppress printing period totals. Values are:

Blank: Print period totals.

1: Do not print period totals.

G.3.22 R09424 - Transactions by Subsidiary

The Transactions by Subsidiary report shows the account balances and posted transactions for every object account and subsidiary over the period that you select. It displays all the posted transactions for each account and subsidiary in the debit/credit format.

All posted transactions for the period, object account, and subsidiary selected are printed in the debit, credit, and total columns. If no transactions were posted for an account and subsidiary during the period selected, only the totals for the account and subsidiary appear.

This list describes each of the total amounts that appear at the end of the Transactions by Subsidiary report:

  • Total Transactions: Sum of all transactions for the current period.

  • Prior Period Transaction Total: Sum of all transactions from previous periods in the fiscal year up to the current period.

  • Column Total: Sum of the Total Transactions plus the Prior Period Transaction Total from the F0902 table.

  • Prior Year End Balance: Balance of the object account from the previous year from the F0902 table.

  • Prior Period End Balance: Sum of all prior period transactions and the prior year-end balance.

  • Ending Balance: Sum of the Prior Year End Balance and the Column Total balance.

G.3.23 Data Selection for the Transactions by Subsidiary

The system ignores data selection for a specific business unit for this report.

G.3.24 Processing Options Transactions by Subsidiary (R09424)

The processing options for the Transactions by Subsidiary report are the same as those for the Transactions by Object report.

See Processing Options for Transactions by Object (R09423) and Transactions by Subsidiary (R09424).

G.3.25 R09451 - Account Totals by Supplier/Customer

The Account Totals by Supplier/Customer report shows the balance for each customer or supplier by object account. The report lists the balance for each account for which the customer or supplier has transactions, as well as a total of all account balances for each customer or supplier. You can include only posted transactions or both posted and unposted transactions.

G.3.26 Processing Options for Account Totals by Supplier/Customer (R09451)

Processing options enable you to specify the default processing for reports.

G.3.26.1 Report Detail

1. From Period or From Date

Enter either the period or from date in which to begin the report.

2. Thru Fiscal Year and Period or Thru Date

Enter the two-digit fiscal year and the period or thru date in which to end the report.

G.3.26.2 Document

1. Document

Enter a specific ledger type. If you leave this processing blank, the system uses ledger type AA.

2. Document Type

Enter a specific document type. If you leave this processing option blank, the system uses all document types.

3. Unposted Transactions

Specify whether to print posted or both posted and unposted transactions. Values are:

Blank: Print posted transactions only.

1: Print posted and unposted transactions.

G.3.26.3 Currency

1. As if Currency

Enter the currency code in which to print as if currency amounts. If you leave this processing option blank, the system uses the company currency.

2. As of Date

Enter the date in which to retrieve the exchange rate for the as if currency. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

G.3.27 R09470 - G/L by Category Code

To use a statutory account number instead of business.object.subsidiary, print the G/L 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 and uses information from the F0901, F0911, F0902, and F0006 tables.

G.3.28 Processing Options for G/L by Category Code (R09470)

Processing options enable you to specify the default processing for reports.

G.3.28.1 Select

1. From Period

Specify the beginning fiscal period for the system to use when selecting account balances for this report. Values are:

0: Year to date. Use the first period of the current fiscal year as the beginning period. The report prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

1: Current period. Use the current period as the beginning period. The report prints a balance forward total for the current fiscal year and transactions for the current period for each account. It does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit-and-loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2: Inception to date. Use the first period of the first fiscal year in which you began using the JD Edwards EnterpriseOne General Accounting system as the beginning period. The report prints transaction information from the date when you began using the JD Edwards EnterpriseOne General Accounting system through the current period. This report can be lengthy, depending on the amount of data that you have.

2. From Date

Specify a beginning date in a range of general ledger dates for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

3. Fiscal Year

Specify a thru fiscal year for the system to use when selecting records for this report. Enter the last two digits of the fiscal year, for example, 07 for 2007.

4. Period

Specify a period for the system to use when selecting records for this report.

5. Thru Date

Specify an ending date in a range of general ledger dates for the system to use when selecting records for this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

G.3.28.2 Print

1. Ledger Type

Specify the ledger type for the system to use when selecting records to print on this report. Enter a valid ledger type from the F0025 table. If you leave this processing option blank, the system uses ledger type AA.

2. Document Type

Use this processing option, with the Ledger Type processing option, to specify the document type that the system uses to select records for this report. Enter a document type code from UDC table 00/DT. If you leave this processing option blank, the system selects all document types.

Note:

If you do not enter a value in the Ledger Type processing option, the system ignores the value for this processing option.
3. Transaction Type

Specify whether the system prints only posted transactions. Values are:

Blank: Print only posted transactions.

1: Print both posted and unposted transactions.

4. Account Category Code (1–23)

Specify the account category code (1–23) that the system prints on the report. If you leave this processing option blank, the system prints category code 21.

The value you enter in this field is used only to print the category codes on the report. It is not used for data selection.

5. Units

Specify whether the system prints units as well as amounts. Values are:

Blank: Print amounts only.

1: Print both amounts and units.

6. Zero Balances

Specify whether the system prints accounts with zero balances. Values are:

Blank: Print accounts with zero balances.

1: Do not print accounts with zero balances.

7. Date Order

Specify whether the system prints information in ascending or descending order by date. Values are:

Blank: Print information in descending order by date.

1: Print information in ascending order by date.

G.3.28.3 Currency

1. As-If Currency Code

Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.

2. Exchange Rate Date

Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the date specified in the Thru Date processing option for the exchange rate.

G.3.29 R09472 - Debit/Credit T/B by Category Code

Use the Debit/Credit T/B by Category Code report to print a statutory account (category code value) on a trial balance instead of the business unit.object.subsidiary account code. The category code indicates the account number, and the category code description indicates the account description.

G.3.30 Processing Options for Debit/Credit T/B by Category Code (R09472)

Processing options enable you to specify the default processing for reports.

G.3.30.1 Select

1. Fiscal Year

Specify the fiscal year for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the current fiscal year.

2. Period

Specify the period number for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the current period number.

3. Ledger Type

Specify the ledger type for the system to use when selecting records to print on this report. Enter a valid ledger type from the F0025 table. If you leave this processing option blank, the system uses ledger type AA.

4. Category Code (21–23)

Use this processing option to specify the account category code (21–23) that the system prints on the report. If you leave this processing option blank, the system prints category code 21.

The value you enter for this processing option is used only to print the category codes on the report. It is not used for data selection.

G.3.31 R11C750 - Cash Basis Integrity Test

The Cash Basis Integrity Test reviews all of the cash basis entries for a specified time period and produces an exception report that shows the accounts that are out of balance. Only cash accounts can be expected to balance between the two ledgers (AA and AZ).

The report prints summary or detail information. The integrity test with transaction detail can be lengthy. You might want to run the report without detail first to see how many accounts within the selected range are out of balance.

If you specify the detail format in the processing option, all of the posted detail records in the AA and AZ ledgers appear above the ledger balances for each period that is out of balance. If you do not specify the detail format, the two ledger balances appear side by side for each period that is out of balance.

Information on the report appears in reverse chronological order, beginning with the as of date that you specify in the processing option and going back through all years that you specify in the data selection.

The Cash Basis Integrity Test shows transactions from the F0911 and F0902 tables.

G.3.32 Data Selection and Sequence for the Cash Basis Integrity Report

Enter the prior fiscal years that you want to view. You must specify ledger type AA. The integrity test and report run more efficiently when you sequence by company.

G.3.33 Processing Options for the Cash Basis Integrity Test (R11C750)

Processing options enable you to specify the default processing for reports.

G.3.33.1 Select

1. As Of Date

Specify the as of date in which to run the integrity test. If you leave this processing option blank, the system uses the current date.

G.3.33.2 Process

1. Transaction Detail

Specify whether to print transaction detail. Values are:

Blank: Print summarized information.

1: Print transaction details.

G.3.34 R11C760 - Cash Basis Audit Report

The Cash Basis Audit Report (R11C760) provides you with information about the cash basis entries at the transaction level. This report is a powerful research tool that allows you to quickly determine which documents are balanced, as well as which documents are posted. Cash basis entries that do not balance are identified by the message Document Not Balanced.

There are three DEMO versions of this report for AR, AP, and GL entries.

The Cash Basis Audit Report uses information from the F0911 table.

G.3.35 Data Selection and Data Sequencing for the Cash Basis Audit Report

Do not change the data selection for Ledger Type equal to AZ (cash basis). You can enter additional data selection to select posted records, a specific batch, or general ledger dates.

Do not change the data sequencing. The report calculates totals, and changing the data sequencing produces unpredictable totaling results.

G.3.36 Processing Options for Cash Basis Audit Report (R11C760)

Processing options enable you to specify the default processing for reports.

G.3.36.1 Display

1. Account Number

Specify which account number format to print on the report. Values are:

Blank: Number specified during data entry

1: Long account number

2: Short account number

3: Unstructured account number