-
-
SELECT 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 [ADDR...
-
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.