-
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...
-
Import changes to existing inventory with a smaller selection of data (for example rate and weight) First export product information (copy/paste the query below into Export Query Builder ) SELECT G.group_code AS [Product Group], G.g...
-
Last Updated: 03/06/2022
in Working With RentalPoint Misc Parameter Setup is locked for updating once accessed by any user, for the duration of the edit. Sometimes, if a user gets disconnected or doesn't log out correctly, the lock can remain in place even when Parameter Setup is no longer in use. Should...
-
When cancelling an invoiced , the corresponding invoice is automatically credited When re-invoicing a booking, processing is dependant on Invoicing Parameter 47 setting: Invoicing Parameter #47 When set to 'Keep the same Number when re-invoi...
-
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...
-
Last Updated: 08/03/2022
in Working With RentalPoint Crew Technician Timesheet for Booking Print a report of technician hours entered for a given booking as follows: Narrow scope to one technician or print for all technicians on the booking Operator Privileges If the above option is not ...
-
SELECT G.group_code AS [Product Group], G.group_descv6 AS [Group Description], IM.category AS [Product Category], C.cat_descv6 ...
-
The query you have will give you assets out between the selected date range Things to Note: ActOutDate is the date the item was checked out ActInDate is the date the item was checked in The 1980 showing in ActInDate would mean the item was neve...
-
You can execute any of the queries below using Excel Query Builder in RentalPoint..... Remember to change the date values (highlighted in red below) as needed. Freight Report for Date Range DECLARE @fromdate DATETIME DECLARE @todate DATE...
-
select B.booking_no 'Booking #', CASE WHEN B.Booking_type_v32 = 0 THEN 'Rental' WHEN B.booking_type_v32 = 1 THEN 'Sub Hire' WHEN B.booking_type_v32 = 2 THEN 'Quote' ELSE '' END AS Type, ...