Inventory Transactions

Inventory transactions record the accounting functions that occur when inventory is moved between locations. After you move inventory, the quantity balance for the item is adjusted and accounting entries are created. The net quantity indicates quantity moved — positive or negative — based on the inventory transaction type. To learn more, see Inventory Accounting.

You can use the list view page to track an item or lot from the point at which you receive the purchase order through work order assignment and sales order allocation. Each transaction includes summary information about the transaction type, the net quantity, and the unique SKID associated with the transaction type.

Inventory Transaction Field Descriptions

The following table lists the fields that Kenandy provides. Your system administrator selects the fields that are displayed on your user interface.

Inventory Transaction Field Descriptions
Field	Description
Accounted	An indication of whether the accounting entries for the selected record are complete.
Bin	The bin to which the Inventory is moved.
Book Value of Related Fixed Asset	Tracks the value of a fixed asset that's returned to inventory when the inventory change is created.
Consigned Owner	The name of the supplier.
Container Item	The container item used to hold the items in this transaction.
Date Received	The date on which inventory was received.
Expiration Date	The date on which the goods (To-SKID) expire.
Extended Cost	The item's standard cost multiplied by the number of items purchased.
Extended Price	This field's value equals Quantity Received multiplied by PO Price. The Extended Price field is populated in all inventory transactions of type `Transfer of Ownership`. Kenandy uses this field for GRNI reconciliation.
Finalized	An indication of whether the document is final. An accounting entry is automatically generated for the source document in the next scheduled batch process.
Finalized Date	The date the transaction was finalized for accounting.
From Bin	The bin from which the inventory is moved.
From Facility	The facility from which the Inventory is moved.
From Location	The location from which the inventory is moved.
From Lot	The lot from which the inventory is moved.
From Packaging UOM	Used only if this inventory transaction shows inventory changing from one packaging UOM to a different packaging UOM. For example, if this inventory transaction shows cases being put onto a pallet, the From Packaging UOM value is `CS` (case).
From SKID	The SKID from which the inventory is moved.
From Standard Cost	The standard cost of the item before the change in location.
Inventory Change	The inventory change associated with the inventory item.
Item	The item affected by the transaction.
Line Type	The line type for the inventory transaction. Options include Standard, Increase, and Decrease.
License Plate Number	The license plate number (LPN) attached to this transaction. License Plate Number will only have a value if the item is LPN-tracked, and the Packaging UOM is of the highest packaging class level.
Lot	The lot to which the inventory is moved.
Net Quantity	The net quantity for the inventory transaction. Change to the quantity on hand.
Non Inventory	This transaction is for a non inventory item. Non inventory item transactions are filtered out of inventory valuation reports and other inventory-specific reports.
Order Line	The order line, if any, associated with the inventory item.
Packaging UOM	The packaging UOM used in this transaction. The Packaging UOM value corresponds to the Quantity (Packaging UOM) field.
Purchase Order Line	The purchase order line, if any, associated with the inventory item.
Quantity (Packaging UOM)	The quantity of items in this transaction by packaging UOM. This shows you how the inventory was packaged when this transaction occurred. For example, if four cases of 12 phones moved in this transaction, the Quantity (Packaging UOM) value = 4.
Quantity (Stocking UOM)	The quantity of items in this transaction by stocking UOM. This shows you how inventory will be counted in this transaction for accounting purposes. For example, if four cases of 12 phones moved in this transaction but your stocking UOM for phones is eaches, the Quantity (Stocking UOM) value = 48.
Receipt Line	The receipt line, if any, associated with the inventory item.
Reversed	An indication of whether the transaction has been reversed.
Sales Order Line	The sales order line, if any, associated with the inventory item.
Shipment Line	The shipment line, if any, associated with the inventory item.
Standard Cost	The standard cost for the inventory transaction. The standard cost is updated periodically, but is constant for a specified period of time.
Stocking UOM	The stocking UOM used in this transaction. The Stocking UOM value corresponds to the Quantity (Stocking UOM) field.
Subtransaction Type	The subtransaction type for the inventory transaction. Subtransaction types can be used in conjunction with a transaction type to determine when to generate an accounting entry. For example, create an accounting rule so that: If transaction type is Purchase Receipt, generate accounting entry If transaction type is Purchase Receipt and subtransaction type is Expense, skip accounting.
To Facility	The facility to which the inventory is moved.
To Location	The location to which the inventory is moved.
To SKID	The SKID to which the inventory is moved.
To Standard Cost	The standard cost of the item after the change in location.
Transaction Date	The date of the transaction.
Transaction Unit Cost
Type	The type of inventory transaction. This field is used to classify a transaction for reporting purposes.
Work Order	The work order, if any, associated with the inventory item.

_________________________________

To search the KnowledgeBase and documentation, ask a question, or log a case, please visit the Kenandy Community. To access our online training, visit the Kenandy Learning Center.

Version: Spring 2017