Updated Articles

  1. Assets out on given date

    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 ...
  2. Assets NOT Scanned Out Since Date

    In search of unused assets?   This query will show  assets that have not be scanned on to or off a booking, thus haven’t been used in RentalPoint. You can execute this query using Excel Query Builder in RentalPoint... select A1.* fro...
  3. Assets NOT Scanned in Stocktake Since Date

    This query can be run to find all the assets that have not be scanned in 12 months or 24 months in a stocktake, so we know the missing items.  You'll need to change the EntryDateTime to get the records within your specified timeframe. You can ex...
  4. Assets checked out to a booking

    /* From within RentalPoint, right click on your booking and print-->packing list */ /* OR change the value of @Booking_no below and execute this query */ You can execute this query using Excel Query Builder in RentalPoint..... DECLARE...
  5. Remove Lock From Parameter File

    Parameter Setup is locked for updating once accessed by any user, for the duration of the edit.  Sometimes, if a user gets disconnected or doesn't log out correctly, the lock can remain in place even when Parameter Setup is no longer in use. Should...
  6. Known Issues

    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...
  7. Margin Panel

    ...
  8. Profit Margin Targets

    ...
  9. Hotel Master Billing

    ...
  10. Excel Query Builder

    ...