Field

Description

Whs (Warehouse)

The number of the warehouse where the transactions took place.

Numeric, 3 positions, optional.

Date

The date the transaction took place.

Numeric, 6 positions (MMDDYY format); optional

Item

A code that represents a unit of inventory.

Alphanumeric, 12 positions; optional.

Clr/size/wdth (SKU codes)

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

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); optional.

Loc

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).

Alphanumeric, 7 positions; optional.

C/D (Code)

The 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 set to Y

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.

Rsn (Reason)

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

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.

Numeric, 6 positions; display-only.

New

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

Numeric, 6 positions; display-only.

Field

Description

Warehouse

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

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 (split SKU) or one 14-position field (full SKU).

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.

Cde (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 displays. The location is blank for drop shipments, non-inventory transactions, and FIFO cost changes (* transactions).

Note: 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.

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#

The identification number entered when the inventory transaction was created. In the case of item-to-item transfers (transaction code = G), the system assigns this number; both "from" and "to" transactions will share the same ID number.

The code NONINVISSU displays for all non-inventory and drop ship inventory transaction records. See the Item Transaction Cost Detail Screen.

The code AUTOTRANS displays for all transactions processed using the Working with Automated Inventory Transactions (WAIT) menu option.

The work order number displays in this field for all finished good make up type transactions (transaction code = M) that are created through the finished good work order process. See Finished Good Work Order Processing (WWOR).

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 (Vendor charge back number)

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 file. See Accounts Payable 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 displays only if the LPN Tracking (E16) field in the System Control file is set to Y. See Radio Frequency.

Numeric, 6 positions.

User

The User ID of the person who performed the transaction.

PKMS displays if the transaction was processed through the PIX ASYNC; see WMS Inventory Transaction Setup.

Alphanumeric, 10 positions.

G/L Acct.#

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.

Cost/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 file for both SKU’ed and non-SKU’ed 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 file for both SKUed and non-SKUed 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. See Item Transaction Cost Detail Screen.

Numeric, 10 positions with a four-place decimal.

Field

Description

Company description

The description of the company where the transaction was performed.

Alphanumeric, 40 positions.

Company

The code that identifies the company where the transaction was performed.

Numeric, 3 positions.

Item number

A code that represents a unit of inventory.

Note: Drop ship items that have on-hand inventory will not appear on this screen.

Alphanumeric, 12 positions.

SKU

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

Alphanumeric, three 4-position fields (split SKU); or one 14-position field (full SKU).

Warehouse

A code that represents the warehouse the item is located in.

Numeric, 3 positions.

Date

The date the transaction was performed.

Numeric, 6 positions (MMDDYY format).

Time

The time the transaction was performed.

Numeric, 6 positions (HHMMSS format).

Field

Description

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, one 14-position field (full SKU) or three 4-position fields (split SKU); 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: The screen sample provided above displays an issue transaction of 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.

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.

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