COMPULINK 3300 Overland Avenue, Suite 201 § Los Angeles, California 90034 § 310 × 204 × 5121 

 

  • Instructions for listing customers with total purchases over a certain amount:

    Before running this report, you have to add up the purchases using [6,2,5,A]

    On this [625A] screen do NOT specify a dollar figure, but you might want to type in a date range 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

    SET INDEX TO C_LAST

    SET FILTER TO PURCHASES >= 100 .AND. PURCHASES <=2000

    LIST LEFT(LAST,12), LEFT(FIRST,10), PURCHASES, HOME, WORK, LAST_PURCH OFF TO PRINT

    QUIT

    Above, you can replace the 100 to 2000 range with whatever dollar figures you want. To display the report, leave off the words TO PRINT

    Note that there is an underline (not a space) in the middle of C_LAST & LAST_PURCH.

    •