Running the Item Sales Report

The Item Sales Report allows for detailed or summary analysis of profitability in a number of ways.

You can specify your needs for exception reporting to run your business on a management by priority basis. For example, if you ran a sales promotion on a group of selected items, you could use this report to evaluate whether the promotion was a success from several perspectives:

• If the promotion involved cutting the price on the selected items, did the increase in volume offset the reduced incremental gross profit?

• Did all of the sales personnel participate in promoting the sale items?

You can run the report for a single period or compare different periods of time. You can display quantity, sales, gross profit, price, and cost information. A comparison report can show the difference between sales periods, percent of difference, or both.

In the report's sort and select options, the outside or inside salesperson is the salesperson listed on the order; the current outside or inside salesperson is the salesperson currently assigned to the account for which the order was entered.

Note: If you run this report frequently, you can save your selections and associate those settings with your user ID. Use theFile > Save Settingsoption to use this feature. When you run the report again, the system displays the selections you made the last time. If there is no default or saved setting, the field is blank. For more information, see How the System Saves Settings on Reports.

To run the Item Sales Report:

1. From the Reports > End of Month Reports menu, select Item Sales to display the Item Sales Report window.

2. In the Branch field, enter the branch or territory to include in this report. To include all branches and territories, enter ALL.

3. In the Start Date field, enter the first date in a range of dates for which to view sales data. This field supports variable dates, and is required only if you run the report for a single period.

4. In the End/As of Date field, enter the last date for which to view sales data. This field supports variable dates.

• If the Start Date field is populated, the date entered in this field is the End Date for the period being defined.

• If the Start Date field is not populated, the date entered in this field is the As of Date for the report's comparison periods.

5. Complete or change any of the fields, as needed:

   Field	Description
   Select Sales By	A subset of transactions to view on the report. Your selection displays in this field and becomes the name of the next field on the screen.
   (Price Line/Sell Group/Buy Line/ Buy Group/Product/ Bill-To Customer/ Ship-To Customer/ Customer PO)	Additional selection criteria on which to select records. For example, if you selected Buy Line in the Select Sales by field, enter a buy line ID in this field. Use the Multi button to enter multiple selections. *Multi* displays in the field.
   Sales Periods	Identifies the periods to compare when you run the report with an as-of date. Note: If you run the report with start and end dates, the dates define only one period. The value in this field defaults to Start-End Date.
   Period Column Headings	Identifies the columns to display for each report period. You must enter a value in the Sales Periods field to access this field.
   Type of Comparison	If you are running the report with an as of date, enter one of the following: None - No comparison. Difference - Lists the cost difference between the sales items. % Difference - Lists the percent difference in sales costs. Difference/% Difference - Lists both the cost difference and the percent difference. Note: This field activates only when a selection is made in the Period Column Headings field.
   Primary Sort	The transaction field name to use to sort and subtotal the transactions selected for the report.
   Page Break on Primary Sort	Indicate whether to insert a page break before each new report section based on the primary sort.
   Primary Heading	Indicate whether to insert a heading for each new report section based on the primary sort.
   Secondary Sort	The transaction field name to use to sort and subtotal each subset of transactions within the primary sort.
   Detail Level	Determines the level of detail and subtotals to show on the report. Product - Prints one line for each product selected for the report, and prints subtotals for the primary and secondary, if any, sorts. Primary Sort - Prints one line on the report per primary sort option and prints subtotals for the primary and secondary, in any, sorts. Invoice - Prints one line on the report for each invoice. This option displays only if the Start Date and End Date fields are completed. Secondary Sort - Prints a second line on the report per secondary sort option. This option displays only if you have a secondary sort selected in the Secondary Sort field.

   Note: If you select a customer that is a parent customer, or has dependent customers, the system displays information for the parent customer and all its dependents.

6. In the Order Type area, indicate if you want to include or exclude credits, directs, or miscellaneous charges:

   Field	Description
   Credits	Indicates whether to include, exclude or run the report for credits only. The default value is Include.
   Directs	Indicates whether to include, exclude or run the report for direct shipments only. The default value is Include.
   Misc Charges	Indicates whether to include or exclude miscellaneous charges in the report. The default value is Exclude.

    

7. Set options, if needed, and generate the report.

If you use the Print or Hold menu options, depending on your authorization level, the system may prompt you to choose whether to view generic (commission) costs, cost of goods sold, or no costs on the report. Select an option to run the report.

See Also:

Sales Statistics Report

Sales Summary by Sales Source Report

Sales Summary for Type and Source Report