To run the General Ledger Export Report: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/L > G/L Reports menu, select General Ledger Export to display the General Ledger Export Report screen.
In the Br/Tr/All field, enter the branch or territory 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/All field, do one of the following to select for which accounts to run the report:
Press F10 and select from a list of accounts.
Type ALL to include all general ledger accounts.
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.
In the Template field, to include all the accounts in a particular general ledger report template, press F10 and select from a list of report template IDs. This field is only accessible if you leave the Account/All field blank.
Note: Define templates on the G/L Report Template Maintenance screen. For more information, see Template Maintenance Overview.
In the SubLedger field, press F10 and select a subledger to include in the report or type All to include all subledgers in the report.
In the Detail/Summary field, press F10 and 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 checked. |
|
Detail |
Prints a line for each transaction on the report. |
Note: Set the parameters for the Export Detail field are set on the G/L Account Maintenance screen. For more information, see Creating G/L Accounts.
In the Branch Detail field, select one of the following to determine how to format detail information by branch:
If you select Detail in the Detail/Summary field, the system populates this field with a Y and moves the cursor to the Reference field.
If you select Summary or Summary/All in the Detail/Summary field, select Y to break out all summary information by branch, or N 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 on the G/L Account Maintenance screen.
Description – Identifies the account by the entry in the Full Description field on the G/L Account Maintenance screen.
Note: For more information about how to set these parameters, see Creating G/L Accounts.
In the Sort by field, press F10 and 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 options:
Faxing
User Defined Heading
Forwarding
Reporting Server
See Also: