Completing the General Ledger Report Options

In this task, define the report type, detail level, and formatting options for a report by populating the G/L Report Generator window Options tab.

To complete the general ledger report options:

Note: Before you begin, be sure you have completed Step One - Starting the General Ledger Report Layout and are in the G/L Report Generator window Options tab.

In the Report Type field, select from the following report types. The report type determines whether the system requires a start and an end date to calculate the correct values for the report.

Listing of Accounts - Does not require a start or end date.
Balance Sheet - Requires an end date.
Operating Statement - (same as Income Statement) Requires a start and an end date.
Change in Financial Condition - Requires a start and an end date.
Trial Balance - Requires a start and an end date.

If the Use G/L Account Type Flags for Trial Balancecontrol maintenance record is set to No, the Actual column on the Trial Balance report shows a negative amount only when an account is carrying a balance opposite of its "natural" balance.

Select the Audited Report check box to have the system verify that the report template has included all of the appropriate accounts for the following report types:

Report	Includes...
Listing of Accounts	every valid G/L account.
Balance Sheet	every G/L account that is designated as a Balance Sheet account.
Operating Statement	every G/L account that is designated as an Income Statement account.
Trial Balance	every valid G/L account that is a balance sheet account in the first portion of the report and every G/L account that is designated as an Income Statement account in the second portion of the report.

Select the Show Zero Lines check box to include a report line item that contains a value of zero.

Select the Show Zero Branches check box to include branches with a zero balance on the report.

In the Detail Level field, type a number between 0 and 9 to designate the level of detail to print on the report. The default is 1. Keep in mind the following:

Start and End groups and templates that have detail levels with numbers less than or equal to the report detail level print in the expanded format.
Comments with a detail level less than or equal to the report detail display.

In the Represent Numbers field, select one of the following to determine how dollar amounts print:

To the Penny - Displays dollars and cents.
Whole Dollars - Displays dollar values rounded to whole dollars.
Thousands - Displays dollar values rounded to thousands of dollars.

In the % Decimals field, enter a number between 0 and 3, to indicate the number of decimals you want the report to contain for percentages.

For example, if you enter 2, the percentage displays two numerals after the decimal point. The default is 0.

In the Company Override field, enter the name of a different company to override the default company name. This name displays on both the report window and on the report itself.

By default, if you run the report for a single branch, the system uses the name assigned to that branch on the Branch Maintenance window. If you run the report for multiple branches, the system uses the name assigned to the first branch.

Select the Allow Dvr Update check box to allow a user to change the G/L report template or override the company name used for the report.

In the Report Currency field, do one of the following:

To print reports in the company's base currency, leave this field blank.
To print the report in a currency other than the default base currency, select or enter a new currency. For example, if you have a branch in Germany, select Dtsch.

Note: Indicate the method for selecting the exchange rate to use for converting each transaction amount to a foreign currency in the G/L Account Maintenance window.

Continue with the procedure below to define download options.

To enter the general ledger report download options:

In the ColumnDelimiter field, enter the character the system uses as a delimiter between columns, such as a comma (,).
In the Record Delimiter field, enter a character the system uses as a delimiter between records.
In the Negatives As field, select one of the following options:

< > - Places angle brackets around a negative number and inserts commas in large numbers.
- - Places a minus sign in front of a negative number and deletes commas from large numbers.

Select the Trim Blanks check box to trim the trailing blanks from the fields of data.
Continue wit the procedure below to define subledger options.

To enter the general ledger report subledger options:

In the ShowSubLedgers field, select one of the following:

Field	Description
Y (Yes)	Includes subledgers on the report and allows you to determine whether to include the account balance for the entire account. If you set the Show Subledgers field to Yes, the data on the Subledger lines of the report shifts to the left 10 characters to distinguish it from data in Account Balances lines. Because of this shift, all data columns should be at least 11 characters wide to keep subledger data from shifting into the adjacent columns.
N (No)	Does not include subledgers on the report.
Only	Includes only accounts on the report that have subledgers defined. Use the SubLedgers list to define which subledgers you want to include in the report. If you do not define subledgers, the report includes any account that has a subledger attached.

Select the Account Balances check box to include the subledger account totals in the reports.
Save your changes and exit the window.
Continue with Step Three - Completing the Report Generator Options.