New Articles | Page 3

Racks & Roadcases

Created On: 15/09/2020 in Working With RentalPoint Products Rental & Sales Products

Racks and Roadcases Defined When Should I use a Roadcase? Use a road case when you have a barcoded container that items can be scanned and placed into, prior to the road case being scanned and loaded onto the truck for shipping; items can easil...
Change Customer Code for Existing Customer

Created On: 20/07/2020 in Troubleshooting FAQ's

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...
Venue Flow Sheet

Created On: 04/06/2020 in Working With RentalPoint Misc

Output Information The Venue Flow Sheet is used in conjunction with Hotel Master Billing . The report itemizes: Each venue selected Booking reference/number Product usage timeline (based on setup, show start and end times from calendar t...
Customer with Notes (using SQL function)

Created On: 03/04/2020 in Reports and Templates SQL Queries

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...
Cancelled Bookings

Created On: 27/03/2020 in Reports and Templates SQL Queries

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....
Active Customers with Notes

Created On: 25/03/2020 in Reports and Templates SQL Queries

/* 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, ...
RentalPoint Add-Ins Tab in Word 2016

Created On: 17/12/2019 in Reports and Templates Microsoft Office and RTF Fields

Find the location of your Word Startup Folder Open Word, then press Alt+F11 to open the macro editor, VBE . In the VBE window, press Ctrl+G to go to the Immediate window . In the Immediate window , type: ?Application.StartupPath Press ...
Mobile Delivery App

Created On: 27/11/2019 in Additional Modules

Available in RentalPoint v12, use this Web based Mobile Delivery App to view RentalPoint scheduled Deliveries and Returns, Print a Delivery Sheet/ Collection Docket and Collect Digital Signatures on the go. Scalable to fit on any tablet or cell phone screen!
Customers with Invoices Within Date Range

Created On: 21/11/2019 in Reports and Templates SQL Queries

--Lists Customers with invoices between the date range specified--- --Change the dates below for the dates you want to run the query -- DECLARE @StartDate AS VARCHAR (20) DECLARE @EndDate AS VARCHAR (20) SET @StartDate = ' Jan 1 2019 ' ...
Configure RentalPoint to use Projects

Created On: 19/11/2019 in Working With RentalPoint Bookings Projects

Goto Setup-->Parameters-->Operational Enable Projects Check Project Manager User Interface Tab-->Check Projects Access from the Bookings Menu Scope section Optional Project Parameters Goto Setup-->Parameters-->Operational...