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-9) and the Service
Inquiries menu (SD-2-19). Any existing coupon book can be accessed
in the inquiry by entering the coupon book number. The Coupon 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 redeemed. 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). On Fixed Quantity Coupon Books, the Number Of Coupons field was 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 is found on the Order Entry Inquiry menu, 2-9 and Service Inquiries menu, 2-19. Any existing coupon book can be accessed in the inquiry by entering the coupon book number. The Coupon 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 redeemed. 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.
Enter Data
Upon entry to the program the cursor is at the following prompt.
Coupon Book No. Or E'nd
5/02/96 Coupon Inquiry 7:54
Coupon Book No. Or E'nd No. Coupons Left
Ship-To Customer 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. A coupon book number was assigned to the coupon book when the Coupon Book invoice was created. This is the number that you must enter to access the coupon book's information. If an invalid coupon book number is entered, the prompt Coupon Book Not Found appears. The cursor returns for reinput. (8 Digits)
Enter Data (Cont’d)
Once a valid coupon book number is entered, the information is displayed.
5/02/96 Coupon Inquiry 7:54
Coupon Book No. Or E'nd 397 No. Coupons Left 3
Ship-To Customer 5552222 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
State WI State WI CROSSE
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. UM P/M
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.
Another Inquiry (Y/N)
The cursor is at one of the two following prompts.
Another Inquiry (Y/N)
Next Page (Y/N)
The first prompt appears if the items and messages that are on the coupon do not exceed one screen. The second prompt appears when the items and messages on the coupon book exceed one screen.
Another Inquiry (Y/N)
Enter a Y for yes to exit the displayed coupon book and return to the Coupon Book No. Or E'nd prompt. Enter a N for no to exit the inquiry.
Next Page (Y/N)
Enter Y for yes to view the next screen of items and messages. When the last screen is reached, the prompt Another Inquiry (Y/N) appears. Enter a N for no to exit the displayed coupon book and return to the Coupon Book No. Or E'nd prompt.
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 display.
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.