Display Sales by Customer by Item

Use the Sales by Customer by Item Inquiry (SCI) program to display sales and invoice information for items that you have shipped to a customer. See Background and Road Map for more information.

Note
If you accessed this program from another program, skip step 1.

Enter data in these fields:

Field Name	Type / Max Length	Action / Description
Customer number	Required 10 alphanumeric	Enter the customer's number or click the Lookup icon and use the standard lookup options to select the customer from a list.
Item number	Optional 30 alphanumeric	Leave blank to display all items purchased by this customer. To limit the display, enter part of an item number with wildcard characters. For example, enter CO-* to display all item numbers that start with "CO-". Enter the number of a specific item or click the Lookup icon on the left and use the standard lookup options to select the item from a list. Click the Lookup icon on the right and use the standard lookup options to select a customer item number that is cross-referenced to your item.

The program displays these fields:

Field Name	Displays
Customer no	The selected customer number
Customer name	The name of the selected customer
Item number	The number of the item or items this customer purchased
Description	The description of the item or items If the customer or item number is not found, the program displays No longer on file.
Invoiced	The date the order was invoiced
Qty shipped	The quantity shipped in the stocking unit of measure; for example, 12 if the sales unit is dozen and the stocking unit is each
Unit selling price	The unit price charged for this item on this order
Sales total	The extended amount for this item: Qty shipped x Unit selling price
Order no	The number of the sales order for this item
Cust PO no	The customer's purchase order number for this sales order
Ship-to	The ship-to number to which you shipped this order
Invoice no	The number for the invoice for this sales order
Base price	The unit price for this customer, item, and quantity at the time the customer placed the order
Ln disc	The line discount amount for this order
Prod cl	The product class of the item
Cust item no	The customer's item number

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See Set Options for Reports and Inquiries.
Print the listing	Click Print. See Print an Inquiry.
Go to a related program	Click Jump. See Jump.
Display total and subtotal amounts if you selected Subtotal? for a sort option	Click Totals. Click Totals again to redisplay detail.
Display shipped lines for an order	Highlight the line and click Order. See Display Shipment Lines. Click OK to return to this program.
Specify a different customer and/or item	Click OK.
Return to the menu	Click Exit.