-
How Does RentalPoint Support Crystal Reports? RentalPoint Software only supports Crystal Reports written by RentalPoint Software. There are significant differences between Rentalpointv10 and Rentalpointv11 integration with Crystal Reports. Y...
-
Lists Assets in inventory with some rate and product information You can execute this query using Excel Query Builder in RentalPoint... SELECT A.description AS [Asset Description], A...
-
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...
-
You can execute this query using Excel Query Builder in RentalPoint... SELECT A.asset_code [Barcode],
A.product_code [Product],
A.description,
A.Location,
A.stock_number [Stock Number],
A.serial_...
-
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...
-
Shows what booking an asset is checked out on.. You can execute this query using Excel Query Builder in RentalPoint... select booking_no_v32, product_code_v42, trans_qty, qtycheckedout, qtyreturned from tblitemtran where qtychecked...
-
Assets NOT Returned Rentalpointv10.
Lists all asset Tracked items with WH in date that has passed (i.e. NOT returned)
-
The query you have will give you assets out between the selected date range Things to Note: ActOutDate is the date the item was checked out ActInDate is the date the item was checked in The 1980 showing in ActInDate would mean the item was neve...
-
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 ...
-
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...