New Articles | Page 3

Customers

Created On: 02/03/2021 in Working With RentalPoint

Customer / Financial Reports Credit Card Processing in RentalPoint Invoicing Options Cancel/Credit an Invoice Applying Payments Online Payment Option ...
Asset Out Between Date Range

Created On: 19/02/2021 in Reports and Templates SQL Queries

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...
Product Setup

Created On: 21/09/2020 in Working With RentalPoint Products Rental & Sales Products

The Product Record Add/Edit Products To add, edit duplicate or delete items in your inventory tree you can use the buttons located on the right side of the F10 window, or you can use the right click options. General Tab This section is use...
Asset Overview

Created On: 21/09/2020 in Working With RentalPoint Products Assets

The Asset Record Assets are the individual items that are sent to a client, where each item is tracked in RentalPoint via a unique barcode. You may have five microphones in your warehouse; to track the microphones at an asset level you'll need to...
Racks & Roadcases

Created On: 15/09/2020 in Working With RentalPoint Products Rental & Sales Products

Racks and Roadcases Defined When Should I use a Roadcase? Use a road case when you have a barcoded container that items can be scanned and placed into, prior to the road case being scanned and loaded onto the truck for shipping; items can easil...
Change Customer Code for Existing Customer

Created On: 20/07/2020 in Troubleshooting FAQ's

Current Customer Current Bookings To change the customer code, access the Database Wizard per menu option below Use to search for the current customer, then enter the new customer code and click Th...
Venue Flow Sheet

Created On: 04/06/2020 in Working With RentalPoint Misc

Output Information The Venue Flow Sheet is used in conjunction with Hotel Master Billing . The report itemizes: Each venue selected Booking reference/number Product usage timeline (based on setup, show start and end times from calendar t...
Customer with Notes (using SQL function)

Created On: 03/04/2020 in Reports and Templates SQL Queries

Knowledge of SQL Server Management Studio is needed to create the function below in the database, please contact support@rentp.com for assistance if needed Execute the function below in SQL Server Management Studio using your database name U...
Cancelled Bookings

Created On: 27/03/2020 in Reports and Templates SQL Queries

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....
Active Customers with Notes

Created On: 25/03/2020 in Reports and Templates SQL Queries

/* 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, ...