Coupon Processing

Introduction

Coupons can be created in IP1, linked to order based bonus rules with rewards. Bonus rules define all the qualifying conditions, along with the minimum value/quantity that must be satisfied before the rewards can be applied. Coupons can be set to be applied automatically to orders on sales order entry.

Business rules setup

The following business rules have to be setup to handle Coupons Processing. Business rules for Coupons Processing must be setup with support from Iptor IP1 consultants. It is critical to understand the setting of control files and how it works. Control files must be setup correctly for the system to operate as intended. Any changes to the control files setup should be addressed cautiously and in consultation with Iptor IP1 consultants.

Note This document does not cover customised setup tasks of specific companies. Deviations from this setup should be covered by setup tasks written by individual companies.
View business rules
 Control file  Setup
TMSDS/BO-CPUSL Order based bonus coupon usage level Define all the coupon usage levels, i.e. per customer, per contact, per email address or for all. If the usage level is by customer then the number used will be maintained by customer and will be checked against maximum use specified for the coupon.
TMSDS/BO-RWDOP Order based bonus reward options Setup the applicable reward options with the valid system defined reward rule. The following reward options are available.

User defined option Description Reward rule
A % off each line 6
B % off each order 2
C $ off an order 3
D % off cheapest on bulk buy 7
E $ off cheapest on bulk buy 8
F fixed price freight 4
G $ off freight 5
H Fixed price item A
I Bonus items 1
J Override discount on an existing order line 9
T Override discount term T

 

Note You can set up reward groups and link it to the reward options (column C on the control file). The reward group is a way to control the definition of multiple incentive rules on the same coupon. If a coupon has multiple incentive rules within same reward group, it will apply the first rule only. This will restrict the setting up of conflicting or illogical incentive rules such as fixed freight charge and $ off freight on the same coupon.

View Reward options and conditions

TMSDS/RTN-OBO Retention period for order bonus rules/coupons Define the retention period (in months) by company for the order based bonus rules. If the retention period is entered as 1 month then the bonus rule will be purged 1 month after expiry date. If no value is defined or 0 is defined it will not be purged. 
TMSDS/BO-CBCD Charge back code Define charge back code and description that will be used for 3rd party business where order based bonus for freight needs to be charged back to their client.

Procedure

It is your responsibility to ensure that you understand this procedure before performing the following tasks.

Note Deviations from this procedure should be covered by procedures written by your company. Before performing any tasks please ensure all the business rules are set-up accordingly.

Work with coupons

  1. Expand menu Base > Distribution > Masterfiles Database Management > Database Management > Promotional Package > Incentives and double-click Work with Coupons. DSW080 Work with Coupons panel appears listing all the existing coupons.
  2. Click Add to create a new coupon.

  1. Enter the following coupon information, as necessary.
 Field Description
Coupon code  A unique code to identify the coupon.
Usage level  Usage level defines against who the coupon should be used. From the drop down, select one of the system defined usage level (per contact, per customer, per email address or for all).
Max use  Maximum number of times the coupon can be used for the usage level defined.
Note  An notes or additional information regarding the use of the coupon.
Company  Company, that the coupon is applicable for.
Currency  Currency the coupon is valid for.
Auto bonus Flag this field with a ‘Y’ if  the coupon bonus is to be automatically applied to an order, without having to to key the coupon during order entry.  If the flag is not set to ‘Y’, it can be still applied to an order but the operator will have to key in the coupon. The usage will be restricted based on the coupon settings.

Note It is recommended to turn this flag off after the coupon offer expires, for system performance reasons.
Coupon status  The coupon status will automatically default to ‘A’ for Active. When the coupon expires the status can be closed.
  1. Click OK to save the coupon. DSM251A Work with Order Based Bonus panel appears to add the bonus rules and rewards for the coupon.
  2. Click Add.

  1. Enter the following information, as necessary.
Field  Description
Sequence number 

Entering a sequence number is mandatory when creating an order based rule. The order based rules are added to the system in the ascending order of sequence numbers. The sequence number is used to decide which rule is to be used when more than one order based rule exists. When sales orders are processed, system will look at the rules in the system and will apply the first valid rule to the order.

Description  A descriptive text for the order based bonus rule.
Effective/expiry  The date range in which the order based rule will apply.
Field  Select the fields  to be included in the order based rule.
Option  The option to be used for the selected field against the values specified in the next field, example 2=Select List, 3=Omit List etc.
Values  Values to be used with the selected field.
  1. Click OK to save the order based bonus rule. DSM251C Order based bonus rewards panel appears.
  2. Click Add to add the bonus reward. DSM251C Order based bonus rewards panel appears in Add mode.

  1. Enter the following information, as necessary.
 Field  Description
Reward option  Select from the list of available reward options. These rewards options are maintained in control file TMSDS/BO-RWDOP. The reward rules in the system can be defined with one or more reward options. View Reward options and conditions for a complete list of reward options and the associated conditions and the input required.
Min sales basis 

Specify if the reward is based on minimum sales value or minimum sales quantity.

Sales rep 

Some of the reward options allow sales rep to be overridden on the sales order line. See reward options below to see which options allow sales rep override and enter the overriding sales rep if required for the reward option.

  1. Click OK. The information displayed on the next Order based bonus rewards panel is dependent on the Reward option selected.

  1. Enter the required information for selected reward option.
  2. Click OK to save the order based bonus reward.