General Ledger Detail Report

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections.  Once the default selections display in the screen, you can override the defaults as necessary.

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

This non-editable field displays a value of "One."

Enter, or use Lookup to select, the fiscal year for which you want to print G/L detail.

Enter, or use the drop-down box to select, the range of active periods to be included on this report.  The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."

The value you enter in this field varies depending on the Active Period Option you select. If you selected "All" periods, this field will be inactive.

Enter the starting period in this field within the selected year to appear on the report.

This non-editable field displays the end date of the starting period.

The value you enter in this field varies depending on the Active Period Option you select.  If you selected "All" periods, this field will be inactive.

Enter the ending period in this field within the selected year to appear on the report.

This non-editable field displays the end date of the ending period.

Enter, or select from the drop-down box, the range option for the accounts you want to include on the report. The system-defined options are:

• All - This option prints the G/L detail for all accounts at the level specified.

• One - This option prints the G/L detail information for a single account.

• Range - This option prints G/L detail information for a range of accounts.

• From Beginning - This option prints G/L detail information beginning from the first account in the chart of accounts up to and including a specific ending account.

Enter the starting account for the range of accounts you want to include on this report. You can also use Lookup to select the account for this field.  This field may be disabled, depending on your Option selection.

Enter the ending account for the range of accounts you want to include on this report. You can also use Lookup to select the account for this field.  This field may be disabled, depending on your Option selection.

From the drop-down box, select the appropriate option for the grouping of your report. The system-defined options are "Organization," "Ref 1," "Ref 2," or "Alternate Reporting."

Enter, or select the range option for the range of "Organizations," "Ref No 1s," "Ref No 2s," or "Alternate Reporting" structures that you want to include on the G/L Detail Report.

The system-defined options are "All," "One," "Range," "From Beginning," and "To End."

Refer to the documentation for the Accounts row in this block for details on these options.

Enter the starting "Organization," "Ref No 1," "Ref No 2," or "Alternate Reporting" structure ID for the organization(s), etc., you want to include on the report.  You can also use Lookup to select the values for this field.  This field may be disabled, depending on your Option selection.

Enter the ending "Organization," "Ref No 1," "Ref No 2," or "Alternate Reporting" structure ID for the organization(s), etc., you want to include on the report.  You can also use Lookup to select the value for this field.  This field may be disabled, depending on your Option selection.

Identify the highest account level you want to print on this report, based on the levels you established in the G/L Settings screen.  Accounts below the specified level will be summed and will show as a summary total.

Select this checkbox to insert a page break after each account, or leave this checkbox unchecked to allow the printing of more than one account per page.

Identify the highest "Organization" (or "Ref No 1," "Ref No 2," or "Alternate Reporting" structure) level you want to print on this report.  Balances on the report will roll up to the specified level.

Select this checkbox to insert a page break after each group you specified in the Select By field.  Leave this checkbox unchecked if you do not require page breaks after each "Organization," "Ref No 1," "Ref No 2," or "Alternate Reporting" structure.

Select this checkbox to print transaction level detail for labor postings.

Note that Labor Suppression is in effect in this screen. If you selected the Labor checkbox in the table window of the Users screen (Administration\Maintain\Users), you will not be able to see the labor cost detail.

Select this checkbox to print transaction level detail for Accounts Payable postings.

Select this checkbox to print document detail. Examples of document detail include: voucher number, check number, invoice number, etc.

Select this checkbox to print reference numbers on the report.

Select this checkbox to print inactive accounts on the report.

Unselect this checkbox to prevent inactive accounts from printing on the report.

This checkbox is selected by default.

Use the drop-down box to sort the report either by "Account" or by the selected alternate reporting option ("Organization," "Ref No 1," "Ref No 2," or "Alternate Reporting" structure).