New Articles | Page 4

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...
Quick Turnaround Items

Created On: 13/11/2019 in Working With RentalPoint Bookings Inventory and Bookings

Quick turnaround can cover shortages by quickly prepping equipment for early release when it comes back into the warehouse or directly transferring it to another booking onsite. Setting a line as quick turnaround does not affect regular availability...
Auto Resolve on Checkout

Created On: 12/11/2019 in Working With RentalPoint Bookings Tracking a Booking

Auto-resolve option for alternatives, allows an additional item scanned at check-out to automatically replace an unshipped item. Set Up Items must be set up to auto resolve in Inventory Setup. Ensure the possible replacement product is lis...