Replenishing Inventory

This chapter provides an overview of inventory replenishment processing and discusses how to:

Define replenishment options.
Create and modify replenishment requests.
Use the Fixed Picking Replenishment workflow.
Review and print fixed bin restocking requests.
Integrate with a third-party forecast planning application.

Understanding Inventory Replenishment Processing

Replenishment processing enables you to maintain the inventory stocking levels, also known as on-hand quantity balances. Use one of two replenishment methods:

Ad hoc replenishment.

Create replenishment requests in response to specific demands for stock that you cannot fulfill. You can automate ad hoc replenishment by selecting the Create Ad Hoc Requisitions option for all items in a business unit on the Setup Fulfillment page or for a specific item on the Setup Item Fulfillment page or the Define Business Unit Item-Inventory: Replenishment page. When this option is active, the Reserve Materials process (IN_FUL_RSV), Shortage Workbench, and Shipping/Issues component create ad hoc replenishment requests whenever insufficient available on-hand quantity results in the creation of a backorder.
Reorder point replenishment.

Specify stocking levels for each item in a business unit and then generate replenishment requests when the available on-hand quantity is less than or equal to the reorder point specified. You can have the Calculate Replenishment Parameters process (IN_RPL_PRM) calculate reorder points for each business unit-item combination or enter these values manually on the Setup Item Replenishment page. The Create Replenishment Requests process (IN_REPLEN_AE) compares the available on-hand quantity (plus any on-order quantity) with the replenishment point set for each item and generates a replenishment request for any item with quantity equal to or below the reorder point.

PeopleSoft Inventory records both ad hoc and reorder point replenishment requests in the replenishment request table (REPLEN_RQST_INV). If the installation includes PeopleSoft Purchasing, the Requisition Loader process (PO_REQLOAD) moves the requests into the purchasing tables. You can view, cancel, or print these requests from the Manage Replenishment Requests page.

If you use fixed picking locations, you can also take advantage of these options:

Fixed bin replenishment.

Fixed bin replenishment, which works in conjunction with ad hoc or reorder point replenishment, generates an internal request to restock the fixed picking locations from the main warehouse or stockroom, using the optimal quantities defined on the Fixed Picking Locations page. When the on-hand quantities in these storage locations fall below the optimal quantity, the Create Replenishment Requests process (IN_REPLEN_AE) generates a restocking request. You can print a list of restocking requests using the Fixed Bin Replenishment Report page. You can also use the Fixed Bin Replenishment workflow to streamline transfers when you run the Replenishment multiprocess job (REPLN_AE).
Fixed Pick workflow.

If you select the Use Fixed Pick Workflow option on the Setup Item Fulfillment page or the Setup Fulfillment-Order Release page, the Picking Plan report initiates the Fixed Pick workflow whenever there is insufficient quantity available in the sequence of fixed picking locations to fulfill an order. This occurs when there is no quantity available to allocate or, in environments that allow shipment of partial quantities, when the full quantity is not available and there is sufficient quantity outside of the fixed picking locations to fulfill the order. If the quantity does not exist in the business unit, the picking plan prints an error message.

The Fixed Pick workflow creates a worklist entry to notify you that you must transfer stock to the fixed picking locations before picking can continue. When you open the worklist entry, the workflow transfers you to the EZ Transfers page, where you can select storage locations from which to transfer stock. The worklist entry recommends transferring enough stock to fill the highest priority fixed picking location to its optimal quantity; however, it also displays the order line quantity that triggers the workflow and indicates whether any partial quantity has been allocated to the order line, so you have the option to transfer only the minimum quantity required to fulfill the order.

On-Order Quantity

PeopleSoft Inventory uses on-order quantity along with the reorder point to determine whether a replenishment request should be created. On-order quantity includes:

Quantities on open purchase requisitions (depending upon the business unit settings).
Quantities on open purchase orders (POs) (minus any quantity that has already been received and put away).
Quantities on interunit transfers for which the destination business unit is the current inventory business unit and the quantities have not yet been received and put away.
Quantities soft-committed from a work order in PeopleSoft Maintenance Management.

See Also

Promising and Reserving Inventory

Understanding Directed Picking

Defining Replenishment Options

This section discusses how to:

Select business unit replenishment options.
Define item replenishment attributes.
Enter additional stock-in probabilities.

Pages Used to Define Replenishment Options

