Skip to content

CP0504 Customer Order Processing Sales Analysis Reports

Sales Analysis Reports

Application Overview

 

There are three Sales Analysis Reports available in Customer Order Processing.  Each provides a different perspective on the company's sales.  The three reports are Sales Analysis by Item, Sales Analysis by Product Category and Sales Analysis by Sales Volume.

 

These reports show sales, costs and gross margins, as well as applicable percentages.  Unlike other Sales History Reports, these reports utilize data available in the Inventory Item file rather than in the Sales History file.

 

Run Instructions

 

Select Sales Analysis Reports from the pull down COP Reports window.  The following screen will then be displayed:

 

 

Sales Analysis Reports Entry Screen

 

 

 The following options are available:

    • Select the desired mode from the Sales Analysis Reports menu bar
    • A window will appear allowing you to select one of these options:

        - Sales Analysis By Item

        - Sales Analysis By Product Category

        - Sales Analysis By Sales Volume

     
      • Enter the data requested on the screen

       

      To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

      Entry Field Descriptions

       

      Sales Analysis By Item

       

      Name

      Type and Description

      1.  Starting Item No

      15 alphanumeric characters.

      Enter the starting item number of the range. 

      Press the F7 key to search by item number or press the F8 key to search by item description.

      Defaults to All.

      2.  Ending Item No

      15 alphanumeric characters.

      Enter the ending item number of the range. 

      Press the F7 key to search by item number or press the F8 key to search by item description.

      Defaults to the starting item number.

      3.  Exclude Items With Zero            Qty Sold Ptd/Ytd ?

      Y or N.

      Enter Y to not include items that have not been sold.  Default is N.

       
      Sales Analysis By Product Category

       

      Name

      Type and Description

      1.  Show Product Categories              On Separate Pages ?

      Y or N.

      Enter whether you wish to print each product category on a separate page or not.  Default is N.

      2.  Print Category Summary               Only ?

      Y or N.

      Enter whether you wish to print a product category summary only.  Default is N.

      3.  Starting Category                   

      3 alphanumeric characters.

      Enter the starting product category of the range. 

      Press the F7 key to search for product category codes.

      Default is All.

      4.  Ending Category

      3 alphanumeric characters.

      Enter the ending product category of the range.

      Press the F7 key to search for product category codes.

      Default is the starting product category.

      5.  Exclude Items With Zero  Qty       Sold Ptd/Ytd ?

      Y or N.

      Enter Y to not include items that have not been sold.  Default is N.

       
      Sales Analysis By Sales Volume

       

      Name

      Type and Description

      1.  Ptd or Ytd Sales Volume                Order ?

      1 alphanumeric character.

      If you want the sales volume to be listed in order by period‑to‑date sales amount, enter a P; if you want it in year‑to‑date order, enter a Y.

      2.  Minimum Sales Volume To          Be Shown

      8 numeric digits with 3 decimal places and an optional minus sign

      (99,999.999-).

      Enter the minimum sales volume to be shown on the report.  Defaults to All.

      3.  Number Of Items To Print

      6 numeric digits (999,999).

      Enter the number of items which you want to print.  If there are 300 items on file and you specify 100 here, only the top 100 items will be printed. 

      Defaults to All.

      4.  Exclude Zero Quantity?

      Y or N.

      Enter Y to not include items that have not been sold.  Default is N.

       

       

       


       

      Sales Analysis By Item

       

       

       



       

      Sales Analysis By Product Category

       

       

       

                             

      Sales Analysis By Sales Volume

       

       

       

       

       

       

       

       

      Feedback and Knowledge Base