-
The Tax report displays a listing of all customers, the total amount of an invoice, any credited invoices and how much tax they paid on that invoice in the given time frame. It is possible to isolate singular taxes and divisions. This is not the onl...
-
SELECT c.OrganisationV6 AS Company,
c.contactV6 AS Contact,
CASE
WHEN c.stop_credit = 0 THEN 'Allow Credit'
WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT TRADE'
WHEN c.stop_credit = 2 THEN 'STO...
-
The Late Returns report lists all rentals that are past their expected return date. This does not take into account partial returns. If a booking is not in returned status and is past due to be returned, this report will flag it. An example output ...
-
The Cross Rental Statistics report details all bookings with cross rentals and how much the customer was charged for the cross rentals. There are several scopes that are available to this report. ...
-
Last Updated: 17/07/2017
in Training Videos
-
This report displays the top cross rented products that have the highest dollar value for cross rentals over the selected period. A Detailed option lists all the cross rental bookings that comprise the total. ...
-
Shows a list of all assets entered since a specific purchase date. Change the purchase date below for specific results. select A.ASSET_CODE as [Barcode], A.DESCRIPTION as [Asset Description], A.modelNumber as [Asset Model #], ...
-
/* This query will show a count of all given customer bookings, current and archived, that have a warehouse out date within the date range provided */ DECLARE @StartDate AS VARCHAR(20) DECLARE @EndDate AS VARCHAR(20) DECLARE @CustCode AS VARC...
-
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...
-
The product movements report will show increases and decreases in stock quantity due to purchases, sales or transfers to and from another location. Product movements can be viewed for a specific product, group or category, as well as for specific...