Page Name	Object Name	Navigation	Usage
Setup Replenishment	REPLEN_SETUP_INV	Inventory, Replenish Inventory, Setup Replenishment	Select replenishment options for a business unit.
Setup Item Replenishment	REPLEN_ATTRIB_INV	Items, Define Items and Attributes, Define Business Unit Item, Inventory: Replenishment Inventory, Replenish Inventory, Setup Item Replenishment	Define and modify replenishment attributes for a business unit-item combination. The Calculate Replenishment Parameters process can calculate some of these attributes, using the item’s demand history. The Create Replenishment Requests process then uses the attributes to determine whether the item needs to be replenished and what the requested quantity should be. See Defining Item Replenishment Attributes.
Stock-In Probabilities	STOCKOUT_PROB_INV	Inventory, Replenish Inventory, Stock-In Probabilities	Enter additional stock-in probabilities (statistical values used in the calculation of safety stock).

Selecting Business Unit Replenishment Options

To set up replenishment options at the business unit, use the Setup Replenishment component.

Access the Setup Replenishment page.

Replenishment Options

Reorder Point Replenishment	Select to generate replenishment requests when stocking levels for items in the business unit are equal to or below the reorder point quantities calculated by the Calculate Replenishment Parameters process or entered on the Setup Item Replenishment page.
Fixed Bin Replenishment	Select to generate internal restocking requests for fixed picking storage locations with quantities below the optimal levels defined on the Fixed Picking Locations page.

Reorder Point Order Quantities

Indicate how the Create Replenishment Requests process should determine the order quantity for reorder point replenishment requests. The order quantity is the quantity that is requested when the calculated available quantity is equal to or below the item’s designated reorder point.

EOQ (economic order quantity)	Select to create replenishment requests using the economic order quantity defined on the Setup Item Replenishment page.
Min/Max (minimum/maximum)	Select to calculate the order quantity required to meet the maximum stocking level on the Setup Item Replenishment page. The reorder quantity calculation for the Min/Maxfield is: (Maximum Quantity − (Quantity Available + On-order Quantity)).
Static Reorder Qty (static reorder quantity)	Select to create replenishment requests using the reorder quantity defined on the Setup Item Replenishment page.
Demand Quantity	Select to order the demand quantity, which will order the required quantity up to the reorder point. For example, if available quantity is 0, reorder point is 10, and soft commit quantity is 25. If Demand Quantity is selected as the reorder point order quantity, the system will order a quantity of 35, which brings the quantity back to the reorder point. Note. To use the demand quantity method, you must select the Include Demand check box on the Setup Item Replenishment page.
Include Requisition Quantities	Select to include the quantity that appears on open PeopleSoft Purchasing requisitions in on-order quantity calculations.
Include WIP Quantity (include work-in-process quantity)	Select to add the quantity in WIP storage locations to the quantity available when determining whether an item has reached its reorder point.

Reorder Point Range Checking

Reorder Point Range Checking

Enables you to minimize ordering costs and increase the order size from a single vendor. When an item requires replenishment, the Create Replenishment Requests process evaluates the stock levels of other items supplied by the same primary vendor. It then creates a replenishment request for each item with current available and on-order balances within the defined Range Checking Percentage.

You must establish item-vendor relationships in the appropriate PeopleSoft Purchasing tables before you can use this option.

Range Checking Percentage

Multiplier used to set the reorder point tolerance value. For example, a value of 20 percent sets the tolerance value, so that the reorder point is multiplied by a factor of 1.20.

EOQ Parameters

Avg Order Prep Cost (Base Cur) (average order preparation cost in the base currency)	The inventory business unit's overhead cost per order, in the business unit's base currency.
Carry Rate	The interest rate used to calculate inventory storage costs.

General Parameters

Desired Stock-In Probability	The percentage of the time that you want to have stock on hand for an item. The system uses this percentage when calculating safety stock for the Calculate Replenishment Parameters process.
Replenish Calc Period (Days) (replenishment calculation period in days)	The number of days to use in calculating the item's average replenishment lead time. This value becomes the default on the Setup Item Replenishment page and can also be selected on the Stock-In Probabilities page to calculate the Z value for the additional stock-in probabilities calculation.

Replenishment Request Cancel Method

Indicate whether the system should delete manually canceled replenishment requests or retain them with a status of Cancel. If PeopleSoft Purchasing is not installed, the system deletes the requests.

See Also

Defining Purchasing Item Attributes

Defining Item Replenishment Attributes

Access the Setup Item Replenishment page.

See Defining Item Replenishment Attributes.

Entering Additional Stock-In Probabilities

