New Articles

  1. Asset - Due for Service Report

    This Report is Based on Asset Usage since the Last Test Date This report identifies assets that have met or exceeded their allowed usage and are due for servicing, helping to quickly highlight equipment that is due or overdue for service base...
  2. RentalPoint2 ESign

    RentalPoint Software eSign makes it easy to request and collect digital signatures directly within the software when sending quotes to clients. Because the feature is fully built into the system, there’s no need for any third-party applications—...
  3. Rolling Revenue Report Future Years

    /* This query provides monthly operator-level summary of bookings, WH Out, invoiced revenue, averages, closure ratios, lost revenue, and prior-year revenue for trend analysis over a rolling multi-year period. The report starts at 2022 and is forw...
  4. Labour Products and Assigned Technicians

    /* Listing of Labour Products, the first three rates for location zero and the technicians assigned to them */ WITH cte      AS (SELECT  Isnull (I.groupfld, ' ')                             AS                 ParentGroup,                  Isnul...
  5. Inventory Macros

    Provides a list of all macros in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint.....           WITH CTE AS (     SELECT         ISNULL(...
  6. Inventory Packages

    Provides a list of all packages in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint.....           WITH CTE AS (     SELECT         ISN...
  7. Inventory Packages (Simple)

    Provides a list of all packages in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint.....           WITH CTE AS (     SELECT         ISNULL(I...
  8. Inventory Packages and Macros

    Provides a list of all packages and macros in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint.....          WITH CTE AS (     SELECT    ...
  9. Print Barcode(s)

    Print barcode label for an asset or for all assets belonging to a product
  10. Inventory Report of Assets (No Maintenance Detail)

    /* Lists all assets in the Database */ SELECT I.groupfld               AS [Group],        g.group_descv6           AS [Group Desc],        i.category               AS [Category],        c.cat_descv6             AS [Category Desc],        A.pr...