PRINT DETAILED PART AVAILABILITY REPORT
Use this report to select range of parts and prepare a detailed schedule for each part, showing its current inventory and all anticipated supply and demand for a given range of inventory projects.
Inventory balances and safety stock requirements always reflect current balances, but future supply and demand does not reflect modifications to orders, requisitions, and requirements done since the last time MRP was executed. Therefore, we suggest that you run this report right after MRP execution. The report will print the last MRP run date, and any part modified after the MRP process was run will be flagged.
Use this report to get a printout of supplies and demands.
Location
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 are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
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 in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in 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 in 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.
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 in 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 in 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 in 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.
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.
Include Common Inventory
This check box defaults to selected and disabled if the Selection Option is All Projects. Keep it selected to include projects with Common Inventory flag set as selected, even if they are not within the selection criteria. This check box option is disabled and unchecked if you selected Project Plan Group in the Selection Option.
Sort By
Use this group box to select the sorting criteria.
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.
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.