Customer Sales History by Item

 

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

 

 

Miscellaneous Item Maintenance

Purge Sales History

Customer Sales History

Sales Order Options

Customer Sales History by Product Line

Update FAQs

 

Navigation

Select Sales Order Reports menu > Customer Sales History by Item.

Overview

The Customer Sales History by Item report provides customer sales history information by item for the selected year and prior years. This report allows you to track customer sales activity for all item types, charge items, miscellaneous items, special items, and inventory items. 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 the customer's primary salesperson. You can enter a selection of customer numbers, customer types, customer names, salespersons, item codes, and defined UDFs to print. Use this report in conjunction with the Customer Sales History and Customer Sales History by Product Line 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

Fiscal Year / Calendar Year

Description

Include Prior Year Information

Type

Data to Print

Default Report

Item Types 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

Reporting Basis