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.

Note: Inventory balances and safety stock requirements always reflect current balances, but future supply and demand does not reflect changes 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 changed after the MRP process was run will be flagged.

Use this report to get a printout of supplies and demands.

Sort

Use this group box to select the sorting criteria.

Part

Select this radio button to sort part detail by part/revision. This is the default option. There will be a page break after each part/revision if you selected the Page Break on Part checkbox.

Make/Buy

Select this radio button to sort part detail by make/buy status. There will be a page break after each type of code. If you selected the Page Break on Part checkbox, there will also be a page break after each part/revision.

Commodity

Select this radio button to sort the part detail by commodity code. There will be a page break after each commodity code. If you selected the Page Break on Part checkbox, there will also be a page break after each part/revision.

Select Part

Use the fields in this group box to select the part/revision that you would like to include in the 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 checkbox, parts with a non-MRP planning type will be excluded.

Range Option

Use the drop-down box to select the range of parts/revisions to include in the report. Available options are "All," "One," "Range," "From Beginning," and  "To End." This field defaults to "All."

From

Enter, or use Lookup to select, the part/revision (or beginning part for a range) that you would like to include in the report. The revision field (to the right of the From part field) is displayed if you selected the Allow Multiple Revisions for Each Item checkbox in the Product Definition Corporate Settings subtask of the Product Definition Settings screen in Costpoint Product Definition.

To

Enter, or use Lookup to select, the ending part/revision (for a range) that you would like to include in the report. The revision field (to the right of the To part field) is displayed if you selected the Allow Multiple Revisions for Each Item checkbox in the Product Definition Corporate Settings subtask of the Product Definition Settings screen in Costpoint Product Definition.

Select Planner

Use the fields in this group box to select the planners you want to include in the report. You can exclude or include parts, depending on the Planner Assignment method in the 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.

If the Range Option is "All," all projects will be included in the report, even those without a commodity code or a planner assigned to them or their netting group.

Range Option

Use the drop-down box to select the range of planners to include in the report. Available options are "All," "One," "Range," "From Beginning," and "To End." The default is "All."

From

Enter, or use Lookup to select, the planner (or beginning planner for a range) whose messages you would like to view.

To

Enter, or use Lookup to select, the ending planner (for a range) whose messages you would like to view.

Project Selection Option

Use the drop-down box to select the inventory projects/netting groups that you would like to include in the report.

Include Common Inv

Select this checkbox to include common inventory projects in the availability report, even if they do not meet the other project selection criteria. If you selected "All Projects" as your Project Selection Option, this checkbox is checked and disabled.

Select Project

Use this group box to select the projects that you want to include in the report.

Range Option

Use the drop-down box to select the range of projects to include in the report. Available options are "All," "One," "Range," "From Beginning," and "To End." The default is "All." This field is disabled if the Project Selection Option is "Netting Group" or "All Projects." If the Project Selection Option is "Proj Plan Group" or "Top-Level Project," this field defaults to "One."

From

Enter, or use Lookup to select, the project (or beginning project for a range) that you would like to include in the report.

To

Enter, or use Lookup to select, the ending project (for a range) that you would like to include in the report.

Select Netting Group

Use this group box to select the netting groups that you would like to include in the report.

Range Option

Use the drop-down box to select the range of netting groups to include in the report. Available options are "All," "One," "Range," "From Beginning," and "To End." The default is "All." This field is enabled only if the Project Selection Option is "Netting Group."

From

Enter, or use Lookup to select, the netting group (or beginning netting group for a range) that you would like to include in the report.

To

Enter, or use Lookup to select, the ending netting group (for a range) that you would like to include in the report.

Select Warehouse

Use the fields in this group box to select the warehouses that you would like to include in the report.

Range Option

Use the drop-down box to select the range of warehouses to include in the report. Available options are "All," "One," "Range," "From Beginning," and  "To End." This field defaults to "All" and is disabled if you did not select the Plan Warehouse Separately checkbox in the MRP Corporate Settings subtask of the MRP Settings screen. It defaults to "One" and is enabled if you selected the Plan Warehouse Separately checkbox in the MRP Settings screen.

From

Enter, or use Lookup to select, the warehouse (or beginning warehouse for a range) that you would like to include in the report.

To

Enter, or use Lookup to select, the ending warehouse (for a range) that you would like to include in the report.

Select Buyer

Use the fields in this group box to select the buyers that you would like to include in the report. If the Range Option is not "All," and you selected Commodity in the Buyer Assignments group box in the 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, the system will use the buyer code associated with the part in the Planning Part Data screen in Costpoint Product Definition to determine whether or not the part is within the selected buyer range. If the Range Option is "All," the report includes all buyers, along with the parts and commodities without a buyer assigned.

Range Option

Use the drop-down box to select the range of buyers to include in the report. Available options are "All," "One," "Range," "From Beginning," and "To End." This field defaults to "All," in which case the report includes all buyers, along with parts and commodities without a buyer assigned.

From

Enter, or use Lookup to select, the buyer (or beginning buyer for a range) that you would like to include in the report.

To

Enter, or use Lookup to select, the ending buyer (for a range) that you would like to include in the report.

Select Make/Buy

Use the options in this group box to specify whether "Make," parts, "Buy" parts, or both should be included. Both are selected by default.

Buy

Select this checkbox to include parts with a make/buy status of "B" (Buy). This is selected by default.

Make

Select this checkbox to include parts with a make/buy status of "M" (Make). This is selected by default.

Date Cutoff

Enter 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.

Include Non-MRP Planned Parts

Select this checkbox to include parts that do not have a Planning Type of "MRP" in the Planning Part Data screen in Costpoint Product Definition.

Page Break on Part

Select this checkbox to force a page break every time a new part/revision is printed.