Inventory allocation details (IN402000)
The typical user of this window is a warehouse manager or a salesperson, who uses it to find out which items are available, check the availability and location of a single item and reallocate items if necessary.
You also can view the on-hand (book) quantity and actual quantity of the stock item according to unreleased documents. You can set up filters to display only the data you want to view.
The quantities displayed in the window are calculated automatically, based on the availability calculation options defined for the item class associated with the stock item.
These settings are specified on the General settings tab of the Item classes (IN201000) window.
The top part
By using the first five elements in this area, you can select the most relevant data to be displayed in the table for your information needs. This area also includes informational elements that show the base unit of the item and the distribution of the available quantity of the selected stock item according to various unreleased documents.
The [*] notation indicates that the quantities of the stock item at the locations marked as Except loc. not available are not included in the displayed value.
This notation is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled.
The []** notation indicates that the quantities of the stock 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 is only displayed if the Lot and serial tracking and the Multiple warehouse locations functionalities in the Enable/disable functionalities (CS100000) window are enabled.
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window, where you can view the availability data of the stock item. |
| Element | Description |
|---|---|
| Item ID | The stock 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 field blank to view information about the stock item in all warehouses. Note This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view data. Leave the field blank to view information on all locations. Note This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number for which you want to view data. Leave the field blank to view information not split by lot or serial numbers. Note This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Base unit | Read only. This field shows the unit of measure (UoM) used as a base unit for this stock item. |
| On hand | Read only. This field shows the quantity on hand for this stock item. |
| Total addition | Read only. This field shows the total quantity of stock item to be added to the on-hand quantity at the warehouse. Computation is performed in accordance with availability calculation options specified for the item class. |
| Total deduction | Read only. This field shows the total quantity of stock item to be deducted from the on-hand quantity at the warehouse. Computation is performed in accordance with availability calculation options specified for the item class. |
| Available | Read only. This field shows the quantity of the stock item available at the warehouses. It is the sum of the quantity on hand plus the total addition value and minus the total deduction value. |
| Available for shipping | Read only. This field shows the quantity of the item available for shipping from this location. This value is calculated by the system based on the quantity on hand with the quantities shipped and on shipping deducted. |
| On loc. not available | The quantity of the stock item stored at locations not included in the availability calculation. For each warehouse location, the Include in qty. available option in the Warehouses (IN204000) window defines whether the quantity of items stored at this location is included in the quantity of available items. Note This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. Note If the functionality is disabled, all items from a single location (the MAIN location) are always available for shipping. |
| Expired [*] | The quantity of the stock item that has expired, based on the expiration date specified for the lot. Note This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Sales order prepared | Read only. This field shows the quantity of the stock item listed on sales orders of the Sales, Common settings, and Inventory 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 (as reflected by a read-only check box to the right of the field). |
| Sales orders booked [**] | Read only. This field shows the quantity of the stock item listed on unreleased sales orders. This value is calculated as the total quantity of the item included in all 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 customer orders option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales orders allocated [**] | Read only. This field shows the quantity of the stock item on unconfirmed shipments. This quantity affects the available quantity only if the Deduct qty. shipping check box is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Sales orders shipped [**] | Read only. This field shows the quantity of the stock item shipped according to the confirmed shipments. This quantity affects the available quantity only if the Deduct qty. shipped option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Back orders [**] | Read only. This field shows the quantity of the stock item on sales orders with the Back order status. 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 SA order type. This quantity affects the available quantity only if the Deduct qty. on back orders option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| Inventory issues [**] | Read only. This field shows the quantity of the stock 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 (as reflected by a read-only check box to the right of the field). |
| Sales order to purchase | Read only. This field shows the quantity of the stock item included in open purchase orders created for sales orders. This quantity doesn’t affect the item availability. |
| Sales order to drop-ship | Read only. This field shows the quantity of the stock item included in open purchase orders created for drop-ship orders. This quantity doesn’t affect the item availability. Note This field is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Purchase prepared | Read only. This field shows the quantity of the stock item calculated for all purchase orders that are not yet open, that is, are in the On hold or Pending approval status. This value affects the Available quantity only if the Include qty. on purchase prepared option is selected for the item class in the Item classes (IN201000) window (as reflected by a read-only check field to the right of the field). |
| Purchase orders | Read only. This field shows the quantity of the stock item on all open purchase orders that affects the available quantity only if the Include qty. on purchase orders option is selected for the item class in the Item classes (IN201000) window (as reflected by a read-only check box to the right of the field). |
| Purchase order receipts | Read only. This field shows the quantity of the stock item on unreleased purchase receipts, which affects the available quantity only if the Include qty. on purchase orders receipts option is set for the item class (as reflected by a read-only check box to the right of the field). |
| Inventory receipts [*] | Read only. This field shows the quantity of the stock item on unreleased receipts. This quantity affects the available quantity only if the Include qty. on receipts option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| In transit [**] | Read only. This field shows the quantity of the stock item on unreleased incoming two-step inventory transfers. This quantity affects the available quantity only if the Include qty. in transit option is selected for the item class (as reflected by a read-only check box to the right of the field). |
| In transit to sales order | Quantity of the stock item in transit to sales order. |
| Purchase for sales order (prepared) | Read only. This field shows the quantity of the stock item listed on purchase orders created for back orders and not yet open. This quantity doesn’t affect the item availability. |
| Purchase for sales order | Read only. This field shows the quantity of the stock item listed on open purchase orders created for sales orders. This quantity doesn’t affect the item availability. |
| Sales order receipts | Read only. This field shows the quantity of the stock item listed on purchase receipts that were created for back orders. This quantity doesn’t affect the item availability. |
| Drop-ship for sales order, prepared | Read only. This field shows the quantity of the stock item listed on drop-ship sales orders in the of On hold or Pending approval status. This value is not included in the quantity available. Note This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Drop-ship for sales order | Read only. This field shows the quantity of the stock item listed on open drop-ship sales orders. This quantity doesn’t affect the item availability. Note This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Drop-ship for sales order, receipts | Read only. This field shows the quantity of the stock item listed on receipts for drop-ship sales orders. This value is not included in the quantity available. Note This column is only displayed if the Drop shipments functionality in the Enable/disable functionalities (CS100000) window is enabled. |
The table
In this table, you can view detailed information matching the criteria specified in the Selection area about the allocation of the selected stock item.
| Column | Description |
|---|---|
| Workspace | The workspace where the document with the availability information about this stock item originated. |
| Allocation type | The type of allocation for the specified quantity of the stock 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 stock item. |
| Ref. no. | The reference number of the document used as a source of allocation information about the specified quantity of the stock item. |
| Warehouse | The warehouse where the specified quantity of the stock item was allocated. Note This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the specified quantity of the stock item was allocated. Note This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number assigned to the specified quantity of the stock item. Note This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Qty. | The quantity of the item allocated at the specified location. |
| 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 | This check box indicates (if selected) that this quantity is not available (for example, broken) at the location. |
| Expired | This check box indicates (if selected) that the expiration date for quantity has passed. |