-
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 ...
-
Assets NOT Returned Rentalpointv10.
Lists all asset Tracked items with WH in date that has passed (i.e. NOT returned)
-
Shows a list of all assets scanned out to maintenance You can execute this query using Excel Query Builder in RentalPoint... SELECT IM.groupFld [Group],
IM.category [Category],
A.PRODUCT_COde [Product],
A.ASSET...
-
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...
-
Shows movement of all assets in the database You can execute this query using Excel Query Builder in RentalPoint... SELECT IM.groupFld [Group], IM.category [Category], A.PRODUCT_COde [Product], A.ASSET_CODE [Barcode], A.SERIAL_NO [Ser...
-
List of third party accounting packages available to export to. Each package listed has been designed in RentalPoint to export the required data and format.
-
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...
-
This is a very complex query so it will be difficult for most users to modify. however if changes need to be made please contact support. This will export the same data that is available via the booking grid. You can execute this query using ...
-
.
-
For counting barcode tracked items you may want to set Operational Parameter 65 to YES so that the stock qty for each product is counted from the asset records.