Program Description
This program is new in Rev 13 and can be found on the Billing Inquiries menu (BI-2-10) and the Order Entry Inquiries menu (OE-2-11). It allows the user to enter a customer number (or name) and item number (or item alpha search). The program will then go through the Contract (Special) Price File (CONTPD) and find all records associated with the buying groups in the Customer file (CUSTD) and the item number, or the buying groups and the product class associated with the item number. There are 10 buying groups stored in the Customer file that will be checked. Any contract pricing record with a start date later than the transaction date will be skipped in addition to any record that has an expiration date prior to the transaction date. The inquiry will display the buying group, list price from the Item (ITEM) file, sale price (calculated from percent or dollar discount in the Contract Pricing (CONTPD) file, the start and expiration date of the sale, and a message stating if the price was obtained by looking at the item or by looking at the product class. This program will also display any customer messages after the customer number is entered.
Results
Following is a sample screen display of the results for Customer # 4830000 and Item # TONER:
Rev 14 Changes
The record length of the Contract (Special) Pricing File (CONTPD) was enlarged from 32 to 128.
Also, the program used to only display special prices based on the customer’s buying group(s) in the Customer File (CUSTD). The program will now also check to see if the customer number / item number and customer number / product class combinations are in the special price file (CONTPD). These special prices will also be displayed on the screen. The Buying Group heading has been changed to Cust/BuyG since it will display buying group numbers and customer numbers. See screen sample below:
Also, when there are no special pricing records found, a message will display “No Special Pricing Found”.