Inventory Allocation Details

The warehouse for which you want to view data. Leave the box blank to view information about the inventory item in all warehouses.

This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

The location for which you want to view data. Leave the box blank to view information on all locations.

This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

The subitem of the inventory item. Leave the box blank to view information on all subitems.

This box appears only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form.

The lot or serial number for which you want to view data. Leave the box blank to view information not split by lot or serial numbers.

This box appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.

The total quantity of the inventory item to be added to the on-hand quantity at the warehouse.

This computation is performed in accordance with the availability calculation options specified for the item class.

The total quantity of inventory item to be deducted from the on-hand quantity at the warehouse.

This computation is performed in accordance with the availability calculation rule specified for the item class on the Item Classes (IN201000) form.

The quantity of the inventory item available at the warehouses.

This value is the quantity on hand plus the total addition value minus the total deduction value.

For details on the availability calculations rules, see Availability Calculation Rules: General Information.

The quantity of the item available for shipping.

This value is calculated by the system as the quantity on hand minus the following quantities:

• The quantities shipped
• The quantities allocated for sales, production, and service orders
• The quantities in locations for which the Include in Qty. Available check box is cleared on the Locations tab of the Warehouses (IN204000) form
• The quantities on issues that have not been released yet
• The quantities of stock components on the kit assembly documents that have not been released yet—that is, documents with the Production type on the Kit Assembly (IN307000) form
• The quantities of stock kits on the kit disassembly documents that have not been released yet—that is, documents with the Disassembly type on the Kit Assembly (IN307000) form

For details on the calculation of the quantity that is available for shipping, see Availability Calculation Rules: General Information.

The quantity of the item available for issue from this warehouse and location.

This value is calculated by the system based on the quantity on hand (On Hand), with the shipped quantity (SO Shipped) deducted.

The quantity of the inventory item stored at locations not included in the availability calculation.

For each warehouse location, the Include in Qty. Available check box on the Warehouses (IN204000) form defines whether the quantity of items stored at this location is included in the quantity of available items. If the check box is not selected, all items from a single location (the MAIN location) are always available for shipping.

The quantity of the inventory item that has expired, based on the expiration date specified for the lot.

This box appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.

The subitem of the inventory item.

This column is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form.

The warehouse where the specified quantity of the inventory item was allocated.

This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

The location where the specified quantity of the inventory item was allocated.

This column appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.

The lot or serial number assigned to the specified quantity of the inventory item.

This column appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.

The cost layer type to which the item plan is related.

This column appears only if the Project-Specific Inventory feature is enabled on the Enable/Disable Features (CS100000) form.

A check box that indicates (if selected) that this quantity is allocated at locations not included in the availability calculation (those for which the Include in Qty. Available check boxes are cleared on the Warehouses (IN204000) form).

This check box appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item calculated for all purchase orders that are not yet open (that is, that have a status of On Hold or Pending Approval).

This value affects the available quantity only if the Include Qty. on Purchase Prepared option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item on all open purchase orders.

This quantity affects the available quantity only if the Include Qty. on Purchase Orders option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item on unreleased purchase receipts.

This quantity affects the available quantity only if the Include Qty. on PO Receipts option is set for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item on unreleased receipts.

This quantity affects the available quantity only if the Include Qty. on Receipts option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item that is included in the two-step transfer documents that have been released, and the inventory receipts for this quantity were not created in the destination warehouse or the inventory receipts have been created but not released.

This quantity affects the available quantity only if the Include Qty. In-Transit option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item calculated for all production orders that are not yet open (that is, that have a status of On Hold or Planned). This value affects the available quantity only if the Include Qty. on Production Prepared option is selected on the Availability Calculation Rules (IN201500) form (as reflected by the read-only check box to the right of this box).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item on all open production orders (that is, that have a status of Released or In Process). This quantity affects the available quantity only if the Include Qty. on Production Orders option is selected on the Availability Calculation Rules (IN201500) form (as reflected by the read-only check box to the right of this box).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on purchase orders of the line type Goods for MFG for all production orders that are not yet open (that is, that have a status of On Hold or Planned).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on purchase orders of the line type Goods for MFG for all production orders that are not yet open (that is, that have a status of Released or In Process).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on production orders created for parent production orders where the child production order has a status of On Hold or Planned.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on production orders created for parent production orders where the child production order has a status of Released or In Process.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on production orders created for sales orders where the production order has a status of On Hold or Planned.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on production orders created for sales orders where the production order has a status of Released or In Process.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item (as a kit or as a kit component) listed on unreleased kit assembly documents. This quantity affects the available quantity only if the Include Qty. of Kit Assembly Supply option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

This box appears only if the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on purchase orders created for back orders and not yet open. This quantity doesn't affect the item availability.

This box appears only if the Sales Order to Purchase Order Link feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on open purchase orders created for sales orders. This quantity doesn't affect the item availability.

