-
...
-
Used to export all Venue information to Excel via the Excel Query builder. The first line will provide the Venue name and address information, if you don't need any of the other information you can remove it from the query, each line in italicizes...
-
While using RentalPoint, you’ll notice a small map button in the address areas. Hover over it to reveal Get directions to this address. RentalPoint interfaces with two popular search engines, Google Maps and Microsoft Bing Maps. Operators can use th...
-
For a history of Asset Movement Go to Inventory Setup (hit F10 for shortcut) Locate the asset you want to get a history on in the Inventory Tree Right Click on the asset and click 'Show Asset Movement' Note the scope at the bottom of ...
-
DECLARE @Today DATETIME set @Today = CONVERT(datetime,Convert(Char(10), GetDate(),20),20) select I.booking_no_v32 as [Booking Number] , I.product_code_v42 AS [Product Code], I.trans_qty AS [Qty Ordered], ...
-
Last Updated: 03/06/2022
in Working With RentalPoint Misc
...
-
select I.booking_no_v32 as [Booking #], I.FirstDate as [Out Date], I.RetnDate as [In Date], I.product_code_v42 as [Product], m.descriptionV6 as [Description] from tblitemtran I left outer join tblinvmas m on m.pr...
-
In search of unused assets? This query will show assets that have not be scanned on to or off a booking, thus haven’t been used in RentalPoint. You can execute this query using Excel Query Builder in RentalPoint... select A1.* fro...
-
Shows New Bookings Entered TODAY SELECT B.booking_no AS Code, B.organizationv6 AS Company, B.ddate AS [Out Date], D.div_name AS Division, CASE ...
-
Booking Cross Section This report retrieves all confirmed, current and archived bookings between the selected dates. It retrieves basic information such as the total gross rental amount, discount amount and sub rental amount. This report may also b...