APPX Software Library

4Reports and Inquiry

Option 10Sales History Inquiry

For a given customer, product, salesperson, and year, this inquiry shows monthly totals in terms of net sales, costs, gross margin percentage, commission dollars earned, stockkeeping units shipped, and stockkeeping units not shipped.

Here is a sample Sales History Inquiry.

                          Expert Distributing, Inc.
04/09/91 04:19 pm                                               KAY Page:     1
                            Sales History Inquiry
===============================================================================
Customer 00000010  Alexander's, Inc.
Product 20  #4 12" Gold Plated Black Round
Salesperson 010  Mr. Jarvis W. Payne
Year 88
            Net Sales        Costs   GM%   Commission    Shipped    Not Shipped
            ---------        -----   ---   ----------    -------    -----------
      JAN        0.00        0.000     0         0.00       0.00           0.00
      FEB        0.00        0.000     0         0.00       0.00           0.00
      MAR        0.00        0.000     0         0.00       0.00           0.00
      APR        0.00        0.000     0         0.00       0.00           0.00
      MAY      200.00       50.000    75         0.00       1.00           1.00
      JUN      200.00       50.000    75         0.00       1.00           0.00
      JUL      600.00      300.000    50         0.00       3.00           0.00
      AUG      400.00      195.000    51         0.00       2.00           0.00
      SEP      690.00      300.000    57         0.00       3.00           0.00
      OCT     1610.00      700.000    57         0.00       7.00           0.00
      NOV     1380.00      600.000    57         0.00       6.00           0.00
      DEC     1380.00      630.000    54         0.00       6.00           0.00

      EOY        0.00        0.000     0         0.00       0.00           0.00
           ----------  -----------   ---   ----------   --------       --------
Totals        6460.00     2825.000    56         0.00      29.00           1.00