Contents of the Print Project Status Report Screen

Use the fields and options to configure the Print Project Status Report screen.

Print Project Status Report

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

Use this group box to limit the project reports that print. You can also define the level of the project, organization, and account in this group box.

Field Description
Select By

Use the drop-down list to select how the report is printed. Valid options are:

  • Project: If you select Project, the application prints a separate report for each project or each branch of the project tree, depending on the Project Level/Alt Project Level selection.
  • Owning Organization: If you select Owning Organization, the application prints a separate report for each organization or each branch of the organization tree, depending on the Organization Level selection, for all organizations that are specified as an owning organization on the Basic Info tab of the Manage Project User Flow. Note that all organizations, regardless of the performing organization, are summarized into the report by Owning Organization.
  • Performing Organization: If you select Performing Organization, the application prints a separate report for each organization or each branch of the organization tree, depending on the Organization Level selection, for all organizations that have incurred costs in the performance of the project. Note that all organizations, regardless of the owning organization, are summarized into the report by Performing Organization.
  • WIP Project: If you select WIP Project, the application prints a report that displays both the balance sheet (capitalized costs) and income statement sections of the project. Select this grouping only if the Project Classification is designated as Work In Process on the Basic Info tab of the Manage Project User Flow.
  • Alternate Project: If you select Alternate Project, the application prints a separate report for each alternate project or each branch of the alternate project tree, depending on the Project Level/Alt Project Level selection.
  • WIP Alternate Project: If you select WIP Alternate Project, the application prints the report described for the WIP Project selection using the Alternate Project feature.
  • Reorganization: If you select Reorganization, the application prints a separate report for a combined organization that may be linked with another organization, per the settings in the screens in the Reorganizations menu in Costpoint General Ledger. 
  • WIP Owning Organization: If you select WIP Owning Organization, the application prints a report that displays both the balance sheet (capitalized costs) and income statement sections of the project. Select this grouping only if the Project Classification is designated as Work In Process on the Basic Info tab of the Manage Project User Flow. One report prints for each owning organization.
  • WIP Performing Organization: If you select WIP Performing Organization, the application prints a report that displays both the balance sheet (capitalized costs) and income statement sections of the project. Select this grouping only if the Project Classification is designated as Work In Process on the Basic Info tab of the Manage Project User Flow. One report prints for each performing organization.
Option

Use the drop-down list to select the range of projects or organizations to print. This range must be consistent with the projects you have updated in the PSR table. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the starting project or organization for the range of projects or organizations to be printed. This field is enabled if you selected One, Range, or To End in the Option field.

End

Enter, or click to select, the ending project or organization for the range of projects or organizations to be printed. This field is enabled if you selected Range or From Beginning in the Option field.

Non-Contiguous Ranges

Select this checkbox to choose a non-contiguous range of projects to print on the report. Use the Project Non-Contiguous Ranges subtask to select the ranges.

This checkbox is visible and enabled only when you select Project or WIP Project in the Select By field. If you selected this checkbox and entered data in the Project Non-Contiguous Ranges subtask, that will override the project range selected from the Selection Ranges group box.

Project Managers

These fields are enabled only when you select Project (the default selection) or WIP Project in the Select By field.

Field Description
Option

Use the drop-down list to select the range of project managers for the selected project or range of projects to print. If you enter a project range in the Start and/or End fields for Select By, the project manager(s) assigned to these project(s) are listed when you click in the enabled Start and/or End fields in this group box. This range must be consistent with the projects you have updated in the PSR table. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the starting project manager for the range of projects to be printed. This field is enabled if you selected All, One, Range, or To End in the Option field.

End

Enter, or click to select, the ending project manager for the range of projects to be printed. This field is enabled if you selected All, Range, or From Beginning in the Option field.

Accounting Period

Use these fields to select the period ending date for data to be included on the report.

Field Description
Option

This field always displays One.

Fiscal Year

Enter, or click to select, the fiscal year you want included on the report.

Period

Enter, or click to select, the fiscal period you want included on the report. This period is considered the Current Period for column option purposes.

Subpd

Enter, or click to select, the subperiod you want included on the report. This subperiod is considered the Current Subperiod for column option purposes.

Ending Date

This non-editable field displays the selected subperiod end date.

Only Projects with Alternate Revenue Profiles

Select this checkbox to print only projects that have alternate revenue profiles (that is, the project, its parent project, or any of its children is in the ALT_PROJ table).

Note: This checkbox is available only when the Alternate Revenue Calculations database option is selected on the Corporate Settings subtask of the Configure General Ledger Settings screen.

Billing Currency

Use this group box to select the billing currency that you want to use on the report.

Field Description
Option

This field always displays One.

Start

Enter, or click to select, the billing currency for which you want to print the report. This field is enabled only if you select Billing Currency or Both in Column Options.

Sort By

Use this group box to sort the selected reports by Project. If you do not want to use this feature, the reports print in numerical order and are not sorted. Note that this feature is available only if you select Project or WIP Project in the Select By field in the Selection Ranges group box.

Field Description
Performing Org As Secondary Sort

Select this checkbox if you want a secondary sort on the report by performing organization. This checkbox is available only if you selected Project for your Select By grouping.

1st sort

Use this drop-down list to select the first level of sorting. If you selected Project in the Select By field, the option selected in this field is the 2nd sort. The available options are:

  • Project
  • Organization
  • Project Manager
  • Project Type
2nd Sort

Use this drop-down list to select the second level of sorting. The available options are

  • Project
  • Organization
  • Project Manager
  • Project Type
