MS Sales Activity By Customer

You can use the MS Sales Activity By Customer report by selecting Material Sales > Reports > MS Sales Activity By Customer.

The Material Sales Activity by Customer report prints sales units, dollars and haul amounts and allows the user to sort by either customer sort name or customer job code. Depending on the print level selected, the report summarizes the sales information by printing one line per (1) Month , (2)Location, (3) Matl Category. or (4) Material. Depending on the print level, the report also subtotals the sales data for material category, location, and month. The report then prints a total for each customer selected as well as a grand total for all customers.

Report Parameters

Description

Company

Accept the default, or press F4 to select a company.

(P)osted Mth, (L)ocation, Mat’l (C)atgy, (M)atl

Enter P, L, C, or M.

Sorty by Cust (J)ob or Cust (P)O

Enter J or P.

Beginning Customer #

Press F4 to select the beginning customer number for sorting.

Ending Customer #

Press F4 to select the ending customer number for sorting.

Beginning Customer Job

Click the Field Lookup button or press F4 to select beginning customer job, or leave blank for all.

Ending Customer Job

Click the Field Lookup button or press F4 to select ending customer Job, or leave blank for all.

Beginning Customer PO

Click the Field Lookup button or press F4 to select beginning customer PO, or leave blank for all.

Ending Customer PO

Click the Field Lookup button or press F4 to select ending customer PO, or leave blank for all.

Beginning Month

Enter beginning month (MM/YY).

Ending Month

Select the date-range arrows to select the Ending Month

Beginning Location

Select the Field Lookup button or press F4 to select the beginning location.

Ending Location

Select the Field Lookup button or press F4 to select the ending location.

Beginning Material

Select the Field Lookup button or press F4 to select the beginning material.

Ending Material

Select the Field Lookup button or press F4 to select the ending material.