I created another spreadsheet to display all parts that were installed that have a warranty. This would allow you to check to see if part was under warranty when it failed.
To make this as useful as possible; you should add a note as to the warranty duration when you add a part to a Work Order and check the Warranty Box for the part.
Here are the fields that will display in this spreadsheet
Equip Num
Work Order ID
Requested Date
Completed Date
Part Num
Part Descr
Qty
Cost Per Unit
Total Cost
Notes
Warranty?
You can download it here:
TATEMS-PartsReplacedUnderWarranty.xls
You can also find this and many other spreadsheets we have created here
http://tatems.com/spreadsheets
Here is a short video tour of the Parts Replaced Under Warranty spreadsheet :
Do you think we should add a warranty term next to the check box for the part in TATEMS?
Please leave your comments below.
Thanks Again
Marc