TCSDocuStocktakeDiscrep
Stocktake Discrepancies
ACME TRUCK SERVICING LTD
From document 21 to document 21, full stocktake report, ordered by bin location, including lot/serial references
Count quantities asterisked are not pack quantity multiples
Pack Qty
Last Count
Cum Var Amt
Variance Amt
Unit Cost
Var Qty
Stock Qty
Count Qty
Count Ref
Count
Line
Bin Locn
Account Name
Account
Warehouse: MAIN - Main-Parts Warehouse Count Date: 23 Apr 2010 Narration: Stocktake Adj
Type: Manual
Zero Qty: No
Lot/Serial Checking: Yes
Stocktake: 21
141605
Brake Drum, 15", 3 Spoke
M01A01
1
1
206.52
11
11
25 Nov 2009
Warning:
Owned stock and consignment stock holdings may exist
141607
Brake Drum, 16", 5 Spoke
M01A02
2
1
225.07
10
10
25 Nov 2009
Warning:
Owned stock and consignment stock holdings may exist
145710B
Slack Adjuster, 10 Spline
M01A03
3
1
-1
33.41
33.41 Cr
33.41 Cr
7
6
25 Nov 2009
145728B
Slack Adjuster, 28 Spline
M01A04
4
1
29.26
7
7
25 Nov 2009
142312
Brake Lining Set, COF 0.36
M01A05
5
1
180.74
13
13
25 Nov 2009
142312
Brake Lining Set, COF 0.36
M01A06
6
1
-2
180.74
361.47 Cr
394.88 Cr
22
20
25 Nov 2009
165159
Misc Waterpump Re-manf
M01E09
7
1
125.50
3
3
26 Feb 2010
165151-R2
Detroit 8.2 Waterpump Re-Manf
M05E01
8
1
1
187.50
187.50 Dr
207.38 Cr
3
4
26 Feb 2010
1
1
187.50
1
Lot/Serial:
DWP2009018
1
1
187.50
1
Lot/Serial:
DWP2009113
1
1
187.50
1
Lot/Serial:
DWP2009222
1
1
187.50
1
Lot/Serial:
DWP2009233
165151-R2
Detroit 8.2 Waterpump Re-Manf
M05E02
9
1
-1
187.50
187.50 Cr
394.88 Cr
4
3
26 Feb 2010
0
1
-1
187.50
1
Lot/Serial:
DWP2009233
***Missing***
1
1
187.50
1
Lot/Serial:
DWP2009261
1
1
187.50
1
Lot/Serial:
DWP2009278
1
1
187.50
1
Lot/Serial:
DWP2009383
197151-R2
Detroit 8.2 Engine Re-Manf
M05E05
10
1
15,895.00
1
1
26 Feb 2010
1
1
15,895.00
1
Lot/Serial:
DDR2009915
197151-R2
Detroit 8.2 Engine Re-Manf
M05E06
11
1
15,895.00
1
1
26 Feb 2010
1
1
15,895.00
1
Lot/Serial:
DDR2009267
Lines with count entered:
Lines with positive variances:
Lines with negative variances:
11
11
100.00%
79
82
-3
1
9.09%
1
187.50 Dr
3
27.27%
-4
582.38 Cr
394.88 Cr
44,765.89 Dr
Totals: Stock Value:
Document Lines:
-3.66%
-4.88%
1.22%
-1.30%
0.42%
-0.88%
4
3
29
33
Page 1 of 1
Printed on 23 Apr 2010 at 12:41 PM