Inventory Allocation Details

Form ID: (IN402000)

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

By using this form, you can view how a selected inventory item is distributed among warehouses and warehouse locations. You also can view the on-hand quantity and actual quantity of the inventory item according to unreleased documents. You can set up filters to display only the data you want to view.

The quantities displayed on the form are calculated automatically, based on the availability calculation rule defined for the item class associated with the inventory item. The availability calculation rule is specified in the Availability Calculation Rule box on the General tab of the Item Classes (IN201000) form. For details, see Availability Calculation Rules: General Information.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
View Document Opens the document that contains the selected line in a new browser window.
Inventory Summary Navigates to the Inventory Summary (IN401000) form, where you can view the availability data of the inventory item.

Selection Area

By using the input boxes in this area, you can select the most relevant data to be displayed on the form for your information needs.

Element Description
Inventory ID The inventory item for which you want to view data. You must select an item.
Warehouse

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.

Location

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 form.

Subitem

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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Lot/Serial Nbr.

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 form.

The upper area of the form also includes informational elements that show the base unit of the item and the allocation of the available quantity (in base units) of the selected inventory item according to various unreleased documents.

This area uses notations as follows:
  • The [*] notation indicates that the quantities of the inventory item at the locations marked as Except Loc. Not Available are not included in the displayed value. (This notation appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features form.)
  • The [**] notation indicates that the quantities of the inventory item at the locations marked as Except Expired and Loc. Not Available, as well as the quantities of expired items, are not included in the displayed value. (This notation appears only if the Lot and Serial Tracking and the Multiple Warehouse Locations features are enabled on the Enable/Disable Features form.)
Note: A selected check box to the right of a specific quantity indicates that this quantity is involved in the availability calculation in accordance with the availability calculation rule assigned to the item class on the Item Classes (IN201000) form.
Element Description
Base Unit The unit of measure (UOM) used as a base unit for this inventory item.
On Hand The quantity on hand for this inventory item.
Total Addition

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.

Total Deduction

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 form.

Available

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.

Available for Shipping

The quantity of the item available for shipping.

This value is calculated by the system as the quantity on hand minus the quantities shipped, minus the quantities allocated for sales, production, and service orders, minus the quantities in locations for which the Include in Qty. Available check box is cleared on the Locations tab of the Warehouses (IN204000) form, minus the quantities on issues that have not been released yet.

Available for Issue

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.

On Loc. Not Available

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.

This box appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features form.
Expired[*]

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 form.

Item Plans Tab

In this tab, you can view a list of documents that were used as the sources of availability information according to the settings of this item's item class on the Item Classes (IN201000) form.

Table 1. Table Columns
Column Description
Module The identifier of the module (that is, the part of the system) where the document with the availability information about this inventory item originated.
Allocation Type The type of allocation for the specified quantity of the inventory item.
Allocation Date The date of the allocation.
Document Type The type of document used as a source of allocation information about the specified quantity of the inventory item.
Reference Nbr. The reference number of the document used as a source of allocation information about the specified quantity of the inventory item.
Subitem

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.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Warehouse

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 form.

Location

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 form.

Lot/Serial Number

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 form.

Qty. The quantity of the inventory item with the specified properties allocated according to the document.
Note: The quantities on return sales orders and receipt-type shipments are shown as negative values.
Account ID The identifier of the business account associated with the allocation.
Account Name The company name of the business account associated with the allocation.
Loc. Not Available

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.

Expired A check box that indicates (if selected) that the expiration date for quantity has passed.

Qty by Plan Type Tab

On this tab, you can view plan types that could increase (left pane) or decrease (right pane) the item quantity in stock.

Table 2. Left Pane: AdditionYou can filter the records in the table by using predefined filters: All Records, and Addition Non-Zero Qty (selected by default).
Column Description
Plan Type The plan type that could increase the item quantity in stock.
Quantity The quantity of the inventory item included in the plan.
Included A check box that indicates (if selected) that the quantity of the inventory item by the plant type is included to the total sum of additions.
The list of plan types that could increase the item quantity in stock.
Purchase Prepared

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 form (as reflected by the read-only check box to the right of this box).

Purchase Orders

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 form (as reflected by the read-only check box to the right of this box).

PO Receipts

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 form (as reflected by the read-only check box to the right of this box).

IN Receipts[*]

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 form (as reflected by the read-only check box to the right of this box).

In Transit[**]

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 form (as reflected by the read-only check box to the right of this box).

Production Supply Prepared

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 box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production Supply

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 form (as reflected by the read-only check box to the right of this box).

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Purchase for Prod. Prepared

The quantity of the inventory item listed on purchase orders not yet open with a the line type of Goods for MFG.

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Purchase for Production

The quantity of the inventory item listed on open purchase orders with the line type of Goods for MFG.

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production for Prod. Prepared

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 box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production for Production

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 box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production for SO Prepared

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 box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production for SO

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 box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Kit Assembly Supply

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 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 form.

Purchase for SO Prepared

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 form.

Purchase for SO

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 form.

Receipts for SO

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 form.

Drop-Ship for SO Prepared

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 form.

Drop-Ship for SO

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 form.

Drop-Ship for SO Receipts

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 form.

Purchase for FS Prepared

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.

Purchase for FS

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.

Receipts for FS

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.

FS to Purchase

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.

Table 3. Right Pane: DeductionYou can filter the records in the table by using predefined filters: All Records, and Deduction Non-Zero Qty (selected by default).
Column Description
Plan Type The module where the document with the availability information about this inventory item originated.
Quantity The quantity of the inventory item included in the plan.
Included A check box that indicates (if selected) that the quantity of the inventory item by the plant type is included to the total sum of deductions.
In Transit to SO

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 form.

SO Prepared

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 form (as reflected by the read-only check box to the right of this box).

SO Booked [**]

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 form (as reflected by the read-only check box to the right of this box).

SO Allocated [**]

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 form (as reflected by the read-only check box to the right of this box).

SO Shipped [**]

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 form (as reflected by the read-only check box to the right of this box).

SO Back Ordered [**]

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 form (as reflected by the read-only check box to the right of this box).

IN Issues [**]

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 form (as reflected by the read-only check box to the right of this box).

Kit Assembly Demand

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 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 form.

Production Demand Prepared

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 form (as reflected by the read-only check box to the right of this box).

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production Demand

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 form (as reflected by the read-only check box to the right of this box).

Attention: The system does not update an item plan for a production order that has the Completed status if a material has not been issued in full for the production order, such as when the material is out of stock.

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production Allocated

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 form (as reflected by the read-only check box to the right of this box).

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

SO to Production

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

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production to Purchase

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

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Production to Production

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

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

FS Prepared [**]

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.

FS Booked [**]

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 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.

FS Allocated [**]

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 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.

SO to Purchase The quantity of the inventory item included in open purchase orders created for sales orders. This quantity doesn't affect the item availability.
SO to Drop-Ship

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 form.