-
/*Export a distribution list for all contacts in the database with an email address and send emails box checked*/ SELECT [CallListID], [ContactID], [Completed], [ActivityID], C.firstname, C.surname, C.AskFor, c....
-
Last Updated: 03/06/2022
in Working With RentalPoint Misc Error producing reports/merging templates when using Office 365 Error text: "There is no application associated with the '.CSV' file extension" Reason: Latest Office 365 updates (Apr 2019) have left Windows unable to open Excel or Word when c...
-
Values for Event Type and Source/Campaign can be stored against each booking and used for reporting purposes. Here's how to use them...... For Event Type, set your Event List in Operational Parameter 83, you'll then see a drop down list against Eve...
-
The Items Not Returned Discrepancy report details all assets and the bookings that they are assigned to that have been delivered but have not yet been returned. If your company is running multi locations this report is location specific. This repor...
-
Last Updated: 18/01/2019
in Working With RentalPoint Misc RentalPoint Offers the ability to increase/decrease inventory pricing across a selection of products *** Please take a backup of your database before using this feature to update pricing *** ** Once updated, there is no 'undo' option ** Refer to...
-
Change the booking number to the one you are working on. This query will show all sub rentals, transfers, PO's assigned to your booking DECLARE @MYBOOKING VARCHAR(13) = 'CATHAY00003' DECLARE @Items TABLE ( [id] DECIMAL(10...
-
SELECT contactname,
count(1) AS cnt
FROM tblcontact
GROUP BY Contactname
HAVING count(1) >1;
-
Last Updated: 24/04/2019
in Working With RentalPoint Misc Contact Management Preferences Goto Setup-->Contact Management to set up parameters for Contact Management From here you can set up Contact Management Preferences, including 'pop up message preference' and 'check message interval' for...
-
The query you have will give you assets out on a given date - even if they were checked back in after that date Technically they were OUT on the given date, it will also show items that were never returned. Things to Note: ActOutDate is the ...
-
SELECT c.ContactName AS [Contact Name], c.firstname as [First Name], c.surname as [Surname], T.OrganisationV6 AS [Company], c.position as [Position], c.Email AS [E-mail], ...