Assets Checked Out on What Booking?

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 qtycheckedout > qtyreturned

and product_code_v42 = 'ABC123'