To define stock in probabilities, use the Stock In Probability component.

Access the Stock-In Probabilities page.

Use these values in the Desired Stock-In Probability fields on the Setup Item Replenishment page and the Setup Replenishment page.

Desired Stock-In Probability	The percentage of the time that you want to have stock on hand for an item.
Z Value	A statistical value derived from the standard normal distribution curve that reflects the standard deviation from the mean. Use a standard normal distribution chart for the Z values to calculate additional stock-in probability values.

Creating and Modifying Replenishment Requests

The Calculate Replenishment Parameters process (IN_RPL_PRM) computes item replenishment parameters such as reorder point, safety stock, and economic order quantity (EOQ). Each of these calculations is based on an item's average daily demand. All replenishment parameter calculations use the historical item demand for the calculation period. The results of the Calculate Replenishment Parameters process appear on the Setup Item Replenishment page. Fractional results will be rounded if the item's precision indicates whole numbers.

You can run either the IN Replenishment Options process (IN_REPLEN_AE) or the IN Replenishment multiprocess job (REPLN_AE) from the Create Replenishment Requests page.

The IN Replenishment Options process compares the available on-hand quantity, plus any on-order quantity, with the replenishment point set for each item and generates a replenishment request for any item with quantity equal to or below the reorder point.
The IN Replenishment multiprocess job (which includes the IN Replenishment Options process and the Fixed Bin Replenishment Notify process (IN_WFFBREPL)) works in conjunction with the Fixed Bin Replenishment workflow to transfer stock to fixed picking locations in which the item has fallen below the optimal quantity.

Note. Whether calculated by the Calculate Replenishment Parameters process or entered manually, replenishment parameters must be defined on the Setup Item Replenishment page before using the Create Replenishment Requests page to generate replenishment requests. Items that you want included must have a replenishment class assigned, and the Not Included In Replenishment option must be clear.

This section discusses how to:

Define replenishment parameters.
Specify parameters for the Create Replenishment Requests process.
Modify replenishment requests.
Search for replenishment requests.
Sort returned replenishment requests.

Pages Used to Create and Modify Replenishment Requests

Page Name	Object Name	Navigation	Usage
Calc Replenishment Parameters	REPLEN_PRM_REQ_INV	Inventory, Replenish Inventory, Calc Replenishment Parameters	Define options for the Calculate Replenishment Parameters process.
Create Replenishment Reqs (AE)	REPL_OPT_REQ_INV	Inventory, Replenish Inventory, Create Replenishment Requests	Generate replenishment requests by specifying business unit and replenishment class and then running the Create Replenishment Requests process.
Manage Replenishment Requests	REPLEN_REQUIST_INV	Inventory, Replenish Inventory, Manage Replenishment Requests Inventory, Replenish Inventory, Review Replenishment Requests	Modify replenishment requests created by reorder point and ad hoc replenishment methods.
Replenishment Requests Selection	REPL_RQST_SRCH_INV	Click the Search button on the Manage Replenishment Requests page or the Review Replenishment Requests inquiry page.	Search for the replenishment requests that you want to review and modify.
Sort	REPL_RQST_SORT_INV	Click the Sort Display link on the Manage Replenishment Requests page or the Review Replenishment Requests inquiry page.	Sort returned replenishment requests.

Defining Replenishment Parameters

Access the Calculate Replenishment Parameters page.

Replenish Class

Enter a value to calculate the replenishment parameters for items belonging to a specific class. If this field is blank, the replenish lead time will be calculated for all items where the replenish class is not blank. For all other calculations, a blank replenish class on the run control page means to calculate for all items.

Include Cancelled Orders

Select to include canceled orders in the demand history calculations.

Safety Stock

Select to calculate safety stock levels.

Safety stock is equal to the Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) multiplied by the Replenishment Lead Time for the item (REPLENISH_LEAD). The safety stock calculation uses the window of time between today's date and today's date minus the replenishment calculation period.

After you run the Calculate Replenishment Parameters process, the system determines the Average Demand (AVG_DEM_QTY) by taking the sum of the Actual Demand (SUM_DEM_QTY) and dividing it by the Replenishment Calculation Period (REPL_CALC_PERIOD) for the item. Next, the system loops through each day of the calculation period, sums the Actual Demand (DEM_QTY) for the day, and subtracts the Average Demand (AVG_DEM_QTY) to result in the mean absolute deviation as an absolute value (MAD_DELTA_QTY). The Actual Demand (DEM_QTY) is the Sum of Quantity Base for all orders for an item on a specific schedule date. Then the system adds all of the deviations: the sum of the average absolute deviation (MAD_SUM_QTY) is equal to the sum of the mean absolute deviations (MAD_DELTA_QTY). Finally, the formula for safety stock is applied as follows:

