Updated Articles

  1. Using Booking Source or Event Type

    Values for Event Type and Source/Campaign can be stored against each booking and used for reporting purposes. Here's how to use them...... For Event Type, set your Event List in Operational Parameter 83, you'll then see a drop down list against Eve...
  2. Inventory Report of Assets by Purchase Date

    /* Report of all assets in the system ordered by Purchase Date (newest to oldest) */ SELECT I.groupfld                       AS [Group],        g.group_descv6                   AS [Group Desc],        i.category                       AS [Category...
  3. Inventory Report of Non Tracked Gear

    Shows a list of all non asset tracked gear in your system.
  4. Updating Your RentalPoint License File

    Update your RentalPoint license file from the main RentalPoint menu as follows: If you are running an older version of the software and don't have this option, please consider upgrading or contact support@rentp.com to update your license file. ...
  5. Archiving in RentalPoint

    Archiving is a tool designed to improve performance and remove the clutter of non-relevant or old items in the RentalPoint system database. Archiving Bookings Archiving prevents the system from having to load hundreds or thousands of bookings in...
  6. Transfers Checked out today and balance Pending checkout

    DECLARE @Today DATETIME set @Today = CONVERT(datetime,Convert(Char(10), GetDate(),20),20) select    I.booking_no_v32 as [Booking Number] ,              I.product_code_v42 AS [Product Code],              I.trans_qty AS [Qty Ordered],         ...
  7. Contacts List - All Contacts Added in the Last 30 Days

    SELECT c.ContactName AS [Contact Name],              c.firstname as [First Name],              c.surname as [Surname],              T.OrganisationV6 AS [Company],             c.position as [Position],              c.Email AS [E-mail],         ...
  8. Crew Reports

    Crew Report Operator Privileges Many Crew Reports have associated operator privileges limiting access to users.  See Setup-->Operators-->Reports Tab for operator privileges governing Crew Reports Crew Assignment This report details the activit...
  9. Products in Trash used on Bookings

    select I.booking_no_v32 as [Booking #],         I.FirstDate as [Out Date],         I.RetnDate as [In Date],         I.product_code_v42 as [Product],        m.descriptionV6 as [Description] from tblitemtran I left outer join tblinvmas m on m.pr...
  10. v11.3.2 Release Features Guide

    New Features Added: ** Click on the adjacent link where relevant which will open full documentation in another tab ** New Asset Audit Trail - [Learn More Here] Unpack button now available in the pack rack/roadcase window   [Full Documentation ...