Reading the Inventory Transactions Report
What is the Inventory Transactions report?
Inventory Transactions report involves the movement or changes in the quantity and location of inventory items within a business. The fields are commonly used to track and record these transactions.
How can I filter Inventory Transactions?
The Inventory Transactions report can be filtered for the product and Warehouse.
What do each of the fields mean on the Inventory Transactions?
Warehouse: The specific location or facility where the inventory transaction took place, such as a storage facility or distribution center.
OPSKU: An abbreviation for "Original Product Stock Keeping Unit." It is a unique identifier assigned to a specific product or item within the inventory management system.
Part No: The part number that uniquely identifies the specific part or item in the inventory.
Title: The name of the item being transacted.
Date: The date when the inventory transaction occurred. If this was a backdated adjustment, the report will display this information.
Qty: The quantity of items involved in the transaction, indicating the number of units added or deducted from the inventory.
Balance: The updated quantity of the item after the transaction, representing the remaining stock level.
Transfer: An indication of whether the inventory was transferred between different locations or warehouses.
Who: The individual or entity responsible for initiating or performing the inventory transaction.
Reason: The reason or purpose behind the inventory transaction, such as sales, returns, adjustments, or stock replenishment.
Order: This order listed was completed with the following product.
Return: The order listed was refunded with the following product
Adjustment: A manual adjustment was made to the product
Backdate Adjustment: A Manual adjustment was made to the product and backdated.
Transfer: This will display the name of the warehouse to the Name of the warehouse it was transferred to.
Brand: The brand or manufacturer of the item being transacted. This is imputed in the catalog manager.
Cost: The cost associated with the item or the value assigned to it for accounting and tracking purposes. This is imputed in the catalog manager.
Why does my SKU look like this: "SKU: 88882013-2251-5_001"?
This is related to Loyalty points. If the winery saves loyalty point information on the item in the Catalog Manager, it adds those additional digits at the end of the SKU. If the winery were to update that loyalty point information, it would update the SKU to 5_002, and so on. The system just needs to be able to differentiate between the regular item and the item purchased with loyalty points.