Program Description
This program can be found on the Order Entry Reports menu (OE-4-8). When a coupon book is sold, the total amount of the coupon book is posted to a liability general ledger account. The journal entry is made by using the Branch Item Sales Report and the Sales Interface in the Billing system. As coupons are redeemed by a customer, the amount redeemed needs to be removed from the liability account and entered into an income account. This report provides the necessary data to make the journal entry transfer from the liability account to the income account. Coupon books are sorted by branch, item number, and product class. With the proper set up, the report will provide the necessary calculations in order to post the correct income accounts. For each coupon book included, the current liability amount that is left on the coupon book is calculated. This is based on the original selling price of the coupon book, number of coupons in the book, and the number of coupons left to be redeemed. A total liability amount is printed for each branch and product class within the branch. This report can also be used to provide a listing of all coupon books in the Coupon system. The report can be run for a specific customer or range of customers and provides a list of a particular customer's coupon books. It can also be run to provide a listing of coupon books based on a specific range of expiration dates. Click on the book to learn more about the Coupon system.
Results
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. The detail line was modified slightly to accommodate the extra length on the quantity fields. The Number of Coupons, Number Used, Number Credit and Number left on the Product Class, Branch and Report totals have been staggered onto two lines to allow for 6 digits on Fixed Quantity coupons.
Rev 14 Changes
N/A
Rev 13 Changes
Internal program changes were made to correct a problem with a command.
Also, internal program changes were made to correct a year 2000 problem.
Program logic was added for Variable Quantity coupon books. The Number Coupon, Number Used, Credit Coupon, and Number Left fields have been enlarged to have three decimal positions.
Click on the book to learn more about the Coupon system.