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—ke...
  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 (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...
  7. Print Barcode(s)

    Print barcode label for an asset or for all assets belonging to a product
  8. 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...
  9. RTF Colour Insert Fields

    RTF Insert fields are used to merge data from your RentalPoint Database with your MS Word template.  Fields are available via the RentalPointInsertFieldModules.dll  file or see our list of RTF Insert fields . Colour Insert Fields INSERT FIEL...
  10. Technicians - Active

    SELECT         c.contactname    AS [CONTACT NAME],        c.firstname      AS [FIRSTNAME],        c.midname        AS [MIDDLE NAME],        c.surname        AS [SURNAME],        c.adr1           AS [ADDRESS 1],        c.adr2           AS [ADDR...