General Ledger Detail Report

General Ledger Detail Report - Fields

Report Setting

Enter a report setting, or click the Lookup button to list all report settings. The Standard report setting provides a set of default options, sort criteria, and selection criteria for each report.

Description

This field displays the description for the selected report setting. Enter a description that describes the output of the report. The description can be up to 60 characters.

Type

This field displays the type of access assigned to the report setting. A Public report setting allows access to all users. This includes the ability to access, modify, save, print, and delete the report setting; however, the Standard report setting cannot be deleted. This field can only be viewed.

Default Report

Select this check box to set the current report setting as the default report setting. The default report setting is the first report setting displayed when the report is accessed. Clear this check box if you do not want this report setting to be the default.

When a default report setting is not selected, the Report Setting field displays the Standard report setting.

Print Report Settings

Select this check box to print the options, sort criteria, and selection criteria for the selected report setting. This information prints on a separate cover page when the report is printed. Clear this check box if you do not want to print the report settings.

Three Hole Punch

Select this check box to print the report with a larger margin. This allows enough space for you to three-hole punch the report. Clear this check box if you do not want a larger margin for this purpose.

Number of Copies

Select the number of copies to print.

Collated

Select this check box to print each copy of the report or form in proper binding order when printing multiple copies. Clear this check box if you do not want to collate the report or form. This check box is available only if the value selected in the Number of Copies field is greater than 1.

Sort Report By

Select an option for sorting the report.

Selection Criteria

Select a method for selecting the range of dates.

Fiscal Year

Select the fiscal year to use for printing the report. This field is available only if By Period is selected in the Selection Criteria field.

Starting Period / Starting Date

If By Period is selected in the Selection Criteria field, select the starting period to use for printing the report. If By Date is selected in the Selection Criteria field, select the starting date to use for printing the report. You must also select a period or date in the Ending Period / Ending Date field.

The number of periods you can select from depends on the number of periods entered in the Number of Accounting Periods field in the Fiscal Year Maintenance window.

Ending Period / Ending Date

If By Period is selected in the Selection Criteria field, select the ending period to use for printing the report. If By Date is selected in the Selection Criteria field, select the ending date to use for printing the report. You must also select a period or date in the Starting Period / Ending Date field.

The number of periods you can select from depends on the number of periods entered in the Number of Accounting Periods field in the Fiscal Year Maintenance window.

Summarize Detail

Select this check box to print only the summary line for each account. If this check box is selected, beginning balances and ending balances are excluded from the report, even if the Value fields are entered for source journal, journal number, transaction amounts, and posting comments. Clear this check box to print details for each account, including beginning and ending balances, source journal, source type, posting comments, and journal entry information.

Source Type

Select the type of information to print.

Select All Types to print postings from all sources on the report.

Select G/L Journals to print only General Ledger journal postings (for example, General Journal, Recurring Journal, or Transaction Journal).

Select Module Registers to print only postings from other module registers (for example, Accounts Payable Invoice Register or Accounts Receivable Invoice Printing).

Print Comments

Select the type of comments to print on the journal.

Select Full to print the entire comment entered on the Lines tab of the applicable data entry window.

Select Partial to print only the first 40 characters of the comment entered on the Lines tab.

Select None if you do not want to print Lines tab comments.

This field is available only if the Summarize Detail check box is cleared.

Print Posted By/Date

Select this check box to print the user logon of the user who performed the update of each journal, along with the date the journal was updated. This field is available only if the Summarize Detail check box is cleared.

Print Condensed

Select this check box to print the report in condensed format. Clear the check box if you do not want to print in condensed format. If you select this check box, the report will print in portrait view without the Source, Batch, User Logon, and Posted Date fields displayed. Also, if you select Partial in the Print Comments field, only the first 30 characters of the comments will print.

Operand

Select an operand to limit your selection to a particular value or range of values. When selecting a value using the Lookup button or entering a value directly into the Value field (and moving out of the field), the operand automatically changes to Equal to. Likewise, when selecting a value using the Lookup button for a range or entering values directly into both Value fields, the operand automatically changes to Range.

The following operands are available:

Operand

Operand Function

All Selects all information for the Select Field.

