-
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...
-
The Product History report retrieves statistics about past transactions of a product. Details are compiled from both current and archived bookings and are listed in Warehouse Out Date order. Information such as Total Cost Value, Amount Earned, utili...
-
WARNING: This report may take some time to process. It is highly recommended that you narrow down your search by selecting a specific group, category or product. How to run the Asset Listing report? 1. Click on the Reports menu 2. Select Pro...
-
Parameters Affecting Asset Depreciation Operational Parameter 112 'Depreciation Basis' Accounting - Use the start date of the asset to determine the starting date to depreciate from. Tax - Use purchase date of the asset to determine th...
-
The accessories and components are stored in a table called tblBill and link back to the main inventory master table tnlInvmas. The easiest way of creating this report will be by an Excel ODC query as per the instructions on the knowledge base at ...
-
This is an advance query as you will need to change date range as needed. This query will allow you to get the revenue that packages generated as well as determine how many times a package has been rented within a particular time period. Date r...
-
Assets NOT Returned Rentalpointv10.
Lists all asset Tracked items with WH in date that has passed (i.e. NOT returned)
-
The queries below will provide an export OF your RentalPoint Labour IN Excel format.
For Labour listed IN unarchived bookings
/*This query will provide a summary OF crew requirements*/
SELECT IM.descriptionV6 [Designation],
T....
-
Shows CARNET details for all items that were checked out after a given date and have not been returned yet. SELECT A.BOOKING_NO AS [Booking], M.groupFld AS [Group], M.category AS [Category], A.DESCRIPTION AS [Description], ...
-
Shows Bookings entered IN the LAST 7 days
SELECT B.booking_no AS Code,
B.OrganizationV6 AS Company,
B.dDate AS [Out Date],
D.div_name AS Division,
CASE
WHEN B.BookingProgressStatus = 0 THEN 'Quote'
...