Warehouse

The number of the warehouse where the transactions took place.

Enter a valid warehouse code and select OK to display inventory transaction history for the specified warehouse. The description of the warehouse displays next to this field.

Leave this field blank if you want to display inventory transaction history for all warehouses; in this situation, the text ALL WAREHOUSES displays next to this field.

Numeric, 3 positions, optional.

Date From

Date To

The date the transaction took place.

• Enter a date range in MMDDYY or MM/DD/YY format and select OK to display inventory transaction history for the specified date range. The From date must be equal to or earlier than the To date.

• Enter a valid date in the first date field and select OK to display inventory transaction history, beginning with the date you entered.

• Enter a valid date in the second date field and select OK to display inventory transaction history, ending with the date you entered.

Numeric, 6 positions (MMDDYY or MM/DD/YY format); optional

A separate row displays for the first 500 item transaction history records that meet your search criteria.

Item

A code that represents a unit of inventory.

Enter a valid item code and select OK to display inventory transaction history that matches your entry.

Alphanumeric, 12 positions; optional.

Clr/size/wdth (SKU codes)

The item's unique characteristics, such as its color and size.

Enter a valid SKU code and select OK to display inventory transaction history for items associated with this SKU.

Alphanumeric, three 4-position fields; optional.

Date (Transaction date)

The date the transaction took place, in MM/DD/YY format.

Numeric, 6 positions; display-only.

Code

The inventory transaction code.

Enter a valid inventory transaction code and select OK to display inventory transaction history for the specified inventory transaction code.

These may be system- or user-defined.

The system-defined codes are:

• A = Adjustment

• C = Customer Return

• E = Express Bill

• G = Item to Item Transfer

• I = Issue

Note: The system writes an issue (I) type transaction history record when non-inventory and drop ship items go through billing if the Create Item Transaction History for Non-Inventory Items (E39) system control value is selected.

• M = Make up Finished Good

• O = Reset On-Hand Quantity

• P = Physical

• R = Receiving

• T = Transfer

• V = Return to Vendor

Additionally, the system creates a * transaction when you change the cost of a FIFO layer. See * = Change FIFO Cost.

Note: The system does not create a * transaction history record when you update the standard or average cost of an item. See * = Change Average or Standard Cost.

See Work with Inventory Transaction Codes (WITC).

Alphanumeric, 1 position; optional.

Location

The item's location at the time the transaction took place. The location is blank for drop shipments, non-inventory transactions, and FIFO cost changes (* transactions).

Enter a valid location and select OK to display inventory transaction history for the specified location.

Alphanumeric, 7 positions; optional.

Reason

A code that represents the reason why the inventory transaction was performed. See Work with Inventory Transaction Reason Codes (WIT1).

Enter a valid reason code and select OK to display inventory transaction history for the specified reason code.

Numeric, 2 positions; optional

Qty (Quantity)

The number of units that this transaction affected.

Numeric, 8 positions; display-only.

On-Hand Fields

Old

The on-hand quantity for the item/location before the transaction was processed.

The old on-hand quantity is blank for drop shipments and non-inventory transactions.

Numeric, 6 positions; display-only.

New

The on-hand quantity for the item/location after the transaction was processed.

The new on-hand quantity is blank for drop shipments and non-inventory transactions.

Numeric, 6 positions; display-only.

Warehouse

A code that represents the warehouse where the transaction was performed.

The warehouse is 0 for drop shipments and non-inventory transactions.

Numeric, 3 positions.

Item/SKU

Item = A code representing a unit of inventory.

Alphanumeric, 12 positions.

SKU = The item's unique characteristics, such as its color and size.

Alphanumeric, three 4-position fields.

Item description = A description of the item. The item description displays below the item code.

Alphanumeric, 40 positions.

Date/Time/Seq# (Date, time and sequence number)

The date and time when the transaction was performed, and a unique number to identify how many transactions for the same warehouse and item/SKU took place at this same date and time.

Date: Numeric, 8 positions (MMDDYY format).

Time: Numeric, 8 positions (HHMMSS format).

Sequence number: Numeric, 3 positions.

Code

