TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
For selected debtor control accounts, for all inventory control accounts, for all warehouses, top 5 items ranked by sales quantity
Debtor control
130
Item ranking for the period 01 Jun 2009 to 30 Jun 2009, customer purchasing for the period 01 Jun 2009 to 30 Jun 2009, ordered by sales analysis code
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Sales Analysis:
D - Detroit Products
114151-S2 Oil Filter, Detroit 8.2
117151-S2 Fuel Filter, Detroit 8.2
55
55
Customer Account Number & Name
Non Purchased Items
10015 Auckland Storage & Freight Ltd
114151-S2
117151-S2
10120 Balmoral Transport Co
114151-S2
117151-S2
10000 Cash Sales
114151-S2
117151-S2
18001 Central Transport Holdings Ltd
114151-S2
117151-S2
10215 Coastal Storage & Freight
114151-S2
117151-S2
10350 Davies Transport
114151-S2
117151-S2
19305 Deagon Transport Services Ltd
114151-S2
117151-S2
10695 Mr R G Edwards
114151-S2
117151-S2
10835 Mr M L Grant
114151-S2
117151-S2
11520 Hutt Transport Services
114151-S2
117151-S2
11540 Hutt Transport Supplies
114151-S2
117151-S2
11600 Mainfreight NZ Ltd
114151-S2
117151-S2
10645 Mr G D Mitchell
114151-S2
117151-S2
11715 N Z Freight Services Ltd
114151-S2
117151-S2
11870 Prestige Removals Ltd
114151-S2
117151-S2
11655 Mr T B Robinson
114151-S2
117151-S2
11985 Mr T J Robinson
114151-S2
117151-S2
10999 Sundry Debtors
114151-S2
117151-S2
11880 Taranaki Motor Spares
114151-S2
117151-S2
11890 Transport NZ Ltd
114151-S2
117151-S2
11950 Waikato Transport Ltd
114151-S2
117151-S2
Sales Analysis:
P - Perkins Products
114152-S2 Oil Filter, Perkins
117152-S2 Fuel Filter, Perkins
35
35
Customer Account Number & Name
Non Purchased Items
10015 Auckland Storage & Freight Ltd
114152-S2
117152-S2
10000 Cash Sales
114152-S2
117152-S2
18001 Central Transport Holdings Ltd
114152-S2
117152-S2
10215 Coastal Storage & Freight
114152-S2
117152-S2
10350 Davies Transport
114152-S2
117152-S2
19305 Deagon Transport Services Ltd
114152-S2
117152-S2
10695 Mr R G Edwards
114152-S2
117152-S2
10725 Frankton Freight
114152-S2
117152-S2
Page 1 of 3
Printed on 24 Jul 2009 at 11:06 AM
TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Sales Analysis:
P - Perkins Products (Cont.)
Customer Account Number & Name
Non Purchased Items
10835 Mr M L Grant
114152-S2
117152-S2
11480 Highways Freight Services Ltd
114152-S2
117152-S2
11520 Hutt Transport Services
114152-S2
117152-S2
11540 Hutt Transport Supplies
114152-S2
117152-S2
11600 Mainfreight NZ Ltd
114152-S2
117152-S2
10645 Mr G D Mitchell
114152-S2
117152-S2
12570 Nationwide Freighters Ltd
114152-S2
117152-S2
11870 Prestige Removals Ltd
114152-S2
117152-S2
11650 Rangitikei Transport Co
114152-S2
117152-S2
11655 Mr T B Robinson
114152-S2
117152-S2
11985 Mr T J Robinson
114152-S2
117152-S2
10999 Sundry Debtors
114152-S2
117152-S2
11880 Taranaki Motor Spares
114152-S2
117152-S2
11890 Transport NZ Ltd
114152-S2
117152-S2
11900 Wanganui Transport Ltd
114152-S2
117152-S2
Sales Analysis:
Z - All Makes Products
122105 Exhaust Tubing, 5"
122104 Exhaust Tubing, 4"
122205 Exhaust Clamp, 5"
50
20
20
122103 Exhaust Tubing, 3"
101692 Headlamp Insert, Outer, Q/H
12
8
Customer Account Number & Name
Non Purchased Items
10015 Auckland Storage & Freight Ltd
101692
122103
122104
122105
122205
10120 Balmoral Transport Co
122103
122104
10000 Cash Sales
101692
122103
122104
122105
122205
18001 Central Transport Holdings Ltd
101692
122103
122104
122105
122205
10215 Coastal Storage & Freight
101692
122103
122104
122105
122205
10350 Davies Transport
101692
122103
122104
122105
122205
19305 Deagon Transport Services Ltd
101692
122103
122104
122105
122205
10695 Mr R G Edwards
101692
122103
122104
122105
122205
10725 Frankton Freight
101692
122104
122105
122205
10773 Freightline NZ Ltd
101692
122104
122105
122205
10835 Mr M L Grant
101692
122103
122104
122105
122205
11480 Highways Freight Services Ltd
122103
11520 Hutt Transport Services
101692
122103
122104
122105
122205
11540 Hutt Transport Supplies
101692
122103
122104
122105
122205
11600 Mainfreight NZ Ltd
101692
122103
122104
122105
122205
10645 Mr G D Mitchell
101692
122103
122104
122105
122205
12570 Nationwide Freighters Ltd
122103
122104
122105
122205
11715 N Z Freight Services Ltd
101692
122103
122104
122105
122205
11870 Prestige Removals Ltd
101692
122103
122104
122105
122205
Page 2 of 3
Printed on 24 Jul 2009 at 11:06 AM
TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Inventory Item Code & Description
Sales Qty
Sales Analysis:
Z - All Makes Products (Cont.)
Customer Account Number & Name
Non Purchased Items
11650 Rangitikei Transport Co
122103
11655 Mr T B Robinson
101692
122103
122104
122105
122205
11985 Mr T J Robinson
101692
122103
122104
122105
122205
15523 Smiths Transport Ltd
101692
122103
122104
122105
122205
10999 Sundry Debtors
101692
122103
122104
122105
122205
11880 Taranaki Motor Spares
101692
122103
122104
122105
122205
11890 Transport NZ Ltd
101692
122103
122104
122105
122205
11950 Waikato Transport Ltd
101692
122103
122104
11900 Wanganui Transport Ltd
122103
122104
Page 3 of 3
Printed on 24 Jul 2009 at 11:06 AM