Sts (Status)

The status of the FIFO cost layer. Valid statuses are:

O = Open: There is currently an on-hand quantity of the item/SKU for this FIFO cost layer

X = Closed: The on-hand quantity of this FIFO layer has been exhausted. If you try to change a closed FIFO layer, an error message indicates:

Invalid option - Not allowed to change a closed layer.

See FIFO Costing Overview.

Alphanumeric, 1 position; optional.

Item

A code representing the unit of inventory associated with the FIFO cost layer. Item codes are defined in and validated against the Item table.

Alphanumeric, 12 positions; optional.

SKU

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

Alphanumeric, three 4-position fields; optional.

Whs (Warehouse)

The code representing the warehouse associated with the FIFO cost layer. FIFO layers track the cost of on-hand inventory for an item or SKU at the warehouse level. In other words, a receipt into a warehouse creates a FIFO cost layer, while a transfer within a warehouse has no impact on FIFO layers.

Warehouse codes are defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; optional.

FIFO dt(FIFO date)

The date the FIFO cost layer was created.

Typically, the system creates a FIFO cost layer when you receive a purchase order, but layers are also created when you receive a return from a customer, transfer inventory between warehouses, or perform certain other inventory transactions. See Inventory Transactions: Cost Selection and Updates.

Numeric, 6 positions (user date format); optional.

PO# (Purchase order number)

The purchase order number associated with the FIFO cost layer.

Typically, a FIFO cost layer is associated with a purchase order number through purchase order receipt. However, you can also associate a purchase order with a FIFO cost layer by entering the number during an inventory transaction. See Purchase Order Number in Inventory Transactions.

Numeric, 7 positions; optional.

Cur FIFO cost (Current FIFO cost)

The unit cost to use for inventory transactions when the FIFO costing hierarchy selects this FIFO cost layer. See FIFO Costing Overview.

Typically, this cost is assigned when the FIFO cost layer is created, but you can change the current cost of a layer. See Change FIFO Cost Layer Screen.

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

Cur FIFO O/H (Current FIFO on-hand)

The current quantity of the item or SKU on-hand for this FIFO layer. Typically, the quantity is reduced through sales until the quantity is exhausted, which closes the FIFO layer. See Inventory Transactions: Cost Selection and Updates.

Numeric, 7 positions; display-only.

Cur FIFO ext (Current FIFO cost extension)

The total cost of the entire unit quantity for this FIFO cost layer. This amount is calculated by multiplying the current cost by the current on-hand quantity for the FIFO layer.

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

Item

A code representing the unit of inventory associated with the FIFO cost layer. Item codes are defined in and validated against the Item table.

Alphanumeric, 12 positions; display-only.

SKU

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

Alphanumeric, three 4-position fields; display-only.

Whs (Warehouse)

The code representing the warehouse associated with the FIFO cost layer. FIFO layers track the cost of on-hand inventory for an item or SKU at the warehouse level. In other words, a receipt into a warehouse creates a FIFO cost layer, while a transfer within a warehouse has no impact on FIFO layers.

Warehouse codes are defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; display-only.

FIFO date

The date the FIFO cost layer was created.

Typically, the system creates a FIFO cost layer when you receive a purchase order, but layers are also created when you receive a return from a customer, transfer inventory between warehouses, or certain other inventory transactions. See FIFO Costing Overview.

Numeric, 6 positions (user date format); optional.

Sequence #

This number identifies when this FIFO cost layer was created relative to other layers for the same item, SKU, warehouse, and date.

The system assigns numbers in ascending sequence. If you have created only one FIFO cost layer for a given item/SKU, warehouse, and date combination, it will have a sequence number of 1.

Numeric, 7 positions; display-only.

Status

The current status of the FIFO cost layer.

Open: There is currently an on-hand quantity of the item for this FIFO cost layer.

See FIFO Costing Overview.

Alphanumeric, 1 position; display-only.

Current FIFO cost

The current cost to use for inventory transactions when the FIFO costing hierarchy selects this FIFO layer. You can use this screen to change the current cost if it was created incorrectly.

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

Cost change date

The last date when the current FIFO cost was changed through the Change FIFO Cost Layer Screen.

Numeric, 6 positions (user date format); display-only.

Current quantity O/H (Current FIFO quantity on-hand)

The current quantity of the item or SKU on-hand for this FIFO layer. Typically, the quantity is reduced through sales until the quantity is exhausted, which closes the FIFO layer. See Inventory Transactions: Cost Selection and Updates.

Numeric, 7 positions; display-only.

Original FIFO cost

The original cost for the FIFO layer at creation.

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

Original FIFO quantity

The original on-hand quantity for the FIFO layer at creation. This quantity may differ from the current on-hand quantity if there has been any activity against the FIFO cost layer.

Numeric, 7 positions; display-only.

PO # (Purchase order number)

The purchase order number associated with the FIFO cost layer. A FIFO cost layer can be associated with a purchase order number if it was created through purchase order receipt, or if you entered a purchase order number while creating the FIFO layer through an inventory adjustment.

Numeric, 7 positions; display-only.

Item

The item associated with the FIFO cost layer you selected at the Work with FIFO Cost Layers Screen. Item codes are defined in and validated against the Item table.

Alphanumeric, 12 positions; display-only.

SKU

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

Alphanumeric, three 4-position fields; display-only.

Whs (Warehouse)

