Hi Gill
Can you add your first name so that it appears under the signature line on your posts please? Saves us looking it up each time. (Via edit profile--> signatures)

I would've thought that you could pull a sales activity report showing all sales entries to a specific sales account, although I am no means a VT expert, which then you can drill down via a dump into excel, plus playing with lookups etc.

If that is possible, my only thoughts then are is this going to give you the info you need? That does of course depend on the nature of the garage in question, which we don't have much info about. But for the average back street type, non chain, garage, then stocks of products are kept very low due to cashflow pressures and because generally they can work on a JIT ordering system, literally getting parts and tyres in within an hour or so of ordering them.

Plus eg tyres come in a million different sizes, types and makes, all with their own unique category coding, and if the specifics are not put on the sales invoice then is it not a bit pointless?

Again with parts, some come as a whole, other such as exhausts, in parts. Some exhaust parts cost pennies, large chunks a bit more, but it's only the whole that goes on a sales invoice, or the vague 'centre box' type of description.

Of course you may well be talking about a parts supplier.