Click on the book to learn more about the Coupon system.Program Description
This program can be found on the Order
Entry Inquiries menu (OE-2-10) and the Service
Inquiries menu (SD-2-20). The existing coupon books can be accessed
in the inquiry by entering the ship to customer number or an alpha search.
The inquiry provides the current status of the coupon book. This includes
the total number of coupons on the coupon book and the total number that
are left to be used. The items and messages on the coupons are also displayed.
Basically, most of the information that is stored in the Coupon Files
is displayed in this program. Click on the book to learn more about the Coupon system.
Rev 15 Changes
Internal changes were made to the program to accommodate the new position of the Number Of Coupons field in the Coupon Header File (CINVHDRD). The Number Of Coupons field on coupons with Fixed Quantity coupon types, enlarged from 4 digits to 6 digits.
Rev 14 Changes
N/A
Rev 13 Changes
Program changes were made to accommodate Variable Quantity coupon books. The coupon type (either Fixed Qty Cpn or Var Qty Cpn) will be displayed at the top of the screen. If the coupon is a Variable Quantity coupon, the Number of Coupons Used, Number of Credit Coupons, Number Coupons Last Release and Number Of Coupons Left fields will display with three decimal positions.
The following is a Variable Quantity coupon book sample:
The following is a Fixed Quantity coupon book sample:
Click on the book to learn more about the Coupon system.
Rev 12 Documentation
The Coupon Inquiry By Customer is found on the Order Entry Inquiry menu, 2-10 and Service Inquiries menu, 2-20. The existing coupon books can be accessed in the inquiry by entering the ship to customer number or an alpha search. The inquiry provides the current status of the coupon book. This includes the total number of coupons on the coupon book and the total number that are left to be used. The items and messages on the coupons are also displayed. Basically, most of the information that is stored in the Coupon Files is displayed in the Coupon Inquiry By Customer.
Enter Data
Upon entry to the program the cursor is at the following prompt.
Ship-To Customer Or E'nd
5/02/96 Coupon Inquiry By Customer 8:34
Ship-To Customer Or E'nd No. Coupons Left
Coupon Book Number Bill-To Customer
Name Name
Address 1 Address 1
Address 2 Address 2
City City
State State
Zip Code Zip Code
Phone Date Of Invoice
Sales Rep Invoice Number
No. Coupons No. Coupons Last Release
No. Coupons Used Last Order/Call No.
No. Credit Coupons Last Release Date
Selling Price Expiration Date
Model No. Coupon Type
Serial No.
Item Description Qty. UM P/M
Enter an E to exit the inquiry. There are two ways to access the desired customer number. Enter the ship to customer number or perform a customer alpha search. If a number from 6 to 8 digits is entered the program checks to see if there are any coupon books assigned to the number. If there are no coupon books found, the prompt Customer Has No Coupons appears. The cursor returns for reinput. If an alphanumeric entry of 1 through 20 characters is entered the customer alpha search is accessed. One of the following two prompts appear.
Enter Data (Cont’d)
Select Customer Choice
Display N'ext, Select Customer Choice, Or E'nd: N
6/28/95 Coupon Inquiry By Customer 8:42
Ship-To Customer Or E'nd TRI No. Coupons Left
No Customer Name Address City St
1 TRI CITY ORTHOPEDIC
2 TRI COUNTY HEALTH CENTER 125 TURTLE LANE LA CROSSE WI
3 TRI COUNTY MEDICAL 1300 WESTVIEW LA CROSSE WI
4 TRI COUNTY MEDICAL CTR 1310 WESTVIEW LA CROSSE WI
5 TRI COUNTY MESSAGE 345 HALL ST LA CROSSE WI
6 TRI STATE INN 1200 MOTEL DRIVE LA CROSSE WI
7 TRI STATE INN 599 WAVERLY DRIVE LA CROSSE WI
8 TRI STATE INN OF LACROSSE 2400 MOTEL DRIVE LA CROSSE WI
9 TRI STATE LEASING 1234 TERRY LANE LA CROSSE WI
10 TRI STATE MEAT PACKAGING ROUTE 3 WINONA MN
Select Customer Choice Or E'nd:
The first prompt appears if there are less than 18 choices. The second prompt will appear if there are more than 17 choices. All customer names, from the Customer File, that match with the input are displayed. A computer assigned number, customer name, address 1, and city and state are displayed for each record found. Enter the computer assigned number that corresponds with the desired customer. Enter a N for next to view the next screen of selections. Enter an E to exit the alpha search and return to the Ship-To Customer Or E'nd prompt. If a number is entered that does not exist, the prompt Selection Is Out Of Range appears and the cursor returns for reinput. When a N for next is entered one of the two following prompts appear.
Display N'ext, P'revious, Select Customer Choice, Or E'nd: N
Display P'revious, Select Customer Choice, Or E'nd:
The first prompt appears until the last screen of alpha selections is reached. The second prompt appears when the last screen is accessed. Enter the computer assigned number that corresponds with the desired customer. Enter a N for next to view the next screen of choices. Enter a P for previous to go back one screen. You may go back and forward as many screens as exist. Enter an E to exit the alpha search and return to the Ship-To Customer Or E'nd prompt.
Enter Data (Cont'd)
Once a customer number with a valid coupon book, is input or selected through the alpha search, the information is displayed. If the customer has more than one coupon book, the coupon book with the smallest coupon book number displays first. The cursor is at one of the two following prompts.
Continue With Next Coupon (Y/N)
Next Page (Y/N)
5/02/96 Coupon Inquiry By Customer 8:34
Ship-To Customer Or E'nd 5552222 No. Coupons Left 3
Coupon Book Number 397 Bill-To Customer 7856200
Name THE SLEEP INN MOTEL Name MISSISSIPPI BOAT SERVICES
Address 1 54 HOWARD ST Address 1 E. WISCONSIN ST.
Address 2 P.O. BOX 1235 Address 2 P.O. BOX 345
City LA CROSSE City LA CROSSE
State WI State WI
Zip Code 546032222 Zip Code 539012222
Phone 507-555-2222 Date Of Invoice 4/30/96
Sales Rep 1 Invoice Number 93074
No. Coupons 4 No. Coupons Last Release 1
No. Coupons Used 1 Last Order/Call No. 52256
No. Credit Coupons 0 Last Release Date 5/01/96
Selling Price 360.00 Expiration Date 4/30/97
Model No. 2110A Coupon Type COUPON BOOK
Serial No. BR85
Item Description Qty.
TONER CASE OF TONER 2 CT 4
SUPPLY1 PAPER 1 EA 1
* Message * THE COUPON BOOK IS ENCLOSED. PLEASE CALL THE ORDER
* Message * DEPARTMENT TO REDEEM THE COUPONS.
Continue With Next Coupon (Y/N)
The first prompt appears if there is only one screen of items and messages on the coupon book. The second prompt appears if there is more than one screen to display on the coupon book.
Continue With Next Coupon (Y/N)
Enter a N for no to not view the next coupon assigned to the customer. The prompt, Another Inquiry (Y/N) will appear. Enter a Y for yes to view the next coupon book assigned to the selected customer. The coupon books will appear in numeric order, smallest to largest coupon book number. When a Y is entered and the last coupon book is reached for that customer, the prompt No More Coupons appears. The prompt, Another Inquiry (Y/N), displays.
Enter Data (Cont'd)
Next Page (Y/N)
6/28/95 Coupon Inquiry By Customer 10:06
Ship-To Customer Or E'nd 4830000 No. Coupons Left 4
Coupon Book Number 344 Bill-To Customer 4830000
Name HOME HEATING INC. Name HOME HEATING INC.
Address 1 ATTN: MR. TROY MAC DONALD Address 1 ATTN: MR. TROY MAC DONALD
Address 2 900 SIMPSON LANE ROADWAYS Address 2 900 SIMPSON LANE ROADWAYS
City LA CROSSE City LA CROSSE
State WI State WI
Zip Code 54603 Zip Code 54603
Phone 608-483-0000 Date Of Invoice 6/28/95
Sales Rep 10 Invoice Number 89814
No. Coupons 4 No. Coupons Last Release 0
No. Coupons Used 0 Last Order/Call No. 0
No. Credit Coupons 0 Last Release Date
Selling Price 360.00 Expiration Date 6/28/96
Model No. 2004 Coupon Type COUPON BOOK
Serial No. K445T
Item Description Qty. UM P/M
TONER BLACK TONER 1 CT 2
TONER BLACK TONER 1 EA 1
SUPPLY PAPER 1 EA 4
* Message * THE COUPON BOOK IS ENCLOSED. PLEASE CALL THE ORDER
Next Page (Y/N)
Enter a N for no to exit the displayed coupon book. The prompt, Continue With Next Coupon (Y/N), appears. Enter a Y for yes to view the next screen of items and messages that are on the coupon book. When the last screen is reached the prompt Continue With Next Coupon (Y/N) displays.
Another Inquiry (Y/N)
Enter a Y for yes to exit the displayed coupon book and return to the Ship-To Customer Or E'nd prompt. Enter a N for no to exit the inquiry.
Program Results
The following information is displayed for each coupon book.
No. Coupons Left This is the number of coupons left to be redeemed. No. Coupons - No. Coupons Used - No. Credit Coupons
Ship-To Customer The ship to customer number that the coupon book invoice was sold to.
Bill-To Customer The bill to customer number of the ship to customer, from the Customer File. Note, this is not the bill to number that was entered on the Coupon Book invoice. The bill to number is not stored in the Coupon Files.
Name The current customer name from the Customer File.
Address 1
Address 2
City State Zip Code The current address 1 and 2, city, state and zip code from the Customer File.
Phone Field 8 from Customer File Maintenance of the ship to customer.
Date Of Invoice The system date that the Coupon Book invoice was created.
Sales Rep The sales rep number that was assigned to the Invoice header on the Coupon Book invoice.
Invoice Number The invoice number that was assigned to the Coupon Book invoice.
No. Coupons The total number of coupons that are on the coupon book. This is the amount that was invoiced to the customer on the Coupon Book invoice.
Program Results (Cont'd)
No. Coupons Last Release When a coupon is redeemed an order is entered through Order Entry or Order File Maintenance. This is the number of coupons that are redeemed on the order. The Coupon File stores the most current order. Voiding or deleting an order for the coupon, zeroes this out. You may also redeem a coupon through Service Ticket Entry. Service Ticket Entry also updates this field with the amount of coupons redeemed on the service ticket. Voiding the service ticket zeroes this out.
No. Coupons Used When a coupon is redeemed an order or service ticket is entered through Order Entry, Order File Maintenance or Service Ticket Entry. This is the total number of coupons that have been redeemed through all of the programs. This is the total redemptions not just the most current.
Last Order/Call No. This is the last order or service call number that the coupon book had a coupon redeemed. This can be zeroed out by Order Void, Void Service Invoices, or a deletion through Order File Maintenance.
No. Credit Coupons If a credit memo is entered on the Coupon Book invoice, the number of coupons credited displays. If more than one credit is issued this would be the total number.
Last Release Date This is the system date that the last order number or service call number for the coupon redemption was created on.
Selling Price This is the total amount of the coupon book that was invoiced to the customer. This is not for one coupon but the entire book.
Expiration Date This is the expiration date that was entered when the Coupon Book invoice was created.
Model No. This is the model number that was entered when the Coupon Book invoice was created.
Serial No. This is the serial number that was entered when the Coupon Book invoice was created.
Coupon Type This is the coupon book item number used when creating the Coupon Book invoice.
Program Results (Cont'd)
Item Description Qty All of the items and messages that were entered on the Coupon Book invoice display in the order they were entered on the invoice. The current Item File description displays. The quantity of the items for one coupon displays.
UM P/M The unit of measure and pack multiple from the Item File. If a broken pack was entered on an item, the unit of measure is EA and the P/M is 1.