Previous  Next          Contents  Index  Glossary  Library

Reorder Point Report

Use the Reorder Point Report to show planning information for items for which the Inventory Planning Method is set to Reorder Point. See: Oracle Inventory Profile Options.

The reorder point is a planning method based on history that is used for spare parts where no bill of material exists. This method is useful when you have independent demand items.

In this report, Lead Time is the sum of preprocessing, processing, and postprocessing lead times. The Reorder Point is the Safety Stock plus the Lead Time Demand. The On-Hand Quantity is for the organization at the time the report was generated, excluding expired lots. The Supply Quantity is the current quantity on order, calculated from approved requisitions, approved purchase orders, and intransit inventory. The Total Available is the On-Hand Quantity plus the Supply Quantity less the Demand Quantity. The Reorder Quantity is the economic order quantity (EOQ), subject to the minimum order quantity, maximum order quantity, and fixed lot multiple. The Demand Quantity is the unsatisfied sales order quantity (reserved and unreserved).

Report Submission

Use the All Reports or Submit Requests window and enter Reorder point report in the Name field to submit the report.

Report Parameters

Item Selection

Select one of the following options:

All reorder point planned items Report all items identified as reorder point planned items. The report contains all items, whether or not their on-hand and on-order balances fall below their reorder points. This allows you to see where item balances stand in relation to the specified order point.
Items under reorder point Report only items with on-hand and on-order balances that fall below their reorder point.

Demand Cutoff Date

Enter the demand cutoff date. The report considers only demand with dates equal to or earlier than the demand cutoff date.

Supply Cutoff Date

Enter the supply cutoff date. The report considers only supply with expected receipt dates equal to or earlier than the cutoff date.

Restock

Select Yes or No to indicate whether you want to create demand records in the interface tables for requisitions and/or WIP jobs. You can enter a value here only if you are defined as an employee. To actually create the requisitions/discrete jobs, you will need to run the import processes: See: Requisition Import Process and Importing Jobs and Schedules.

Default Delivery To

Select the default delivery location for the requisition. You can enter a value in this field only if you choose Yes in the Restock field.

Forecast

Enter the forecast designator. This forecast is used to determine the demand to be used in the reorder point calculation.

First Sort

Select one of the following options for the first sorting criterion:

ABC Class Sort the report by ABC class.
Buyer Sort the report by buyer.
Category Sort the report by category.
Inventory item Sort the report by inventory item.
No sort Do not sort the report.
Planner Sort the report by planner.

Second Sort/Third Sort

Select one of the above options for the second and third sorting criteria. The second sort option sorts by the first sort type and then by the second type within the first type. The third sort option sorts by the first type, then by the second type within the first type, and finally by the third type within the second type.

Items From/To

To restrict the report to a range of items, select the beginning and ending items.

Planners From/To

To restrict the report to a range of planners, select the beginning and ending planners.

Buyers From/To

To restrict the report to a range of buyers, select the beginning and ending buyers.

Category Set

Select the category set for which you want to run the report.

Categories From/To

To restrict the report to a range of categories, select the beginning and ending categories.

ABC Assignment Group

To restrict the report to a specific ABC Assignment group, select the group.

ABC Class

If you selected an ABC Assignment group, you can further restrict the report to a specific ABC Class by selecting the class.

Include PO Supply

Select Yes or No to indicate whether to include purchase order supply.

Include WIP Supply

Select Yes or No to indicate whether to include WIP supply.

Include Interface Supply

Select Yes or No to indicate whether to include interface supply.

Include Non-nettable Subinventories

Select Yes or No to indicate whether to include non-nettable subinventories.

Display Item Description

Select Yes or No to indicate whether to print the item description.

Display Additional Information

Select Yes or No to indicate whether to display the following additional item information: Category, Planner, Buyer, and ABC Class.

See Also

Submitting a Request


         Previous  Next          Contents  Index  Glossary  Library