Previous  Next          Contents  Index  Navigation  Glossary  Library

General Journals Reports

The General Journals Report is available in three different formats. You can request a report of Posted Journals, Unposted Journals or Error Journals. Each are described below.

Posted Journals

Review your posted journal batches and the journals associated with each posted journal batch. This information allows you to trace your transactions back to the original source.

The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report.

Parameters

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

Type: Choose Line Item to generate a report showing REFERENCE_1 from the GL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4 from the GL_JE_LINES table. These references appear only if you used Journal Import and included a journal voucher number, an invoice date and number, or some other source document information that helps you to identify the origin of this journal.

Posting Status: Choose the Posted status.

Currency: Choose the functional currency for your set of books or STAT.

Period: (optional) Choose any accounting period in your calendar. If you leave this field blank, the report will include posted journal batches for all accounting periods.

Start/End Date: (optional) Enter the posting date range for your report. If you skip these fields, the report will include journal batches posted on any date.

Source: (optional) Choose the journal entry source for your report. If you leave this field blank, the report will include posted journal batches from all sources.

Batch Name: (optional) Choose any posted journal batch. If you leave this field blank, the report will include all posted journal batches which comply with the other parameters.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the period you specified in your batch. For manual journals to future periods, the first day of the period you specified in your batch. For manual journals to the current period or for journals created by feeder systems, the date on which the batch was created.

Balance: Actual, Budget, or Encumbrance to indicate the type of batch. General Ledger first prints your Actual batches, then your Budget batches, and finally your Encumbrance batches.

Line/Source Item: If you chose the Line Item type, prints REFERENCE_1 from the GL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from the GL_JE_LINES table.

Units: statistical amount, if any, associated with your journal line.

Unposted Journals

Review your unposted journal batches and their associated journals. This information allows you to trace your transactions back to the original source.

The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report.

Parameters

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

Type: Choose Line Item to generate a report showing REFERENCE_1 from the GL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4 from the GL_JE_LINES table. These references appear only if you used Journal Import and included a journal voucher number, an invoice date and number, or some other source document information that helps you to identify the origin of this journal.

Posting Status: Choose the Unposted status.

Currency: Choose the functional currency for your set of books or STAT.

Period: (optional) Choose any accounting period in your calendar. If you leave this field blank, the report will include unposted journal batches for all accounting periods.

Start/End Date: (optional) Enter the batch effective date range for your report. If you leave the start and end date blank, the report will include unposted journal batches from any date.

Source: (optional) Choose the journal entry source for your report. If you leave this field blank, the report will include unposted journal batches from all sources.

Batch Name: (optional) Choose any unposted journal batch. If you leave this field blank, the report will include all unposted journal batches which comply with the other parameters.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the period you specified in your batch. For manual journals to future periods, the first day of the period you specified in your batch. For manual journals to the current period or for journals created by feeder systems, the date on which the batch was created.

Balance: Actual, Budget, or Encumbrance to indicate the type of batch. General Ledger first prints your Actual batches, then your Budget batches, and finally your Encumbrance batches.

Line/Source Item: If you chose the Line Item type, REFERENCE_1 from the GL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from the GL_JE_LINES table.

Units: statistical amount, if any, associated with each journal line.

Error Journals

Review your error journal batches and their associated journals. This information allows you to trace your transactions back to the original source. Journal batches become error journals if posting fails; they do not lose their error status until they are posted successfully.

The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal entry batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report.

Parameters

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

Type: Choose Line Item to generate a report showing REFERENCE_1 from the GL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4 from the GL_JE_LINES table. These references appear only if you used Journal Import and included a journal voucher number, an invoice date and number, or some other source document information that helps you to identify the origin of this journal.

Posting Status: Choose the Error status.

Currency: Choose the functional currency for your set of books or STAT.

Period: (optional) Choose any accounting period in your calendar. If you leave this field blank, the report will include error journal batches for all accounting periods.

Start/End Date: (optional) Enter the batch effective date range for your report. If you leave the start and end date blank, the report will include error journal batches from any date.

Source: (optional) Choose the journal source for your report. If you leave this field blank, the report will include error journal batches from all sources.

Batch Name: (optional) Choose any error journal batch. If you leave this field blank, the report will include all error journal batches which comply with the other parameters.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Batch Effective Date: For manual journals to prior periods, the last day of the period you specified in your batch. For manual journals to future periods, the first day of the period you specified in your batch. For manual journals to the current period or for journals created by feeder systems, the date on which the batch was created.

Balance: Actual, Budget, or Encumbrance to indicate the type of batch. General Ledger first prints your Actual batches, then your Budget batches, and finally your Encumbrance batches.

Line/Source Item: If you chose the Line Item type, REFERENCE_1 from the GL_JE_LINES table. If you chose the Source Item type, REFERENCE_4 from the GL_JE_LINES table.

Units: statistical amount, if any, associated with your journal line.

         Previous  Next          Contents  Index  Navigation  Glossary  Library