Display Sales by Item by Customer
Use the Sales by Item by Customer Inquiry (SIC) program to display sales and invoice information for items that have shipped to a customer or all customers. See Road Map for more information.
Enter data in these fields:
Field Name |
Type / Max Length |
Action / Description |
Item number |
Optional |
Enter the item number, click the Lookup icon and use the standard lookup options to select the item from a list, or enter a wildcard string to include multiple items. For example, enter CO-* to display all item numbers that start with "CO-". |
Customer number |
Required |
Leave blank to display sales of the item(s) to all customers, enter a customer number, or click the Lookup icon and use the standard lookup options to select the customer from a list. |
The program displays these fields:
Field Name |
Displays |
Cust no |
The number of a customer about which you are inquiring or of customers who have purchased this item |
Customer name |
The customer's name |
Invoiced |
The date an invoice was created |
Order no |
The number assigned to the sales order for this item |
Ln |
Line number for this order |
Cust PO number |
The customer's PO number for this sales order |
Selling price |
The unit price charged |
Qty shipped |
The quantity of this item that have shipped |
Sales total |
The extended amount for the sale of this item: Selling price x Qty shipped |
Invoice no |
The number assigned to the invoice for this shipment |
Base price |
The unit price from the Price-Contract Maintenance (PCM) program when the order was placed for the item |
Ln disc |
The line discount amount for this order: (Base price x Quantity shipped) - Line discount percent |
Prod cl |
The item's product class |
Item number |
The number of the item that you entered or selected |
Description |
The description 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 order listing |
Click Print. See Print an Inquiry. |
Display shipped lines for an order |
Highlight the line and click Order or double click the line. See Display Shipment Lines. Click OK to return to this program. |
Display the total quantity shipped and sales total, and subtotal amounts if you select Subtotal? for a sort option |
Click Totals. Click Totals to redisplay details. |
Specify a different item number |
Click OK. See step 1. |
Exit the program |
Click Exit. |