-
SELECT T.OrganisationV6 AS [COMPANY],
c.ContactName AS [CONTACT NAME],
c.FirstName AS [FIRSTNAME],
c.MidName AS [MIDDLE NAME],
c.Surname AS [SURNAME],
c.Adr1 AS [ADDRESS 1],
c.Adr2 AS [ADDRESS 1],
...
-
SELECT c.OrganisationV6 AS Company, c.contactV6 AS [Main 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 TH...
-
SELECT c.OrganisationV6 AS Company, BK.MAX_DATE [Last Booking Entry], c.contactV6 AS [Main Contact], CASE WHEN c.stop_credit = 0 THEN 'Allow Credit' WHEN c.stop_credit = 1 THEN 'STOP CREDIT - DO NOT ...
-
This will provide the mailing address for active customers, this could be used for creating mailing lists. SELECT c.OrganisationV6 AS Company, c.contactV6 AS [Main Contact], CASE WHEN c.stop_credit = 0 THEN 'All...
-
Offered in RentalPoint v11.4 and higher, Once configured, all invoices, payments and credits processed in RentalPoint, can now be exported to Quickbooks Online!
-
Print barcode label for an asset or for all assets belonging to a product
-
/*All NON Barcode tracked Rental Items in Inventory Master with a count of whats out on a booking */ Select m.product_code AS [PRODUCT CODE], m.descriptionV6 AS [DESCRIPTION], ('$' + convert(VARCHAR,convert(money,m.cost_price...
-
Shows a list of all assets in inventory, their current status and if they're out on a booking.
-
/* Lists all assets in the Database */ SELECT I.groupfld AS [Group], g.group_descv6 AS [Group Desc], i.category AS [Category], c.cat_descv6 AS [Category Desc], A.pr...
-
RTF Insert fields are used to merge data from your RentalPoint Database with your MS Word template. Fields are available via the RentalPointInsertFieldModules.dll file or see our list of RTF Insert fields . Colour Insert Fields INSERT FIEL...