Scribd Logo
Upload

Welcome to Scribd!

  • 348 views

    Oracle Advanced Pricing Promo Modifier

    Uploaded by

    mdeldred
    1. To create a Buy One Get One Free modifier in Oracle Pricing Manager, first verify the buy and get items are on the price list. Then create a promotional modifier type at the header level with line level pricing, an item number product attribute, and a recurring break between 1-9999999 units. 2. Under the get product block, enter the free item number, quantity of 1, and price list. Set the application method to percent and value to 100% to make it free. 3. Run the QP Maintains Denormalized Data report to populate the modifier qualifiers table for use on sales orders. The modifier can then be tested on a sales order line for the buy item

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle Advanced Pricing Promo Modifier

    Uploaded by

    mdeldred
    348 views5 pages
    1. To create a Buy One Get One Free modifier in Oracle Pricing Manager, first verify the buy and get items are on the price list. Then create a promotional modifier type at the header level with line level pricing, an item number product attribute, and a recurring break between 1-9999999 units. 2. Under the get product block, enter the free item number, quantity of 1, and price list. Set the application method to percent and value to 100% to make it free. 3. Run the QP Maintains Denormalized Data report to populate the modifier qualifiers table for use on sales orders. The modifier can then be tested on a sales order line for the buy item

    Original Description:

    Examples for adding a promotional item automatically to a sales order line in Oracle R12.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. To create a Buy One Get One Free modifier in Oracle Pricing Manager, first verify the buy and get items are on the price list. Then create a promotional modifier type at the header level with line level pricing, an item number product attribute, and a recurring break between 1-9999999 units. 2. Under the get product block, enter the free item number, quantity of 1, and price list. Set the application method to percent and value to 100% to make it free. 3. Run the QP Maintains Denormalized Data report to populate the modifier qualifiers table for use on sales orders. The modifier can then be tested on a sales order line for the buy item

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    348 views5 pages

    Oracle Advanced Pricing Promo Modifier

    Uploaded by

    mdeldred
    1. To create a Buy One Get One Free modifier in Oracle Pricing Manager, first verify the buy and get items are on the price list. Then create a promotional modifier type at the header level with line level pricing, an item number product attribute, and a recurring break between 1-9999999 units. 2. Under the get product block, enter the free item number, quantity of 1, and price list. Set the application method to percent and value to 100% to make it free. 3. Run the QP Maintains Denormalized Data report to populate the modifier qualifiers table for use on sales orders. The modifier can then be tested on a sales order line for the buy item

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    The setup for creating a simple Buy One Get One Free Modifier is as follows:

    1.
    2.

    Via Oracle Pricing Manager Responsibility


    Navigate > Price List > Price List Setup
    Verify items (buy item and get item) are on the price list.

    3. Navigate > Modifiers > Modifiers Setup


    At the header level create a Modifier Type of Promotion
    4. Modifier line info should be setup as follows:

    Level - Line
    Modifier Type - Promotional Goods
    Automatic - Checked
    Pricing Phase - List Line Adjustment

    Product Attribute - Item Number


    Product Attribute value - the item that the customer orders
    Volume type - Item Quantity

    Break type - Recurring


    Operator - Between
    UOM - select the appropriate unit of measure
    Value from - 1
    Value to - 9999999
    Click on the Define Details Button

    Under the "Get" Product Block, enter the item that is free.
    Product Attribute - Item Number
    Product Value - the free item number
    Uom - select the appropriate unit of measure
    Get Qty - 1

    Get price - select Price List (defaults if only one list available)

    Application Method - percent


    Value - 100 ( if it is free)

    Save.

    Run QP: Maintains Denormalized Data in QP Qualfiers for this modifier.


    Responsibility: Oracle Pricing Manager
    Navigate to: Reports.

    One is now ready to test this modifier on a sales order.

    Enter a sales order line for the Buy Item

    A message is shown

    A new order line for the get item is created.

    You might also like