Contents of the Print Detailed Part Availability Report Screen

Use the fields and options to configure the Print Detailed Part Availability Report 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

Use this group box to specify the range of parts information you want to include in this report.

Field Description
MPS Plan

The Option field for this label always displays one. Use the adjacent field to select the MPS plan, from which you want to retrieve planned orders to include in this report.

Part/Rev

Use the drop-down list to select the range of part numbers you want to include in this report. Inactive parts, non-inventory parts, and parts with a release status of "Pre-Release" or "Estimating" will be excluded from the report, even though they may fall within the selected range. If you did not select the Include Non-MRP Planned Parts check box, parts with a non-MRP planning type will be excluded. The available options are:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.

Use the Start and End fields to specify the scope of this range, as applicable.

Planner

Use the drop-down list to select the range of planners that you want to include in this report. You can exclude or include parts, depending on the Planner Assignment method on the Configure Production Control Settings screen in Costpoint Production Control.

If the planner assignment is by Part, the part's planner must be within the selected planner range in order for the part to be included in the report. If the planner assignment is by Commodity, the part's commodity code must be within the selected planner range in order for the part to be included in the report. If the planner assignment is by Inventory Project, the report will exclude inventory projects whose planner IDs are not within the selected planner range. If planner assignment is by Netting Group, the report will exclude projects whose netting group's planner ID is not within the selected planner range.

The available options are:

  • All: Select this option to include all available records. All projects will be included in the report, even those without a commodity code or a planner assigned to them or their netting group. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Warehouse

Use the drop-down list to select the range of planners you want to include in this report.

The available options are:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Buyer

Use the drop-down list to select the range of buyers you want to include in this report. If you select All, and you selected Commodity in the Buyer Assignments group box on the Configure Requisition Settings screen in Costpoint Procurement Planning, parts are included in the report if the buyer associated with the part's commodity code is within the selected buyer range. If the buyer assignment is not by commodity code, Costpoint will uses the buyer code associated with the part on the Manage Part Project Data screen in Costpoint Product Definition to determine whether or not the part is within the selected buyer range. If you select All, the report includes all buyers, along with the parts and commodities without a buyer assigned.

The available options are:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Need/Due Date Cutoff

The option field for this label is always set to From Beginning. Use the End field enter, or use to select, the latest scheduled need/due date to include in the report. This is an optional field. If you enter a date in this field, the report will exclude all supplies with a planned available date later than the date specified, and exclude all requirements with a need date later than the date specified.

Start

Use this field to enter, or use to select, the starting part, planner, warehouse, or buyer, as applicable.

For the MPS Plan label, use this field to select the MPS plan, from which you want to retrieve planned orders. The adjacent field displays the description for the selected MPS plan.

For the Part/Rev label, use this field to enter, or use to select, the starting part number. Use the adjacent field to enter, or use to select, the revision number for the selected part number.

End

Use this field to enter, or use to select, the ending part, planner, warehouse, or buyer, as applicable.

For the Part/Rev label, use this field to enter, or use to select, the ending part number. Use the adjacent field to enter, or use to select, the revision number for the selected part number.

For the Need/Due Date Cutoff label, use this field to enter, or use to select, the latest scheduled need/due date to include in the report.

Inventory Project Selection

Use this group box to specify the projects or netting groups that you want to include in this report.

Field Description
Selection Option

Use the drop-down list to select the inventory projects/netting groups that you want to include in the report.

  • All Projects: Select this option to have all inventory projects included for the part detail. The Project and Netting Group fields are disabled for this option.
  • Netting Group Range: Select this option to specify a range netting groups included for the part. Any inventory tied to projects without netting groups are not displayed. The Project fields are disabled for this option.
  • Project Plan Group: Select this option to include all receipts and requirements within the same project-planning group as that of the selected project. You must specify a project plan group in the Start field of the Project label. The Netting Group fields are disabled for this option.
  • Top-Level Proj: Select this option to include all inventory projects that share the same top-level project ID as projects within the selected range. You must specify a top-level project in the Start field of the Project label. The Netting Group fields are disabled for this option.
  • Project Range: Select this option to include only the projects specifically included in the project range. Use the Start and End fields of the Project label to specify the starting and ending projects. The Netting Group fields are disabled for this option.
Project

Use the drop-down list to select the range of inventory projects you want to include in this report. The available options are:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Netting Group

Use the drop-down list to select the range of netting groups you want to include in this report. The available options are:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Start

Use this field to enter, or use to select, the starting inventory project or netting group, as applicable.

End

Use this field to enter, or use to select, the ending inventory project or netting group, as applicable.

Sort By

Use this group box to select the sorting criteria.

Field Description
1st Sort

Use this drop-down list to select whether to primarily sort this report by Part, Make/Buy, or Commodity.

2nd Sort

This field displays Part, which indicates that each section in the report, as you have specified in the 1st Sort drop-down list, is sorted by part.

Page Break on Part

Select this check box to insert a page break after each part/revision.

Options

Use this group box to specify additional options for this report.

Include Make/buy

Use this group box to specify whether to include "Make" parts, "Buy" parts, or both.

Field Description
Buy

Select this check box to include parts with a make/buy status of B (Buy).

Make

Select this check box to include parts with a make/buy status of M (Make).

Include Non-MRP Planned Parts

Select this check box to include parts that do not have a planning type of MRP in the Manage Part Project Data screen in Costpoint Product Definition.