GL: General Ledger Detail Report

Type a description to name the report. This description prints above the Report Title.

The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies for which you have security permissions to view. If you have permission for only one company, that will be the only one displayed in the list. If you have permissions to multiple companies, the list will display those companies PLUS the default reporting company.

When discernible, WinTeam will print the appropriate company name and logo on each page; otherwise the Default Company Name will print. That is, if a Company level is included in the tiered section and is displayed in the tiered information at the bottom of the page, then that company's Report Name and Logo (if selected) prints on that page.

If there is not a Company identified in the tier area of the page, then the Default Company Name for Reports is used. The default Company Name and Logo is also used for the Total Enterprise report. For more information see Learning about WinTeam Reports.

Use the Report Format option to choose the level of detail for the report.

The Summary report contains only the Debit/Credit (and Net Change, if selected) subtotals and beginning and ending balances.

The Detail report includes all items in the summary report plus transactions.

Use the Account Status option group to include either active, inactive, or all General Ledger Accounts on the report.

The default setting is Both.
Changes to the status of an account may be made on the Chart of Accounts screen.

Select the From and To Posting Dates.

The Fiscal Year populates automatically based on the From Date. From and To Dates must be in the same fiscal year.

Account Categories

Use the Account Categories category to select the General Ledger Account Categories to include on the report.

Select All to include all Account Categories on the report.

Select Pick to define specific categories for the report. When you select Pick, the Account Categories list displays. Select the check box next to each Account Category to include on the report.

Account Types

Use the Account Types category to select the General Ledger Account Types to include on the report.

Select All to include all Account Types on the report.

Select Pick to define specific Account Types for the report. When you select Pick, the Account Types list displays. Select the check box next to each Account Type to include on the report.

Accounts

Use the Accounts category to select the General Ledger Accounts to include on the report.

Select All to include all accounts on the report.

Select Range to define a range of accounts for the report. When you select Range, the range boxes fields. Type the beginning account number in the From field and the ending account number in the To field.

Select Pick to define specific Customers for the report. When you select Pick, the Customer list displays. Select the check box next to each Customer to include on the report.

Select Create to define your own list of GL Accounts. When you select Create, a small grid displays to the right. Enter the GL Account Numbers you want to include in the list, or use the Lookup to locate the Account Numbers.

Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the GL Account Numbers you want to exclude in the list, or use the Lookup to locate the GL Account Numbers.

Logs

Select All to include all details.

Select Pick to define specific logs for the report. When you select Pick, the Logs list displays. Select the check box next to each log code to include on the report

Select Range to define a range of Log Numbers for the report. When you select Range, the Logs range fields display. Type the beginning Log Number ID in the From field and the ending Log Number ID in the To field.

Posting Source

Use the Posting Source category to select the Posting Source Codes for the report.
Select All to include all source codes on the report.
Select Pick to define specific source codes for the report. When you select Pick , the Posting Source Codes list displays. Select the check box next to each code to include on the report.
The following is the list of valid posting source codes:

AJE - Adjusting Journal Entries

APC - Accounts Payable Checks Written

APJ - Accounts Payable Invoice and Liability Transfers Journal

APV - Accounts Payable Voids

ARJ - Accounts Receivable Sales Journal

CPJ - Cash Posting Journal

FXJ - Fixed Assets Journal

IUJ - Inventory Activities Journal

LDJ - Labor Distribution Journal

MCJ - Accounts Payable Manual Check Journal (This code is no longer applicable; it has been replaced with APC.)

NP - Not Posted

OCJ - Other Compensation Journal

ODJ - Other Deduction Journal

PRJ - Payroll Journal

TAJ - Tax Allocation Journal

TRJ - Transfer Journal

Use the Tier Template to define and save customized settings for a report. To use an existing template, select the template from the list and click Load.

To create a new template, you can load an existing template, make the necessary modifications, click Save, and define a new template name in the Save As dialog box. Alternatively, you can start with a blank template by clicking the Clear button.

To modify an existing template, load the template, make the necessary modifications, and then click Save. The name of the existing template display in the Save As dialog box. Click OK.

For more information see Using Tier Templates and Using Tier Parameters.

The Print Company Totals check box is available to users who have only one company, and may be selected to print company totals on the report.

The Print Enterprise Totals check box is available to users who have more than one company, and may be selected to print enterprise totals on the report. This check box is selected by default.

If this is not selected, the report prints only the tiered reports that are marked for printing.

Select the Print Net Change check box to include Net Change amount on the report. This option is selected by default. If the Net Change does not need printed, clear the option.

If the date range is within a single fiscal period, the Net Change prints next to the Debit/Credit subtotals.

If the date range spans multiple fiscal periods, an additional line separates Fiscal Period Debit/Credit subtotals line.

Select the Include Notes to include Notes from the Adjusting Journal Entry (GL Distribution grid) and Notes from the AP: Invoice Entry (GL Distribution grid) on the report.

Select the Group By Log check box to group the transactions by Account, then by Log #. This is available for both Detail and Summary reports.

Select the Suppress Printing of Names on LDJ Entries check box to exclude the names of employees who have a labor distribution entry on the report.

Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.

Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.

Preview

Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.

Print

Click the Print button (or press ALT + P) to send the report to your default printer.

Export

Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).

Section	Item	Value	Purpose
GLReport	SortbyTierDescription	Yes	This setting sorts by Tier Descriptions (instead of the Tier ID). The Tier Descriptions will also display when previewing and using the Toggle Group Tree.