General Ledger Detail (Report)

Additional Information

The General Ledger Detail report is a detailed list of transactions by company, account, organization, and posting period. 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.
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.
  General Ledger Select to include items from the general ledger. The default is true.
  Allocation Ledger Select to include items from the allocation ledger. The default is false.

The report includes the following optional restrictions:

  • Account
  • Client
  • Client Parent
  • Company
  • Currency
  • Document Number
  • Document Suffix
  • Employee
  • External Reference Number
  • Input Document Type
  • Organization
  • Organization Map Level
  • Project
  • Task
  • Vendor

Sorts

The report includes the following sorts:

  • Account Code
  • Account Name
  • Currency Code
  • Currency Name
  • Company Code
  • Company Name
  • Document Number
  • Employee / Vendor / Client Code
  • Employee / Vendor / Client Name
  • EVC Type
  • External Reference Number
  • Input Document Type
  • Input Document Source
  • Organization Code
  • Organization Name
  • Organization Map level 2 - 6 Name
  • Project Code
  • Project Name