A code that identifies types of inventory transactions. Certain codes are supplied by the system, and you can also create your own.

System-supplied codes are:

• A = Adjustment

• C = Customer Return

• E = Express Bill

• G = Item to Item Transfer

• I = Issue

• M = Make up Finished Good

• O = Reset On-Hand Quantity

• P = Physical

• R = Receiving

• T = Transfer

• V = Return to Vendor

Note: Any RF transactions will have a code of T.

The system uses a transaction code of * for changes to the cost of a FIFO layer. See * = Change FIFO Cost.

Note: The system does not create a * transaction history record when you update the standard or average cost of an item. See * = Change Average or Standard Cost.

See Work with Inventory Transaction Codes (WITC).

Alphanumeric, 1 position.

Location

The warehouse location affected by the inventory transaction. For example, if you are viewing an adjustment transaction, the location where the inventory was adjusted is indicated.

The location is blank for drop shipments, non-inventory transactions, and FIFO cost changes (* transactions).

Two inventory transaction history records are created for transfer transactions: One record contains the “from” location; the other contains the “to” location.

Each completed RF transaction will create four records: two each for the “pull” and the “put.” See Radio Frequency Overview.

Alphanumeric, 7 positions.

Quantity

The number of units that this transaction affected.

Numeric, 8 positions.

Old O/H (Old on-hand quantity)

The on-hand quantity before this transaction took place.

This field is blank for non-inventory items and drop ship items, since inventory is not affected. This field is the same as the New O/H quantity for changes to FIFO cost (* transactions).

Numeric, 8 positions.

New O/H (New on-hand quantity)

The on-hand quantity after this transaction took place.

This field is blank for non-inventory items and drop ship items, since inventory is not affected. This field is the same as the Old O/H quantity for changes to FIFO cost (* transactions).

Numeric, 8 positions.

ID#

Item transaction history ID

An identification number or description of the inventory transaction, either entered when the inventory transaction was created or assigned by the system.

Label settings: Possible ID# labels assigned by the system include:

• DROP SHIP = identifies a drop shipment inventory transaction.

• NONINVISSU = identifies an inventory transaction record for a non-inventory item.

Note: The system creates inventory transaction history records for drop ship and non-inventory items only if the Create Item Transaction History for Non-Inventory Items (E39) system control value is selected.

• AUTOTRANS = identifies a transaction processed using the Working with Automated Inventory Transactions (WAIT) menu option.

ID numbers: The system also uses the ID# field to provide additional information for the following types of inventory transactions:

• item-to-item transfers (transaction code = G) = a system-assigned ID number. Both the “from” and “to” transactions share the same ID number.

• finished good make-up transaction (transaction code = M) = the work order number for the finished good created through the work order process. See Finished Good Work Order Processing (WWOR) for background.

• physical inventory update (transaction code = P) = optionally, you can specify a Control ID when you use the Generate Physical Inventory Screen to submit a new physical inventory. Once you complete the physical inventory, the update program saves the Control ID to this field.

• store transfer receipts (transaction code = A) = the store transfer ID defined in the Store Transfer Receipt Table (INSTXR). See Processing Store Transfer Receipts.

Alphanumeric, 10 positions.

Batch#

The number of the batch containing the inventory transaction. The system assigns batch numbers in both immediate and batch inventory transactions.

Numeric, 7 positions.

Transaction#

The number of transactions within the batch.

Numeric, 7 positions.

Order #

The number of the order affected by the inventory transaction.

Numeric, 7 positions.

Invoice #

The number of the invoice affected by the inventory transaction.

Numeric, 7 positions.

Purchase order #

The number of the purchase order affected by the inventory transaction.

Numeric, 7 positions.

Vendor charge back no

A system-assigned number identifying a vendor charge back, when you return merchandise back to the vendor and receive a credit for the return. This number is sequentially assigned from the Vendor Charge Back # field in the Number Assignment table. See Vendor Charge Back Overview for more information on the Vendor charge back process.

Numeric, 7 positions

Reason

A code that represents the reason the inventory transaction was performed. Not all transactions have reason codes. See Work with Inventory Transaction Reason Codes (WIT1).

