PRINT G/L BUDGETS 

Use this screen to print the budget information you entered in the Maintain Org/Account Budgets screen. You can print the budget information at any time. It is useful to print the budgets after entering them to verify the information against your original input documents.

Note: You can apply org security to this function. Use this optional feature to grant or remove rights for individual users to view and/or update specific organizations. In order to do so, you must first set up the necessary org security screens in the System Administration module. You can then activate org security through the use of the Maintain Users and System Settings screens. For more information about org security and how to apply it, see the System Administration Special Topic SA - 5, "Organizational Security" and the documentation for the Organizational Security menu in Costpoint System Administration.

Select

Revision

Choose the revision to print. The revisions available are those that have already been set up in the Maintain Budget Revisions screen. You can also use Lookup to select a revision number.

Sort

Select either the Organization or the Account radio button to indicate your primary sort preference. If you choose Organization, the report will print the selected accounts for each organization selected. If you choose Account, the report prints the selected organizations for each account selected.

Page Break

Select this checkbox if you want a page break after each organization, if you are sorting by organization, or after each account, if you are sorting by account. Leave the checkbox unchecked to enable more than one organization or account, depending on your Sort selection, to print per page.

Select Organizations

Use this group box to choose the organizations for which you will print the report. The Include Level __ and below field provides organization rollup options.

Range Option

Enter, or select from the drop-down box, the range of organizations (orgs) to be included on the report. The system-defined options are "All," "One," "Range," "From Beginning," and "To End." 

From/To

Enter the starting and/or ending organizations for the range of orgs you want to include on this report. You can also use Lookup to select the orgs for these fields. One or both of these fields may be disabled, depending on your Range Option selection.

Include Level __ and Below

Choose the level of the organization at which you will print the report. For example, if you choose organization 1.02.03 at level 4, all organizations beginning with 1.02.03 will be printed and rolled up to level 4: org 1.02.03.01 (including all its subsidiaries), org 1.02.03.02, etc.

Select Accounts

Use this group box to select the accounts that you will include on the report. The report is sorted first by revision, then by either organization or account number, depending on your Sort selection.

Range Option

Enter, or use the drop-down box to select, the range of accounts to be included on the G/L Budgets Report. The system-defined options are:  "All," "One," "Range," "From Beginning," and "To End." 

From/To

Enter the starting and/or ending accounts(s) for the account(s) you want to include on the report. You can also use Lookup to select the values for these fields. One or both of these fields may be disabled, depending on your Range Option selection.

Include Level __ and Below

Enter the level of the account at which you will print the report. For example, if you choose the range of accounts 1000 through 1999 at level 2, all accounts beginning with 1000 through 1999 will be printed, rolled up to level 2.

Select Active Periods

Use this group box to select the range of periods for which to print the report. The selections you make here affect the report category that will be printed; see Report Category section for more information.

Range Option

Enter, or use the drop-down box to select,  the range of active periods to be included on this report. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End." 

Fiscal Year

Enter, or select from the drop-down box, the fiscal year for which you want to print G/L Budgets.

Period Starting and Ending

These fields may or may not be active, depending on the period Range Option you selected. If you elected to print for "One" period, enter, or use the drop-down box to select, that period in the Starting field. If you selected a "Range" of periods, enter both the starting and ending periods in their respective fields. If you selected periods beginning from a specific period ("To End"), enter, or use the drop-down box to select, that period in the Starting field. If you selected periods up to a specific ending period ("From Beginning"), enter that period in the Ending field.

The non-editable fields to the right display the starting and ending dates for the periods selected.

Format

In this group box, you can choose to print the horizontal or vertical version of the report. If you want to select amounts or hours, select the Horizontal print format. If you want to show zero-balance periods, select the Vertical format. The selections you make here affect the report category that will be printed; see Report Category section for more information.

Horizontal

Select this radio button to print the horizontal version of the report. The horizontal version of the report looks a lot like a spreadsheet. It is a Category 2 or 3 report, which contains up to 132 or 225 columns, respectively. You will need 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 CPI on landscaped legal-sized paper. One line is printed for each account, if you are sorting by organization, or one line per organization, if you are sorting by account.

Vertical

Select this radio button to print the vertical version of the report. The vertical version of the report prints a line for each accounting period for each account, if you are sorting by organization, or one line per organization, if you are sorting by account. There is no limit on the number of periods that will fit, but this is a much longer report. It is a Category 1 report, which contains up to 89 columns and can be printed portrait-style on letter-sized paper.

Include

If you selected the Horizontal radio button, you can print either currency Amounts or Hours on one report. If you selected the Vertical radio button, these radio buttons are disabled.

Show

Zero Balance Periods

If you selected the Vertical radio button, select this checkbox to skip periods for which there is no budget for a given account, to save both printing time and paper. This option does not apply to the Horizontal version of the report. The default status for this checkbox is unchecked.

Include

Inactive Organizations

Select this checkbox to include organizations that are no longer active. The default status for this checkbox is unchecked, i.e., only active organizations will be printed on the report.

Inactive Accounts

Select this checkbox to include accounts that are no longer active. The default status for this checkbox is unchecked, i.e., only active accounts will be included on the report.

Show

Use this group box to specify different levels of detail to be printed on the report. The selections you make here have an affect on the report category that will be used for printing; see Report Category section for more information.

Amounts in Thousands

Select this checkbox to round to the nearest thousand. For example, "1,000,000.00" will be printed as "1,000." The default status for this checkbox is unchecked, i.e., amounts will not be rounded.

Period Totals

Select this checkbox to print period totals on the report. The totals are calculated by adding all the period data printed on the report for each account/organization. The totals may or may not be the same as the YTD total. These totals can be useful when you are printing the budgets for a quarter. The default status for this checkbox is unchecked, i.e., period totals will not be included.

Last Update Date

When you enter data in the Maintain Org/Account Budgets screen, the system automatically records the last date that an organization/account budget was changed. Select this checkbox to print this information. The default status for this checkbox is checked.

Hint: You can save the report parameters specified for future use. To save the selected report parameters, select the Save button on the toolbar after you have entered your report selections. Enter an appropriate ID and description for the report, and then select the OK pushbutton to save. Stored report parameters are especially useful if reports are to be run through the Process Manager. When creating the batch job to be executed, the report ID stored through the report parameters is used to identify report criteria.

Report Category

Based on the report options you choose, a category 1, 2, or 3 report will be printed. (Refer to Basic Functions Special Topic BF-2, "Printing in Costpoint," for more information.) The YTD total is always printed in the right-most column. The Org-Acct-Bud table is used for this report.

If you want to use the horizontal format and have more than 13 periods to print, print the report twice: periods 1-13 in the first run, and the remaining periods in the second run.