> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/inventory/inventory-change-log/inventory-change-log-fields.md).

# Inventory Change Log Fields

The inventory change log module provides comprehensive information about each inventory change, facilitating efficient management, tracking, and analysis of inventory transactions within the system.

### Inventory Change Log Search Fields

The inventory change log module offers various search fields to make navigating the module easier. The fields allow you to filter the data and quickly locate specific inventory transactions.

<figure><img src="/files/tiEvmXQyh8YVnsK2Um98" alt=""><figcaption></figcaption></figure>

* **Inventory Type:** This field allows you to select the inventory level for which you want to see the change log.
* **Stores:** Select the store(s) for which you want to see the inventory changes.
* **Item#:** This field allows users to search for inventory transactions by the unique item number assigned to each item.
* **Description:** Use this field to search for inventory transactions based on the description of the items.
* **Location:** Search by the location within the store or warehouse where the inventory transaction took place.
* **Ref Number:** This field allows you to search for the inventory transaction using the reference number associated with the transaction, such as a sales order number, purchase order number, or invoice number.
* **Brand:** Search the inventory transaction using item's brand.
* **Category:** This field allows you to filter inventory transactions based on predefined categories or classifications assigned to items.
* **Item Barcode:** This field allows you to search for the inventory transaction by item barcode.
* **Alternate Item#:** Enter the alternative item number in this field to search for related inventory transactions.
* **LPN Number:** This field allows you to search for inventory transactions based on the LPN number, which is useful for tracking grouped inventory movements.
* **Pallet:** This field allows you to search and filter pallet movement details more efficiently. By entering the pallet ID, users can now quickly access specific pallet movement logs.

### Inventory Change Log Columns

The inventory change log module offers various columns that meticulously records essential details associated with each inventory transaction.

<figure><img src="/files/EIaJ8I4uNmwEuZUzNtfV" alt=""><figcaption></figcaption></figure>

<table><thead><tr><th width="254">Field</th><th>Description</th></tr></thead><tbody><tr><td>Type</td><td>This field indicates whether the inventory change was an addition ("In") or a deduction ("Out").</td></tr><tr><td>Txn Type</td><td>This field specifies the type of transaction related to the inventory change, such as sales order, purchase order, inventory adjustment, etc.</td></tr><tr><td>Txn Ref</td><td>This field captures the reference number that is unique to each transaction.</td></tr><tr><td>Store</td><td>This field captures the store where the inventory change occurred.</td></tr><tr><td>Location</td><td>This field specifies the specific location within the store where the inventory change occurred.</td></tr><tr><td>Item</td><td>This field displays the item involved in the inventory change.</td></tr><tr><td>Qty</td><td>This field shows the number of items added or removed in the transaction.</td></tr><tr><td>Created By</td><td>This field captures the user name of the individual who initiated the transaction.</td></tr><tr><td>Create Datetime</td><td>This field indicates the date and time when the inventory change was recorded in the system.</td></tr><tr><td>Image</td><td>This field captures the image of the item involved in the inventory change, providing visual reference and aiding identification.</td></tr><tr><td>Txn Date</td><td>This field captures the date of the transaction.</td></tr><tr><td>Description</td><td>This field displays the item description.</td></tr><tr><td>Group</td><td>This field shows the item group.</td></tr><tr><td>Season</td><td>This field displays the season associated with the item, if applicable.</td></tr><tr><td>Tags</td><td>This field shows any tag(s) added to the item.</td></tr><tr><td>Standard Price</td><td>This field captures the standard selling price of the item.</td></tr><tr><td>Brand</td><td>This field displays the item brand, if applicable.</td></tr><tr><td>Item Category</td><td>This field shows the category to which the item belongs.</td></tr><tr><td>Item Barcode</td><td>This field shows the barcode associated with the item.</td></tr><tr><td>UPC</td><td>This field captures the item UPC.</td></tr><tr><td>Standard Cost</td><td>This field captures the standard cost of purchasing the item.</td></tr><tr><td>Custom Prices</td><td>The custom price fields depict the custom pricing applied to the item for specific conditions or sales.</td></tr><tr><td>Memo</td><td>This field captures any notes or additional information related to the inventory transaction.</td></tr><tr><td>SO Number</td><td>This field indicates the sales order associated with the transaction, if applicable.</td></tr><tr><td>Alternative Item Number1</td><td>This field shows the alternative item number 1 given to the item.</td></tr><tr><td>Alternative Item Number2</td><td>This field shows the alternative item number 2 given to the item.</td></tr><tr><td>Alternative Item Number3</td><td>This field shows the alternative item number 3 given to the item.</td></tr><tr><td>Inventory Type</td><td>This field displays the inventory level corresponding to the inventory change.</td></tr><tr><td>From LPN#</td><td>This field depicts the LPN number from which the item was moved.</td></tr><tr><td>To LPN#</td><td>This field depicts the LPN number to which the item was moved.</td></tr><tr><td>From Pallet</td><td>This field depicts the pallet from which the item was moved.</td></tr><tr><td>To Pallet</td><td>This field depicts the pallet to which the item was moved.</td></tr><tr><td>From OLPN#</td><td>This field depicts the OLPN number from which the item was moved.</td></tr><tr><td>To OLPN#</td><td>This field depicts the LPN number to which the item was moved.</td></tr><tr><td>From LPN Lot#</td><td>This field depicts the lot number from which the item was moved.</td></tr><tr><td>From LPN Batch#</td><td>This field depicts the batch number from which the item was moved.</td></tr><tr><td>From LPN Mfg Date</td><td>This field depicts the manufacturing date of the LPN number from which the item was moved.</td></tr><tr><td>From LPN Quality</td><td>This field depicts the quality of the LPN number from which the item was moved.</td></tr><tr><td>From LPN Exp Date</td><td>This field depicts the expiry date of the LPN number from which the item was moved.</td></tr><tr><td>To LPN Lot#</td><td>This field depicts the lot number to which the item was moved.</td></tr><tr><td>To LPN Batch#</td><td>This field depicts the batch number to which the item was moved.</td></tr><tr><td>To LPN Mfg Date</td><td>This field depicts the manufacturing date of the LPN number to which the item was moved.</td></tr><tr><td>To LPN Quality</td><td>This field depicts the quality of the LPN number to which the item was moved.</td></tr><tr><td>To LPN Exp Date</td><td>This field depicts the expiry date of the LPN number to which the item was moved.</td></tr><tr><td>Customer Name</td><td>This is the name of the customer associated with each inventory change.</td></tr><tr><td>Pallet (From/To)</td><td>This column displays the source and destination pallets for inventory movements.</td></tr></tbody></table>