The warehouse associated with the FIFO cost layer that you selected at the Work with FIFO Cost Layers Screen. Warehouse codes are defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; display-only.

FIFO date

The date the FIFO layer was created. Typically, FIFO layers are created through a purchase order receipt, but they are also created when you process a customer return or through certain other inventory transactions. See FIFO Costing Overview.

Numeric, 6 positions (user date format); display-only.

FIFO Seq # (FIFO sequence number)

This number identifies when this FIFO cost layer was created relative to other layers for the same item, SKU, warehouse, and date.

The system assigns numbers in ascending sequence. If you have created only one FIFO cost layer for a given item/SKU, warehouse, and date combination, it will have a sequence number of 1.

Numeric, 7 positions; display-only.

Status

Open: There is currently an on-hand quantity of the item for this FIFO cost layer

Closed: The on-hand quantity of this FIFO layer has been exhausted. You can change the cost of a FIFO layer even if it is closed, because there are situations when the system uses a closed FIFO layer to derive the cost of an item. See FIFO Costing Overview for more information on the FIFO costing hierarchy.

Alphanumeric, 1 position; display-only.

Date

The date that the transaction against the FIFO cost layer took place.

Numeric, 6 positions (user date format); display-only.

TC (Transaction code)

A code representing a type of inventory transaction. The system-assigned codes are:

A = Adjustment. The adjustment quantity always appears as a positive number; for example, if you enter an adjustment of -2, the transaction appears on this screen with a quantity of 2.

C = Customer return. The return creates one or more new FIFO layers.

E = Express bill. An express bill works the same way as an issue transaction, described below.

I = Issue. An issue represents a shipment to a customer, and decreases the first FIFO layer in the standard hierarchy.

M = Make up finished good. This transaction decreases the on-hand quantity and extended cost for each component item's FIFO layers, and creates a new FIFO layer for the finished good item.

R = Receipt. Receiving a purchase order creates a new FIFO layer for each item/SKU, using the receipt cost and quantity.

T = Transfer. Transfers affect FIFO cost layers only if they are between warehouses; transfers within the same warehouse have no impact on FIFO layers. A transfer between warehouses reduces the on-hand quantity and on-hand cost extension of the "from" warehouse, and creates a new FIFO layer for the "to" warehouse, using the cost of the originating FIFO layer.

V = Return to vendor. You can process a V transaction by entering the transaction code in an interactive or batch inventory transaction. Typically, these transactions reflect a decrease in inventory, but a reversal produces an increase and a new FIFO layer.

* = FIFO layer cost change. When you change the cost of a FIFO layer, the Display FIFO Cost Layer History Screen indicates the:

• change in cost per unit

• change to the extended cost change for the layer

• new total on-hand extended cost of the FIFO layer

The transaction quantity, old on-hand quantity, and new on-hand quantity remain the same. See FIFO Cost Change Updates.

User-defined transaction codes: Any additional transaction codes you have set up in your company will create new FIFO layers if they increase inventory, or decrease the totals for FIFO layers if they decrease inventory.

First transaction: The first transaction that appears on the history screen is normally the one that created the FIFO cost layer, such as a receipt, adjustment, customer return. The exception is when you create FIFO layers by converting from another costing method; in this situation, the first transaction to appear on the screen is the next transaction that takes place following the conversion.

Alphanumeric, 1 position; display-only.

Qty (Quantity)

The quantity involved in the transaction. In the case of a * transaction, this is the total quantity of the FIFO cost layer, and the old on-hand and the new on-hand quantities, described below, are the same.

Numeric, 7 positions; display-only.

Old O/H (Old on-hand quantity)

The total on-hand quantity of the FIFO layer before processing the transaction.

Numeric, 7 positions; display-only.

New O/H(New on-hand quantity)

The total on-hand quantity of the FIFO layer after processing the transaction.

Numeric, 7 positions; display-only.

Cost

The unit cost of the transaction. In the case of a * transaction, this represents the change to the FIFO unit cost. Decreases in cost appear as negative amounts (for example, when you change the cost from $10.00 to $9.50, the cost appears here at .50-).

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

Trans cost ext (Transaction cost extended)

The total cost of the transaction, calculated by multiplying the quantity by the cost.

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

Total O/H cost ext (Total on-hand cost extended)

The total extended cost of the FIFO layer after processing the transaction.

All transactions produce a decrease in the total on-hand extended cost of a FIFO layer except for the transaction that creates the layer, or a * transaction that increases the unit cost.

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

Warehouse

Optionally, enter a warehouse code to include FIFO cost layers only within this warehouse. Leave this field blank to include all warehouses on the report.

Numeric, 3 positions; optional.

FIFO date range...

Optionally, enter a beginning and ending date to include FIFO cost layers only if they were created within these two dates. To include all FIFO layers created up to a particular date, you can also enter the end date only and leave the beginning date field blank. However, you cannot enter a beginning date without indicating an end date.

Numeric, 6 positions each (user date format); optional.

From item/SKU

Enter the first item or SKU to include on the report. It is not necessary to enter SKU information, even if the item has SKUs.

Item: alphanumeric, 12 positions; required.

SKU: three 4-position fields; optional.

To item/SKU

Enter the last item or SKU to include on the report. It is not necessary to enter SKU information even if the item has SKUs.

Item: alphanumeric, 12 positions; required.

SKU: three 4-position fields; optional.