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
Work Order ID
Cost Per Unit
You can download it here:
You can also find this and many other spreadsheets we have created here
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.