It's really a scheme I need broader than that.
Basically, when I see a S/N, I want to be able to click on it and know its location.
If we sold that S/N to a customer, then I want to see that information on the screen. Further, I want to know when it was purchased, for how much, the support/warranty coverage purchased along with it (if at all).
It would be great if the reverse of this is also possible. For example, I look up a customer and see which products they have purchased along with serial numbers and the coverage they purchased along with the items. And, again, if I see a list of support coverages, I want to be able to click on one and see which S/N have the selected coverage. Note: we treat the warranty/support coverage as a stock item.