Popular Articles

  1. Package Products

    Package Products A package is used when you would like to set up a group of items/products that would have a package price when booked together.  Set up your package product first.  Identify the item as a package product under the general tab--...
  2. Cancelled Bookings

    SELECT B.booking_no as [Booking Number],        B.organizationv6 as [Company],        B.Showname as [ShowName],        B.DateLastModified as [Cancellation Date],        B.dDate [Warehouse Out Date],        B.ShowSdate as [Show Start Date],        S....
  3. RentalPoint To Go

    RentalPoint has two mobile scanner options: Windows Mobile Scanner The Windows tablet is large enough to run RentalPoint in full screen.  Scanner handle is available from the 'related products' at the bottom of the link Mobile Tablet: http...
  4. Change Customer Code for Existing Customer

    Current Customer Current Bookings To change the customer code, access the Database Wizard per menu option below Use  to search for the current customer,  then enter the new customer code and click Th...
  5. Venues Export

    Used to export all Venue information to Excel via the Excel Query builder.  The first line will provide the Venue name and address information, if you don't need any of the other information you can remove it from the query, each line in italicizes...
  6. RentalPoint Port & Additional Module Usage

    RentalPoint2 is designed to run on a Windows Operating System using a compatible Network Type with Minimum Hardware Requirements.   Information is stored in a RentalPoint Database hosted in Microsoft SQL Server.   Below is an outline of ports ...
  7. Customer with Notes (using SQL function)

    Knowledge of SQL Server Management Studio is needed to create the function below in the database, please contact support@rentp.com for assistance if needed Execute the function below in SQL Server Management Studio using your database name U...
  8. Active Customers with Notes

    /* Shows all active customers with notes */ SELECT        CASE WHEN N.line_no = 1 THEN n.customer_code ELSE '' END AS [COMPANY CODE],        CASE WHEN N.line_no = 1 THEN C.OrganisationV6 ELSE '' END AS [COMPANY NAME],        N.line_no AS LINE, ...
  9. Asset Listing

    Lists Assets in inventory with some rate and product information You can execute this query using Excel Query Builder in RentalPoint... SELECT A.description                                            AS [Asset Description],        A...
  10. Add default Multi Stage Terms for all Customers that don't have default terms

    /* Set up default 50/50 payterm stages for all customers that are not already set up for multi stage invoicing  Change the Stage and StageName values as needed Contact support@rentp.com to modify this query */ DECLARE mycursor CURSOR fast_forward...