Purging Coupon Redemption Records (MPCP)

Purpose: Use the Purge Redeemed Coupons function to purge redeemed and expired coupon records from the Coupon Redemption table.

Overview: When you generate and print a batch of coupons through the Coupon Generation function, some of the coupons are redeemed before the expiration date designated and some are not. In order to delete the redeemed and expired coupons from the system you must purge the records.

Purpose: Use this screen to purge redeemed or expired coupon records from the Coupon Redemption table and create the Print Purged Coupons Report. You can purge coupons by redeemed date or expired date.

See Redeeming Coupons, Certificates, and Credits (WCPN) for more information on creating and redeeming coupons.

Purge Coupons Screen

How to display this screen: Enter MPCP in the Fast path field at the top of any menu or select Purge Redeemed Coupons from a menu.

Field

Description

Redeemed

Indicates whether to purge coupons by the date they were redeemed. Valid values are:

Selected = Purge coupons by redemption date

Unselected = Do not purge coupons by redemption date

A coupon is redeemed when a customer uses it as payment for an order. If you select this field, the system purges coupons redeemed on or before the date you enter in the Date Redeemed field.

Date (Date redeemed)

The cutoff coupon redemption date. The system purges all coupons redeemed on or before this date if you selected the Redeemed field.

Numeric, 6 positions (MMDDYY format); required if you selected the Redeemed field.

Expired

Indicates whether to purge expired coupons. Valid values are:

Selected = Purge coupons by expiration date

Unselected = Do not purge coupons by expiration date

A coupon expires when the coupon expiration date is less than the current date. When the coupon expires, it is no longer a valid method of payment. If you select this field, the system purges coupons expired on or before the date you enter in the Date Expired field.

Date (Date expired)

The cutoff coupon expiration date. The system purges all coupons expired on or before this date if you selected the Expired field.

Numeric, 6 positions (MMDDYY format); required if you selected the Expired field.

Screen Option

Procedure

Purge records and print the Print Purged Coupons Report

Select Accept.

MPCP OROMS 5.0 2018 OTN