This box appears only if the Sales Order to Purchase Order Link feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on purchase receipts that were created for back orders. This quantity doesn't affect the item availability.

This box appears only if the Sales Order to Purchase Order Link feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on drop-ship sales orders with a status of On Hold, Credit Hold, or Pending Approval. This value is not included in the quantity available.

This box appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on open drop-ship sales orders. This quantity doesn't affect the item availability.

This box appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on receipts for drop-ship sales orders. This value is not included in the quantity available.

This box appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on purchase orders created for service orders and not yet open. This quantity doesn’t affect the availability of the item.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item listed on open purchase orders created for service orders. This quantity doesn’t affect the availability of the item.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item listed on purchase receipts that were created for service orders. This quantity doesn’t affect the availability of the item.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item included in service order lines that are marked for purchasing. This quantity doesn’t affect the availability of the item.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item on transfer orders (not yet released) that were generated for sales order allocations.

This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on sales orders of the SO, CS, and IN types with the On Hold, Credit Hold, Rejected, and Pending Approval statuses.

This quantity affects the available quantity only if the Deduct Qty. on Sales Prepared option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item listed on open sales orders of the SO type. This value is calculated as the total quantity of the item included in all open sales orders after deduction of the quantities of shipped items and items being shipped.

This quantity affects the available quantity only if the Deduct Qty. on Sales Orders option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item on unconfirmed shipments. This value also includes the quantities on orders of the SA type with On Hold, Credit Hold, Pending Approval, Rejected, and Open statuses; it also includes the quantities specifically allocated for sales orders of the SO type with the On Hold, Credit Hold, Pending Approval, and Open statuses.

This quantity affects the available quantity only if the Deduct Qty. Allocated check box is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item shipped according to the confirmed shipments; the value also includes the quantities on open orders of the CS and IN types.

This quantity affects the available quantity only if the Deduct Qty. Shipped option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item on sales orders with the Back Order status; this quantity also includes the unallocated quantities (those which are unavailable at the specified locations) for On Hold, Credit Hold, Rejected, Pending Approval, and Open orders of the SA order type.

This quantity affects the available quantity only if the Deduct Qty. on Back Orders option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item included in the inventory issue documents that were not released yet.

This quantity affects the available quantity only if the Deduct Qty. on Issues option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

The quantity of the inventory item included in unreleased kit assembly documents as kits or kit components. This quantity affects the available quantity only if the Deduct Qty. on Kit Assembly Demand option is selected for the item class on the Item Classes (IN201000) form (as reflected by the read-only check box to the right of this box).

This box is available only if the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity required of the inventory item calculated for all production orders that are not yet open (that is, that have a status of On Hold or Planned). This value affects the available quantity only if the Deduct Qty. on Production Demand Prepared option is selected on the Availability Calculation Rules (IN201500) form (as reflected by the read-only check box to the right of this box).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity required of the item (which is the material) calculated for all production orders that are open (that is, that have a status of Released or In Process). This value affects the available item quantity only if the Deduct Qty. on Production Demand check box is selected on the Availability Calculation Rules (IN201500) form (as reflected by the read-only check box to the right of this box).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity allocated of the inventory item calculated for all production orders. This value affects the available quantity only if the Deduct Qty. on Production Allocated option is selected on the Availability Calculation Rules (IN201500) form (as reflected by the read-only check box to the right of this box).

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed on sales order lines marked for production. This quantity does not affect the item availability.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item included in open purchase orders created for production orders. This quantity does not affect the item availability.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item on production order supply allocated to another production order. This quantity does not affect the item availability.

This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

The quantity of the inventory item listed in service orders with the On Hold status. This quantity affects the available quantity only if the Deduct Qty. on Service Orders Prepared check box is selected on the Availability Calculation Rules (IN201500) form for the item class. The check box to the right of this box displays the status of the Deduct Qty. on Service Orders Prepared check box.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item listed on open service orders. This quantity affects the available quantity only if the Deduct Qty. on Service Orders check box is selected on the Availability Calculation Rules (IN201500) form for the item class. The check box to the right of this box displays the status of the Deduct Qty. on Service Orders check box.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item allocated on the undelivered service orders. This quantity affects the available quantity only if the Deduct Qty. Allocated on Service Orders option is selected on the Availability Calculation Rules (IN201500) form for the item class. The check box to the right of this box displays the status of the Deduct Qty. Allocated on Service Orders check box.

This box appears on the form only if the Service Management feature is enabled on the Enable/Disable Features form.

The quantity of the inventory item included in incomplete sales order lines that require creating and processing purchase orders to completion—that is, the Mark for PO check box is selected and the Purchase to Order or Blanket for Normal option is selected in the PO Source column for a line with this inventory item on the Details tab of the Sales Orders (SO301000) form.

For more information about sales orders that require processing purchase orders, see Processing Purchases for Sale.

The quantity of the inventory item included in open purchase orders created for drop-ship orders. This quantity doesn't affect the item availability.

This box appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.