New Articles | RentalPoint

Print Barcode(s)

Created On: 16/07/2025 in Working With RentalPoint Products Assets

Print barcode label for an asset or for all assets belonging to a product
Inventory Report of Assets (No Maintenance Detail)

Created On: 15/07/2025 in Reports and Templates SQL Queries

/* 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...
RTF Colour Insert Fields

Created On: 02/04/2025 in Reports and Templates Microsoft Office and RTF 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...
Technicians - Active

Created On: 14/02/2025 in Reports and Templates SQL Queries

SELECT c.contactname AS [CONTACT NAME], c.firstname AS [FIRSTNAME], c.midname AS [MIDDLE NAME], c.surname AS [SURNAME], c.adr1 AS [ADDRESS 1], c.adr2 AS [ADDR...
Rental Items not returned between date range

Created On: 16/07/2024 in Reports and Templates SQL Queries

/* All gear that didn't make it back from a show within date range, include warehouse status of the booking */ DECLARE @StartDate AS VARCHAR(20) DECLARE @EndDate AS VARCHAR(20) SET @StartDate = '2024-03-30' SET @EndDate = '2024-07-01' sele...
Invoices Outstanding

Created On: 21/12/2023 in Reports and Templates SQL Queries

/* Shows all invoices with outstanding balance based on closing date with an outstanding amount greater than InvValue */ DECLARE @ClosingDate AS VARCHAR (20) DECLARE @InvValue FLOAT SET @ClosingDate = '2024-2-1' SET @InvValue = 1 SELECT B.b...
RP2 (RentalPoint for Windows version) Release Notes

Created On: 10/05/2023 in Getting Started With RentalPoint RentalPoint Related I.T General Release Notes

Access to the latest release is free with a current SSAP/Cloud subscription RentalPoint Cloud clients should email support@rentp.com to request an upgrade to your server Click here to Register for SSAP downloads RentalPoint3 release...
Assets Purchased Between Date Range

Created On: 14/03/2023 in Reports and Templates SQL Queries

SELECT IM.groupfld AS [Product Group], IM.category AS [Product Category], A.product_code AS [Product Code], IM.descriptionv6 AS [Product Description], A.asset_code AS [Bar Code Number], A.descr...
Rental Products and Assets

Created On: 07/02/2023 in Reports and Templates SQL Queries

SELECT G.group_code AS [Product Group], G.group_descv6 AS [Group Description], IM.category AS [Product Category], C.cat_descv6 ...
Customer Details with Last Booking Entered

Created On: 03/02/2023 in Reports and Templates SQL Queries

SELECT c.OrganisationV6 AS Company, BK.MAX_DATE [Last Booking Entry], c.contactV6 AS [Main Contact], CASE WHEN c.stop_credit = 0 THEN 'Allow Credit' WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT ...