<% 'on error resume next warranty_id = request.querystring("wid") if warranty_id = "" then warranty_id = 0 sql = "select * from warranty where warranty_id = " & warranty_id set rs = conn.Execute(sql) on error resume next %> Lynx Power Systems Warranty
Lynx Power System Warranty
  
 
Lnyx Authorized Service Center:
<%=rs("service_center")%>		 User :
<%=rs("theUser")%>		 User Location:
<%=rs("user_location")%>		 Date:
<%=rs("theDate")%>
Genset Model #:
<%=rs("model_num")%>		 Genset Serial #:
<%=rs("serial_num")%>		 Genset EMI #:
<%=rs("emi_num")%>		 Hours:
<%=rs("hours")%>
Engine Component Failure:
Engine Make:
<%=rs("engine_make")%>		 Engine Model #:
<%=rs("engine_model")%>		 Engine Serial #:
<%=rs("engine_serial")%>
Transfer Switch Component Failure:
Switch Make:
<%=rs("switch_make")%>		 Switch Model #:
<%=rs("switch_model")%>		 Switch Serial #:
<%=rs("switch_serial")%>
Failure Summary:
<%=rs("failure_summary")%>
Summary of Work Performed:
<%=rs("work_summary")%>
Work Performed by: <%=rs("performed_by")%> MX #: <%=rs("mx_num")%>
Materials Replaced:
<% sql = "select * from materials_replaced where warranty_id = " & warranty_id & " order by mr_id" set rsX = conn.Execute(Sql) do while not rsX.eof %> <% rsX.movenext: loop %>
Qty Parts Description Parts # Price Per Item Total
<%=rsX("mr_qty")%> <%=rsX("mr_descr")%> <%=rsX("mr_part_num")%> <%=rsX("mr_price")%> <%=rsX("mr_ext")%>
Travel Time: <%=rs("travel_hours")%> Hours x <%=rs("travel_rate")%>/hr Total $:<%=rs("travel_time_ext")%> Submitted By: <%=rs("submitted_by")%>
Travel Distance: <%=rs("travel_miles")%> Miles x <%=rs("travel_mile_rate")%>/mi Total $:<%=rs("travel_distance_ext")%>
Repair Time: <%=rs("repair_hours")%> Hours x <%=rs("repair_rate")%>/hr Total $:<%=rs("repair_ext")%> Tel #:<%=rs("phone_num")%>
Total warranty expense claimed     $:<%=rs("total_expense_claimed")%>     Date: <%=rs("claim_date")%>     Number of Trips: <%=rs("num_trips")%>
To Be Completed By Customer:
Signature
 		 I agree Warranty work was completed on this day to my satisfaction.
 
Printed Name
<%=rs("customer_name")%>		      Date:
<%=rs("signed_date")%> 
To Be Completed By Lynx Power Systems:
Approved Amounts:   Travel Time: <%=rs("aa_travel_time")%>         Travel Miles: <%=rs("aa_travel_miles")%>         Repair Time: <%=rs("aa_repair_time")%>         Total: <%=rs("aa_total")%>
Approved by: <%=rs("approved_by")%>
Comments: <%=rs("comments")%>