New Articles | RentalPoint

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 = ...
RP2/RP3 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.descrip...
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 &...
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.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...
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 Ente...
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], &...
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 f...
RentalPoint Registration and Software Upgrades

Created On: 20/05/2022 in Getting Started With RentalPoint RentalPoint Related I.T General Upgrading RentalPoint

Register your company for access to RentalPoint upgrades