New Articles | Page 1

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 n...
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 ...
Import Products from Excel File

Created On: 09/12/2022 in Working With RentalPoint Products Rental & Sales Products

Using the 'Rental Inventory.csv' template available with the Product Import option in RentalPoint2, you can import Products and their assets using the 'Clear All' 'Match All' functionality in the system. Please take a backup of your database befo...
Custom Fields

Created On: 15/11/2022 in Working With RentalPoint Customers

Occasionally users may find it necessary to store additional customer information against a customer record. Our custom field option allows users to achieve this with ease. Right click on customer grid Admin-->setup custom fields Enter whatev...
Transfers

Created On: 12/09/2022 in Reports and Templates SQL Queries

/* All transfers and bookings they are assigned to*/ Select T.booking_no [Code], isnull(B.OrganizationV6,'') [Company], DATENAME(WEEKDAY,T.ddate) [Out], convert(varchar,T.ddate,105) [Date], dbo.MakeTime(T.de...