Reply to neil:
I've put together a spreadsheet of my parts acquisitions. I create a list for the parts that I want "this time" and date when I send the list to Cat for pricing and availability. The list always has the part number and exact description as it is in the parts book. I also have a second part number column which I use for any parts that are superseded and a column if the description changes. I have a column for the price quoted per unit, the quantity needed, and the extended price (per unit x qty). Finally, I have a date for when I receive them.
That way I can look back over my history and know what was ordered when, in what qty, how much they cost. I also indicate when the parts are used in the machine so I know whether I have inventory or not.
Anal I know but it helps me keep track of everything and avoid duplicate purchases : )
Almost forgot, I also have a couple of columns showing the general area that the part relates to e.g. cooling, main transmission, fuel system, PTO, etc, and one for the precise location e.g. bearing on the rear end of the main transmission countershaft. I need all this information for my poor memory...
[quote="Neil"]I've put together a spreadsheet of my parts acquisitions. I create a list for the parts that I want "this time" and date when I send the list to Cat for pricing and availability. The list always has the part number and exact description as it is in the parts book. I also have a second part number column which I use for any parts that are superseded and a column if the description changes. I have a column for the price quoted per unit, the quantity needed, and the extended price (per unit x qty). Finally, I have a date for when I receive them.
That way I can look back over my history and know what was ordered when, in what qty, how much they cost. I also indicate when the parts are used in the machine so I know whether I have inventory or not.
Anal I know but it helps me keep track of everything and avoid duplicate purchases : )
Almost forgot, I also have a couple of columns showing the general area that the part relates to e.g. cooling, main transmission, fuel system, PTO, etc, and one for the precise location e.g. bearing on the rear end of the main transmission countershaft. I need all this information for my poor memory...[/quote]
That's a smart move Neil. Sounds like something to be in the data base some day if it ever gets working. It could be added to for all machines. It seems time and time again we are trying to remember what someone else had done when the part was not available.