Defining status inventory types

You can define how and when inventory is updated for Sellers and Buyers tracking inventory, on a status-by-status basis.

The Status Inventory Types table is used to associate statuses with specific supply and demand types according to organization. When an order moves through the statuses of a given fulfillment pipeline the values corresponding to the Buyer supply type and Seller demand type associated with the original status are decreased and the values for the status the order is moving into are increased.

Example

Assume you have the following records in the Status Inventory Type table:

Table 1. Sample status inventory type records.

Sample status inventory type records
Status Buyer Supply Type Seller Demand Type Seller Supply Type Increment Seller Supply
1100 Purchase Order Placed Open Order Onhand N
3200 Purchase Order Released Released Onhand N
3700 Intransit     Y

When an order with a line item quantity of 10 is created in Created (1100) status, the Purchase Order Placed supply record is updated with a quantity of 10. A Open Order demand type with a quantity of 10 is created for the Seller.

In this example, if a quantity of 3 is moved into Released (3200) status, the Purchase Order Placed supply record is decreased by 3 and a new supply record with a quantity of 3 is created for the Purchase Order Released supply type. The Open Order demand record is also decreased by 3 and a new demand record is with a quantity of 3 is created for the Released demand type.

When the order moves from Released (3200) status to Shipped (3700) status, the Buyer's supply is decreased for the Purchase Order Released supply type and increased for Intransit. The Seller's demand is decreased for the Released demand type. However, the demand type is not increased for a new type, because the Seller Demand Type associated with the Shipped (3700) status is blank.

In the above configuration, the Increment Seller Supply flag is set to 'Y' and the Seller's supply type for the Shipped (3700) status is Onhand. The Increment Seller Supply flag indicates that the Seller's supply must be adjusted when moving any quantity into the Shipped (3700) status.

The value in the Seller Supply Type column indicates the supply type that should be updated, in this example, Onhand. Since the record for the Released (3200) status has the Onhand Seller supply type associated with it and the Shipped (3700) status record has a blank Seller supply type associated with it, the Onhand Seller supply type decreases when moving from Released (3200) status to Shipped (3700) status. The Seller supply type is not increased with this status move because the value in the Seller Supply Type column for the Shipped (3700) status is blank.

To view a process type's status inventory types, from the tree in the application rules side panel, choose Document Specific > (Document Type) > Fulfillment > Status Inventory Types. The Status Inventory window displays. Refer to Table 2 for assistance.
Table 2. Status inventory types window.

Status inventory types field value description
Field Description
Orders Without Chaining/Orders With Chained Children/Procurement Orders Select the Orders Without Chaining tab to view the status inventory types for orders that flow through the process type pipeline without having any associated chained orders.

Select the Orders With Chained Children tab to view the status inventory types of orders having associated drop-ship chained orders.

Select the Procurement Orders tab to view the status inventory types of procurement orders.
Status The order document's status.
Buyer Supply Type The Buyer's supply type associated with the order document's status.
Seller Supply Type The Seller's supply type associated with the order document's status.
Update Seller Supply Indicates if inventory updates are made when an order document moves into the associated status.
Seller Demand Type The Seller's demand type associated with the order document's status.