> 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 enables you to further extend 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 and download data in various file formats, providing a summarized overview for quick reference. Options include CSV, TXT, MS-Word, MS-Excel, PDF, and MS-Excel(.xlsx), catering to diverse user preferences and use cases.


---

# 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:

```
GET https://docs.xorosoft.com/xoroerp-1/inventory/inventory-change-log/inventory-change-log-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.