SQL Queries
News & Events
 
 

Credit Card Processing with PPI

CreditCards

JMM has teamed with Payment Processing, Inc. (PPI) to offer you an integrated solution that provides one resource for everything your business needs to process credit card payments.

JMM Email Suite

JMM Software now gives TRS users an easy way to produce and send HTML based emails. Read more..

QuickBooks Interface!

Click here to read about this new, free tool for sending detailed TRS sale information to QuickBooks


TRS11 Available

New Modules: Easy Service and Repairs, Unlimited Tax Rates, User-defined Required Fields, Kit Manager and more...


TRS11 - Improvements

Go to the TRS11 page now

View System Requirements


Updates to Previous Versions of TRS

Version 10

Version 9

Version 8

Versions 7 & 6

Version 5 and Earlier


Upcoming Shows

CHA
Jan. 29 - Feb. 1, 2012
Anaheim, CA

VDTA
February 27-29, 2012
New Orleans, LA

Spring Quilt Market
May 18-20, 2012
Kansas City, MO

 





   

XXXX

ZZZZ

 


SQL Query Info

A SQL database provides TRS users with a great resource for extracting and analyzing their store's records. Although TRS comes preloaded with some excellent, detailed reports (which utilize this SQL power), additional data is sometimes needed.

Here you will find a number of reports you can run within TRS. The granular detail that is extracted will make you a more knowledgeable seller and help you make smart business decisions. Best of all, they're FREE!

How to use these files:
Still have questions?


Category: Customers
Description
Link
Best Customers
A simple report that lists your best customers based on dollars spent. Top spenders are displayed top to bottom.

Best Customers with
Date Range

Same report as above but with customizable dates and additional customer info.
Best Customers with
Date Range, Less Classes
Same report as above but Class Fees are not counted.
Birthdays
Lets you see all your customers whose birthday falls in the specified month. A great report if you didnt enter all birthdays as the same year.
Customers by City
Gives you a tally of your customers by their city.

Category: POS Sales
Description
Link
Best Sellers by Dollar Amount
Lists your best sellers from POS Sales based on total dollars within a specific date range.
Best Sellers by Dollar Amount for a Department
Same report as above but you can specify a single Department
Sales by Date
Gives you a list of each days sales within your specified date range
Sales By City
Gives you the total sales within a date range, but grouped by city.

 



 
Home Products Order Updates Support Contact Links Site Map

COPYRIGHT (C) 2003-2009, JMM Software, Inc. ALL RIGHTS RESERVED