The average absolute deviation (MAD_QTY) is determined by the sum of the average absolute deviations (MAD_SUM_QTY) divided by the Replenishment Calculation Period (REPL_CALC_PERIOD).

The Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) is determined by multiplying the average absolute deviation (MAD_QTY) by the stock-in probability (Z_VALUE) specified by the customer.

Safety Stock is equal to the Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) multiplied by the Replenishment Lead Time for the Item (REPLENISH_LEAD).

From the window of BETWEEN TODAY & TODAY − (REPL_CALC_PERIOD)

AVG_DEM_QTY = SUM_DEM_QTY / REPL_CALC_PERIOD

This portion loops for every day in the window regardless of DEM_QTY = 0

MAD_DELTA_QTY = |DEM_QTY − AVG_DEM_QTY|

MAD_SUM_QTY = MAD_SUM_QTY + MAD_DELTA_QTY

MAD_QTY = MAD_SUM_QTY / REPL_CALC_PERIOD

MAD_SFTY_STK = Z_VALUE * MAD_QTY

SAFETY_STOCK = MAD_SFTY_STK * REPLENISH_LEAD

Reorder Point

Select to calculate reorder points for the business unit. The Calculate Replenishment Parameters process calculates reorder points as follows: ((sum of the demand during calculation period * lead time) / calculation period) + safety stock.

Replenish Lead

Select to calculate the business unit’s replenishment lead time. The Calculate Replenishment Parameters process calculates replenishment lead time for all items except those that have an Under Initialization, Pending Approval, or Denied Approval status. The process averages the difference between an item's PO date and its subsequent put away date. The PO date is required for this calculation. If the transaction date is before the PO date, the transaction will be ignored by the replenish lead calculation.

Annual Demand

Select to calculate the annual demand for the business unit. PeopleSoft Inventory calculates this value as follows: Sum of the demand from (today’s date less 365 days) through today’s date.

Maximum Stock Qty (maximum stock quantity)

Select to calculate the maximum on-hand quantity for the business unit. This calculation is computed as follows: (average daily demand for calculation period * (lead time + calculation period)) + safety stock.

EOQ (economic order quantity)

Select to calculate economic order quantities for the business unit This option will not be available if the EOQ option is not selected on the Setup Replenishment page. The Calculate Replenishment Parameters process calculates EOQ by using the industry standard calculation. In this formula, d equals the last calculated annual demand for an item, c equals order preparation cost of EOQ defined on the Setup Replenishment page, i equals annual inventory carrying cost percentage defined on the Setup Replenishment page, and u equals the item’s standard or average cost, depending on the item’s cost method.

EOQ

Note. EOQ always calculates to zero unless the reorder point quantities option on the Setup Replenishment page is EOQ.

Understanding Order Fulfillment Processing

Specifying Parameters for the Replenishment Options Process

Access the Create Replenishment Requests page.

Replenish Class

Enter a value to replenish items belonging to a specific replenishment class. Leave this field blank to replenish all items in the business unit that are marked for replenishment. Fixed bin replenishment ignores this field.

Dedicated Temp Table Stats

This process stores some of its temporary working data in dedicated temporary tables. This check box is defaulted to make it easier for database administrators to generate accurate table statistics for these types of tables.

Modifying Replenishment Requests

Access the Manage Replenishment Requests page.

