-
For bulk modifications to asset fields, you can export all assets to csv, modify the field content and re-import using the following approach. Take a backup of your Database..click to see how (do not skip this step) Export all as...
-
SELECT T.OrganisationV6 AS [COMPANY],
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 [ADDRESS 1],
...
-
RentalPoint2 is designed to run on a Windows Operating System using a compatible Network Type with Minimum Hardware Requirements. Information is stored in a RentalPoint Database hosted in Microsoft SQL Server. Below is an outline of ports ...
-
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...
-
Goto Setup-->Parameters-->Operational Enable Projects Check Project Manager User Interface Tab-->Check Projects Access from the Bookings Menu Scope section Optional Project Parameters Goto Setup-->Parameters-->Operational...
-
What is it? When bookings are added to a project entered for a festival or event, there may be equipment that is not required for the entire duration of the project that can be reused for another booking on the same event. The optimal equipment ...
-
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...
-
Overview RentalPoint now offers functionality to build a Virtual Carnet for checked out bookings. Users can create a list of boxes/cases, allocate items to each case and either manually enter dimensions or have RentalPoint load dimensions from I...
-
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, ...
-
Asset Maintenance RentalPoint supports tracking of assets in and out of maintenance for service and repairs. Access the maintenance menu via Products-->maintenance tab Find a Maintenance Record Use the 'Find' menu option to search by barcod...