-
/* 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...
-
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...
-
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...
-
SELECT G.group_code AS [Product Group], G.group_descv6 AS [Group Description], IM.category AS [Product Category], C.cat_descv6 ...
-
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 ...
-
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...
-
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...
-
/* 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...
-
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...
-
Register your company for access to RentalPoint upgrades