Contents of the Compute/Print Pool Rates Screen

Use the fields and options to configure the Compute/Print Pool Rates screen.

Compute/Print Pool Rates

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

Accounting Period

Use this group box to select the period through which you would like to compute pools. All incurred costs up to and including the one you enter here are included in the pool calculation.

Field Description
Option

This field always displays One.

Fiscal Year

Enter, or click to select, fiscal years that have been set up on the Manage Fiscal Years screen. You can select any fiscal year that has a Status of O (Open). This is a required field.

Period

Enter, or click to select, periods that have been set up on the Manage Accounting Periods screen. The drop-down list contains all periods that have a Status of O (Open). You can select any period. This is a required field.

Subpd

This field automatically displays the lowest-numbered open subperiod from Costpoint General Ledger. However, you can click to select another subperiod. This is a required field.

Ending Date

This non-editable field displays the ending date of the selected subperiod.

Allocation Group Number

Use this group box to select the allocation group number for which you would like to compute.

Field Description
Option

This field always displays One.

Start

Select an allocation group number. displays all allocation group numbers that have been set up on the Manage Allocation Groups screen. Group 1 is the primary allocation group because all the pools in that group allocate to projects. However, you can select any valid allocation group. This is a required field.

The non-editable field to the right displays the description of the allocation group.

Sequence Numbers/Pools

Use this group box to limit the range of pools that are included in the calculation.

Field Description
Option

Use this drop-down list to select a range of sequence numbers and pools. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start Seq No/Pool No

Use these fields to select the starting range for pool rate calculations. Service center pools can be included in the range. Example: From Seq 1 Pool 1 to Seq 4 Pool 10, or From Seq 3 Pool 5 To Seq 3 Pool 5. Pool ranges are often used when using intermediate pools for financial statement reclassification. These are required fields.

End Seq No/Pool No

Use these fields to select the ending range for pool rate calculations. Service center pools can be included in the range. Example: From Seq 1 Pool 1 to Seq 4 Pool 10, or From Seq 3 Pool 5 To Seq 3 Pool 5. Pool ranges are often used when using intermediate pools for financial statement reclassification. These are required fields.

Options

Report

Use this group box to select various report options.

Field Description
Account Level ____ and below

Enter the level of the account that you would like to print on the Statement of Indirect Expenses. If you enter 0, all accounts are displayed at the level of the charging occurred. This is the most detailed report. Enter "1" to view all costs summarized to level 1. Enter 2 to view all costs summarized to level 2. If you enter 2, any costs at level 1 are included on the report. Remember that, for the Statement of Indirect Expenses report to calculate the rate correctly, all costs are included even if they are at higher levels.

Organization Level ____ and below

Enter the level of the organization that you would like to print on the Statement of Indirect Expenses. If you enter 0, all organizations are displayed at the level of the charging occurred. This is the most detailed report. Enter 1 to view all costs summarized to level 1. Enter 2 to view all costs summarized to level 2. If you enter 2, any costs at level 1 are included on the report. Remember that for the Statement of Indirect Expenses report to calculate the rate correctly, all costs are included even if they are at higher levels.

Show amounts in thousands

Select this check box to present the Statement of Indirect Expenses in thousands. The default value is blank.

Show base account names

Select this check box to present the Statement of Indirect Expenses with account numbers or account numbers and names for the base account section of the report. If names are included, they are printed above the account numbers. The default value is selected (print account names).

Show Variance Column

Select this check box to display the Variance amount column on the Statement of Indirect Expenses. Variance amount is calculated as Budget amount - Actual amount. You can display variance amounts in either the current period or year to date:

  • Current Period: Select this option to display variance amounts in the current period. When you select this option, the Variance column is displayed under Current Period on the Statement of Indirect Expenses, together with the Actual and Budget columns.
  • Year To Date: Select this option to display year-to-date variance amounts. When you select this option, the Variance column is displayed under Year To Date on the Statement of Indirect Expenses, together with the Actual and Budget columns.
Note: The Year To Date Budget column is hidden when you select Current Period, and the Current Period Budget column is hidden when you select Year To Date.

Process

Field Description
Ignore Project Account Group Validation

Select this check box if you do not want the Compute/Print Pool Rates process to validate each project account by ensuring that the account exists in the project account group of the project.

Delete Prior Non-Primary Allocations

Select this check box if you want the application to delete rows from the POOL_SIE_SUPPORT table if they do not belong to allocation group one.

Print

Click the arrow to the right of and select one of the following options:

  • Compute Pool Rates: Select this option to compute actual rates and allocation amounts for the pools in the range selected. For service center pools, the allocation amounts and amount to post are calculated and updated on the Maintain Allocation Journal screen. For non-service center pools, indirect rates are calculated and updated in this screen and allocation amounts and amount to post are updated on the Manage Allocation Journal screen.
  • Compute & Print Pool Rates: Select this option to compute rates and amounts and to automatically print the Statement of Indirect Expenses after the computation is made.
Print

Click to print actual rate and allocation amount information after computing. You can use this icon to reprint the Statement of Indirect Expenses any time after the rates have been computed. Costpoint stores the most recently computed rate calculations.

Subtasks

Subtask Description
Pools Click this link to open the Pools subtask, where you can view information about the pools and the calculation of the pool base.
Purge Old SIE Click this link to open the Purge Old Statement of Indirects subtask. Use this subtask to purge data from the POOL_SIE_SUPPORT table. This table stores the data required for reprinting old Statement of Indirect Expenses (SIE).