Examples to use in setting up modifiers in Oracle Advance Pricing

Example 1: Line level discount of 8% discount on all products

File Path: $QP_TOP/patch/115/sql/QPXEXDS1.sql

Example 2: Buy more than 5 quantities of item 62081 , Get 8% discount

File Path: $QP_TOP/patch/115/sql/QPXEXDS2.sql

Example 3: For customer 1000, Buy more than 2 Units of item 62081, Get 10% discount

File Path: $QP_TOP/patch/115/sql/QPXEXDS2.sql

Example 4: Charge 2% surcharge on all products

File Path: $QP_TOP/patch/patch/115/sql/QPXEXSUR.sql

Example 5: For customer 1000, Buy more than 2 units of item 62081, Get a Payment Term 2/10 NET 30

File Path: $QP_TOP/patch/115/sql/QPXEXTSN.sql

Advertisements

2 thoughts on “Examples to use in setting up modifiers in Oracle Advance Pricing

  1. Dear Ahmad ,

    I am the techi man . I need to know the basic price list set up with screen shot. for example i need 10% discount for a item when the against customer.

    Regards,
    Sharad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s