Print	Click to generate the Replenishment Register report, which lists all replenishment requests for the selected business unit.
Change Status	To change the status of all reorder point replenishment requests at once, select Canceled or Ready in the Replenish Status (replenishment status) field, then click this button. The PeopleSoft Purchasing Requisition Loader process does not pick up canceled replenishment requests. Note. The copy status feature does not change the status of ad hoc requests.
User ID	Because both reorder point and ad hoc replenishment requests are generated by PeopleSoft Inventory processes, the assigned user ID is SYSTEM.
Source, Src BU, (source business unit) and Order No (order number)	The default values come from the order that generated the ad hoc replenishment request. For reorder point replenishment requests, the location is the inventory business unit's location.
Reorder Qty (reorder quantity) and Required By	You can modify these fields before the system passes the information to PeopleSoft Purchasing. Note. If the business unit requires closure calendar validation and processing for receiving activities as defined on the Closure Calendar page, and you enter a required by date that is a defined closure date, you receive an error message. Click No to accept the closure date, or click Yes to reschedule. If you click Yes, the system returns the first valid future date defined for the function.
Status	Change the status of reorder point replenishment requests. Values are: Ready: The request is ready to be loaded into the PeopleSoft Purchasing system tables by the Requisition Loader process. Important! To avoid duplicate replenishment requests, the Create Replenishment Requests process does not create a replenishment request if a previous replenishment request with a status of Ready already exists for the item, regardless of the reorder quantity. If you do not have PeopleSoft Purchasing installed, cancel these requests manually on the Manage Replenishment Requests page. In Process: The request is currently being processed by the Requisition Loader process. Processed: The request has been moved into the PeopleSoft Purchasing system tables by the Requisition Loader process. Error: The Requisition Loader process found an error in the request that must be corrected before the request can be processed successfully. Canceled: The request was canceled manually and will not be picked up by the Requisition Loader process. Depending on the Request Cancel Method specified on the Setup Replenishment page, the system either deletes the request or leaves it in the system tables with a status of Canceled. If your installation does not include PeopleSoft Purchasing, the Create Replenishment Requests process deletes existing reorder point replenishment requests if the item no longer needs replenishment (regardless of the status). In this case, change the status to Canceled to delete the replenishment request, because the Request Cancel Method value on the Setup Replenishment page is always set to Delete. If PeopleSoft Purchasing is installed, the Requisition Loader process ignores previously processed replenishment requests; therefore, these requests do not need to be deleted. If PeopleSoft Purchasing is installed, the Create Replenishment Requests process might delete existing reorder point replenishment requests. If you change the status to Canceled, the order is either canceled or deleted, depending on the Request Cancel Method setting on the Setup Replenishment page. You can run purge routines to remove canceled replenishment requests from the system tables.
Expected By and Required By	The system calculates the expected by date by adding the replenishment lead days for the item (specified on the Setup Item Replenishment page) to the required by date. Note. If the business unit requires closure calendar validation and processing for receiving activities as defined on the Closure Calendar page, and the system encounters a closure date, it uses the previous valid receiving date to determine the required by date.
Details	Click to access the Maintain Requisitions page.

See Also

Creating Requisitions Online

Purging and Archiving Inventory Data

Using the Fixed Picking Replenishment Workflow

You can use workflow to transfer stock from the main warehouse or stockroom to the fixed picking locations. When you run the Replenishment multiprocess job from the Create Replenishment Requests page, the system generates replenishment information for all items in fixed picking locations with quantities below the optimal item quantity defined on the Fixed Picking Locations page. Information about which fixed picking locations need additional quantity is placed into the INV_REPLEN_TMP workflow temporary table, which populates a worklist for an assigned user to transfer stock to the fixed picking location. When the user selects the task on the work list, the system populates the EZ Transfers page with the data from the worklist so that inventory personnel can transfer the stock. When the transfer is complete, the user selects Worked for the entry to clear the entry from the worklist.

You can use the Fixed Bin Replenishment report to view a list of items in the fixed picking locations that have an on-hand quantity below the optimal quantity.

To use the Fixed Picking Replenishment workflow:

Set up an item in a fixed picking location on the Fixed Picking Locations page.
Select the Fixed Bin Replenishment option on the Setup Replenishment page.
Run the Replenishment multiprocess job from the Create Replenishment Requests page.
Select the task on the worklist to transfer items to the fixed picking location.

Reviewing and Printing Fixed Bin Restocking Requests

With the Review Fixed Pick Bin Replen component, you can review which fixed picking storage locations that are scheduled for restocking have not yet been replenished.

Pages Used to Review Fixed Bin Restocking Requests

Page Name	Object Name	Navigation	Usage
Fixed Bin Replenishment Report	RUN_INC5501	Inventory, Replenish Inventory, Fixed Bin Replenishment Report	Define parameters for the Fixed Bin Replenishment report.
Review Fixed Pick Bin Replen	FPB_REPLEN_INQ_INV	Inventory, Replenish Inventory, Review Fixed Pick Bin Replen	Review and print the fixed picking restocking requests generated by the Create Replenishment Requests process.

Defining Parameters for the Fixed Bin Replenishment Report

Access the Fixed Bin Replenishment Report page.

Reviewing Restocking Requests

Access the Review Fixed Pick Bin Replen page.

