New Articles

81. Inventory Report of Assets by Purchase Date

    Created On: 03/12/2018 in Reports and Templates SQL Queries
    /* 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...

82. Updating Your RentalPoint License File

    Created On: 27/11/2018 in Getting Started With RentalPoint RentalPoint Related I.T
    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. ...

83. RTF Insert Fields

    Created On: 29/10/2018 in Reports and Templates Microsoft Office and RTF Fields
    ...

84. Margin Panel

    Created On: 16/10/2018 in Working With RentalPoint Misc
    ...

85. Profit Margin Targets

    Created On: 16/10/2018 in Working With RentalPoint Misc
    ...

86. Archiving in RentalPoint

    Created On: 02/10/2018 in Working With RentalPoint Bookings Miscellaneous
    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...

87. Transfers Checked out today and balance Pending checkout

    Created On: 27/09/2018 in Reports and Templates SQL Queries
    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],         ...

88. Contacts List - All Contacts Added in the Last 30 Days

    Created On: 14/09/2018 in Reports and Templates SQL Queries
    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],         ...

89. Products in Trash used on Bookings

    Created On: 04/09/2018 in Reports and Templates SQL Queries
    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...

90. Hotel Master Billing

    Created On: 04/09/2018 in Working With RentalPoint Misc
    ...

• ← Back
• Viewing 81 - 90 of 359
• More →