New Articles

  1. 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 2023 and is forw...
  2. Rolling Revenue Report for Previous 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. */ /* Key Features & Metrics: ...
  3. Labour Products and Assigned Technicians

    /* Listing of Labour Products and the technicians assigned to them  */ WITH CTE AS (     SELECT         ISNULL(I.groupfld,' ')                AS ParentGroup,         ISNULL(PG.group_descv6,' ')           AS ParentGroupDesc,         ISNULL(I...
  4. 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(...
  5. 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...
  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. 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    ...
  8. Print Barcode(s)

    Print barcode label for an asset or for all assets belonging to a product
  9. 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...
  10. 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...