-
-
Using the 'Rental Inventory.csv' template available with the Product Import option in RentalPoint2, you can import Products and their assets using the 'Clear All' 'Match All' functionality in the system. Please take a backup of your database befo...
-
SELECT BK.CUST as [Customer Code], c.OrganisationV6 as [Organization], c.contactv6 as [Contact], c.phone1countrycode as [Phone1 Country], CONCAT(c.Phone1AreaCode,' ', c.Phone1Digits) as [Phone1], ...
-
SELECT IM.groupfld AS [Product Group], IM.category AS [Product Category], A.product_code AS [Product Code], IM.descriptionv6 AS [Product Description], A.asset_code AS [Bar Code Number], A.descr...
-
/* All transfers and bookings they are assigned to*/ Select T.booking_no [Code], isnull(B.OrganizationV6,'') [Company], DATENAME(WEEKDAY,T.ddate) [Out], convert(varchar,T.ddate,105) [Date], dbo.MakeTime(T.de...
-
Last Updated: 11/03/2022
in Troubleshooting FAQ's AutoEmail errors are reported to the data\logs\errorlog.txt The message below will be reported when an operator has auto-emailing turned on but the operator doesn't have an email address set up. Use the query below with Excel Query Builder ...
-
/* Shows all invoices with outstanding balance based on closing date with an outstanding amount greater than InvValue */ DECLARE @ClosingDate AS VARCHAR (20) DECLARE @InvValue FLOAT SET @ClosingDate = '2024-2-1' SET @InvValue = 1 SELECT B.b...
-
SELECT c.RPwebservicesActive, c.Contactname, c.username, c.password, c.ID,c.CustCodeLink FROM tblContact c INNER JOIN tblInvMas IM ON C.ID = IM.ContactID ORDER By Contactname
-
/* All gear that didn't make it back from a show within date range, include warehouse status of the booking */ DECLARE @StartDate AS VARCHAR(20) DECLARE @EndDate AS VARCHAR(20) SET @StartDate = '2024-03-30' SET @EndDate = '2024-07-01' sele...
-
...