-
The accessories and components are stored in a table called tblBill and link back to the main inventory master table tnlInvmas. The easiest way of creating this report will be by an Excel ODC query as per the instructions on the knowledge base at ...
-
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...
-
/* Report of all assets in the system ordered by Purchase Date (newest to oldest) */ SELECT I.groupfld AS [Group], g.group_descv6 AS [Group Desc], i.category AS [Category...
-
Update your RentalPoint license file from the main RentalPoint menu as follows: If you are running an older version of the software and don't have this option, please consider upgrading or contact support@rentp.com to update your license file. ...
-
...
-
...
-
...
-
Archiving is a tool designed to improve performance and remove the clutter of non-relevant or old items in the RentalPoint system database. Archiving Bookings Archiving prevents the system from having to load hundreds or thousands of bookings in...
-
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], ...
-
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], ...