Program Description
This program can be found on the Billing Reports Sales History Exception Reports menu (BI-4-5-2). The exception report provides information from the Sales History data file (SHHIST.DT). Therefore any sales history that has been purged will not be a true picture of this report. The exception report serves two functions. One is to provide a listing of customers that have never purchased the products for the specific product class. The other function is to provide a listing of customers that have purchased the products for the specific product class in the past, but since the inputted date have not made any purchases of that product.
Rev 13 Changes
The modifications to this report are the inputs of the specific branch, range of branches, or all branch inputs. Also, the specific sales reps, range of sales reps, or all sales representatives one through five are new. These new inputs are verified from the Customer data file (CUSTD). If the inputted values do not equal what is in the customer file, those customers will not print on the report or labels.
The following fields are described below:
Invalid Product Class
The Product Class entered must be valid or this message will display.
Beginning Branch Is Greater Than Ending Branch
Enter in a specific branch, range of branches, or A for all branches. If the ending branch is less than the beginning branch entered, the message of Beginning Branch Is Greater Than Ending Branch will display and the cursor will return to the ending branch for re-input. Branch number up to 256. The branch is checked from the customer file (CUSTD).
Beginning Sales Rep.# Is Greater Than Ending Sales Rep.#
Enter in a specific sales representative 1-5, range of sales representatives 1-5, or A for all sales representatives 1-5. If the ending sales rep. is less than the beginning sales rep., the message Beginning Sales Rep.# Is Greater Than Ending Sales Rep.# will display and the cursor will return to the ending sales rep. The sales reps. are checked from the customer file (CUSTD).
Enter N for no purchases from customers for this product class or enter L for last purchases since the certain date also inputted.
Enter R to print the report showing the list of customers or enter L to print the labels for the customers. With the label option, the choice is given to print the contact name or not on the label. The standard label that will print is 3 ½ “ X 15/16”.
Enter a forward slash (/) to cancel out of the program and return to the menu. Enter Shift-6 (^) to return to a previous field.
Now Processing&ldots;Customer #,
When the program runs, it will display the customer number that is processing and return to the menu when completed.
No Records Found
If there are no selections within the ranges entered, this message will display and return to the menu.
Results