V9 - Using transaction history
An item's transaction history shows any transaction which has affected the quantity and value of the item, as well as any location transfers. Other details that you can see within the transaction history are the associated customer or vendor, the to and from location as needed, reference numbers of associated transactions, and changes in quantity and cost basis. If you are using multicurrency, the transaction history will show the item values in your home currency only.
Transaction history is available only for Inventory and Assembly item types. The transaction history list is sortable. You can also set filters and perform a quick search.
Troubleshooting cost basis errors
An item's transaction history is an excellent tool for troubleshooting inventory and cost-basis discrepancies. Most inventory and cost basis discrepancies are due to an item, date, or quantity that was incorrectly entered in a transaction—or has not been entered at all. The transaction history reveals the point at which the error occurred so that the appropriate correction can be taken.
To view the history of an item, locate the item record on the Items list (Operations > Inventory > Items), then select Show transaction history under the record's Actions menu dropdown. Click a reference number link in the Ref # column to go to the suspect transaction on its associated list.
Transaction history column heading descriptions
The descriptions are in the order they appear on the transaction history.
Date. The date on which the transaction Event occurred.
Event. The type of transaction. (For example, shipment or receipt.)
Ref #. The transaction reference number. Click the link to open the transaction.
Txn qty. The quantity for this particular transaction. It will affect the Total qty value positively or negatively, based on the type of transaction.
Total qty. The total quantity you have in stock of this item after the transaction was saved.
Cost basis (three-letter home currency designator). The value of this transaction. Cost basis can be influenced by the transactions that precede it, especially for those that remove inventory.
Variance (three-letter home currency designator). The difference between the standard cost in the item definition and the cost basis of this transaction. Example: If you buy/sell baseballs and your standard purchase cost is $10, but you buy 2 for $8 each, the variance for the item receipt would be $4, calculated by multiplying 2 baseballs x the $2 difference in price per baseball. This number can change if you change your standard purchase cost of an item.
Total cost basis (three-letter home currency designator). The total value you have of the item. The total cost basis is influenced by every transaction that precedes it.
Avg value (three-letter home currency designator). The average value shows the cost per unit of current stock levels. It is calculated using the Total cost basis value divided by the Total qty.
Txn cost/unit (three-letter home currency designator). The average cost per unit, as calculated using the Cost basis value divided by the Txn qty.
Entity. The customer or vendor on the transaction, if applicable.
From location. The from location where the transaction affected inventory, on item receipts, inputs on production transactions, adjustments, returns to vendors, and transfers.
To location. The to location where the transaction affected inventory, on shipments, returns, outputs on production transactions, and transfers.