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.

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

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

Inventory Change Log Header Level Icons

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.