Begins with Selects only the information for the Select Field that begins with the value entered in the Value field.

Ends with Selects only the information for the Select Field that ends with the value entered in the Value field.

Contains Selects only the information for the Select Field that contains the value entered in the Value field.

Less than Selects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field.

Greater than Selects only the information for the Select Field that is greater than or equal to the value entered in the Value field.

Range

When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields.

Entering a range of account numbers produces different selection results than entering a range of main accounts and segments. When you specify a range of account numbers, all account numbers in that range are selected. When you specify a range of main accounts, all accounts beginning with the specified main account numbers are selected. Main account selections override account number selections.

Note Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C.

Equal to

Selects only the information for the Select Field that is equal to the value entered in the Value field.

Not Equal to

Selects only the information for the Select Field that is not equal to the value entered in the Value field.

Additional operands are available for date Select fields. The system date is used to calculate the date ranges. When one of the date operands is selected, the Value fields automatically default to the appropriate dates.

Multiple values can be entered using a comma (,) to enlarge the selection criteria. You can also use alternate separators (other than the reserved comma) to separate multiple selection values.

Note When alternate separators are used, the value list must end with the alternate separator character.

The alternate separators include the following:

~ ! @ # $ % ^ & * ( ) = [ ] \ ; " / _ + { } | : < > ?

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

Value

Enter a value based on the operand entered, or click the Lookup or Calendar button to select a value from the list. Multiple values can be entered by using a comma or alternate separators to separate values.

You can enter single or multiple values as follows:

Operand

Value

All Selects all information for the Select Field.

Begins with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Ends with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Contains

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Less than Only single values are allowed.

Greater than Only single values are allowed.

Range Both Value fields are used to define a range. Only single values are allowed at each Value field.

Equal to Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Not Equal to

Multiple values are separated by a comma or alternate separator. An AND condition is assumed.

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

Printer/Output

Select a printer or output method. The following output methods are available:

Select Deferred to save the report or listing to your hard drive for printing at a future time using Deferred Printing.

Select Export to export to a file type, such as PDF or Excel. The file can then be saved to your hard drive.

Select Data Only Export to export only the data portion of the report (excluding header information) to a file type, such as PDF or Excel. The file can then be saved to your hard drive or e-mailed.

Note This option is available only if the report or listing contains header information.

Select Office Merge to export data to a Microsoft Word or Excel template. For more information, see Office Template Manager.

Select Paperless Office to e-mail, fax, or print the report as a PDF document. When you select this option and click Print, the Paperless Office Selection window appears and allows you to define recipient and message options.

Keep Window Open After Print

Select this check box to keep this window open after you print. Clear this check box if you want this window to close automatically after you print.

Note The selection for this check box is set by user and workstation.

Keep Window Open After Preview

Select this check box to keep this window open after you preview the report or form. Clear this check box if you want this window to automatically close after you preview the report or form.

Note The selection for this check box is set by user and workstation.

Operand	Operand Function
All	Selects all information for the Select Field.
Begins with	Selects only the information for the Select Field that begins with the value entered in the Value field.
Ends with	Selects only the information for the Select Field that ends with the value entered in the Value field.
Contains	Selects only the information for the Select Field that contains the value entered in the Value field.
Less than	Selects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field.
Greater than	Selects only the information for the Select Field that is greater than or equal to the value entered in the Value field.
Range	When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields. Entering a range of account numbers produces different selection results than entering a range of main accounts and segments. When you specify a range of account numbers, all account numbers in that range are selected. When you specify a range of main accounts, all accounts beginning with the specified main account numbers are selected. Main account selections override account number selections. Note Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C.
Equal to	Selects only the information for the Select Field that is equal to the value entered in the Value field.
Not Equal to	Selects only the information for the Select Field that is not equal to the value entered in the Value field.

Operand	Value
All	Selects all information for the Select Field.
Begins with	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Ends with	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Contains	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Less than	Only single values are allowed.
Greater than	Only single values are allowed.
Range	Both Value fields are used to define a range. Only single values are allowed at each Value field.
Equal to	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Not Equal to	Multiple values are separated by a comma or alternate separator. An AND condition is assumed.