-
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...
-
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...
-
/* 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...