Numeric, 2 positions.

License plate number

The number the system assigned to the case, carton or pallet to track the inventory through the warehouse if you use radio frequency (RF). License plate numbers do not appear for R (receipt) inventory transactions, when the license plate number is actually created.

This number is included only if the LPN Tracking (E16) system control value is selected. See Radio Frequency Overview.

Numeric, 6 positions.

User

The User ID of the person who performed the transaction.

Alphanumeric, 10 positions.

G/L account #

The General Ledger number to which this transaction was posted. See General Ledger Overview for more information on how the system determines which general ledger account number to use for inventory transactions.

Numeric, 8 positions.

Extended Cost)

The Costing Method (A25) system control value controls how the system determines the cost of an item.

Average Cost: If you use average costing, this is the unit cost of the item. The system uses the Average cost from the SKU table for both SKU’d and non-SKU’d items.

Standard Cost: If you use standard costing, this is the unit cost of the item. The system uses the Standard cost from the SKU table for both SKU’d and non-SKU’d items.

FIFO Cost: If you use FIFO costing, this is the extended cost of all units. In FIFO costing, a single transaction may derive unit costs from more than one FIFO cost layer, making it impossible to display a single unit cost on this screen.

Note: The Display Cost in Inventory (A38) secured feature controls the display of this field.

Numeric, 10 positions with a four-place decimal.

Warehouse

The warehouse where the transaction took place.

Numeric, 3 positions; display-only

Item/SKU

The item and SKU affected by the transaction.

Item: alphanumeric, 12 positions; display-only.

SKU: alphanumeric, three 4-position fields; display-only.

Item description (Unlabeled field below the item/SKU)

The description of the item.

Alphanumeric, 40 positions; display-only.

Date/time/seq # (Date/time/sequence number)

The date and time when the transaction took place, followed by a number to identify how many transactions for the same warehouse and item/SKU took place at this same date and time.

Date: numeric, 6 positions (MM/DD/YY format); display-only.

Time: numeric, 6 positions (HH:MM:SS format); display-only.

Sequence number: numeric, 7 positions; display-only

FIFO Seq # (FIFO sequence number)

A unique number to identify which FIFO cost layer for the warehouse, creation date, item, and SKU provided the cost for this inventory transaction.

Numeric, 7 positions; display-only.

FIFO date

The date when the FIFO cost layer was created. Typically, FIFO layers are created through a purchase order receipt, but the system also creates them due to customer returns, adjustments, physical inventory counts, vendor charge back reversals, or when you convert to FIFO costing from another costing method.

Numeric, 5 positions (MM/DD/YY format); display-only

Qty (Quantity)

The number of units using the FIFO cost indicated. The system selects a FIFO layer for costing an inventory transaction based on a standard hierarchy; see FIFO Costing Overview.

Sometimes the on-hand quantity of the first selected FIFO layer is lower than the total quantity of the transaction. In this situation, the system exhausts the quantity of the first FIFO layer and selects the next FIFO layer in the standard hierarchy to cost the remaining quantity of the transaction.

Example: An issue transaction involves 10 units. There were two FIFO layers for the item in warehouse 2. The first FIFO layer, created on 11/10 through a purchase order receipt, had an on-hand quantity of 5 units remaining. The second FIFO layer, created on 12/23 through a customer return, had an on-hand quantity of 10 units. The system selected the older FIFO layer and exhausted those 5 units. Then the system selected the next available FIFO layer to provide the cost of the remaining 5 units of the issue transaction.

Numeric, 7 positions; display-only.

FIFO cost

The unit cost from the FIFO layer selected for the transaction.

Note: The Display Cost in Inventory (A38) secured feature controls the display of the FIFO cost field.

Numeric, 11 positions with a 4-place decimal; display-only.

Extended cost

The total cost of the transaction from this FIFO layer. The extended cost is calculated by multiplying the FIFO cost by the quantity for the FIFO layer.

Note: The Display Cost in Inventory (A38) secured feature controls the display of the Extended cost field.

Numeric, 13 positions with a 4-place decimal; display-only.