Fixed Bin Restocked	Select to indicate that the bin has been replenished with the specified reorder quantity.
Print	Click to print the Fixed Bin Replenishment report, which shows all of the business unit's outstanding fixed picking bin replenishments for the given process date, that is the bins for which you have not selected the Fixed Bin Restocked check box.

Integrating With a Third-Party Forecast Planning Application

With PeopleSoft Inventory, you can download the demand data to third-party demand forecasting software applications. The inventory demand history data is loaded into intermediate files and then transferred using standard file transfer technology to the third-party forecast planning application database. Forecast and inventory planning information from the third-party forecast planning application can then be uploaded to PeopleSoft system tables.

Use the Forecasting Download process (INS9080) to generate a flat file containing the demand history data to pass to the third-party demand forecasting system for analysis. With the Forecasting Upload process (INS9081), you can upload a flat file with the same format containing the forecast data from the third-party demand forecasting system.

This section discusses how to:

Download demand history.
Establish process request parameters to transfer forecast and inventory data.

Third-Party Demand Forecast File Formats

PeopleSoft Inventory background processes generate a flat file containing the data to be analyzed for demand forecasting. This flat file is passed to a third-party demand forecasting system that performs the analysis and then generates a flat file to be returned to PeopleSoft in the same format.

The files to which you download and from which you upload must conform to these rules:

The file name length must be eight characters or less.

An extension of .dwn is automatically appended to downloaded file names.
The system expects the file that is read by the upload process to have a .upl extension.

Download File Formats Based on Booked Orders

If the system includes PeopleSoft Order Management and you selected the Bookings option on the Forecasting Download process page, PeopleSoft Inventory creates a download file based on demand history for sales orders in this layout:

Field	Format	Description
PROD_ITEM.INV_ITEM_ID	Char 18	Item
ORD_SCHEDULE.SHIP_FROM_BU	Char 5	Business Unit
MASTER_ITEM_TBL.DESCR	Char 30	Item Description
ORD_LINE.PRODUCT_ID	Char 18	Product ID
ORD_SCHEDULE.SHIP_TO_CUST_ID*	Char 15	Customer
CUSTOMER.NAME1*	Char 40	Customer Name
ORD_SCHEDULE.QTY_SCHED_ORIG	Nbr 11.4	Demand Quantity
ORD_SCHEDULE.REQ_SHIP_ORIG	YYYYMMDD	Demand Date
MASTER_ITEM_TBL.INV_ITEM_GROUP	Char 15	Item Group
MASTER_ITEM_TBL.INV_PROD_FAM_CD	Char 10	Family
PROD_PRICE.LIST_PRICE	Nbr 11.4	Unit Price
BU_ITEMS_INV.DFLT_ACTUAL_COST for actual-costed items; CM_PERPAVG_COST.CM_UNIT_COST for perpetual average-costed items; BU_ITEMS_INV.AVERAGE_COST for periodic average-costed items; CM_STDCOSTD_VW.TL_COST for standard cost items	Nbr 10.4	Unit Cost
BU_ITEMS_INV.PLANNER_CD	Char 12	Planner
BU_ITEMS_INV.UTILIZ_CD	Char 4	ABC Classification

* See field-specific notes.

Field Specific Notes for the Customer and Customer Name

This is included only if you selected the Include Customer Detail check box on the Forecasting Download page.

Download File Formats Based on Shipped Orders

If you selected the Shipments option on the Forecasting Download process page, PeopleSoft Inventory creates a downloaded file based on demand history for shipped orders in this layout:

Field	Format	Description
IN_DEMAND.INV_ITEM_ID*	Char 18	Item
IN_DEMAND.BUSINESS_UNIT	Char 5	Business Unit
MASTER_ITEM_TBL.DESCR	Char 30	Item Description
IN_DEMAND.PRODUCT_ID	Char 18	Product ID
IN_DEMAND.CUST_ID*	Char 15	Customer
IN_DEMAND.CUST_NAME*	Char 40	Customer Name
IN_DEMAND.QTY_SHIPPED	Nbr 11.4	Demand Quantity
IN_DEMAND.SHIP_DTTM	YYYYMMDD	Demand Date
MASTER_ITEM_TBL.INV_ITEM_GROUP	Char 15	Item Group
MASTER_ITEM_TBL.INV_PROD_FAM_CD	Char 10	Family
PROD_PRICE.LIST_LIST PRICE	Nbr 11.4	Unit Price
BU_ITEMS_INV.DFLT_ACTUAL_COST for actual-costed items; CM_PERPAVG_COST.CM_UNIT_COST for perpetual average-costed items; BU_ITEMS_INV.AVERAGE_COST for periodic average-costed items; CM_STDCOSTD_VW.TL_COST for standard cost items	Nbr 10.4	Unit Cost
BU_ITEMS_INV.PLANNER_CD	Char 12	Planner
BU_ITEMS_INV.UTILIZ_CD	Char 4	ABC Classification

