FIFO Activity Report by Warehouse

How to print: Complete the FIFO Activity Report Screen. This version is sorted by warehouse, item, SKU, and FIFO date.

CWDirect Rel 3.5 FIFO Activity Report EKAPLAN INR1313 1/07/99 11:23:46 Page 1

EZK Mail Order

Selection Criteria :

Date . . . . . . . . . . : 1/07/99

Warehouse . . . . . . . : 0

Vendor . . . . . . . . . : 0

Buyer . . . . . . . . . :

Stock older than . . . . : 1

Stock over total dollars : 40.0000

Item/SKU Selection . . . : BE123 to BL456

Sort by . . . . . . . . : Whs

Dates Units Cost Extension

Whs Item SKU FIFO Date Trans Date Reference Tran Cd Trans Qty Old OH New OH FIFO Cost Trans Ext Total OH

_______________________________________________________________________________________________________________________

2 BE123 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

SKU Totals : 3 260 2510.0000

Weighted Average : 5.5717

2 BL445 LRGE 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

SKU Totals : 11 11 220.0000

Weighted Average : 20.0000

2 BL456 MEDM 11/10/98 11/11/98 0 I 1 31 30 15.0000 15.0000 450.0000

SKU Totals : 1 30 450.0000

Weighted Average : 9.1666

2 BL456 SMLL 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

SKU Totals : 105 105 2010.0000

Weighted Average : 7.7631 6 BL456 LRGE 11/10/98 12/01/98 0 * 15 15 15 5.0000 75.0000 75.0000

SKU Totals : 15 15 75.0000

Weighted Average : 20.0000

6 BL456 MEDM 11/10/98 12/01/98 0 * 42 42 42 10.0000 420.0000 420.0000

SKU Totals : 42 42 420.0000

Weighted Average : 9.1666

6 BL456 SMLL 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 : 85 85 850.0000

Weighted Average : 7.7631

Item Totals: 142 142 1345.0000

Contents: This version of the report contains the same information as the FIFO Activity Report by Item. However, the SKU and item totals on the "by warehouse" version of the report include only FIFO layers within the warehouse indicated.

WH14_05r CWDirect 18.0 August 2015 OTN