All Assets Outs to Maintenance

Shows a list of all assets scanned out to maintenance

You can execute this query using Excel Query Builder in RentalPoint...

SELECT IM.groupFld [Group],
       IM.category [Category],
       A.PRODUCT_COde [Product],
       A.ASSET_CODE [Barcode],
       A.SERIAL_NO [Serial],
       A.locn [Item Location],
       A.COST,
       A.EST_RESALE,
       A.INSURED_VAL,
       CASE
           WHEN A.ServiceStatus = 0 THEN 'Active'
           WHEN A.ServiceStatus = 1 THEN 'Temporarily Out of Service'
           ELSE 'Permanently Out of Service'
       END [Status]
FROM tblAsset01 A
LEFT OUTER JOIN tblInvmas IM ON IM.product_code = A.PRODUCT_COde
WHERE A.ServiceStatus = 1
ORDER BY IM.groupFld,
         IM.category,
         A.PRODUCT_COde,
         A.ASSET_CODE