Menu Path: Purchasing Distribution Resource Planning Product DRP Management
Note You can also access this window by drilling down in Summary DRP Management.
Manage the Distribution Resource Planning schedule for products.
Use Product DRP Management to project and anticipate future shortages and recommend action in the form of suggested order quantities in a time-phased manner. For information on how to implement it for your specific company, see Distribution Resource Planning Overview.
Note Use the DRP Schedule Management tab to help you plan requirements and the Requirements tab to execute those requirements.
Button |
Description |
Exit |
Click this button to close the Product DRP Management window. |
Show Data |
Click this button to display DRP information for the selected product on all tabs. Note The system forecast is recalculated every time this button is clicked. |
As Is |
If the Manage Product Forecasts tab is displayed, click this button to re-populate Actual Forecast or Forecast to Use data in the Product Forecasts grid. For more information on forecast data, see Using Forecasts in DRP FAQ. Select a specific forecast group before you click this button to re-populate Actual Forecast from a Customer Forecast or System Forecast. Select the All (Forecast Groups) check box before you click this button to re-populate Forecast to Use from Actual Forecast Total. The Actual Forecast changes based on the selected AS IS Option radio button. If the DRP Schedule Management tab is displayed, click this button to recalculate the schedule and restore Actual Planned Receipt data with Suggested Planned Receipt data. Note If you have manually overridden the Actual Planned Receipt data, this will cancel those override quantities. |
Product History |
Click this button to display Product History Inquiry, which allows you to view product history information by location for the selected product. |
Product Sales |
Click this button to display Product Sales Inquiry, which allows you to view sales information for the selected product. |
Inventory Matrix |
Click this button to display Inventory Matrix Inquiry, which allows you to view inventory information for the selected product. |
Blanket Release |
Click this button to display Blanket Purchase Order Inquiry, which allows you to view blanket purchase orders for the selected product. |
Sales Contract Inquiry |
Click this button to display Sales Contract Inquiry, which allows you to view sales contract information for the selected product. |
Buying Method |
Click this button to display Buying Method Maintenance, which allows you to view the buying method for the selected product/location. Note If no location is selected, then the buying method for the product is displayed. |
Product Notes |
Click this button to display Notes Entry, which allows you to view notes for a selected product. |
Notes |
Click this button to display Notes Entry, which allows you to view and enter notes for a selected DRP value. This button is only available if the Manage Product Forecasts tab is displayed. |
Product Override Maintenance |
Click this button to display Product Override Maintenance, which allows you to replace one product with another product. This button is only enabled if you select a product with an override that was previously set up. |
New |
Click this button to add an order to the Requirements grid. This button is only available if the Requirements tab is displayed. |
Update |
Click this button to edit a selected order in the Requirements grid. This button is only available if the Requirements tab is displayed. |
Delete |
Click this button to delete a selected order in the Requirements grid. This button is only available if the Requirements tab is displayed. |
OK |
Click this button to accept an order entered on the Requirements tab. This button is only available if the Requirements tab is displayed. |
Cancel |
Click this button to cancel an order entered on the Requirements tab. This button is only available if the Requirements tab is displayed. |
Field or Button |
Description |
Enter a product code for which to display product DRP information, or click the Lookup button to select a product code. |
|
Enter a product name for which to display product DRP information, or click the Lookup button to select a product name. |
|
This field displays the lead time for the selected product. |
|
All (DRP Regions) |
Select this check box to display product DRP information for all DRP regions. This check box is selected by default, and is only enabled if you select the Consolidate PO check box. |
Enter a DRP region ID for which to display product DRP information, or click the Lookup button to select a DRP region ID. This field is only enabled if you clear the All check box. |
|
Enter a DRP region name for which to display product DRP information, or click the Lookup button to select a DRP region name. This field is only enabled if you clear the All check box. |
|
Select this check box to display product DRP information for consolidated purchase orders. If you select this check box, you can specify a specific DRP region for which to display product DRP information. |
|
Select this check box to display actual and forecasted direct/drop ship sales by forecast group. This check box is only available if Yes is entered for the Forecast Direct Ship parameter used in the selected product's forecast method. |
|
Select this check box to display product DRP information totalled for all shipping locations. This check box is only enabled if you clear the Consolidated PO check box. |
|
Enter a shipping location prefix for which to display product DRP information, or click the Lookup button to select a shipping location prefix. This field is only enabled if you clear the All check box. |
|
Enter a shipping location name for which to display product DRP information, or click the Lookup button to select a shipping location name. This field is only enabled if you clear the All check box. |
|
Select this check box if you are selecting a specific location, and you want to view all of the satellite locations of that location. In a multi-level satellite location model, you may want to view the rolled up inventory position. If you select this check box, the satellite locations appear to the right of the check box, and cannot be edited. This check box is only enabled if the All (Shipping Location) check box is cleared. Note Satellite locations are set up in Product Location Maintenance by selecting a primary replenishment path of Location, and then selecting a primary replenishment location. |
|
This grid displays satellite locations for a selected location. This grid is only available if you select the All Satellite Locations check box. |
|
Select whether to display product DRP information for a period of months, weeks, or days. This defaults from the Forecast Time Bucket parameter for the buying method. |
|
Enter a unit of measure for displayed product quantities, or click the Lookup button to select a unit of measure. You must enter or select a unit of measure that is defined for the selected product. This field defaults to the default purchasing unit of measure for the selected product. |
|
This check box is selected if the selected Non Stocked Item check box is selected for the product/location in Product Location Maintenance. |
|
Select this check box to display product DRP information for all forecast groups. |
|
Enter a forecast group for which to display product DRP information, or click the Lookup button to select a forecast group. This field is only enabled if you clear the All check box. |
|
Select this check box to display product DRP information for forecast groups that have no forecast quantity. |
|
This field displays the total unreleased quantity for the selected product. |
|
Enter the number of future and past time bucket periods. Enter the first number with a negative sign to indicate a period before the current period. These fields default from the Time Horizon Forward and Time Horizon Past parameters for the buying method. The unit of the time bucket periods is based on whether you selected the Monthly, Weekly, or Daily radio button. Example If Monthly is selected for the Forecast Time Bucket, today’s date is in the month of August, and you enter -2 and 2, data is displayed for June, July, August, September, and October. |
Field or Button |
Description |
These fields display the method used to color code significant differences between the actual net sales and the actual forecast values, as follows:
|
|
Select one of the following options for how the Actual Forecast data is calculated after you click the As Is button in the ribbon:
|
|
Select this check box to manually update the POS Sell Through and Adjusted Net Sales values in the Product Forecasts grid for specific forecast groups. This check box is only enabled if the All check box to the left of the Shipping Location field is cleared, and if the selected product is not marked as a non-stocked product in Product Maintenance. |
|
Select this check box to manually update Customer Forecast and Promotional Forecast values in the Product Forecasts grid for specific forecast groups. This check box is only enabled if the All check box to the left of the Shipping Location field is cleared, and if the selected product is not marked as a non-stocked product in Product Maintenance. |
|
Select this check box to manually update Actual Forecast values in the Product Forecasts grid for specific forecast groups, or manually update Forecast to Use values in the Product Forecasts grid. This check box is only enabled if the All check box to the left of the Shipping Location field is cleared, and if the selected product is not marked as a non-stocked product in Product Maintenance. |
|
This grid is divided into two sections. The upper section displays specific forecast groups and the lower one displays the total of all forecast groups. The grid includes the following columns:
Note If you select the Weekly radio button, the first day of each week is based on the value entered for the First Weekday field in System ID Maintenance. The week column headers are also preceded by the week number if the Include Week Numbers in Column Label check box is selected in Purchasing Control Maintenance. Each row in the Forecast column displays the types of forecast data displayed in the Forecast Time Buckets columns, as follows:
Note Typically this is supplied by mass merchants through an EDI product activity file. You can import this data in Forecast Sales History Import or EDI Product Activity Import. You can also manually enter it in Forecast Sales History Maintenance. Double-click this row to display Point of Sale Inquiry, which allows you to review point-of-sale and other product activity data for mass merchant stores.
Note This can also be edited using Forecast Sales History Maintenance.
Note This is informational only, and is already included in the Adjusted Net Sales values.
Note Forecast to Use must be entered to calculate the requirement values on the DRP Schedule Management tab. A quick way to do this is to highlight the All Forecast Group row, then click the As Is button in the ribbon. You cannot edit the Forecast to Use row if Forecast Group is selected for the Remainder Forecast parameter in Forecast Method Maintenance. For more information on how forecast fields are used, see Using Forecasts in DRP FAQ. Note You cannot graph data in this grid. |
Field or Button |
Description |
This field displays the minimum purchase quantity and unit of measure. For more information about how this value is calculated and used, see DRP - Suggested Planned Receipt FAQ. |
|
This field displays the multiple purchase quantity and unit of measure. For more information about how this value is calculated and used, see DRP - Suggested Planned Receipt FAQ. |
|
This grid displays DRP schedule information for the selected product. The grid contains the following rows:
Note For purchase orders, the scheduled delivery date is used to determine the time bucket. For work orders, the expected date is used to determine the time bucket.
Double-click the Shipments in Transit, Purchase Orders and Work Orders, or Transfers From Other Locations row to display Scheduled Delivery Dates, which allows you to view delivery date information for the selected product. Double-click the PO Blanket Releases row to display Blanket Purchase Order Inquiry, which allows you to view detailed information for blanket purchase orders. Double-click the Inventory Reservations row to display Product Inventory Reservation Maintenance, which allows you to view inventory reservations for the product. Double-click the Special Sales Orders row to display Product / Style Order Inquiry, which allows you to view all open special sales orders. Double-click the Pending Special Purchase Orders row to display Product / Style Order Inquiry, which allows you to view all open special sales orders for which purchase orders are not yet created. Double-click the Special Purchase Orders row to display Special Purchase Orders, which allows you to view all open special purchase orders. For more information, see DRP - Lead Time Calculation FAQ. Note You cannot graph data in this grid. |
Field or Button |
Description |
This grid displays order requirements for the product. The grid contains the following rows:
Note If you select the Weekly radio button, the first day of each week is based on the value entered for the First Weekday field in System ID Maintenance. The week column headers are also preceded by the week number if the Include Week Numbers in Column Label check box is selected in Purchasing Control Maintenance. Note You cannot graph data in this grid. |
|
Click the Lookup button to select an order type. |
|
Enter the supplier code, or click the Lookup button to select the supplier code. This field is only available if you select Purchase Order for the Order Type field. |
|
Enter the supplier name, or click the Lookup button to select the supplier name. This field is only available if you select Purchase Order for the Order Type field. |
|
Location |
Enter the location prefix, or click the Lookup button to select the location prefix. This field is only available if you select Transfer Order for the Order Type field. |
Name (Location) |
Enter the location name, or click the Lookup button to select the location name. This field is only available if you select Transfer Order for the Order Type field. |
Enter the quantity for the order. |
|
Enter the date for the order, or click the Lookup button to select a date. |
|
This grid displays details for the order. Note You can also use the grid to update quantities for specific order types. |
|
Click this button to add an order line in the Details grid. |
|
Click this button to delete an order line in the Details grid. |