Search Results for: sort order

Do you have a discrepancy between Wintix and Quickbooks?

Posted on February 27, 2015

…Click on the Export list button. The spreadsheet will be automatically stored in the C:\tix7\Output file Open the file with your favorite spreadsheet program. The spreadsheet file will display the records in alphabetical order. Our client wanted the report to list in chronological order. Highlight the Today_date column. After highlighting the appropriate column, click on Data | Sort. In this example we used an open office spread sheet program and… Continue reading →

Posted in Accounting, Desktop Software, Reports, Wintix5 | Tagged | Leave a comment

Run a report for all sales for a season with zip codes

Posted on November 13, 2013

…give you a spread sheet listing all sales, with the zip code. You can then sort the spread sheet by zip code and total up each zip using the spreadsheet tools. select customer.first, customer.last, customer.zip, customer.email from mainsale left join customer on customer.customer_id=mainsale.customer_id left join master on mainsale.master_id=master.master_id left join shows on mainsale.shows_id=shows.shows_id where ( mainsale.today_date >= ’20XX-X… Continue reading →

Posted in Desktop Software, Reports, Wintix5 | Tagged | Leave a comment

Run a report of names entered in Wintix within a certain time frame

Posted on July 16, 2014

…email != ” and customer.optin_email_list = 1 and entry_date > “2014-01-01” order by customer.last, customer.first Use the < or > sign and input the date you want within the quotation marks that you want to find in the mailing list database. This will include patrons who have asked to be in your database, but have not necessarily purchased any tickets. Click on the Export list button. Once you run the query, you will see a list like this: Number Tw… Continue reading →

Posted in Desktop Software, Reports, Wintix5 | Tagged | Leave a comment