* See field-specific notes.

Field-Specific Notes for Items

If you performed an item substitution on the Material Picking Feedback page, the Forecasting Download process downloads the substitute item rather than the original one.

Field-Specific Notes for the Customer and Customer Name

This is included only if you selected the Include Customer Detail check box on the Forecasting Download page.

Upload File Formats

The upload file created by the third-party forecasting application must have this layout:

Field	Format	Description
FORECAST_INV.FORECAST_SET	Char 20	Forecast Set
FORECAST_INV.INV_ITEM_ID STOCK_PERIOD_IN.INV_ITEM_ID	Char 18	Item
FORECAST_INV.BUSINESS_UNIT STOCK_PERIOD_IN.INV_BUSINESS_UNIT	Char 5	Business Unit
FORECAST_INV.FORECAST_DATE STOCK_PERIOD_IN.START_DT	YYYYMMDD	Start Date
STOCK_PERIOD_IN.END_DT	YYYYMMDD	End Date
FORECAST_INV.QTY_FORECAST	Nbr 11.4	Forecast Quantity
STOCK_PERIOD_IN.DESIRED_SAFETY	Nbr 9.0	Desired Safety Stock

Pages Used to Integrate With a Third-Party Forecast Planning Application

Page Name	Object Name	Navigation	Usage
Forecasting Download	RUN_INS9080	Inventory, Forecast Items, Download Forecasts, Download Forecasts	Download demand history to a third-party forecasting application.
Forecasting Upload	RUN_INS9081	Inventory, Forecast Items, Upload Forecasts, Upload Forecasts	Establish process request parameters to transfer forecast and inventory data produced by the third-party forecasting application to PeopleSoft system tables.

Downloading Demand History

Access the Forecasting Download page.

The system calculates demand history, or past market demand, for each business unit-item combination. This history is based on request dates, shipped quantities, and requested quantities for sales orders or material stock requests.

Forecast Selection

Bookings

Select to extract data from sales orders entered through PeopleSoft Order Management.

Shipments

Select to extract data from shipped orders. This is the orders in the demand fulfillment table (IN_DEMAND) with a fulfillment state (IN_FULFILL_STATE) between 60 and 70.

Note. If you performed an item substitution on the Material Picking Feedback page, the Forecasting Download process extracts data for the substitute item rather than for the original one.

Customer Option

Include Customer Detail

Select to extract data by customer. This enables the third-party application to forecast by customer.

Forecast Period

Initial	Select for the first data transfer to the third-party forecast application. The initial download transfers demand history up to the past 36 months, if available. If you have some historical data, but less than 36 months, you can perform the initial download; however, forecasts will not be as precise. If no historical data is available, or if PeopleSoft Order Management is not part of the installation, enter descriptive information for each item into the third-party forecasting application manually.
Monthly	Enter the month and year for which customer sales orders are currently being placed. Demand history is downloaded for the previous month.
Demand Source	If you are using the Shipments forecast option, you can select All demand sources or a Specific source. If you selected Bookings as the forecast option, the demand source is assumed to be PeopleSoft Order Management.
Planner Code	Select to extract only those items associated with a planner code. Planner codes are established on the Planner Code page and can be associated with an item on the Define Business Unit Item - Planning: General page.
File Name	Enter the full path and file name for the file.

Establishing Process Request Parameters to Transfer Forecast and Inventory Data

Access the Forecasting Upload page.

Forecast Period	Specify the time period for the data upload. Values are: Initial: Select for the initial upload of forecast data. Monthly: Enter the month and year of the first period for which the forecast data should be uploaded.
Planner Code	Select to upload only items associated with a planner code. Planner codes are established on the Planner Code page and can be associated with an item on the Define Business Unit Item - Planning: General page.
Forecast Set	Only forecast information associated with this forecast set is replaced with the uploaded forecasts.
Frozen Periods	Enter the number of periods beginning immediately after the forecasting month for which demand should not be updated. For example, suppose that the forecasting month is 2 and the number of periods selected is 3, demand is not updated for periods 3, 4, or 5, but is updated for the remaining 9 months.
File Name	Enter the file to load. Do not include a directory, drive name, or file extension. Your environment setting indicate where to find the file.

