Figure 3
AVEM57 - Pre-MAPICS Physical Inventory Tag & Reporting System
01/02/02
12:06:54
PHYSICAL INVENTORY VALUE VARIANCE REPORT
VALUED AT- S - STANDARD COST
VMIPQ PAGE 1
SELECTIONS- WAREHOUSES FROM-
A
TO-
A
SEQUENCED- 01- WAREHOUSE
ITEMS FROM-
FRM1000
TO-
FRM8X10
02- ITEM NUMBER
S/L LOCATIONS
FROM-
TO-
9999999
03- ITEM MASTER WAREHOUSE LOCATION
I/M LOCATIONS
FROM-
TO-
9999999
04- ITEM BALANCE WAREHOUSE LOCATION
I/B LOCATIONS
FROM-
TO-
9999999
05- STOCK LINE LOCATION
ITEM TYPES
FROM-
TO- 9
ITEM CLASSES
FROM-
TO- 9999
DEPARTMENTS
FROM-
TO- 9999
I/M VENDORS
FROM-
TO- 999999
I/B VENDORS
FROM-
TO- 999999
POSITIVE VARIANCES
FROM-
.000 TO-
9999999.999
NEGATIVE VARIANCES
FROM-
.000 TO-
9999999.999
W
ITEM
ITEM
COUNTED MAPICS
VARIANCE
UNIT
*** E X T E N D
E D C O S T ***
H
NUMBER
DESCRIPTION
QTY
QTY
QTY
COST
COUNTED
MAPICS
VARIANCE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TAG
U/
LOCATION
STOCK/LINE
BATCH/LOT
FIFO
DEPT
VENDOR VENDOR
ITEM ITEM TAG
NUMBER /M
I/M
I/B
LOCATION
NUMBER
DATE
NUMBER MASTER
BALANCE TYPE CLASS
DATE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
A
FRM1000
OAK FRAMING WOOD
1000.000
200.000
800.000
6.3000
6300.00
1260.00
5040.00 *
00001 EA
R1L2
R1L2
AA0111
WHA100
0/00/00
WOOD
FLS000
FLS000
2
WD 12/13/01
A
FRM1000 OAK FRAMING WOOD
1400.000
1.000
1399.000
6.3000
8820.00
6.30
8813.70 *
00002 EA
R1L2
R1L2
AA0121
WHA0121000 9/13/01
WOOD
FLS000
FLS000
2
WD 12/13/01
A
FRM1010
VARNISH
X
2000.000
.000
2000.000
2.7500 5500.00
.00
5500.00 *
00003 EA
R1L2
R1L2
0/00/00
WOOD
SNI000
SNI000
1 VR
12/13/01
A
FRM1300
SCREW #09,
3/4"
1000.000
1.000
999.000
.0900
90.00 .09
89.91 *
00004 EA
R1L2
R1L2
AA0111
WHA1300 9/13/01
10
NAT000
NAT000
1
SC 12/13/01
A
FRM1800
OAK FRAMING WOOD
1500.000
.000
1500.000
1.3560 2034.00
.00
2034.00 *
00005 EA
R1L2
R1L2
0/00/00
WOOD
FLS000
FLS000
4
WD 12/13/01
A FRM2000 WOOD FRAME 8 X
13 2500.000
.000
2500.000
.0000
.00
.00
.00 *
00006 EA
0/00/00
2
12/13/01
A
FRM8X10 PICTURE FRAME (8X10) 2000.000
.000
2000.000
68.8766
137753.20
.00
137753.20 *
00007 EA
R1L2
R1L2
0/00/00 GRDN
1 FM
12/13/01
QUANTITY
COUNTED
11,400.00
ITEM BALANCE
QUANTITY
202.00
QUANTITY VARIANCE
-
11.198.00
COUNTED
VALUE
160,497.20
MAPICS
VALUE
1.266.39
NET VARIANCE
-
159,230.81
*** NOTE - DELETED, VOIDED AND NON-MAPICS
TAGS NOT INCLUDED IN TOTALS