Comparative Customer Sales Report

From GivenHansco Keystone Help
Jump to navigation Jump to search

This report prints total sales to each customer for the current month, year-to-date, the comparison periods from the previous year, and previous year’s total. For each sales number, the change from previous year to current year is printed both as a simple dollar amount and as a percentage of previous year.

3/8/2002                                         Comparative Customer Sales Report                                        4:14:40 PM
Program: ARPRSCC                                     Company: Hansco Materials                                            User: PETE
  
                                                      In Sequence By Customer Id
                                                    Customer Id JAM100 thru LUC100
                                                  Last Year 1/1/2001 thru 12/31/2001
                                           Last Year for the period 2/1/2001 thru 2/28/2001
                                                     This Year beginning 1/1/2002
                                           This Year for the period 2/1/2002 thru 2/28/2002
  
 Customer                                                ---------Current Month--------- -----------Year to Date----------- Last Year
    Id      Name                           City           This Yr  Last Yr     Diff    %   This Yr   Last Yr      Diff    %   Total
  
 JAM100     James & James                  W. Springfield    1844      487     1357  279      4048       607      3441  567       607
 JOL100     Jolter & Associates            Somerset         14433     6911     7522  109     16143      7136      9007  126      7136
 KLE100     Klesson & Smith Co., Inc.      Winchester       23185     4200    18985  452     42941     15780     27161  172     15780
 LUC100     Luchessi Pools                 Chicopee           954        0      954    0      2014         0      2014    0         0

 Grand Total                                                40416    11597    28819  248     65146     23522     41624  177     23522

Options

Note that Sales this Yr. (Descending) is available as a sequence option to bring the most important customers to the top of the report.