# Inventory by Location Fields

The Inventory by Location module comprises several essential fields, each capturing specific details about inventory status and location. This helps to give a clear view of the inventory distribution and handle inventory allocation effectively.

#### Inventory by Location Fields

<table><thead><tr><th width="219">Field</th><th>Description</th></tr></thead><tbody><tr><td>Store Name</td><td>This field displays the store name.</td></tr><tr><td>Type</td><td>This field shows the inventory location type associated with the item, such as Warehouse, Return, QA, In Transit, etc. The In Transit type helps users identify inventory that is currently being transferred or is in transit between locations. To view in-transit inventory items, users can use the Advanced Search option in the Inventory by Location module and filter records where the Type field is set to In Transit.</td></tr><tr><td>Item Number</td><td>This field captures the item's name.</td></tr><tr><td>Description</td><td>Item's description is captured in this field.</td></tr><tr><td>Group</td><td>This field shows the item's group.</td></tr><tr><td>Brand</td><td>This field shows the item's brand.</td></tr><tr><td>Category</td><td>The item category is captured in this field.</td></tr><tr><td>Tags</td><td>Any tag(s) associated with the item are captured in this field.</td></tr><tr><td>Location</td><td>This field shows the store's location.</td></tr><tr><td>Pick Seq</td><td>This field displays the pick sequence for the item.</td></tr><tr><td>Location Barcode</td><td>This field shows the barcode associated with the item.</td></tr><tr><td>Class</td><td>This field shows the item class.</td></tr><tr><td>On Hand</td><td>The on hand quantity of the item is captured in this field.</td></tr><tr><td>UOM</td><td>The item's UOM (Unit of Measurement) is displayed in this field.</td></tr><tr><td>Not Available</td><td>The item quantity not available to sell is captured in this field.</td></tr><tr><td>Available</td><td>The available item quantity is shown in this field.</td></tr><tr><td>Allocated</td><td>The allocated item quantity is displayed in this field.</td></tr><tr><td>Net Available</td><td>The net available quantity for the item is captured in this field.</td></tr><tr><td>Area</td><td>This field shows the area specified for the location.</td></tr><tr><td>Aisle</td><td>This field shows the aisle specified for the location.</td></tr><tr><td>Bay</td><td>This field shows the bay specified for the location.</td></tr><tr><td>Level</td><td>This field shows the level specified for the location.</td></tr><tr><td>Position</td><td>This field shows the position specified for the location.</td></tr><tr><td>Depth</td><td>This field shows the depth specified for the location.</td></tr><tr><td>Length</td><td>This field shows the length specified for the location.</td></tr><tr><td>Width</td><td>This field shows the width specified for the location.</td></tr><tr><td>Height</td><td>This field shows the height specified for the location.</td></tr><tr><td>Is Sellable?</td><td>This field indicates whether the item is sellable or not.</td></tr><tr><td>Is Manufacturable?</td><td>This field indicated whether the item is manufacturable or not.</td></tr><tr><td>Is Raw Material?</td><td>This field indicated if the item can be used as a raw material or not.</td></tr><tr><td>Is Purchaseable?</td><td>This field indicated whether the item is purchaseable or not.</td></tr><tr><td>Is Active?</td><td>This field shows if the item is active or not.</td></tr><tr><td>Unit Price</td><td>This field shows the standard price of the item.</td></tr><tr><td>Unit Cost</td><td>This field shows the standard cost of the item.</td></tr><tr><td>Average Unit Cost</td><td>This field shows the average cost of the item.</td></tr><tr><td>Default Vendor</td><td>This field specifies the default vendor, if any, associated with the item.</td></tr><tr><td>Item Barcode</td><td>This field displays the item barcode.</td></tr><tr><td>UPC</td><td>This field shows the item UPC.</td></tr><tr><td>Season(s)</td><td>The field shows any season(s) associated with the item.</td></tr><tr><td>LPN#</td><td>This field displays the LPN number associated with the item.</td></tr><tr><td>Manufacture Date</td><td>This field shows the manufacturing date of the item.</td></tr><tr><td>Expiry Date</td><td>This field shows the expiry date of the item.</td></tr><tr><td>Batch#</td><td>This field displays the batch number associated with the item.</td></tr><tr><td>Lot#</td><td>This field displays the lot number associated with the item.</td></tr><tr><td>LPN Pick Seq</td><td>This field displays the LPN pick sequence for the item.</td></tr><tr><td>LPN Create Datetime</td><td>This field displays date and time of LPN creation.</td></tr><tr><td>LPN Created By</td><td>This field shows the username of the individual who created the LPN.</td></tr><tr><td>LPN Modify Datetime</td><td>This field displays date and time when the LPN was last modified.</td></tr><tr><td>LPN Modified By</td><td>This field displays the username of the individual who last modified the LPN.</td></tr><tr><td>Quality</td><td>This field displays the item quality.</td></tr><tr><td>Pallet</td><td>This field displays the pallet details associated with the location.</td></tr><tr><td>Case Qty</td><td>This field displays the case quantity set for the item.</td></tr><tr><td>Is Sealed Case?</td><td>This field indicated whether the case is sealed or not.</td></tr><tr><td>Image</td><td>This field shows the item image.</td></tr><tr><td>Custom Prices</td><td>This custom fields shows any custom prices added for the item.</td></tr><tr><td>Item Alert Notes</td><td>Any alert notes added at the item level are captured in this field.</td></tr><tr><td>Item Sales Notes</td><td>Any sales notes added at the item level are captured in this field.</td></tr><tr><td>Alternative Item Number1</td><td>This field displays an alternative item number1 for the item, providing additional identification.</td></tr><tr><td>Alternative Item Number2</td><td>This field displays an alternative item number21 for the item, providing additional identification.</td></tr><tr><td>Alternative Item Number3</td><td>This field displays an alternative item number3 for the item, providing additional identification.</td></tr><tr><td>Location Zone</td><td>The zone associated with the location is displayed here.</td></tr><tr><td>Last Counted Datetime</td><td>This field displays the date and time when the inventory was last counted.</td></tr><tr><td>Last Counted By</td><td>This field displays the user name of the individual who last conducted the cycle count.</td></tr><tr><td>Item Sub Category</td><td>This field shows the item sub category.</td></tr></tbody></table>

### **Inventory by Location Header Search Fields**

The Inventory by Location module features a range of search fields at the header level, enabling users to filter data effectively to retrieve specific records. These fields facilitate the search for inventory stock of a chosen item throughout various stores and locations, as well as viewing the availability of items at a designated store and location.

1. **Store:** Choose the specific store to view its inventory details.
2. **Location:** Pick the exact location within the chosen store to explore its inventory.
3. **Item#:** Enter the item number to check its inventory distribution.
4. **Description:** Enter the description associated for the item for which you want to see the inventory distribution.
5. **Brand:** Enter the item's brand.
6. **Category:** Enter the item's category.
7. **Item Barcode:** Enter the item's barcode.
8. **Alternate Item#:** Enter the alternative item number associated with item for which you want to see the inventory distribution.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/inventory/inventory-by-location/inventory-by-location-fields.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.