Customer Sales History by Product Line

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax, or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

 

 

Customer Sales History

Purge Sales History

Customer Sales History by Item

Sales Order Options

Update FAQs

 

 

 

Navigation

Select Sales Order Reports menu > Customer Sales History by Product Line.

Overview

The Customer Sales History by Product Line report provides customer sales history information by product line for the selected year and prior years. This report allows you to track each customer’s sales activity for each product line purchased by the customer. For each customer, you can print the quantity sold, dollars sold, gross profit amount, gross profit percentage, cost of goods sold, and quantity returned. You can display fiscal year sales history by posting date, or calendar year sales history by invoice date.

Note Whether the report is printed by posting date or invoice date may affect the grouping of data in the report if the invoice date for an invoice occurs in a different period or month than the posting date. For more information, see Update FAQs.

The report can be sorted by customer number, customer type, customer name, or customer's primary salesperson. You can enter a selection of customer numbers, customer types, customer names, customer's primary salesperson, product lines, and defined UDFs to print. Use this report in conjunction with the Customer Sales History and Customer Sales History by Item to provide comparisons of pertinent sales history information.

Totals are printed after the last period/month for all periods/months, each customer, each division, and the entire report.

The number of years of sales history available for this report is dependent on the number of years entered in the Years to Retain Sales History field in Sales Order Options.

Data is available for printing until you purge it using the Purge Sales History utility.

Fields

 

Report Setting

Reporting Basis

Description

Fiscal Year / Calendar Year

Type

Include Prior Year Information

Default Report

Data to Print

Print Report Settings

Operand

Three Hole Punch

Value

Number of Copies

Printer Output

Collated

Keep Window Open After Print

Sort Report By

Keep Window Open After Preview