Calculations of Available Inventory and Demand

The following calculations are used in the Just-in-Time, Master Scheduling, and Requirements Planning, modules to determine available quantities for various inquiries and reports. 

1.   For the manufacturing warehouse, all inventory balances where the Order Planning flag on the balance type is Y, are totaled.

2.   The Work in Process balance is added to the total.

3.   For the manufacturing warehouse, if any balance types are available for both planning and distribution (both Order Planning Flag and Distribution Flag = Y on the balance type), and sales orders are not considered for planning (the Sales Order Planning Flag on the Warehouse Description File is N), then the inventory quantity reserved for customer sales orders is subtracted from the total. 

4.   For every distribution warehouse associated with the plant, the Warehouse Description File is read to determine if balances at the warehouse are available for planning.  If so, any distribution balance at the warehouse is added to the total.

Demand calculations include component requirements, flow requirements, transfer orders, offset releases, part delivery point relationships, and customer sales orders.  Transfer orders are included if they have a relief code of M.  (The Sales Order Planning flag refers only to customer sales orders, not transfer orders).  The sales orders are only included if they are sourced from manufacturing inventory (relief code = M) or they are sourced from distribution inventory (relief code D) at a manufacturing warehouse where the Sales Order Planning flag = Yes.  Customer sales orders sourced from distribution warehouses are never included in demand calculations within the manufacturing modules.  Sales orders, reserved inventory, and backordered inventory are considered in inventory status reports within Inventory Control and Order Processing.

Note that Master Scheduling and Requirements Planning treat planned and unplanned orders differently.  Depending upon each part's consumption code, planned orders are netted against forecast demand to determine whether actual or predicted demand is higher.  Unplanned orders are added to this net quantity to give the total demand.  Transfer requisitions and transfer orders are labeled as planned or unplanned on the multi-line and line detail screens in the Requisition Maintenance conversation and on the header and multi-line screens in the Transfer Order Maintenance conversation, respectively.  Sales orders, transfer orders, and transfer requisitions are labeled as planned or unplanned on the line detail screen of each respective conversation.  Note, however, that for transfer orders the relief code is still in effect, and for sales orders the Sales Order Planning flag on the warehouse is still in effect--for sales orders that are not considered for planning, the Planned/Unplanned flag is irrelevant.  In other words:

·     Planned/Unplanned flag is never relevant for any orders or requisitions sourced from distribution warehouses

·     Planned/Unplanned flag is always relevant for orders and requisitions sourced from manufacturing inventory at manufacturing warehouses, if the part's consumption code warrants this.

·     Planned/Unplanned flag is relevant only for sales orders sourced from distribution inventory at manufacturing warehouses only if the Sales Order Planning flag is Y.