### Inventory Change Log Header Level Icons

<figure><img src="/files/9hz1wRTeh08daOJ6KbfS" alt=""><figcaption></figcaption></figure>

1. **Refresh:** This allows you to refresh the search results after changing the search criterion.
2. **Save:** This option enables you to preserve any updated user interface (UI) settings (for example, if you have hidden or added any columns for viewing), ensuring a personalized and consistent experience during future interactions with the module.
3. **Advance Search:** The advance search option lets you refine the search criteria. You can delve into a nuanced search by specifying criteria such as Column Name, Operator, and Value, facilitating precise and tailored searches.
4. **Columns (Bento Menu):** All the columns available for the module are listed under this icon. You can use this option to hide or add the columns and tailor the module view as per your requirements.
5. **Download:** This versatile feature allows users to export data in various file formats and provides a summary for quick reference. Options include CSV, TXT, MS Word, MS Excel, PDF, and MS Excel (.xlsx), catering to diverse user preferences and use cases.

#### FAQs

#### How can users view the inventory movement history of an item?

Users can view the complete inventory movement history of an item through the **Inventory Change Log** module.

Navigate to:

**Menu → Inventory → Inventory Change Log**

The Inventory Change Log provides a detailed audit trail of all inventory transactions associated with an item, helping users track inventory movements and investigate stock discrepancies.

***

#### What information is available in the Inventory Change Log?

The **Inventory Change Log** displays detailed transaction information, including:

* Transaction Type (Inbound or Outbound)
* Quantity Changed
* Transaction Date
* Reference Number
* Location
* User who performed the transaction

This information helps users understand when inventory was added, removed, transferred, or adjusted.

***

#### How can users check the current inventory quantity of an item by location?

To view the current stock available at each store or location, navigate to:

**Menu → Inventory → Inventory by Location**

The Inventory by Location module displays item quantities across locations and provides visibility into where inventory is currently stored.

***

#### What is the difference between the Inventory Change Log and the Inventory by Location?

Both modules provide inventory-related information but serve different purposes:

| Requirement                                            | Recommended Module    |
| ------------------------------------------------------ | --------------------- |
| View inventory transaction history and audit trail     | Inventory Change Log  |
| View current inventory quantities by store or location | Inventory by Location |
| Investigate stock movement details                     | Inventory Change Log  |
| Check available stock across locations                 | Inventory by Location |

***

#### Can users investigate inventory movements for a specific item?

Yes. Users can filter the **Inventory Change Log** by item to review all inventory transactions associated with that specific item.

This allows users to trace inventory movement history, identify transaction sources, and review inventory changes over time.

***

#### Can users drill down into inventory activity from the Inventory by Location screen?

Yes. The **Inventory by Location** module not only displays current inventory quantities by location but also allows users to drill down into inventory activity related to specific locations and items for additional visibility.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/inventory/inventory-change-log/inventory-change-log-fields.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.