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.
TABLE OF CONTENTS
Running and Filtering the Report
The Inventory Transactions report can be found in the Reports module under Standard Reports > Compliance Reports. Enter the date range and click Build. Once the report is open, it can be filtered for the product and the warehouse.
Report Terminology
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 were a backdated adjustment, the report would 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 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 which it was transferred.
Brand: The brand or manufacturer of the item being transacted. This is entered in the catalog manager.
Cost: The cost associated with the item or the value assigned to it for accounting and tracking purposes. This is entered in the catalog manager.
FAQ's
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.