-
You can execute this query using Excel Query Builder in RentalPoint..... SELECT A.product_code AS [Product Code], I.descriptionv6 AS [Product Description], A.asset_code AS [Bar Code], LO.locn_name AS [Locatio...
-
SELECT B.booking_no as [Booking Number], B.organizationv6 as [Company], B.Showname as [ShowName], B.DateLastModified as [Cancellation Date], B.dDate [Warehouse Out Date], B.ShowSdate as [Show Start Date], S....
-
/* Shows all active customers with notes */ SELECT CASE WHEN N.line_no = 1 THEN n.customer_code ELSE '' END AS [COMPANY CODE], CASE WHEN N.line_no = 1 THEN C.OrganisationV6 ELSE '' END AS [COMPANY NAME], N.line_no AS LINE, ...
-
Quick turnaround can cover shortages by quickly prepping equipment for early release when it comes back into the warehouse or directly transferring it to another booking onsite. Setting a line as quick turnaround does not affect regular availability...
-
Alternate language description for product We would like to add an alternate description for English (we consider French as main) for every product (including crew products) on the database. In “other details” tabs of the booking, we could select th...
-
--Lists Customers with invoices between the date range specified--- --Change the dates below for the dates you want to run the query -- DECLARE @StartDate AS VARCHAR (20) DECLARE @EndDate AS VARCHAR (20) SET @StartDate = ' Jan 1 2019 ' ...
-
Rentalpoint offers the ability to resolve discrepancies on bookings, ie. when gear that has been scanned out/checked out and shipped for a booking, is different to what was originally booked. This article covers resolving discrepancies only,...
-
Auto-resolve option for alternatives, allows an additional item scanned at check-out to automatically replace an unshipped item. Set Up Items must be set up to auto resolve in Inventory Setup. Ensure the possible replacement product is lis...
-
RentalPoint Fast Reports at a Glance Fast Report has been integrated into RentalPoint in order to add flexibility to output documentation and report generation. Unlike RTF templates where you could only use a certain set of data, with Fast Report...
-
Available in RentalPoint Version 12 Predetermine how RentalPoint should handle items that are packed in a roadcase, but scanned out as a single item during checked session! Exceptions: When RFID is in use, the action is set to 'Do not check ou...