Journals (Report)

Additional Information

The Journals report is a list of all of the transactions or activity against accounts. All information is selected and grouped by document number.

The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities. Sample Report.

General

This General area provides options to configure the report.

Field Description
Comment

Enter any comments about the report instance. Comments will display on the report console and the banner page of the report.

Restrictions

The report includes the following default restrictions:

Field Description
Fiscal Calendar

Enter or select a fiscal calendar. This is the definition of the fiscal years and posting periods for a specified fiscal year. This field defaults to the default fiscal calendar.

From Fiscal Period Enter or select a fiscal period. This is the first date in the date range to include items. This field defaults to the current fiscal period.
To Fiscal Period Enter or select a fiscal period. This is the last date in the date range to include items. This field defaults to the current fiscal period.
Currency Type

Enter or select the type of currency to display on the report. This field defaults to Document Currency, but available options include Document Currency, Company Currency, and Base Currency.

Include Image

Select to include an image. This field defaults to the image defined for the Report Model or Theme.

Include Banner

Select to generate the banner page on the report. By default, this field is set to generate the banner page.

Display Detail Select to generate detail level information in the report. By default, this field is set to generate the summary version of the report.
Include Descriptions Select to include text descriptions with transaction detail.
Monetary Scale Select if the monetary values in the report should be scaled, or divided by a number, to reduce the amount of space used. By default, Ones is selected, but available options include None, Ones, Tens, Hundreds, Thousands, and Millions.
Monetary Nbr of Decimals Enter the number of decimal places to display for monetary values. By default two is selected, but the value can be between zero and three.
  Organization Map Enter or select an organization map. This is a hierarchical group of organizations in the system that is used to structure data on the report.

The report includes the following optional restrictions:

  • Account
  • Company
  • Currency
  • Organization
  • Organization Map Level
  • Document Date
  • Document Number

Sorts

The report includes the following sorts:

  • Account Code
  • Account Name
  • Company Code
  • Company Name
  • Currency Code
  • Currency Name
  • Organization Code
  • Organization Name
  • Organization Map level 2 - 6 Name