You create price list lines to define the actual items on the price list and their list prices. When setting up a price list lines, you can define the prices by the following product levels:

• All Items (applies the same price to all items in your product hierarchy)

• Item Number such as AS54888

• Item Category such as Hardware or Software

• iStore Section

  Note: You must define the price list header before you can add price list lines.

You can use negative price, positive prices, or set the price to be zero. You can use modifiers to adjust the prices to your selling price.

From the Price List Lines page, you can create following types of price list lines:

• Price list lines: Create a price list line and assign a unit or formula-based price to a product.

• Price break lines: Create price breaks or bracket pricing to define prices using different price tiers. For example, if 10 items are ordered, the price is $10 per item; but if 12 items are ordered, then the price drops to $8 per item. If you define a price break for an item category, all the items within the category are eligible for the price break. For additional pricing flexibility, you can apply a Block Price and Break Unit Price to a price break. You usually apply these in minimum-price scenarios.

   To create a price list line:

1. Navigate to the Update Price List: Price List Lines page.

2. Click Create Price List Line to create a price list line and assign a unit or formula-based price to a product. For example, you could add line item AS54888 with a selling price of $11 each.

   Alternatively, to create a price break click, click Create Price Break Line. For steps on creating a price break line, see To create a price break line.

3. Complete your entries in the Product region:

   • Product:

     • Item Number: Applies the price against a particular item number.

     • Item Category: Applies the same price against items in the selected item category.

     • All Items: Applies the same price to all items in your product hierarchy.

       The default Product Description is based on the product selected.

   • UOM and Primary UOM: Select a UOM (unit of measure) for the item, and select the Primary UOM box to indicate if the specified UOM is the primary unit of measure.

     For example, an item such as A11111 in a price list may have two price list lines: one with a UOM of Each (EA) - the primary UOM - and the other with a UOM of Boxes. The pricing engine uses the pricing Primary UOM and the Oracle Inventory UOM conversion information to price an order whose UOM does not have a price list line. If an order for item A11111 is placed in UOM Case (CS), the pricing engine accesses the UOM conversion tables to convert CS to EA, which is the primary UOM.

     Note: The default Precedence value is based on the Product Level. You can change the Precedence value if desired.

4. Complete your entries in the Pricing Attributes region:

   • Attribute: Select attributes to further define how you want to price the product for the price list line. For example, if you selected toothbrush as the product, you can use attributes such as color to define the toothbrush to be priced.

   • Value From and Value To: Defines the attribute values. For example, if Color is selected as an attribute, then the values could be some color such as Red or White.

     Note: If you define a Value From/To range using negative numbers, enter the range from lowest to highest value. For example, to define a Volume Order Amount between -99999 to -1, enter the Value From = -99999 and the Value To = -1.

5. Complete your entries in the Price Detail region:

   • Line Type: The default is Price List Line (read-only value).

   • Application Method:

     • Unit Price (default): For inventory items and item categories. This is the per unit price of the item.

     • Percent Price: For service items. Percent Price displays if the price list line is a service item.

   • Price: Enter a list Price.

   • Formula Type: If using a formula to calculate prices, select a Formula Type and Formula Name. At pricing time, the pricing engine calculates the price of the item using one of these formulas:

     • For Static Formulas, run the Build Formula Package program to calculate the value. The result of the calculation changes the value. For more information, see Build Formula Package program.

     • For Dynamic Formulas, you only need to enter a value if the formula includes list price as one of the formula components.

   If you selected Create Price Break Line, then complete the following price break details:

   To create a price break line:

1. Navigate to the Update Price List: Price List Lines page and click Create Price Break Line to create price breaks. Use price breaks (or bracket pricing) to define prices that vary with the quantity ordered.

2. Complete the Product and Attributes regions described in defining a price list line.

3. In the Break Rules region, define the details for each price break:

   • Line Type (Price Detail region): Price Break. This value is read-only.

   • Break Type: Select one of the following break types:

     • Point: Price is based on the price bracket in which the total quantity falls.

     • Range: Price based on the ranges of the defined price breaks. For each range, the engine calculates a price and sums across all ranges to obtain the total extended price. If break type is Range and application method is block price, the Recurring Value field appears. For more information, see Break Types.

   • Application Method: The fields displayed in the Break Details region vary depending on if you select Block Price or Unit Price.

     • Block Price: Block pricing, which is applicable only for price breaks, enables you to apply a lumpsum price rather than a per unit price to a pricing line. Like regular breaks, block pricing can be defined for either Point or Range price types. A Block Price method is appropriate for the situation described in the following example:

       Shipments between 100 and 200 pounds cost a flat rate of $50, regardless of the UOM. Without block pricing, the rate would be calculated by multiplying $50 against the unit quantity. Therefore, a 100-pound shipment would be calculated at $5000 (100 lbs * $50) instead of $50.

       Note: Recurring Value: If Block Price is selected for a range break, you can define a Recurring Value that repeats a price for a defined interval; for example, charging $10 per 100 items up to 1,000 items. In this example, the recurring value is 100.

     • Percent Price: For service items (non blocking related).

     • Unit Price: Defines the price for each item.

   • Volume Based On: This can be any volume attribute, such as Item Quantity or Group Amount.

   If Unit Price is selected in the Application Method field, complete these additional fields:

   • Break UOM: Select a Break UOM such as Each to define the UOM for the price break. The unit of measure (UOM) can be different from the pricing attributes of the child line.

   • Break UOM Attribute: Select a Break UOM Attribute.

   Break Details region

   • Value From and Value To: Enter a Value From and Value To range that defines the price break.

     For example, to define a break for the first 10 items ordered, create a range from 0 to 10. To do this, enter 0 in Value From field and 10 in the Break Value To field. If the Value To field of the price break is left blank, a value of 9999....99 (15 digits) is provided by default. This value is hidden from the end user and does not appear in the Value To field.

   • Price: Enter a list Price.

   • Application Method: This field appears only when Block Price and Break Type of Range are selected. Select an Application Method.

     • Block Price applies a lumpsum price rather than a per unit price to a pricing line.

     • Break Unit Price applies a per unit price, for example, $0.30 per unit above 2,000 units.

       Note: For additional pricing flexibility, both a Block Price and Break Unit Price can be created as separate break lines. This is commonly found in minimum price scenarios. For example, a $100 flat price is charged for 1 to 100 minutes of cellular phone usage, after which the customer is billed a Break Unit Price of $1.00 per minute.

   • Formula: Enter the value of the dynamic formula to be attached to the price break header (PBH) line. At pricing time, the pricing engine calculates the price of the item using the formula.

     Notes

     • A formula can be attached to the PBH line only when the Application Method is Unit Price.

     • You can only attach dynamic formulas to a PBH line, not static formulas.

   • Recurring Value: This field appears only when Break Type is Range and Application Method is Block Price. Enter a Recurring Value to define a price for a defined interval. When a recurring value is used with price breaks, the defined Block Price repeats for the interval defined in the Recurring Value field. For example, to charge $10 per 100 items up to 1,000 items, enter 100 as the Recurring Value.

4. Click Apply to save your changes. A Confirmation message appears if the price list line was successfully created.

   Note: Copying price breaks created in releases earlier than R12: When you copy a price break line created in releases earlier than R12, the price breaks are converted to the continuous price break format standard in release R12 and newer. Since the conversion results in changes to the price break setup and break calculations, you should review the copied price break lines and make any required changes to ensure correct pricing results.