Inventory Transaction History Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Contents

Field Description
Transaction No This column displays the transaction number.
Transaction Type

This column displays the transaction type:

  • IS (Inventory Issues): Transactions that fulfill item requests.
  • QA (Quantity Adjustments): Transactions that adjust the quantity of the inventory item on hand.
  • LM (Location Moves): Transactions that change the location of inventory items within your firm.
  • CA (Cost Adjustments): Transactions that adjust original costs and updated costs for inventory items.
Transaction Date This column displays the date on which the transaction was posted.
Item This column displays the inventory item number.
Description This column displays the description of the item.
Category This column displays the category to which the item belongs (for example, Furniture, Phone, or Office Supplies).
Location This column displays the location in which the item is stored or the location from which the item was issued or moved.
Transaction Quantity This column displays the number of inventory items involved in the transaction.
Transaction Cost This column displays the cost of the inventory items involved in the transaction.
U/M This column displays the unit of measure for the items (for example, each, box, case, or dozen).
Transaction Total This column displays the total cost for the inventory items involved in the transaction.
Performed By This column displays the employee number of the employee who performed the transaction.
Performed By Name This column displays the name of the employee who performed the transaction.
Submitted/Received By This column displays the employee number of the employee who submitted the transaction. For receipt transactions, this column displays the employee number of the employee who received the inventory item, as entered in the Receiving application.
Submitted/Received By Name This column displays the name of the employee who submitted the transaction. For receipt transactions, this column displays the name of the employee who received the inventory item, as entered in the Receiving application.
Submitted/Received Date This column displays the date on which the transaction was submitted. For receipt transactions, this column displays the date on which the inventory item was received, as entered in the Receiving application.
Comment This column displays the text entered to describe the transaction when the transaction was posted.
Location From If the transaction is a location move, this column displays the original location of the inventory item.
Adj Unit Cost If the transaction is a cost adjustment, this column displays the amount by which the original inventory item unit cost was increased or decreased.
Project If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the number of the project associated with the transaction.
Phase If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the number of the phase associated with the transaction.
Task If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the number of the task associated with the transaction.
Project Name If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the name of the project associated with the transaction.
Phase Name If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the name of the phase associated with the transaction.
Task Name If the transaction is an inventory issue, quantity adjustment, or unit cost adjustment, this column displays the name of the task associated with the transaction.
Account If the transaction is a quantity adjustment or cost adjustment, this column displays the account that receives the credit entry for an increase in unit cost.
Skip GL This Yes/No column indicates whether or not you are suppressing charges to the general ledger account associated with the inventory transaction.
Reason If the transaction is a quantity adjustment or cost adjustment, this column displays a code that indicates the reason for the adjustment.
Create User This column displays the user ID of the employee who created the transaction.
Create Date This column displays the date on which the transaction was created.