Instructions for listing customers by total purchases
Before running this report, you have to add up the purchases from the
Customer Sales Report Screen (option [6,2,5,A] from the Main Menu)
On this [625A] screen do NOT specify a dollar figure, but you might want to
type in a date ange or maybe a class code range before choosing option A to
start filling in calculated purchases.
Next, go to Main Menu, Press the Period (.) key. (If using Shop-Pro, choose
Exit, Miscellaneous Options, Dot Prompt)
At the dot-prompt, type
USE CUSTOMER EXCLUSIVE
INDEX ON 0-PURCHASES TO TEMP
SET FILTER TO PURCHASES >= 100
LIST LEFT(LAST,12),LEFT(FIRST,10),PURCHASES,HOME,WORK,LAST_PURCH OFF TO PRIN
Above, you can replace the $100 limit with whatever dollar figure you want.
To display the report, leave off the words TO PRIN
Note that there is an underline (not a space) in the middle of LAST_PURCH.