This tab provides a listing of inventory transactions for this item
Buttons
Refresh
Click this button to re-load with the latest transactions.
Output
Click this button to output the grid contents to a spreadsheet. The output tool includes a variety of filtering and sorting options.
Collapse
When the grid is grouped by a column heading dragged into the upper panel, click this button to collapse the group contents.
Expand
When the grid is grouped by a column heading dragged into the upper panel, click this button to expand the group contents.
Drag & Drop Panel
You can drag and drop any column heading into the header panel to group lines by the field values in that column. You can also drag and drop an additional column heading to create a sub-group.
Grid Fields
Date
This is the transaction date. By default transactions are listed most recent date first.
Trxn Type
This is the transaction type. Possible values include:
JOBREC= Job Receipt
POREC = PO Receipt
PICK = Order Pick
ISSUE = Job Issue
STKADJ = Stock Adjustment
COUNT = Stock Count
Transfer = Stock Transfer
ALTER = Alter Characteristic
VALCHG= Book Value Change
COSTCHG = Inventory Cost Change
Qty
This is the transaction quantity.
Location
This is the location associated with this transaction.
Reference
This is reference text associated with this transaction.
Unit Cost
This is the unit cost associated with this transaction.
Total Cost
This is the Qty x Unit Cost associated with this transaction.
Trxn OH
This is the stock on hand quantity at time this transaction was completed.
Inv Cost
This is the calculated average cost resulting from this transaction.
Value OH
This is the total inventory value on hand at the time this transaction was completed.
Source
This is the Sales Order, Job, or PO Number of the inventory transaction.
Batch No
This is the inventory transaction batch number and live link transition to the Batch tab of the SO Inquiry, Job Inquiry, or PO Inquiry screen.
Name
This will display the Customer name for sales orders, Supplier name for Purchase Orders, or the Job Name for Jobs.
User Name
This is the DBA User that performed the transaction.
