-
Date: November 30, -0001 The Recommended Re-order report is used as a way to preemptively order items before they run out of stock. It is a forward looking report that only retrieves items that are below the re-order level. However if the item ha...
-
Cash Flow If you are looking at creating a future cash flow report, then consider the Revenue Report that is available on the 'Reports' menu in RentalPoint? Although this report may not show all the custom fields you are looking for, it does g...
-
Date: November 30, 2001 This report displays the top number of products that have the highest number of enquiries compared with the quantity owned. When an item is enquired upon it means that the item was added to a booking. However the booking d...
-
select * from tblitemtran where ISNULL(product_code_v42 , '') '' AND ISNULL(product_code_v42 , '') NOT IN ( select ISNULL(product_code, '') from tblinvmas)
-
Invoiced Bookings with shortages, where warehouse out date is greater than Jan 1 2017. Change the date as needed
-
Last Updated: 03/06/2022
in Working With RentalPoint Crew Full Video Demo of RPWebServices for RentalPoint This add on allows technicians to log on, view their jobs on a calendar, accept jobs, update their contact, primary and secondary skill details. This video shows: The web browser based view of t...
-
--Lists Customers with invoices between the date range specified--- --Change the dates below for the dates you want to run the query -- DECLARE @StartDate AS VARCHAR (20) DECLARE @EndDate AS VARCHAR (20) SET @StartDate = ' Jan 1 2019 ' ...
-
Counting Barcode/Asset Tracked Items 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. This will only count assets for products whe...
-
Last Updated: 03/06/2022
in Working With RentalPoint Misc Written by Timothy Grafton 7th August 2015 Settlement discount is a discount that is offered to some clients if they pay their invoice within a set time frame, for example - 30 days. ...
-
/* Report of all assets in the system ordered by Purchase Date (newest to oldest) */ SELECT I.groupfld AS [Group], g.group_descv6 AS [Group Desc], i.category AS [Category...