Understanding Detail Forecast Revisions for Production Controlled Items
After you generate and review a forecast, you can revise the forecast to account for changes in consumer trends, market conditions, competitor activities, marketing strategies, and so on. When you revise a forecast, you can change information in an existing forecast manually, add or delete a forecast, and enter descriptive text for the forecast.
You use the Forecast Revisions program (P3460) to create, change, or delete a detail forecast manually.
Manufactured items may have long lead times and, therefore, begin the production process before a customer order exists. You create a forecast with a generic production number to represent demand for an item.
When you receive orders for production controlled items, you can allocate inventory to the order. If no inventory is available, then you can peg an existing forecast to the order. You create a new sales order with a new production number if no forecast exists for the production controlled item.
A work order may exist on the shop floor based on the forecast of a generic production number. When a customer order is taken, the inventory and production plan is allocated to the order based on the statuses of the work orders. The consumption of generic forecasts enables accurate available to promise (ATP) planning and timely product delivery.
You use the Forecast Revisions program to work with forecasts for production controlled items.
The Production Number field and Query by Example (QBE) line appear in the detail grid of the Work With Forecasts form. The Production Number field also appears on the Detail Forecast Revisions form.
On the Work With Forecasts form, you can search for a forecast by item, branch/plant, or production number.
The Detail Forecast Revisions form enables you to perform the following actions for production controlled items:
Create new forecasts.
Edit single and multiple rows of forecasts.
Copy single and multiple rows of forecasts with and without production numbers.
Delete single and multiple rows of forecasts with and without production numbers.
You use one of the following methods to associate a production number with a production controlled item in a forecast detail line:
Select an existing production number from the Production Number Master File table (F34401) using the Visual Assist button in the Production Number field to access the Production Number Search form (W34401C).
Select the Generate Prod No. option from the Row menu on the Detail Forecast Revisions form to have the system automatically generate a production number.
Tab out of a row for a production controlled item to have the system automatically generate a production number if the Production Number Generation processing option on the Production No. tab of the Forecast Revisions program is set to 1.
The generated production number uses the production number type specified in the Production Number Type processing option on the Production No. tab.
When you automatically generate a production number for a forecast, the system generates a new production number based on next numbers. If branch/plant is defined as a segment in the production number, the system uses the branch/plant from the header or detail line in the production number generation. The system cannot override the branch/plant on the detail line. If month and year are defined as segments in the production number, the system uses the value from the Date Created field in the Production Number Master program (P34401).
The production number resides in a cache file. You can blank out the Production Number field if you do not want the production number and then go back and generate another production number. When you click OK to accept the forecast, the system creates the production number record in the Production Number Master File table.
The system also stores the production number record in the Production Number Master Tag File table (F34401T). However, the record does not include a number in the order number (DOCO) field so the field value is set to 0 (zero).
Although you cannot manually enter a production number in a forecast detail line, you can add an ad hoc production number to the Production Number Master File table using the Production Number Master program (P34401). You can then select the ad hoc production number from the Production Number Master File table for use in a forecast detail line.
When you create a forecast, the system verifies that the production number is not used for a sales order. The system provides an error if the production number exists for a sales order because you can have only one source of demand for a specific production number. After creating a production number, you can edit it in forecasts.
For forecasts containing production controlled items, the system retrieves the Company from the branch/plant specified in the Detail Forecast Revisions form. The system then uses the item number and company to validate the production number. The system does not validate the customer number because no customer is required in the forecast for production controlled items.
The system stores production number information in the Forecast File table (F3460). The Production Number Master File table (F34401) contains data item PNDMDFLG to indicate F for forecasts and S for sales orders.
The JD Edwards EnterpriseOne Forecast Management system contains no intelligence specific to forecasting for production controlled items. The forecast is only labeled with the production number.
The system supports forecasts through electronic data interchange (EDI) using the following programs:
Forecast Transactions Revisions (P3460Z1)
Forecast Inbound Processor (R3460Z1I)
Outbound Extraction - Forecast (R47062)