Updated Articles

  1. Hardware Requirements

    Below are the minimum and suggested system requirements for RentalPoint. These requirements are for the RentalPoint application only, and do not necessarily apply to the OS or SQL requirements. Minimum 1.8 Ghz Intel Core or AMD Athlon CPU 4+ G...
  2. Technicians - Active

    SELECT         c.contactname    AS [CONTACT NAME],        c.firstname      AS [FIRSTNAME],        c.midname        AS [MIDDLE NAME],        c.surname        AS [SURNAME],        c.adr1           AS [ADDRESS 1],        c.adr2           AS [ADDR...
  3. Contacts List

    SELECT T.OrganisationV6 AS [COMPANY], c.ContactName AS [CONTACT NAME], c.FirstName AS [FIRSTNAME], c.MidName AS [MIDDLE NAME], c.Surname AS [SURNAME], c.Adr1 AS [ADDRESS 1], c.Adr2 AS [ADDRESS 1], ...
  4. Customers including Credit Info

    SELECT c.OrganisationV6 AS Company,        c.contactV6 AS [Main Contact],        CASE            WHEN c.stop_credit = 0 THEN 'Allow Credit'            WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT TRADE'            WHEN c.stop_credit = 2 TH...
  5. Customer Details with Last Booking Entered

    SELECT c.OrganisationV6 AS Company,          BK.MAX_DATE [Last Booking Entry],        c.contactV6 AS [Main Contact],        CASE            WHEN c.stop_credit = 0 THEN 'Allow Credit'            WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT ...
  6. Customers List

    This will provide the mailing address for active customers, this could be used for creating mailing lists. SELECT c.OrganisationV6 AS Company,        c.contactV6 AS [Main Contact],        CASE            WHEN c.stop_credit = 0 THEN 'All...
  7. Shortages

  8. QuickBooks Online

    Offered in RentalPoint v11.4 and higher, Once configured, all invoices, payments and credits processed in RentalPoint, can now be exported to Quickbooks Online!
  9. Print Barcode(s)

    Print barcode label for an asset or for all assets belonging to a product
  10. Stock Take - Non Barcoded Items

    /*All NON Barcode tracked Rental Items in Inventory Master with a count of whats out on a booking */ Select m.product_code AS [PRODUCT CODE],           m.descriptionV6 AS [DESCRIPTION],          ('$' + convert(VARCHAR,convert(money,m.cost_price...