Replenish Class	Enter a value to calculate the replenishment parameters for items belonging to a specific class. If this field is blank, the replenish lead time will be calculated for all items where the replenish class is not blank. For all other calculations, a blank replenish class on the run control page means to calculate for all items.
Include Cancelled Orders	Select to include canceled orders in the demand history calculations.
Safety Stock	Select to calculate safety stock levels. Safety stock is equal to the Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) multiplied by the Replenishment Lead Time for the item (REPLENISH_LEAD). The safety stock calculation uses the window of time between today's date and today's date minus the replenishment calculation period. After you run the Calculate Replenishment Parameters process, the system determines the Average Demand (AVG_DEM_QTY) by taking the sum of the Actual Demand (SUM_DEM_QTY) and dividing it by the Replenishment Calculation Period (REPL_CALC_PERIOD) for the item. Next, the system loops through each day of the calculation period, sums the Actual Demand (DEM_QTY) for the day, and subtracts the Average Demand (AVG_DEM_QTY) to result in the mean absolute deviation as an absolute value (MAD_DELTA_QTY). The Actual Demand (DEM_QTY) is the Sum of Quantity Base for all orders for an item on a specific schedule date. Then the system adds all of the deviations: the sum of the average absolute deviation (MAD_SUM_QTY) is equal to the sum of the mean absolute deviations (MAD_DELTA_QTY). Finally, the formula for safety stock is applied as follows: The average absolute deviation (MAD_QTY) is determined by the sum of the average absolute deviations (MAD_SUM_QTY) divided by the Replenishment Calculation Period (REPL_CALC_PERIOD). The Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) is determined by multiplying the average absolute deviation (MAD_QTY) by the stock-in probability (Z_VALUE) specified by the customer. Safety Stock is equal to the Mean Absolute Deviation Safety Stock (MAD_SFTY_STK) multiplied by the Replenishment Lead Time for the Item (REPLENISH_LEAD). From the window of BETWEEN TODAY & TODAY − (REPL_CALC_PERIOD) AVG_DEM_QTY = SUM_DEM_QTY / REPL_CALC_PERIOD This portion loops for every day in the window regardless of DEM_QTY = 0 MAD_DELTA_QTY = \|DEM_QTY − AVG_DEM_QTY\| MAD_SUM_QTY = MAD_SUM_QTY + MAD_DELTA_QTY MAD_QTY = MAD_SUM_QTY / REPL_CALC_PERIOD MAD_SFTY_STK = Z_VALUE * MAD_QTY SAFETY_STOCK = MAD_SFTY_STK * REPLENISH_LEAD
Reorder Point	Select to calculate reorder points for the business unit. The Calculate Replenishment Parameters process calculates reorder points as follows: ((sum of the demand during calculation period * lead time) / calculation period) + safety stock.
Replenish Lead	Select to calculate the business unit’s replenishment lead time. The Calculate Replenishment Parameters process calculates replenishment lead time for all items except those that have an Under Initialization, Pending Approval, or Denied Approval status. The process averages the difference between an item's PO date and its subsequent put away date. The PO date is required for this calculation. If the transaction date is before the PO date, the transaction will be ignored by the replenish lead calculation.
Annual Demand	Select to calculate the annual demand for the business unit. PeopleSoft Inventory calculates this value as follows: Sum of the demand from (today’s date less 365 days) through today’s date.
Maximum Stock Qty (maximum stock quantity)	Select to calculate the maximum on-hand quantity for the business unit. This calculation is computed as follows: (average daily demand for calculation period * (lead time + calculation period)) + safety stock.
EOQ (economic order quantity)	Select to calculate economic order quantities for the business unit This option will not be available if the EOQ option is not selected on the Setup Replenishment page. The Calculate Replenishment Parameters process calculates EOQ by using the industry standard calculation. In this formula, d equals the last calculated annual demand for an item, c equals order preparation cost of EOQ defined on the Setup Replenishment page, i equals annual inventory carrying cost percentage defined on the Setup Replenishment page, and u equals the item’s standard or average cost, depending on the item’s cost method.

Replenish Class	Enter a value to replenish items belonging to a specific replenishment class. Leave this field blank to replenish all items in the business unit that are marked for replenishment. Fixed bin replenishment ignores this field.
Dedicated Temp Table Stats	This process stores some of its temporary working data in dedicated temporary tables. This check box is defaulted to make it easier for database administrators to generate accurate table statistics for these types of tables.