TCSInvSuppAnalysis
ACME TRUCK SERVICING LTD
Consignment Stock Analysis
Supplier:
3150 Marshall Batteries Co Ltd
Detailed Status Report as at 20 Apr 2009
------- REC'D ---------
-------- ADJ'D --------
-------- TRF'D --------
-------- SOLD --------
------- STOCK -------
Value
Value
Value
Value
Value
Qty
Qty
Qty
Qty
Qty
Ex Document
Reference
Typ
Tran Date
ITEM CODE
DESCRIPTION
SUPPLIER ITEM
WAREHOUSE
Battery, 12 Volt 21 Plate
108120
10
1,743.00
-1
-174.30
4
697.20
5
871.50
HAM-3150
2
348.60
2
348.60
2
348.60
01 Apr 2009
MvI
24
24
MAIN-3150
10
1,743.00
-2
-348.60
-1
-174.30
4
697.20
3
522.90
10
1,743.00
25 Mar 2009
Inv
MB2503
LS000103
2
348.60
25 Mar 2009
Out
SI000972
SI000972
-1
-174.30
31 Mar 2009
Jnl
13
13
-2
-348.60
01 Apr 2009
MvO
24
24
4
697.20
03 Apr 2009
Inv
MB0304
LS000108
-4
-697.20
03 Apr 2009
Inv
MB0304
LS000108
1
174.30
06 Apr 2009
Out
SI000981,1
SI000981
1
174.30
20 Apr 2009
Out
SI000985,1
SI000985
Battery, 12 Volt 27 Plate
108150
5
976.50
1
195.30
4
781.20
HAM-3150
2
390.60
1
195.30
1
195.30
2
390.60
01 Apr 2009
MvI
24
24
1
195.30
10 Apr 2009
Out
SI000982,1
SI000982
MAIN-3150
5
976.50
-2
-390.60
3
585.90
5
976.50
25 Mar 2009
Inv
MB2503
LS000103
-2
-390.60
01 Apr 2009
MvO
24
24
1
195.30
03 Apr 2009
Inv
MB0304
LS000108
-1
-195.30
03 Apr 2009
Inv
MB0304
LS000108
Battery, 12 Volt 37 Plate
108200
5
1,221.50
2
488.60
3
732.90
HAM-3150
2
488.60
1
244.30
1
244.30
2
488.60
01 Apr 2009
MvI
24
24
1
244.30
15 Apr 2009
Out
SI000983,1
SI000983
MAIN-3150
5
1,221.50
-2
-488.60
1
244.30
2
488.60
5
1,221.50
25 Mar 2009
Inv
MB2503
LS000103
-2
-488.60
01 Apr 2009
MvO
24
24
1
244.30
03 Apr 2009
Inv
MB0304
LS000108
-1
-244.30
03 Apr 2009
Inv
MB0304
LS000108
1
244.30
17 Apr 2009
Out
SI000984,1
SI000984
Total:
20
3,941.00
-1
-174.30
7
1,381.10
12
2,385.60
Page 1 of 1
Printed on 21 Apr 2009 at 03:21 PM