This is a place to find useful Custom Query Reports and SQL Update statements.  Knowledge Base Index : Custom SQL Queries   <<  Page 1 of 1  >> KB Articles ( 10 ): Generate a List of Items Purchased by a Customer This article provides a custom SQL to generate a report of items purchased by a certain customer.... [More] Export TRS Customers into Constant Contact How to export all of your TRS customers who have email addresses into Constant Contact.... [More] Finding POS Products where Preferred Vendor does not match Vendor Products This article will describe how to run a custom report to find POS Products where the Preferred Vendor in POS Products does not have a corresponding Vendor Product listing with the same Vendor Name... [More] Report of amout spent by customer This report works like the "Special Searches->Customers->By Amount Spent" search, but it allows you to generate a report that actually shows you how much each customer spent.... [More] How to Search POS Products by Last Sold Date This article will describe how to search POS Products by the Last Sold Date.... [More] How to find errors in the Paid Cost column of the Inventory Summary Report This article will describe how to find an error in the Paid Cost column of the Inventory Summary when it is run for the current date (If you are find an error running the Inventory Summary for a past date and after running it for the current date it is not there, then contact Support.)... [More] How to set Customer Dollar Accumulations to Zero This article will describe how to do a mass edit on your customer table to set the Accumualated Dollars for all your customers to zero. IT IS HIGHLY RECOMMEND THAT YOU MAKE A BACKUP COPY OF YOUR DATABASE BEFORE DOING THIS OR ANY MASS EDIT.... [More] Turnover Report for Repair Parts (V10 Only) This article will give a Custom SQL that can be used to generate a turnover report for Repair Parts. This report only works for Version 10 and later users.... [More] Detailed Inventory Adjustment Report This article describes how you can run a more detailed Inventory Adjustment Report in TRS. This article applies to TRS10 and higher only. ... [More] How to mark customers as inactive This article will describe how to handle customers in your TRS database that you no longer want to include on emails and mailing lists.... [More]