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:

  • All: Select this option to include all available organizations. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one organization and then enter that organization in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of organizations. Enter the beginning organization for the range in the Start field and enter the ending organization of the range in the End field.
  • From Beginning: Select this option to include a range of organizations that begins with the first of all the available organizations and ends with the organization that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of organizations that begins with the organization that you enter in the Start field and ends with the last of all the available organizations. The End field is disabled for this option.
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:

  • All: Select this option to include all available accounts. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one account and then enter that account in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of accounts. Enter the beginning account for the range in the Start field and enter the ending account of the range in the End field.
  • From Beginning: Select this option to include a range of accounts that begins with the first of all the available accounts and ends with the account that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of accounts that begins with the account that you enter in the Start field and ends with the last of all the available accounts. The End field is disabled for this option.
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:

  • All: Select this option to include all available active periods. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one active period and then enter that period in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of active periods. Enter the beginning period for the range in the Start field and enter the ending period of the range in the End field.
  • From Beginning: Select this option to include a range of active periods that begins with the first of all the available active periods and ends with the period that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of active periods that begins with the period that you enter in the Start field and ends with the last of all the available active periods. The End field is disabled for this option.
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.