Chapter 100: Printing the FIFO Activity Report (PFCA)
Purpose: Use the FIFO Activity Report to review all activity against selected FIFO cost layers. You can base selection for the report on total valuation, date, warehouse, buyer, vendor, or items. You can sort this report by warehouse or by item.
In this chapter:
• FIFO Activity Report by Item
• FIFO Activity Report by Warehouse
More information:
• Chapter 96: FIFO Costing Overview
• the Costing Method (A25) system control value
How to display this screen: Enter PFCA in the Fast path field at the top of any menu, or select Print FIFO Activity Report from a menu.
INR1256 ENTER FIFO Activity Report 11/30/98 14:34:56 EZK Mail Order
Date . . . . . . . . . . 113098
Select warehouse . . . . (leave blank for all warehouses) Select vendor . . . . . (leave blank for all vendors) Select buyer . . . . . . (leave blank for all buyers)
Show activity on stock older than . . . days
Show stock with Total O/H Ext cost over dollars
Item/SKU Range: From . . To . . .
Sort by: . . . . . . . . (I=Item, W=Warehouse)
F3=Exit F12=Cancel |
Field |
Description |
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 Chapter 41: 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 Chapter 19: 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 Chapter 17: 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. |
Completing this screen: The system submits the job FIFO_ACT_I if you chose to print the FIFO Activity Report by Item, or the job FIFO_ACT_W if you chose to print the FIFO Activity Report by Warehouse.
Note: The FIFO_ACT_I job is submitted in held status. You must release the job in order to generate the report.
FIFO Stock Aging Recap | Contents | SCVs | Search | Glossary | Reports | XML | Index | FIFO Activity Report by Item |
WH14_05 CWDirect 18.0 August 2015 OTN