Generate Spreadsheet - Screen Overview
Generate Spreadsheet
Screen Code: gltbfssprm
Allows you to generate the report in a spreadsheet by defining various parameters.
Navigation Tip: General Ledger >> Year End Processing >> Additional Period JE's and Reports >> Base Financial Statements >> Work with Display Format >> right-click and select Generate Spreadsheet.
It has the following parameters:
Field
|
Description
|
Fund group
|
Name of the Fund Group.
Leaving blank lists all the fund group names.
Upon entering a fund group, Fund Number selection will be disabled.
|
Fund number
|
Name of the Fund Number.
Leaving blank or zero lists all the fund numbers.
Upon entering a fund name, Fund group selection will be disabled.
|
Department number
|
Name of the Department.
|
Program number
|
Program numbers associated with one Fund or Department might differ from the description for the same Program number within a different Fund or Department.
|
From Object
|
Object starting number
|
To Object
|
Object ending number
|
Period Ending
|
Period ending in mmyyyy format. If left blank will generate from the star of the fiscal year.
If specified will generate the report till the specified account ending period.
|
Delimiting character
|
Identifies the columns till the delimited character.
Recommended delimited character is “~”.
|
Include headings?
|
Yes - Include Sub Settings in the report.
No - Exclude Sub Settings in the report.
|
Include subtotals?
|
Yes - Include Sub Settings in the report.
No – Exclude Sub Settings in the report.
|
Print detail or summary?
|
Detail - Includes a detailed summary in the report.
Summary - Excludes detailed summary in the report.
|
Print zero amounts?
|
Yes - Includes zero amounts in the report.
No - Excludes zero amounts in the report.
|
Click Submit button to display Submit Parameters page and submits the job to run.
Version 1.1
