Sales Representative Special Product Analysis

Menu Path: Executive Information Systems Images\bluerarw.gif Sales Images\bluerarw.gif Sales Representative Special Product Analysis

Purpose

Display specially tracked products for sales representatives.

Overview

Use Sales Representative Special Product Analysis to view sales data by sales representative for products that have been assigned a special product code. Special product tracking is initiated by targeting a customer and setting up a special product code for the product.

Sales Representative Special Product Analysis should be used by sales representatives to track their special product sales.

Viewing Special Product Data

To view data for a special product code:

  1. Enter a special product code in the Special Product Code field.

  2. Enter a range of months and years for which you want to display data in the From Date and To Date fields.

  3. If you want to display data for a single sales representative, enter a sales representative ID in the ID field. If you want to display data for all sales representatives, select the All Sales Representatives check box.

Note Your user ID can be assigned a sales representative ID in User Extended Options. If you are assigned a sales representative ID, the Sales Representative field displays that ID, and cannot be changed, and the All Sales Representatives check box is unavailable.

  1. If you want to position data for a specific sales representative at the top of the grid, enter the sales representative name in the Reposition to field.

  2. If you want to display data for customers that did not purchase or return the product during the selected period, select the Include Customers with Zero Activity check box.

  3. Click the Show Data button in the ribbon to display data in the grid.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Sales Representative Special Product Analysis window.

Show Data

Click this button to display data based on the selected criteria.

Inquiry Tab Fields and Buttons

Field or Button

Description

Special Product Code

Enter the special product code for the product for which you want to view sales data. This code is an alphanumeric code assigned to products that require tracking by customer or sales representative.

From Date

Enter the first month and year in a range of dates for which to display data, or click the Lookup buttons to select a month and year. This defaults to the current open period and year.

To Date

Enter the last month and year in a range of dates for which to display data, or click the Lookup buttons to select a month and year. This defaults to the current open period and year.

All Sales Representatives

Select this check box to display data for all sales representatives. This check box is cleared by default. This check box is only available if no sales representative is entered in the Sales Representative field in User Extended Options.

ID/Sales Representative

If a sales representative is assigned to your user ID in the Sales Representative field in User Extended Options, this field displays the sales representative ID and cannot be changed.

If no sales representative is assigned to your user ID in the Sales Representative field in User Extended Options, enter a sales representative ID for which to display data, or click the Lookup button to select a sales representative ID. This field is only enabled if the All Sales Representatives check box is cleared.

Reposition to

Enter a sales representative name if you want to display data for a specific sales representative at the top of the Customer Sales grid.

Include Customers with Zero Activity

Select this check box to display data for customers that did not purchase or return the product during the selected period.

Customer Sales

This grid displays sales data for the selected special product code. The grid includes the following columns:

  • Customer Name

  • Customer Code

  • Territory

  • State

  • Sales Representative Name

  • Sales Representative ID

  • Sales Team ID

  • Amount Sold

  • Amount Returned

  • Net Amount

  • Net Units

  • Units Sold

  • Units Returned

The data displayed in this grid includes amount sold, amount returned, net amount, units sold, and units returned values only after invoices are posted to the general ledger.