Min-Max Planing Report Research

Min-max planning is a method of determining  when and how much to order based on userdefined minimum and maximum inventory levels.

Reorder Qty=  (Max quantity) - [(onhand qty)+(qty on order)] = 1000 - [50 + 0]

When to Order?

Typically, you should order when: On-hand quantity + supply − demand < minimum 

Min-Max Planing:How Much to Order?

Order Quantity = (Max quantity) - [(onhand qty)+(qty on order)]

Restock：Enter Yes or No to indicate whether to restock. If you have set the Planning Level to

Organization , the report generates requisitions or jobs according to the item's

Make/Buy flag. If you have set the Planning Level to Subinventory , the report generates only requisitions.

如果Make or Buy= Buy,restock 会产生PR

如果Make Or Buy=Make，restock之后会产生一个WIP job

Restock改为yes之后，跑完request

select * from PO_REQUISITIONS_INTERFACE_ALL where item_id = 186948

PO_REQUISITIONS_INTERFACE_ALL 会看到一条记录

接着运行requisition import request.

运行完后，如果遇到错误，

 

SELECT    e. error_message

FROM   po_requisitions_interface_all i , PO_INTERFACE_ERRORS e

WHERE   i . TRANSACTION_ID = e. INTERFACE_TRANSACTION_ID AND item_id = 186948;

update po_requisitions_interface_all set process_flag = 'FUTURE' where item_id = 186948

如果没错的话，那么一个PR就产生了

Footnote:

To request the min-max planning report:

1. Navigate to the Min-Max Planning window.

2. Enter Request in the Type field.

3. Enter Min-max planning report in the Name field.

4. Navigate to the Parameters field. The Parameters window appears.

5. Indicate whether the planning level is set for the entire organization or a specific

subinventory. At the subinventory level, the report cannot generate jobs and does

not consider WIP jobs as supply or WIP components as demand. If you select

Subinventory , enter the name of the subinventory.

If you choose subinventory, as the planning level, the report includes VMI stock. If

you choose organization as the planning level, the report does not include VMI

stock.

6. Indicate the type of item to include on the report. You can report on items under the

minimum quantity, items over the maximum quantity, or all min-max planned

items.

7. Enter the category

10. Enter the demand cutoff date and, optionally, the demand cutoff date offset. The

report includes demand on or before this date. If you do not check Net Demand this

calculation is for display purposes only.

11. Enter the supply cutoff date and, optionally the supply cutoff date offset. The

calculation includes open supply orders on or before this date.

12. Enter Yes or No to indicate whether to restock. If you have set the Planning Level to

Organization , the report generates requisitions or jobs according to the item's

Make/Buy flag. If you have set the Planning Level to Subinventory , the report

generates only requisitions.

13. If you are using the Organization Planning Level, choose one of the following For

Repetitive Item options: Create Requisitions for items under minimum quantity,

Create Discrete Jobs for items under minimum quantity or run the Report Only

without creating jobs or requisitions.

14. Enter the default delivery location.

15. Indicate whether to net reserved and unreserved orders.

16. Indicate whether to Net WIP Demand in the available quantity calculation. Net

demand is the unshipped sales quantity for the selected organization or

subinventory. You cannot set this to Yes if you are using subinventory level

planning.

17. Indicate whether to include PO, WIP, and Interface supply and non-nettable

subinventories.

18. Choose one of the following Display Format options: Display All Information, Don't

Display Supply/Demand Details (The report does not display the Minimum Order

Quantity, Maximum Order Quantity, and Multiple Order Quantity columns.), or

Don't Display Order Constraints (The report does not display the On Hand Quantity

column).