-
SELECT c.OrganisationV6 AS Company,
d.div_name AS Division,
c.contactV6 AS Contact,
CASE
WHEN c.stop_credit = 0 THEN 'Allow Credit'
WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT TRADE'
...
-
Purchase Orders entered over the last 90 days
-
This query will return all products due to go out today or in the future for the AUDIO group. Change the AUDIO group below to whatever group you need OR remove the last AND clause to get all groups SELECT i.booking_id [Booking],
i.produc...
-
List items on the Purchase Order Grid based on the selection criteria in the 'Where' clause bolded below SELECT P.Location, P.ID, P.PVendorCode, ISNULL(B.RDate, 'Jan 1 1980') AS rdate, (CASE P.CrossRental WHE...
-
Date: November 30, -0001 The Utilization report determines a percentage of time that an item was used within a specified time period. For example, say you ran the report for a period of 30 days. The utilization figure may display as 60% for a ...
-
Last Updated: 22/09/2017
in Training Videos
-
SELECT CONVERT(VARCHAR, I.EntryDate, 101) AS [Entry Date], CASE WHEN LastUpdate = CAST('Jan 1 1980' AS DateTime) THEN '' WHEN LastUpdate = CAST('Dec 30 1899' AS DateTime) THEN '' ELSE ...
-
Date: November 30, 2001 ROI The Return On Investment (ROI) report is a smaller version of the Product History report. ROI for each product can be determined. Detailed booking information will show the bookings the selected product is on. ROI is ...
-
Last Updated: 17/08/2017
in Training Videos RentalPoint YouTube Videos
-
Please be advised; once a booking has been deleted it will be permanently removed from the database, and it is not recoverable. Deleting cross rentals, purchase orders and transfers that are assigned to bookings can affect item availability in th...