View the inventory history
Looking at a product’s inventory history can help you understand why the product has a specific current cost or a specific current quantity. When you access the product’s inventory history, you can see all transactions that impacted its cost and inventory quantity.
Note: Your inventory is impacted each time you add a product. If you add the initial quantity and initial cost when you add a product, OnBalance will use this information in the inventory history. If you do not add the initial quantity and initial cost when you add a product, you can enter that information through an inventory adjustment.
- Click Inventory History for the product history you want to see.
- Optional: Filter the list to see information, such as a date range or the type of history, on specific products.
- If you do not apply a filter, the list will show the current unit cost and quantity of the product listed by date in descending order, showing the most-recent transactions at the top.
- If you apply a filter in the Date field, the list will show the unit cost and quantity of each product based on the analyzed end date.
- If you apply a filter in the Type field, the list will show only the types of inventory you select in this field.
The following is a list of transaction types.
| Initial Data | Filters the list by when you added the products. There is only one transaction for this type, which shows the cost and/or quantity you defined when you added the product. |
| Invoice | Filters the list by when you added a sale. If you changed the quantity of the product in a sale, OnBalance updated the record with the new quantity. If you canceled or deleted the sale, OnBalance deleted the record. |
| Purchase | Filters the list by when you added a purchase. If you changed the quantity of the product in a purchase, OnBalance updated the record with the new quantity. If you canceled or deleted the purchase, OnBalance deleted the record. |
| Adjustment | Filters by the list of adjustments that you made to products in your inventory. |
| Client's Return | Filters the list by when you added a customer’s product return. If you changed the quantity of the product in the customer’s return, OnBalance updated the record with the new quantity. If you canceled or deleted the customer’s return, OnBalance deleted the record. |
| Return to Vendor | Filters the list by when you added a product return to a vendor. If you changed the quantity of the product in the return to the vendor, OnBalance updated the record with the new quantity. If you canceled or deleted the return to this vendor, OnBalance deleted the record. |
- In the Cost column, you can analyze the current unit cost of the product. For more information about the cost and how OnBalance calculates it, see Inventory cost unit.
- In the Quantity column, you can analyze the current quantity of the product. For more information about how OnBalance calculates the quantities, see Inventory quantity calculation.
You cannot add, edit, or delete any of the records in the inventory history. The records are consequences of actions in other areas of OnBalance, as explained above. If you want to change the current quantity or cost of the product that is listed in the inventory history, you should enter an inventory adjustment.