How to print: Complete the FIFO Activity Report Screen. This version is sorted by item, SKU, warehouse, and FIFO date.
CWDirect Rel 3.5 FIFO Activity Report EKAPLAN INR1310 1/06/99 17: 26:55 Page 1 EZK Mail Order Selection Criteria : Date . . . . . . . . . . : 1/06/99 Warehouse . . . . . . . : 0 Vendor . . . . . . . . . : 0 Buyer . . . . . . . . . : Stock older than . . . . : 30 Stock over total dollars : 50.0000 Item/SKU Selection . . . : BE123 to BL456 Sort by. . . . . . . . . : Item Dates Units Cost Extension Item SKU Whs FIFO Date Trans Date Reference Trans Cd Trans Qty Old OH New OH FIFO Cost Trans Ext Total OH Cost Ext Cost __________________________________ __________________________________________________________________ BE123 2 11/10/98 11/11/98 0 T 3- 257 254 10.0000 30.0000 2540.0000 11/11/98 0 T 3 257 260 10.0000 30.0000 2510.0000 5 11/10/98 12/01/98 0 * 150 150 150 9.0000 1350.0000 1350.0000 6 11/10/98 12/01/98 0 * 99 99 99 9.0000 891.0000 891.0000 SKU Totals : 252 509 4751.0000 Weighted Average : 5.5717 Item Totals: 252 509 4751.0000 BL456 LRGE 2 11/10/98 11/11/98 0 I 2 13 11 15.0000 30.0000 165.0000 12/01/98 0 * 11 11 11 5.0000 55.0000 220.0000 6 11/10/98 12/01/98 0 * 15 15 15 5.0000 75.0000 75.0000 SKU Totals : 26 26 295.0000 Weighted Average : 20.0000 BL456 SMLL 2 11/10/98 11/11/98 0 I 1 97 96 15.0000 15.0000 1440.0000 12/01/98 0 * 96 96 96 5.0000 480.0000 1920.0000 12/02/98 12/02/98 0 C 9 0 9 10.0000 90.0000 90.0000 6 11/10/98 12/01/98 0 * 85 85 85 5.0000 425.0000 425.0000 12/01/98 0 * 85 85 85 5.0000 425.0000 850.0000 SKU Totals : 190 190 2860.0000 Weighted Average : 7.7631 Item Totals: 259 288 4025.0000 |
Contents:
• the selection criteria you entered at the FIFO Activity Report Screen
• the warehouse where you keep the item
• item and SKU codes
• FIFO date: the date when each FIFO cost layer was created for the item or SKU.
• for each transaction against the FIFO layer included in the selection criteria:
• date when the transaction took place
• reference number, if any. A purchase order number appears here if appropriate for the inventory transaction.
• transaction code. This can be a code delivered with the system, or a user-defined code. System-defined codes include:
• A = adjustment • C = customer return • E = express bill • I = issue • M = make up finished good • P = physical inventory • R = purchase order receipt • T = transfer (Note: only transfers between warehouses create FIFO activity) • V = vendor charge back • * = change to FIFO cost |
• transaction quantity. If the transaction reduced on-hand and was a transfer, adjustment, make finished good, or physical inventory count, the quantity appears as a negative number. Changes to FIFO cost (* transactions) display the total unit quantity affected by the cost change.
• old on-hand quantity for the FIFO layer
• new on-hand quantity for the FIFO layer as a result of the transaction. Changes to FIFO cost (* transactions) do not affect the on-hand quantity.
• FIFO unit cost. For changes to FIFO cost (* transactions), this amount represents the increase or decrease to the previous FIFO unit cost.
• extended cost of the transaction, calculated by multiplying the unit FIFO cost by the transaction quantity
• total on-hand extended cost for the FIFO layer as a result of the transaction, calculated by subtracting (or adding) the transaction extended cost from (or to) the previous total on-hand extended cost
• for each SKU:
• total transaction quantity (Note: This total field is not currently implemented)
• total on-hand quantity
• total extended on-hand cost, calculated by adding the total on-hand extended cost for each FIFO layer
• weighted average FIFO cost from the SKU file
• for each item (Note: The following information will be the same as the SKU totals, above, for non-SKU’ed items):
• total transaction quantity (Note: This total field is not currently implemented)
• total on-hand quantity
• total extended on-hand cost
• weighted average FIFO cost from the SKU file
Note: The totals that appear on this report include only those FIFO layers that were included in the selection criteria. See below.
See Chapter 98: Using FIFO Cost Layer Inquiry (WFCF) for more information on FIFO transaction history.
Not included on this report:
• any closed FIFO layers
• any FIFO layers or FIFO activity that do not meet the selection criteria. For example, the total on-hand extended cost for an item may not be current if you selected an earlier date for FIFO activity. Also, FIFO layers created in the past two days are excluded, since the Stock older than... field is required as part of the selection criteria, and the minimum number of days is 1
| Chapter 100: Printing the FIFO Activity Report (PFCA) | Contents | SCVs | Search | Glossary | Reports | XML | Index | FIFO Activity Report by Warehouse |
WH14_05r CWDirect 18.0 August 2015 OTN