Supply/Demand Details Grid
Use the Supply/Demand Details grid in the Supply/Demand Details group to review a consolidated list of supply and demand messages for the item and branch/plant defined in the Planning Selection group. The system uses data from the latest MRP run as the starting point.
The system first displays the inventory in the Supply/Demand Details grid, and then supply or demand, based on the setting in the Supply/Demand Sequence processing option on the Display tab of the Planning Console program. The system first displays the inventory in the grid regardless of the Supply/Demand Sequence processing option setting.
The system sorts the Supply/Demand Details grid by supply and demand within the From and Thru Dates.
You use the From Date and Thru Date fields to filter the rows in the Supply/Demand Details grid. The date filtering does not apply to the charts in the Supply/Demand Charts group.
You select the Show Shipped check box to view shipped quantities in the Supply/Demand Details grid. If you do not select this check box, the system hides the shipped quantities.
The Supply/Demand Details grid displays quantities in the UOM that you enter in the Unit of Measure field in the Planning Selection group. The system displays the negative symbol (-) for demand quantities.
The Planning Console program retrieves all the orders before the Start Date for past due supply and demand. The system displays individual past due supply and past due demand rows in the Supply/Demand Details grid.
The system includes purchase orders, work orders, rate schedules, and co/by products.
The system displays all orders with an ETO project number. The system does not consider ETO orders in the ATP and CATP charts. The system disables grid lines that contain project-specific items based on the stocking type and project number in the Planning Console program (P34X200).
The system converts the UOM to the primary UOM for past due amounts.
The Supply/Demand Details grid includes the following supply:
Inventory on-hand
Lots effective and effective on hold
Lot expired and expired on hold
Purchase orders
Purchase order receipt routings
Work orders
Work order receipt routings
Rate schedules
The system displays all rates that start before the end date in the End Date field in the Planning Selection group. The system uses the quantities in the F31091 table for the distributions for rates that have not started. If the rate start date is in the past or if there is quantity completed on the rate, then the open quantity on the rate is evenly distributed across the remaining work days of the rate. If there is no information in the Schedule Quantity Detail table (F31091), then the system distributes the open quantity based on the month, week, and day schedule. The Adjusted Date field is disabled for rate orders.
For example, if you have a weekly rate for 100, the system displays the rate in the grid, and the quantity is editable. The system also displays five additional rows of rate distribution records, one for each work day of the week, with a quantity of 20 each. You cannot directly edit the rate distribution records but if you change the rate line from 100 to 150, the system updates each of the rate distribution records from 20 to 30 to make up the 150 for that week.
Planned orders (from F3411 messages).
The Supply/Demand Details grid includes the following demand:
Sales orders
Interplant demand
Configured components
Forecasts
Note: If you do not enter forecast document types in the processing options of the Planning Console program, then the system does not include forecasts in the Supply/Demand Details grid.Work order project demand
Parts list
Work order dependent demand (pegging)
If the value of the Interplant Demand processing option is 1, the system considers firm and planned transfer orders as customer demand. If you use forecast consumption, the system uses interplant demand to consume forecast when the Interplant Demand processing option is set to 1.
The system disables inventory, rate distribution, and demand records in the Supply and Demand grid.
The system defines the unadjusted date, adjusted date, unadjusted quantity, and adjusted quantity from the supply and demand orders as follows:
Unadjusted Date (34XSDDJ) |
Adjusted Date (34XSDDJU) |
Unadjusted Quantity (34XSDQ) |
Adjusted Quantity (34XSDQU) |
|
---|---|---|---|---|
Purchase Orders |
Lot Effective Date (DLEJ) from the F4311 table |
Same as Unadjusted Date (34XSDDJ) OR If there is a message to expedite or defer an order, then the date is the Recommended Complete Date (RRQJ) from the F3411 table. |
Units - Open (UOPN) from the F4311 table |
Same as Unadjusted Quantity (34XSDQ) OR If there is a message to increase or decrease order quantity, then the quantity is the Required Quantity (TRQT) from the F3411 table. |
Work Orders |
If the Planned Effective Date (DPL) from the F4801 table is Blank, then the date is the Requested Date (DRQJ) from the F4801 table; otherwise the date is the Planned Effective Date (DPL) from the F4801 table. |
Same as Unadjusted Date (34XSDDJ) OR If there is a message to expedite or defer an order; then that date is the Recommended Complete Date (RRQJ) from the F3411 table. |
[(Units - Order)/(Transaction Quantity (UORG)] - (Quantity Completed (SOQS)) - [(Units - Quantity Canceled)/(Scrapped (SOCN))] from the F4801 table. |
Same as Unadjusted Quantity (34XSDQ) OR If there is a message to increase or decrease order quantity, then the quantity is the Required Quantity (TRQT) from the F3411 table. |
Rate Schedules |
Planned Effective Date (DPL) from the F4801 table |
Same as Unadjusted Date (34XSDDJ) OR If there is a message to expedite or defer an order, then the date is the Recommended Complete Date (RRQJ) from the F3411 table. |
[(Units - Order)/(Transaction Quantity (UORG)] - (Quantity Completed (SOQS)) - [(Units - Quantity Canceled)/(Scrapped (SOCN))] from the F4801 table |
Same as Unadjusted Quantity (34XSDQ) OR If there is a message to increase or decrease order quantity, then the quantity is Required Quantity (TRQT) from the F3411table. |
Planned Orders |
Not Applicable |
Requested Date (DRQJ) from the F3411 table |
Not Applicable |
Required Quantity (TRQT) from the F3411 table |
Forecast Consumption Shipped |
Forecast consumption at the beginning of the period based on End Date (ENDD) from the F3405 table |
Same as Unadjusted Date (34XSDDJ) |
Shipped Quantity (UORG) from the F3462 table |
Same as Unadjusted Quantity (34XSDQ) |
Sales Orders |
Scheduled Pick Date (PDDJ) from the F4211 table |
Same as Unadjusted Date (34XSDDJ) |
[(Units - Order)/(Transaction Quantity (UORG))] - (Units - Shipped to Date (QTYT)) - [(Units - Quantity Canceled)/(Scrapped (SOCN))] from the F4211 table |
Same as Unadjusted Quantity (34XSDQ) |
Forecast |
Requested Date (DRQJ) from the F3460 table |
Same as Unadjusted Date (34XSDDJ) |
Forecast Quantity (FQT) from the F3460 table |
Same as Unadjusted Quantity (34XSDQ) |
Forecast Consumption Period |
Forecast Consumption End Date (ENDD) from the F3405 table |
Same as Unadjusted Date (34XSDDJ) |
Not Applicable |
Not Applicable |
Parts List |
Date Requested (DRQJ) from the F3111 table |
Same as Unadjusted Date (34XSDDJ) |
If the Committed (H/S) (COMM) from the F3111 table is equal to N or Blank, then[(Units - Order)/(Transaction Quantity (UORG))] - (Quantity Available (TRQT) (or 0 if negative)); otherwise, [(Units - Order)/(Transaction Quantity (UORG))] - (Units - Quantity Committed (QNTA) (or 0 if negative)) |
Same as Unadjusted Quantity (34XSDQ) |
Pegging Orders |
Date Requested (DRQJ) from the F3412 table |
Same as Unadjusted Date (34XSDDJ) |
Quantity (UORG) from the F3412 table |
Same as Unadjusted Quantity (34XSDQ) |
The Unadjusted Quantity and Unadjusted Date fields represent the original quantity and date from sales, purchase, and work orders.
You use the Adjusted Date, Adjusted Quantity, Adjusted Start Date, Adjusted Effective Date, Override Supplier Number, and Override Production Number fields to make changes to supply records in the Supply/Demand Details grid.
The Adjusted Quantity and Adjusted Date fields display the recommended quantity and date from MRP messages. You can also change the quantity and date of messages in the Supply/Demand Details grid using the Adjusted Quantity and Adjusted Date fields. The system generates a new message for any change to supply.
The system applies bold font to values in the Adjusted Quantity and Adjusted Date fields to indicate a change to the value from the original value in the Unadjusted Quantity and Unadjusted Date fields. The change in value is the result of either applying MRP messages or manually changing values in the Supply/Demand Details grid.
The system highlights the Adjusted Date, Unadjusted Date, Adjusted Quantity, and Unadjusted Quantity columns in teal color, based on the setting of the Adjusted/Unadjusted option on the Supply and Demand chart.
If the adjusted date violates the lead time level defined for the item, the system displays the Adjusted Date field value in bold red colored font. If you change the quantity for an order that is already within the lead time date, the system highlights the Adjusted Date field in red colored font.
The Adjusted Available and Unadjusted Available fields display a value that represents a running total of availability after the quantity for the current line is applied. The value in the Adjusted Available field also incorporates MRP messages which can adjust the date or quantity of supply orders. The system displays availability in the primary UOM.
The system bases the Unadjusted Available on the Primary Unadjusted Quantity, and changes the value only when you click the Implement button.
The system bases the Adjusted Available on the Primary Adjusted Quantity, and changes the value whenever you change the Adjusted Date or Adjusted Quantity. When you change the Adjusted Date or Adjusted Quantity, the system clears the Adjusted Available column for all rows and the column remains cleared until you click the Find button or the plan is saved, restored, or implemented.
Rows that do not affect availability have a blank availability column. Sales orders and forecasts that the system excludes based on the planning fence rules have a blank availability.
Rate orders have blank availability but the system populates the distribution records. The system adds the past due supply in the Available columns for the inventory row if past due supply is included in the on-hand inventory.
The system populates the Available columns for the past due orders with the appropriate adjustment made to the available quantities.
If the system excludes a record from the Supply and Demand chart and the Ending Available chart, then the system highlights the corresponding grid rows in the Supply/Demand Details grid in gray colored font. The system highlights grid rows in black colored font to indicate that the corresponding records are included in the Supply and Demand and Ending Available charts.
If you use forecast consumption by customer, demand is driven by customer demand and unconsumed forecast for each customer. The system displays all customer demand records and includes them in the charts. Unconsumed forecast is aggregated by date and is displayed using the new forecast type that you specify in the P34X200 processing option, Forecast Type for Demand by Customer. The system hides all forecast records with the forecast type that you specify in the P34X200 processing option Forecast Types (up to 5 types).
This table describes how the 34XDSPF and 34XEXCF flags are set for customer demand and forecast, if you use the forecast consumption by customer functionality:
Customer Demand/Forecast |
Display in Supply/Demand Grid (34XDSPF) |
Include/Exclude from Charts (34XEXCF) |
---|---|---|
Current Customer Demand |
0 (Display) |
0 (Include) |
Current Forecast With Input Forecast Type |
1 (Do not display) |
1 (Exclude) The system excludes this only if all forecast has been consumed. |
Past Due Customer Demand |
0 (Display) |
0 (Include) |
Past Due Forecast |
1 (Do not display) if you do not use forecast consumption. Otherwise, consumed forecast = 1 (Do not display) and unconsumed forecast = 0 (Display) |
1 (Exclude) The system excludes this only if all past due forecast has been consumed. |
Summarized Past Due Forecast |
1 (Do not display) |
1 (Exclude) |
You can freeze or unfreeze a single order using the Freeze Order or Unfreeze Order option on the Row menu. The system displays the Freeze Order and Unfreeze Order options only for purchase orders and work orders. To freeze an order, select the order in the Supply/Demand Details grid and then select the Freeze Order option on the Row menu. To unfreeze an order that is frozen, select the order in the Supply/Demand Details grid and then select the Unfreeze Order option on the Row menu. After you select the Freeze Order or Unfreeze Order option, the system updates the Freeze Code (UNCD) column in the Purchase Order Detail File (F4311) or Work Order Master File (F4801), and immediately refreshes the value of the Freeze Code field in the Supply/Demand Details grid. The system displays Y in the Freeze Code field in the Supply/Demand Details grid to indicate that an order is frozen, and N to indicate that an order is not frozen.
You select the Restore Plan button in the Supply/Demand Details group or the Restore Plan option on the Form menu to cancel unsaved changes and restore the Supply/Demand Details grid to the original supply and demand data and MRP messages. Alternatively, you can navigate back to the Planning Summary form.
You select the Refresh option on the Form menu to delete all changes and reload the F34X200W table with the latest supply and demand data and MRP messages.
The system cancels an order when you change the quantity in the Adjusted Quantity field to zero (0). You review current order information by selecting the orange square in the upper left corner of the Order Number field in the Supply/Demand Details grid.
If you change the quantity to 0 for a supply record with a document number, then the system adds a new Cancel message for the order to the F3411 table.
If you change the quantity to 0 for a supply record without a document number (O, B, and N type messages), then the system deletes the message from the F3411 table.
If the system cancels an order from a message or you cancel an order by entering zero in the Adjusted Quantity field, the system designates the canceled order by using strike-through text on the grid line in the Supply/Demand Details grid. You can change the value in the Adjusted Quantity field, and the system sets the grid row to regular text for an order.
The Inventory, Work Orders, Purchase Orders, Sales Orders, and Forecast grid options are available in the Supply/Demand Details grid to provide different views of the data.