Contents of the Print General Ledger Budgets Screen
Use the fields and options to configure the Print General Ledger Budgets screen.
Identification
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
Field | Description |
---|---|
Parameter ID |
Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY. When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query. You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults. |
Description |
Enter, or click to select, a parameter description of up to 30 alphanumeric characters. |
Selection Ranges
Revision
Field | Description |
---|---|
Start |
Enter, or click to select, the revision for which you want to generate the report. You can report on any revision that has been set up on the Manage Budget Revisions screen. |
Organizations
Use this group box to choose the organizations for which you want to generate the report. The Include Level and below field provides organization rollup options.
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of organizations you want to include. Valid options are:
|
Start/End |
Enter, or click to select, the starting and/or ending organizations for the range of organizations you want to include on this report. One or both of these fields may be disabled, depending on your selection in Option. |
Include Level and below |
Enter the level of the organization at which you want to generate the report. For example, if you choose organization 1.02.03 at level 4, all organizations beginning with 1.02.03 are included and rolled up to level 4: organization 1.02.03.01 (including all its subsidiaries), organization 1.02.03.02, and so on. |
Selection Ranges: Accounts
Use this group box to select the accounts that you will include on the report. Costpoint sorts the report first by revision and then by either organization or account number, depending on your selection in 1st Sort. The Include Level and below field provides account rollup options.
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of accounts you want to include. Valid options are:
|
Start/End |
Enter, or click to select, the starting and/or ending accounts for the range of accounts you want to include on the report. One or both of these fields may be disabled, depending on your selection in Option. |
Include Level and below |
Enter the level of the account at which you want to generate the report. For example, if you choose the range of accounts 1000 through 1999 at level 2, all accounts beginning with 1000 through 1999 are included, rolled up to level 2. |
Selection Ranges: Fiscal Year
Field | Description |
---|---|
Start |
Enter, or click to select, the fiscal year for which you want to generate the report. |
Selection Ranges: Active Periods
Use this group box to select the range of periods for which to print the report. The selections you make here affect whether Costpoint generates a category 1, 2, or 3 report. The last column on the report always displays year-to-date totals.
If you want to use the horizontal format and include more than 13 periods, generate the report twice: periods 1-13 in the first run and the remaining periods in the second run.
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of active periods you want to include. Valid options are:
|
Start/End |
Enter, or click to select, the starting and/or ending periods for the range of periods you want to include on this report. One or both of these fields may be disabled, depending on your selection in Option. The non-editable End Date fields display the ending dates for the periods selected. |
Sort By
Field | Description |
---|---|
1st Sort |
Select either Organization or Account to indicate the primary sorting criterion. If you select Organization, the report displays information by accounts for each organization. If you select Account, the report displays information by organizations for each account. |
Page Break |
Select this check box if you want a page break after each organization, if you sort by organization, or after each account, if you sort by account. |
Options
Format
In this group box, select either the horizontal or vertical version of the report. If you want to select amounts or hours, select Horizontal. If you want to show zero-balance periods, select Vertical. The selections you make here affect whether Costpoint generates a category 1, 2, or 3 report. The last column on the report always displays year-to-date totals.
If you want to use the horizontal format and include more than 13 periods, generate the report twice: periods 1-13 in the first run and the remaining periods in the second run.
Field | Description |
---|---|
Horizontal |
Select this option to generate the horizontal version of the report. The horizontal version is similar to a spreadsheet. It is a category 2 or 3 report, which contain up to 132 or 225 columns, respectively. You must use a very small font and/or very wide paper for category 3. For example, you can use a very small font and fit the report on landscaped letter-sized paper, or use 16.7 characters per inch on landscaped legal-sized paper. The report displays one line for each account if you sort by organization, or one line for each organization if you sort by account. |
Include Amounts/Hours |
If you select Horizontal, indicate if you want to display currency amounts or hours on the report. |
Vertical |
Select this option to generate the vertical version of the report. For each accounting period, the vertical version displays one line for each account if you sort by organization, or one line for each organization if you sort by account. There is no limit on the number of periods that will fit, but this is a much longer report. This report is a category 1 report, which contains up to 89 columns and fits in portrait orientation on letter-sized paper. |
Show Zero Balance Periods |
If you select Vertical, select this check box to include periods for which there is no budget for a given account. Do not select the check box if you want to omit zero-balance periods to save both report generation time and paper. |
Include
Field | Description |
---|---|
Inactive Organizations |
Select this check box to include organizations that are not active. |
Inactive Accounts |
Select this check box to include accounts that are not active. |
Show
Use this group box to control level of detail on the report. The selections you make here affect whether Costpoint generates a category 1, 2, or 3 report.
Field | Description |
---|---|
Amounts in Thousands |
Select this check box to round to the nearest thousand. For example, if you select this check box, the report displays 1,000,000.00 as 1,000. If you do not select this check box, amounts are not rounded. |
Period Totals |
Select this check box to display period totals. The totals are the sum of all the period values included on the report for each account or organization. The totals may or may not be the same as the year-to-date total. These totals can be useful when you generate the budgets for a quarter. |
Last Update Date |
When you enter data on the Manage Organization/Account Budgets screen, Costpoint automatically records the last date that an organization/account budget was changed. Select this check box to include these dates on the report. |
Generate the Report
To generate the General Ledger Budgets Report, enter the report options you want and then click Print General Ledger Budgets on the Action menu.