Use this inquiry screen to display time-phased supply and demand for a part grouped by user-defined time buckets. The inquiry can show the projected inventory at the end of a weekly or monthly bucket and the scheduled supply and demand that will affect that availability. You can select a specific time period and view supply and demand using the warehouse, all projects, a top-level project, a selected project, related projects, or a netting group as a selection criterion. Current inventory, scheduled supply and demand, and order-detail information will also be displayed. This application is enabled for all inventory parts, rather than just MRP-planned parts.
Use this screen to view the supply-and-demand schedules in weekly or monthly buckets.
Enter, or use Lookup to select, the part number for which you would like to view supply/demand information. This required field of up to 30 alphanumeric characters must have a valid part number from the Basic Part Data screen in Costpoint Product Definition.
Enter, or use Lookup to select, the revision of the part number for which you would like to view supply/demand information. You can enter up to three alphanumeric characters, which must be a valid revision number for the part from the Basic Part Data screen in Costpoint Product Definition. A description of the part/revision that you selected will display in the adjacent unlabeled field.
Use the drop-down box to select the project-grouping option to define what inventory projects to view.
All Projects - Select this option to include inventory supply and demand for all projects.
Netting Group - Select this option to include all supply and demand for inventory projects having the same netting group as the one specified (in the Netting Group field). If you selected the Include Common Inventory checkbox, the supply and demand for projects that have been specified as common inventory will also be included, even though they may not have the same netting group.
Project Planning Group – Depending upon whether the part is common-stock or not, this will include all supply and demand for inventory projects that are within the same project-planning group as the project specified in the Project field. See the documentation for MRP Option Code in the MRP Settings screen. If the Include Common Inventory checkbox is selected, the supply and demand for projects that have been specified as common inventory will also be included, even though they may not otherwise meet the project selection criteria.
Single Project - Select this option to include all supply and demand for the inventory project specified (in the Project field). If you selected the Include Common Inventory checkbox, the supply and demand for projects that have been specified as common inventory will also be included.
Top-Level Project - Select this option to include all supply and demand for inventory projects that share the same top-level project as the project specified (in the Project field). If you selected the Include Common Inventory checkbox, the supply and demand for projects that have been specified as common inventory will also be included, even though they may not have the same top-level project.
Select this checkbox to include common inventory supply/demand in the results.
Enter, or use Lookup to select, the warehouse for which you would like to view supply/demand information. This field is available only if you selected the Plan Warehouse Separately checkbox in the MRP Corporate Settings subtask of the MRP Settings screen.
Enter, or use Lookup to select, the inventory project for which you would like to view supply/demand information.
Enter, or use Lookup to select, the inventory netting group for which you would like to view supply/demand information.
Enter the last date for which you would like to view supply/demand information.
This field displays the inventory unit of measure for the part/revision.
This field displays the total quantities in on hand locations for the selected part within the specified project(s) and warehouse.
This field displays the total quantities in shipping, inspection, and reinspection locations for the selected part within the specified project(s) and warehouse. If you selected the Incl MRB as Available Inventory checkbox in the Production Control Settings Screen in Costpoint Production Control, such location types are also included.
This field displays the end date of the period. Weekly time buckets are used and supply/ demand information within that week will be combined and displayed as a sum. The first end-of-period row shows all supply/demand that is past due as of the current date. The second row's period end date depends on which day is selected as the Ending Day of Production Week in the MRP Report Print Options screen. End dates for subsequent rows will be in weekly increments. Depending on the values set in the Summary Report/Inquiry Weekly field in the MRP Report Print Options screen, the time buckets displayed will change from weekly to monthly, and will continue until the value set in Summary Report/Inquiry Monthly is reached, or until the Date Cutoff is reached. Any additional supply/demand beyond this limit is summarized into a single future bucket.
This field displays the sum of all the demand quantities (in inventory unit of measure) within the period for the row.
This field displays the sum of all the supplies (in inventory unit of measure) within the period for the row.
This field displays the supply quantity adjusted for the part's yield factor (Supply Yield Quantity equals Supply Quantity times Yield %). This field is displayed if you have selected the Incl Scrap/Yield % in Planning Process checkbox in the Production Control Settings screen in Costpoint Production Control.
This field displays the total available quantity after accounting for additional supply and demand. For the first row in the table, Projected Avail Qty equals On Hand Qty plus Other Inv Qty plus Supply Quantity - Demand Quantity (first row). In subsequent rows, Projected Avail Qty equals Projected Avail Qty (previous row) plus Supply Quantity - Demand Quantity (current row). Note that Supply Yield Quantity is used in the calculations instead of Supply Quantity if you selected the Incl Scrap/Yield % in Planning Process checkbox in the Production Control Settings screen in Costpoint Production Control.
This field displays the sum of all the planned orders within the date range of the period for the row.
This field displays the sum of all the demands created as a result of planned orders, and which are within the date range of the period for the row.
Use this pushbutton to open the Part Detail subtask, where you can view part/project information.
Use this pushbutton to open the Selected Projects subtask, where you can view project and inventory abbreviation information based on project selection criteria.
Use this pushbutton to open the Warehouse Inventory Detail subtask, where you can view current inventory information by warehouse for the selected part.
Select this pushbutton to open the Inventory Detail Across Warehouses subtask, where you can view current inventory information for the selected part across all warehouses.
Use this pushbutton to open the Supply Information subtask, where you can view details about the supplies that make up the supply quantity.
Use this pushbutton to open the Demand Information subtask, where you can view details about the demands that make up the demand quantity.
Select this pushbutton to open the Substitute Part Inventory subtask for current inventory information for substitute parts.
Use this pushbutton to open the ECN Parts subtask for information on Engineering Change Notices for the part.