FIFO Stock Aging Report by Item

How to print: Complete the FIFO Stock Aging Report Screen.

CWDirect Rel 3.5 FIFO Stock Aging Report EKAPLAN INR1306 4/19/99 9:55:37 Page 1

EZK Mail Order

Selection Criteria :

Warehouse . . . . . . . : 0

Vendor . . . . . . . . . : 2

Buyer . . . . . . . . . :

Stock older than . . . . : 1

Stock over total dollars : .0000

Item/SKU Selection . . . : BU001 to BU001

Sort by. . . . . . . . . : Item

Item SKU Whs Aged Inventory Units & Dollars

Item Description SKU Description

0 - 30 Days 31 - 60 Days 61 - 90 Days 91-120 Days 121-365 Days 365+ Days

Aged Totals

OH $ OH $ OH $ OH $ OH $ OH $ OH $

____________ ____________ ____________ ____________ ____________ ____________ _____________

BU001 BLUE LRGE 2 0 .00 0 .00 0 .00 0 .00 17 157.40 0 .00 17 157.40

CHOCOLATE EASTER BUN DESCRIPT: BLUE LARGE

SKU Totals : 0 .00 0 .00 0 .00 0 .00 17 157.40 0 .00 17 157.40

BU001 CHOC LRGE 2 0 .00 1 9.00 0 .00 0 .00 105 1042.50 0 .00 106 1051.50

CHOCOLATE EASTER BUN GREAT BIG CHOCOLATE

BU001 CHOC LRGE 6 0 .00 0 .00 0 .00 0 .00 8 80.00 0 .00 8 80.00

CHOCOLATE EASTER BUN GREAT BIG CHOCOLATE

BU001 CHOC LRGE 10 0 .00 0 .00 0 .00 0 .00 1 10.00 0 .00 1 10.00

CHOCOLATE EASTER BUN GREAT BIG CHOCOLATE

SKU Totals : 0 .00 1 9.00 0 .00 0 .00 114 1132.50 0 .00 115 1141.50

BU001 CHOC MEDM 2 0 .00 0 .00 0 .00 0 .00 102 281.00 0 .00 102 281.00

CHOCOLATE EASTER BUN DESCRIPT: CHOC MEDM

SKU Totals : 0 .00 0 .00 0 .00 0 .00 102 281.00 0 .00 102 281.00

BU001 CHOC SMLL 2 0 .00 0 .00 0 .00 0 .00 102 249.51 0 .00 102 249.51

CHOCOLATE EASTER BUN DESCRIPT: CHOC SMLL

SKU Totals : 0 .00 0 .00 0 .00 0 .00 102 249.51 0 .00 10 10.00

BU001 CHOC XLRG 2 0 .00 0 .00 10 10.00 0 .00 0 .00 0 .00 10 10.00

CHOCOLATE EASTER BUN GIANT 10-POUND CHOCO

SKU Totals : 0 .00 0 .00 10 10.00 0 .00 0 .00 0 .00 1 10.25

Item Totals . . . . : 0 .00 2 9.00 10 10.00 0 .00 724 1680.01 0 .00 245 1600.15

Total All Items . . : 0 .00 2 9.00 10 10.00 0 .00 724 1680.01 0 .00 245 1600.15

Contents:

• selection criteria for the report

• for each SKU:

• warehouse number

• total on-hand quantity and extended cost for each aging bucket

• total on-hand quantity and extended cost for the SKU by warehouse

• total on-hand quantity and extended cost for the SKU across all warehouses

• total on-hand quantity and extended cost for all SKUs of an item

• total for all items/SKUs and warehouses on the report

 

Note: The totals on the report are restricted to the selection criteria you specified at the prompt screen, and may not reflect the actual totals for the warehouse.

WH14_04r CWDirect 18.0 August 2015 OTN