MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Order Processing > Key Concepts and Procedures > Discounting Methods > Applying Discounts to Orders

Applying Discounts to Orders

 

Discounts can be applied in the sales/quote order maintenance, shipping/billing, or postbilling conversations as long as the value of the Apply Discounts flag is set to 'Y.'  If active in the system discount codes can be defaulted, entered manually, or retrieved using a discount template.  Below is a summary of ways each of the discount types can be applied.

 

 

Methods of Applying Discounts to Orders

Type of Discount


Defaulted

Entered Manually

Retrieved via Template

Contract

Y

N

N

Customer

Y

Y

N

Volume

Y

Y

Y

Header

N

Y

N

Line

Y

N

Y

 

Note:    Defaults for line discounts are not stored on a MAC-PAC file.  They are dynamically applied based on the order header and line characteristics.  If the order characteristics either match the values of the user-defined pricing/discounting key fields or a discount templates key fields, the line discount is applied.

Regardless of how they are entered, customer, header, and line discounts are applied to orders according to a discount hierarchy established in Reference File category G95 - Discount Hierarchy.  Processing for the other discount types is automatically determined—contractual discounts are always applied directly to the base price, volume discounts are always applied after all other discounts.

Apply Discount Flag

The Apply Discount flag determines whether discounts can be applied to the base price of an order line.  The valid values for this field are Y (yes, allow discounts to be applied to this order line) and N (no, do not allows discounts to be applied to this order line).  The value of this field may be changed as long as the Firm Price flag is not equal to Y (yes).

Discount Hierarchy

Reference File category G95 - Discount Hierarchy, shown below, allows you to determine the method in which discounts are applied to the base price of a sales or quote order line.  Discount hierarchies are defined for each company/location on the system.  If you do not wish to use a complex discounting structure, do not set up a record on category G95 and the hierarchy will default to values of 000.

 

WILLIAMS                       COMMON FEATURES                         5/24/94

 DSP01                    REFERENCE FILE CATEGORY G95                    CHANGE

                                                                               

                   Category Name           DISCOUNT HIERARCHY                  

                                                                               

                                        CO(3) LOC(3)                           

                   Category Key         001BEL                                 

                                                                               

                                                                                

            CUSTOMER             HEADER            LINE                        

       Data    0                   1                2                          

               N                   N                N                          

                                                                               

                                                                               

       Data                                                                     

                                                                               

                                                                               

                                                                               

       Data                                                                    

                                                                               

                                                                                

 F2=Command          F3=Exit             F9=Inquiry          F10=Function Select

 F12=Lower Case      F15=Rekey Data                                            

                                                                               

 

    Reference File Category G95 - Discount Hierarchy.

       This category allows you to determine how discounts are applied to orders.

You can determine processing for three types of discounts:  customer, header, and line.  The values established effect the sales/quote order lines' discount amounts and calculated unit prices.  Valid values are:

0 - Apply the discount to the base price.

1 - Apply the discount to the base price after all 0 level discounts are applied.

2 - Apply the discount to the base price after all 0 and 1 level discounts are applied.

3 - Apply the discount to the base price after all 0, 1, and 2 level discounts are applied.

Note:    You can enter up to five header discounts on one order.  If you choose level 0 for header discounts, all applicable header discounts will be applied to the base price.  If you specify level 1, 2, or 3, each applicable header discount will be applied to the net result of the pervious header discount calculation within that level.

Example 1:  Simple Discounting

In the first example, you want to apply customer, header, and line discounts to the base price.  As always, contract discounts are applied to the base price and volume discounts are applied after all other discounts.

Simple Discounting Structure.

 

Assuming that the base price is $200.00, the price applied to the line would be calculated as:

 

Contract Discount

200

x

10%

=

20.00

Customer Discount

200

x

15%

=

30.00

Line Discount

200

x

5%

=

10.00

Header Discount 1

200

x

7%

=

14.00

Header Discount 2

200

x

3%

=

6.00

 

 

 

 

 

80.00

 

 

 

 

 

 

Subtotal

200

¾

80

=

120.00

 

 

 

 

 

 

Volume Discount:

120

x

12%

=

14.40

 

 

 

 

 

 

Total Price

120

¾

14.4

=

$105.60

 

Example 2:  Complex Discounting

In the second example, you want to apply customer and header discounts to the net of level 0 discounts and line discounts to the net of level 1 discounts.  As always, contract discounts are applied to the base price and volume discounts are applied after all other discounts.

Complex Discounting Structure.

 

Assuming that the base price is $200.00, the price applied to the line would be calculated as:

 

Contract Discount

200

x

10%

=

20.00

Subtotal

200

20

=

180.00

 

 

 

 

 

 

Customer Discount

180

x

15%

=

27.00

Header Discount 1

180

x

7%

=

12.60

Header Discount 2

(180 - 12.6)

x

3%

=

5.02

 

 

 

 

 

44.62

 

 

 

 

 

 

Subtotal

180

¾

44.62

=

135.38

                 

 

 

 

 

 

 

 

 

 

 

Line Discount

135.38

x

5%

=

6.77

 

 

 

 

 

 

Subtotal

135.38

¾

6.77

=

128.61

 

 

 

 

 

 

Volume Discount

128.61

x

12%

=

15.43

 

 

 

 

 

 

Total Price

128.61

¾

15.43

=

$113.18

 

Effectivity Dates

The discount start date determines the discount's eligibility.  You can have multiple variations of a discount, but only one, open-ended start date.  To be eligible for a discount, the order's pricing date must be greater than or equal to the discount start date.  Volume and header discounts use the header-level pricing date to determine eligibility; line  and contractual discounts use the line-level pricing date.

Multiple Currencies

In multi-currency environments, discounts are associated with a specific currency code.  When entered on an order, the discount will only be applied if the order selling currency and the discount currency are the same.