Date

Indicates the date of the latest FIFO cost layer activity to include on the report. Any transactions against a FIFO layer that took place after this date will not be selected.

Do not confuse this date with the Show activity older than... field, which refers to the date when the FIFO cost layer itself was created.

The current date defaults, but you can override it.

Numeric, 6 positions (MMDDYY format); required.

Select warehouse

Enter a warehouse code to restrict the report to items located in this warehouse. Only items with activity against FIFO cost layers for this warehouse will be selected.

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

Leave this field blank to select items regardless of the warehouse for the FIFO layer.

Numeric, 3 positions; optional.

Select vendor

Enter a vendor code to restrict the report to items associated with this vendor. Only items with this default vendor (the Vendor on the Create/Change/Display Item screen) will be selected.

Vendor codes are defined in and validated against the Vendor file; see Merchandising Working with Vendors (WVEN).

Leave this field blank to select items regardless of default vendor.

Numeric, 7 positions; optional.

Select buyer

Enter a buyer code to restrict the report to items associated with this buyer. Only items whose default buyer (the Buyer on the Create/Change Display Item screen) will be selected.

Buyer codes are defined in and validated against the Buyer file; see Merchandising Working with Buyers (WBUY).

Leave this field blank to select items regardless of default buyer.

Alphanumeric, 3 positions; optional.

Show stock older than

Enter a number of days to indicate the minimum age of the FIFO cost layers to include on the report. The FIFO layer must exceed the number of days you enter to be selected.

The system bases its selection on the date when the FIFO cost layer was created (the FIFO date). If an item has multiple FIFO layers, some from before the date you enter here and some after, the totals on the report will represent only those FIFO cost layers that are older than the date you enter.

Numeric, 5 positions; required.

Show stock with total on-hand extended cost over

Enter a dollar amount to indicate the minimum total dollar value of the FIFO cost layers to include on the report. The total dollar value must exceed the dollar amount you enter to be selected.

The system bases its selection by adding the extended costs (Current FIFO cost * Current quantity on-hand) of all FIFO layers for an item or SKU.

Leave this field blank to select items regardless of the total on-hand value.

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

Item/SKU range

Enter the beginning and ending item to include on the report. If you enter any SKU information for an item, you must enter a complete, valid SKU.

Item: alphanumeric, 12 positions; required.

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

Sort by

Indicates which version of the FIFO Activity Report to print. Valid values are:

I = Item: The FIFO Activity Report by Item lists items in alphanumeric order by item code, breaking out item/warehouse totals for each.

W = Warehouse: The FIFO Activity Report by Warehouse lists items within each warehouse in alphanumeric order by item code

Enter a valid sort option.

Alphanumeric, 1 position; required.