The General Ledger Export Report lists the posting from each source for a single general ledger account or a group of ledger accounts for a specified period of time. You can list the postings individually, subtotaled by source by day, or subtotaled only by source. The difference between this report and the General Ledger Report is that this report is designed to format the data so that you can download the report. You see the same information as in the other report, but in this one, there are no breaks and heading lines.
To run the General Ledger Export Report:
From the G/menu, selectGeneral Ledger Exportto display the General Ledger Export window.
In the Branch/Terr/All field, enter the branch or branches for which you want to run the report. Enter All to run the report for all branches and territories.
In the Start Date field, enter the first date of the period to include in the report.
In the End Date field, enter the last date of the period to include in the report.
Note: In the Detail version of the report, each transaction is broken out by the day the transaction occurred. In the Summary version of the report, the amount includes the accumulated total for all transactions that occurred on or between the start and end date.
In the Account field, enter or select the account for which to run the report:
Leave the field blank to enter a particular general ledger report type by template. If you select this option you must select a report template in the Template field.
Note: Select the Use All Accounts check box to include all general ledger accounts.
In the Template field, enter or select a report template ID to include all the accounts in a particular general ledger report template. This field is only accessible if you leave the Account field and the Use All Accounts check box blank.
Note: Define templates in the G/L Report Template Maintenance window. For more information, see Template Maintenance Overview.
In the Subledger field, enter or select a subledger to include in the report.
In the Summary/Detail field, select one of the following options:
Options | Description |
Summary | Includes reports in two formats:
|
Summary All | Includes all general ledger accounts in summary form regardless of whether the Export Detail field for an account is selected . |
Detail | Prints a line for each transaction on the report. |
Note: Set the parameters for the Export Detail field are set in the G/L Account Maintenance window for each general ledger account. For more information, see Creating G/L Accounts.
In the Branch Detail check box, do one of the following to determine how to format detail information by branch:
If you select Detail in the Summary/Detail field, the system selects this check box and moves the cursor to the Reference field.
If you select Summary or Summary/All in the Summary/Detail field, select this check box to break out all summary information by branch. Deselect the check box to combine summary information for all the branches.
In the Reference field, select one of the following to specify how each general ledger account is identified in the report:
Key Word 1 - Identifies the account by the entry in the first line of the Key Words field in the G/L Account Maintenance window.
Description - Identifies the account by the entry in the Full Description field in the G/L Account Maintenance window.
Note: For more information about how to set these parameters, see Creating G/L Accounts.
In the Sort by field, select one of the following ways to sort the report:
Account# (Default)
Account# by Branch
Set Options, if needed, and generate the report. Do not use the following menu options, as this report was not designed for them:
Faxing
User Defined Heading
Forwarding
Reporting Server
See Also: