Journals Line Report

Review all of your journals, grouped by ledger and batch, for a particular journal category, currency and balancing segment value.

For each journal line, the report prints the transaction date, account, reference, journal line description, entered amounts, and accounted amounts. Totals are provided for each journal and journal batch included in your report. In addition, totals are provided for each journal category and for each balancing segment, with a grand total for all of the activity included in your report.

Parameters

When you request this report, General Ledger prompts you to enter the following:

Currency: (optional) Choose a ledger currency, foreign currency, or STAT to retrieve journal line information for journals entered using a specific currency. If you leave this field blank, the report includes journals entered for all currencies.

If you use reporting currencies (journal or subledger level), you can choose the currency of a reporting currency.

Begin/End Date: Enter the date range for your report.

Category: (optional) Enter the journal category for your report.

<Balancing Segment>: (optional) Enter the balancing segment value for your report. If you leave this field blank, the report includes journals against all balancing segment values.

Adjustment Periods: Choose whether you want the report to include transactions from adjustment periods.

Ledger/Ledger Set: Choose any ledger or ledger set contained in your Data Access Set. If you choose a ledger set, the report will include all journals for all ledgers in the ledger set.

If you use reporting currencies (journal or subledger level), you can choose a reporting currency.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Date: the effective date of the journal.

Account: the complete account combination for each journal line.

Description: the description of your journal line.

Entered Debit/Credit: the amounts entered in a given currency.

Accounted Debit/Credit: the amounts that have been accounted for in the ledger currency or reporting currency. For journal lines entered using foreign currencies, the accounted columns represent amounts converted to the ledger currency or reporting currency.