Navigating the Maze:Pricing Qualifiers

1 / 18
About This Presentation
Title:

Navigating the Maze:Pricing Qualifiers

Description:

... provides a default grouping number (-1) that if used is included in all other conditions. If you have Advanced Pricing you are allowed to created Qualifier Groups. ... – PowerPoint PPT presentation

Number of Views:31
Avg rating:3.0/5.0
Slides: 19
Provided by: Darc7

less

Transcript and Presenter's Notes

Title: Navigating the Maze:Pricing Qualifiers


1
Navigating the MazePricing Qualifiers
Brian Jaskolski DARC Corporation
2
Why Qualifiers?
  • Decide who can receive particular prices,
    discounts, surcharges, promotions, and benefits
  • Specific customers
  • Customer groups
  • Order types
  • Order amount
  • You link them to price lists and modifiers.

3
Qualifier Examples
  • Customer grouping hierarchies
  • Product grouping hierarchies
  • Effectivity dates
  • Weights, volumes, monetary amounts, and so on
  • Geographic location
  • Any other qualifier that meets your business needs

4
Seeded Contexts and Attributes
Context
Attributes
GSA,Agreement Name, Agreement Type, Ship To/ID,
Sold To Org, Site Org ID, Bill To/ID, Customer
Class, Sales Channel, Account Type, Party ID
Customer
Customer PO, Line Type, Line Category, Order
Type, Order Category, Source Type, Order Date,
request Date, Pricing Date, Warehouse, Shipment
Priority Code, Shippable Flag, Shipped Flag,
Freight Cost Type
Order
Terms
Payment Terms, Freight Terms, Shipping Terms
Volume
Order Amount, Period1 Order Amount, Period2 Order
Amount, Period3 Order Amount, Line Weight, Line
Volume, Order Weight, Order Volume
List Line, Coupon , Promotion , Price List,
Restricted
Modifier List
5
Basic Pricing
  • In Basic Pricing you have the following
    restrictions
  • Cannot create qualifier groups
  • Can only use certain seeded contexts and
    qualifiers
  • Cannot create new qualifier contexts or
    qualifiers

6
Creating a New Qualifier
  • Oracle documentaion suggests first 30 segments
    are either used or reserved for future functions.
    When trying to mapping your new qualifier you
    will find only 30 segments available. To solve
    this you will nee to register more columns in
    Application Developer to make them available.

7
Registering Flexfield Columns
8
Creating a New Qualifier
  • When Creating a new Qualifier the steps are
  • Create any value set needed
  • Create the context and segment
  • Use attribute mapping to tell the system how to
    get the value for your qualifier
  • It is important to remember that although you
    use the Flexfield form to define qualifiers (and
    pricing attributes) they do no have all the
    feature of Flexfields.

9
Creating a New Qualifier
10
Creating a New Qualifier
11
Creating a New Qualifier
  • Now we need to Map the new qualifier. Before
    doing this any SQL pkg that you need will need to
    be written and registered.
  • The form used to map attributes is the same form
    used to create and modify Defaulting Rules.

12
Creating a New Qualifier
13
Creating a New Qualifier
14
Creating a New Qualifier
15
Using Qualifiers
  • Qualifiers can be used on Modifiers and Price
    lists to establish eligibility. They can be
    added to Price Lists Headers, Modifier Lists, or
    Modifiers themselves. Only those Sales Orders
    meeting the eligibility will be able to use the
    pricing entity.

16
Using Qualifiers
17
Using Qualifiers
  • The Qualifier Window allows to to evaluate the
    qualifier value with operands like , between,
    or gt. You can use grouping numbers to set AND/OR
    conditions. Oracle provides a default grouping
    number (-1) that if used is included in all other
    conditions.
  • If you have Advanced Pricing you are allowed to
    created Qualifier Groups. Basically a way to
    remember conditions to be used again later. They
    can be added in the Qualifier window by using the
    Copy Group Button.

18
Using Qualifiers
Write a Comment
User Comments (0)