New Articles | RentalPoint

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 BK.CUST as [Customer Code], c.OrganisationV6 as [Organization], c.contactv6 as [Contact], c.phone1countrycode as [Phone1 Country], CONCAT(c.Phone1AreaCode,' ', c.Phone1Digits) as [Phone1], ...
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...
Sales Inventory Export

Created On: 31/05/2022 in Reports and Templates SQL Queries

The query below will provide an export of all Sales Equipment. Each line is a separate field with the first 3 in Bold being mandatory for importing back into the system. Please contact support@rentp.com before attempting an import for the fir...