3rd Sort

Use this drop-down list to select the third level of sorting. The available options are:

  • Project
  • Organization
  • Project Manager
  • Project Type
4th Sort

Use this drop-down list to select the fourth level of sorting. The available options are:

  • Project
  • Organization
  • Project Manager
  • Project Type

Options

Level

Use the fields in this group box to select various levels of reporting.

Field Description
Project Level/Alt Project Level __ and Below

Identify the highest project level to print on the report. Balances are rolled up to this project level.

Account Level __ and Below

Identify the highest account level to print on the report. Balances are rolled up to this account level.

Organization Level __ and Below

Identify the highest organization level to print on the report. Balances are rolled up to this org level.

Show

Use the options in this group box to select various reporting options.

Field Description
Inactive Projects

Select this checkbox to include projects that have been set inactive on the Project User Flow.

Print Lines With No Activity

Select this checkbox to print lines on the PSR even if they have no activity. Leave the checkbox blank to suppress lines with no activity.

Amount In Thousands

Select this checkbox to print amounts rounded to the nearest thousand.

Revenue Information

Select this checkbox to include revenue information on the report. If you do not select the checkbox, only cost information is printed.

Suppress If No Current Period Activity

Select this checkbox to suppress the report if there is no activity in the current period. If you select this checkbox, no information prints on the report if the following conditions are met:

  • In the Column group box, you selected Current Period Actual, Current Period Budget, or Current Period Variance as one of the columns to show on the report, and
  • The amounts for each row in the column are zero.

If you select this checkbox and these criteria are met, the report is suppressed, but the parameters page and the report page still print.

Suppress If No Year-To-Date Activity

Select this checkbox to suppress the report is there is no year-to-date (YTD) activity. If you select this checkbox, no information prints on the report if one of the following conditions is met:

  • In the Column group box, you selected Year To Date Actual as one of the columns to show on the report, and the amounts for each row in the column are zero.
  • You did not select the Suppress If No Current Period Activity checkbox, selected Year To Date Actual, Current Period Actual, and/or Current Subperiod Actual as one of the columns to show on the report, and the amounts for each row in these columns are zero.

If you select this checkbox and either of these criteria is met, the report is suppressed, but the parameters page and the report page still print.

Costpoint does not consider YTD budget and variance columns for this option. Instead, it checks if there is any YTD, current period, or current subperiod activity for the fiscal year, period, and subperiod specified on this screen.

Labor Hours and Units

Select this checkbox to print labor hours and units information in the footer of the report. This option is available only if you selected Project or WIP Project in the Selection group box.

Pool Burden Rates

Select this checkbox to display pool burden rates on the report. Leave the checkbox blank to suppress the printing of burden rates. Rates for hours-based cost pools print in the functional currency of the company that owns the project, and cost-based pool rates display as percentages.

Pools By Seq. No, Pool No

Select this checkbox to sort and print pools by sequence number, then by pool number.

Column

Field Description
Column Options

Select the option to print the report in the Functional Currency, Billing Currency, or Both.

If you select Billing Currency or Both, the Revenue Information checkbox becomes cleared and disabled. The PSR will only include costs when printing in the billing currency; revenue will not be printed. If you are printing the PSR for a project that has the same billing currency for the entire project tree, values are rolled up at the levels higher than the billing level.

Note: These options are hidden if your Multicurrency license is off.
Attention: To see sample columns and data when the Project Status Report is printed in the billing currency, functional currency, or both, see topics in the Project Status Report Samples section.
As Column 2 - 8

Select the report columns to show on the report by selecting an option from the drop-down list for each column you want to print.

If you selected Functional Currency, valid options are:

  • Current Period Actual
  • Current Period Budget
  • Current Period Variance
  • Current Subperiod Actual
  • Current Subperiod Budget
  • Current Subperiod Variance
  • Year to Date Actual
  • Year to Date Budget
  • Year to Date Variance
  • Prior Year Actual
  • Prior Year Budget
  • Prior Year Variance
  • Contract To Date Actual
  • Contract To Date Budget
  • Contract To Date Variance
  • Total Contract Budget
  • Pending PR Amounts
  • Approved PR Amounts
  • Pending PO Amounts
  • Open PO Amounts
  • Received PO Amounts
  • Accepted PO Amounts
  • Vouchered PO Amounts
  • Unreleased Blanket Amounts
  • Total PO Commitments
  • Expense Commitments
  • Total Contract Variance
  • Account ID
Note: Account ID is available only from the As Column 2 drop-down list.

If you selected Billing Currency, valid options are:

  • MU Current Period Actual
  • MU Current Subperiod Actual
  • MU Year To Date Actual
  • MU Prior Year Actual
  • MU Contract To Date Actual

If you selected Both, all functional and billing currency column options are available.

Profit As Percentage Of

Use this drop-down list to select the method you would like to use to calculate the profit percentage. Options are:

  • Costs: Select this option to print the profit as a percentage of costs.
  • Revenue: Select this option to print the profit as a percentage of revenue.

Rate Type

Use this drop-down list to select the rate type that you would like to use on the report. Options are:

  • Actual: Select this option to burden costs with actual expenses. These amounts are stored in the PSR Final Data table.
  • Target: Select this option to burden costs with target rates. These amounts are stored in the PSR Final Data table.
  • Actual/Target: Select this option to print the PSR with direct expenses using actual rates, and revenue displayed at target rates.

Subtask

Subtask Description
Project Non-Contiguous Ranges Click this link to define the non-contiguous range of projects that you want to include on the report.