Article

Article Body

Overview

All Inventory Cost related transactions are available to view. Details include Location specific information as well as Item, Order Number, Costs, Account, Date, Quantity, and User.

Application

Every Inventory transaction generates an Inventory Cost Transaction record. These records are permanent and not editable. There are audit trail records of each transaction.

Terminology

The various transactions are each coded with a Transaction ID, and potentially a Transaction Sub ID, denoting the transaction type. This gives an explanation of each of the various transaction types and, where applicable, and the associated Sub ID.

Navigation

Inventory Cost Transactions

List View

Select the transaction to view using the Name Column/Row

Page Display

The displayed page provides detailed information about this Cost Transaction. Actual Serial Numbers will appear in the “Serial Text” box.

Fields

Division: The division in which the transaction was processed.

Inventory Item Master: Applicable Inventory Item Master for the given transaction. If using Cost Transaction Inquiry, this can be used to filter results, retrieving only transactions for this item.

Date/Time: This is the date and time the transaction was created.

Transaction ID:  This identifier represents the specific type of cost transaction. Some examples are:
PO Receipt = PORCPT, WO Issue = WOISS, Inv Adjustment = INVLOCADJ. See more Rootstock Cost Transaction ID and Sub ID Listing

Transaction Sub ID: This identifies a sub-classification for this Cost Transaction.

Sequence No: When multiple cost transactions are created as a result of one transaction, this value is incremented for each of those cost transactions.

Transaction Qty: The quantity of the inventory item transacted.

Inventory UOM: This is the Inventory UOM associated with the Item. (Note that all transactions are in Inventory UOM.)

Unit Cost, Total: This is the sum of all the individual Unit Cost components for this transaction.

Unit Cost, Tot Ext: This is the Unit Cost Total extended by the transaction quantity.

User Number: This is the Mfg User Number of the employee that performed the transaction.

Project: Under Project Control, this is the Project associated with the transaction.

Project Charge Code:   This is the Project Charge Code associated with the transaction.

Track Lot: When checked, indicates that the item is Lot Controlled.

Lot Number:  This is the Lot Number entered by the user when processing a transaction for a Lot Controlled Item.

Track Serial: When checked, indicates that the item is Serial Controlled.

Serial Number:  User entered Serial Number for this transaction.

RMA Detail: Cost Transaction RMA Number.

Update GL: Indicates whether there is a GL Impact as a result of the transaction. Nearly all transactions will impact the GL, however, a transaction such as a Stock Location move, where inventory is merely moved from one Stock Location to another, would not.

Debit Account: When the transaction has a GL impact, this is the Mfg Account (which is mapped to a GL Account) that is being debited by this transaction. It is offset by the Credit Account.

Credit Account: When the transaction has a GL impact, this is the Mfg Account (which is mapped to a GL Account) that is being credited by this transaction. It is offset by the Debit Account.

Quantity on Hand: This is the Quantity On-Hand as a result of this transaction.

Non-Nettable Qty: This is the Non-Nettable Quantity on-hand, as a result of the transaction.

Qty Consigned: This is the Consigned Quantity on-hand as a result of this transaction.

UOM Conversion Factor: This is the conversion factor between the Purchasing UOM and the Inventory UOM.

Purchasing UOM: This is the unit of measure for the PO item.

Override Transaction Date: When a transaction is backdated using the Cost Account Control record, this is the date to which the transaction is backdated, and is the date reflected on the GL Journal Entry.

Serial Text: This field contains all of the serial numbers used in the transaction.

Serial Counter: This represents the number of serial numbers involved in this transaction.

Document Number: If applicable, a user can input a document number (up to 10 characters) on transaction input screens for the given transaction.

Comments: When most transactions are being performed, there is an opportunity on the input screen for the user performing the transaction to enter free-form text (up to 100 characters) with information regarding the transaction.

Inventory by Lot: The Inventory by Lot number associated with this transaction. Displays when the item is a lot tracked item.

Origin/Destination Division: Where the given transaction is between different Divisions, this is the originating (i.e. "From") Division for the "From" cost transaction AND the destination (i.e. "To") Division for the "To" cost transaction.

Originating Sequence No:  When the transaction is between different Divisions, this is the Sequence Number of the first (originating) transaction.

RMA Line: The RMA line which was the source of this transaction.

SYDATA - System Transaction Object:  This is the SYDATA record associated with the transaction.

Transaction Accounting Value - CR:  This field represents the total Credit amount of this transaction after it has been rounded to 2 decimal places and passed along to the associated accounting system.

Transaction Accounting Value - DR:  This field represents the total Debit amount of this transaction after it has been rounded to 2 decimal places and passed along to the associated accounting system.

Inventory Container ID: The Unique Identification Number of the Inventory Container associated with the cost transaction.

The lower portion of the screen contains additional information in Tabs,

Cost/Accounting Tab: Displays the detailed accounting information.

Order Tab (Purchase Order/Work Order/Sales Order): The Orders Tab can be seen for order related costs. This tab only appears when the cost transaction relates to a Work/Purchase/Sales Order.

Inv Location Tab: The ‘Inv Location’ tab will display the location data for the completed transaction.

GL Transaction Tab: The ‘GL Transaction’ tab will display the related GL transaction.

IMPORTANT When the flag 'Suppress Cost Transaction Postings to GL' is checked on the Company Master, the GL Transactions will not be created for the Rootstock Cost Transaction (originated from ERP), but the General Journal Header will be created and remain unposted.

Title	Inventory Cost Transactions

URL Name	Inventory-Cost-Transactions