Here you have an updated detailed list of non-closed tickets, filtered, and ordered by product category, and product code.
With short problem description (thai), warranty status, etc.
To quickly identify which of these:
a) Can't be repaired (old products, can't find spare parts, repair is more expensive than prod. replacement, etc.)
-> In warranty: replace product? ( new, show, etc)
-> Out of warranty: propose new product to customer?
b) Can be repaired, but no spare parts available.
-> Use spare part from existing product at WH?
-> Order Spare/Part and/or Inform customer?
Let me know your comments.
Regards,
Ernesto