Implementing Enterprise Pricer

This chapter provides an overview of Enterprise Pricer implementation and discusses how to:

Click to jump to parent topicUnderstanding Enterprise Pricer Implementation

The following diagram provides an overview of the pricing setup tasks that includes the Enterprise Pricer setup process and defining the price-by keys, price list fields, pricing variables and the pricing dates.

Overview of Pricing setup tasks

The setup for Enterprise Pricer is separated into two parts: performing setup tasks and establishing pricing options. Setup tasks involve configuring the pricing features available in your pricing implementation. It may also be used by developers and others who intend to customize the Enterprise Pricer module by adding price-by fields to the list of delivered fields or by adding transactions to be priced. Pricing options are tasks performed to initially configure your system to establish pricing variables, fields you will use to perform your pricing, dates to be used in mathematical equations, and fields to use as Price List business objects.

Note. The general Enterprise Pricer user should not have access to the setup pages. These pages are available to the Enterprise Pricer developer to modify the Enterprise Pricer system data and to modify the pricing features available to the users. You can configure the Enterprise Pricer data entry pages and restrict which price-by fields are available to the general Enterprise Pricer user, but this is not required for a standard implementation of Enterprise Pricer. The system data described in this chapter are delivered for each pricing transaction implementation.

Setup Tasks

A predetermined set of price-by key fields and price list fields are delivered as part of the standard pricing implementation, but the person administering Enterprise Pricer should know that these areas are available for customizations. If a new pricing key is added, the developer must also customize both online and batch pricing to use the new key. In general, these pages are not accessed; however, it is important that you understand how these pages are used to create a pricing structure. Setup tasks, such as expanding the list of price-by keys or expanding the list of price list fields, are considerably more complex. Only a knowledgeable PeopleSoft application developer or information technology person should perform these tasks.

The implementation options are:

  1. Set up Price-by Keys: The All Price-by Key Fieldnames page contains the standard list of available fields that are used when defining price rule conditions at the line level.

    All delivered price-by keys are available at implementation. Here you can add fields that are considered for price list determination and price rule creation.

  2. Set up Transaction Code Options: The options for each transaction are delivered as system data and appear on the online pricing pages.

    They also determine how Enterprise Pricer prices each transaction. Changes to these pages are considered a customization and are not supported by PeopleSoft.

Warning! The Enterprise Pricer application is delivered with standard setup data for the supported applications. Any changes made to the standard delivered data, or customer created pricing variables and dates, and custom mathematical expressions created by the customer are considered system customization and are not supported.

Pricing Options

The basic setup options task are:

  1. Set up system pricing keys on the All Price-by Fieldnames page.

    This defines the list of record fields that are used by the system.

  2. Set up the application on the Price Transaction Code page.

    This sets up the options for the application by defining the acceptable transaction codes.

  3. Set up the price-by keys for the application using the Transaction Price-By Keys page.

    This identifies the price-by keys used by the application when defining price lists and price rules.

    Note. If a price-by field is currently assigned to a price rule or an arbitration plan, you cannot remove it from the list of values assigned to the pricing transaction.

  4. Set up the pricing dates for the application on the Pricing Variables page.

    This defines the pricing date variables used in the creation of price rules and arbitration plans. The dates are used to create breaks on the formula and select price lists.

  5. Set up the pricing variables for the application on the Pricing Dates page.

    This defines the pricing variables used for price formulas when creating price rules. The Pricing Variables page is used to establish the variables to use for calculating the net price using mathematical expressions.

Click to jump to parent topic(Optional) Setting Up Enterprise Pricer

This section provides an overview of transaction code options and discusses how to:

Note. If you are not modifying standard setup data in PeopleSoft Enterprise Pricer, you do not need to complete the tasks discussed in this section. You can continue to the next implementation step. Adding or deleting price-by fields to the standard setup data is considered a customization and is not supported.

Click to jump to top of pageClick to jump to parent topicUnderstanding Transaction Code Options

The options for each transaction are delivered as system data and appear in the online pricing pages. They also determine how PeopleSoft Enterprise Pricer is used to price each transaction. You can customize your pricing definition by selecting the appropriate pricing actions for your organization. This table lists the setup options available for each transaction:

Transaction

Contract

Sales Order, Buying Agreement, Batch

Weight and Volume

Valid Action Types

  • Discount/Surcharge

  • Price Override

  • Minimum/Maximum Target Discount

  • Min/Max Target Price

  • Min/Max Target Surcharge

  • Related Business Objects

  • Discount/Surcharge

  • Pricing Base

  • Rollup Only Rule

  • Minimum/Maximum Margin

  • Price Override

  • Product Add

  • Total Order Discount/Surcharge

  • Minimum/Maximum Target Discount

  • Minimum/Maximum Target Price

  • Minimum/Maximum Target Surcharge

  • Price List Only Condition

  • Related Business Objects

Discount/Surcharge

Valid Adjustment Methods

  • Cascading

  • Summed

  • Cascading

  • Summed

Summed

Valid Price Types

  • Extended Price

  • Quantity

  • Extended Price

  • Quantity

  • Volume

  • Weight

Transaction Code Options

Use Price Index

  • Use Alter Cost Based Pricing

  • Use Buying Agreement

  • Use Cost Based Pricing

  • Use Exclusive Pricing

  • Use External Application Class

  • Use KVI/NDP (known value items/non-discountable products) Products

  • Use mathematical Expression

  • Use Maximum Quantity

  • Use Mutually Exclusive Rule

  • Use One-Time Only Price Rule

  • Use Payment Terms on Formula

  • Use Period-to-Date

  • Use Quantity in Price List

  • Use Rule Distribution Accounts

  • Used Tiered Pricing

  • Use Trade Promotions

  • Use Rule Distribution Accounts

  • Use Payment Terms on Formula

  • Use One-Time Only Price Rule

  • Use Mutually Exclusive Rule

Differences in Pricing Methods Between PeopleSoft CRM and PeopleSoft SCM

In addition to the options defined for each transaction code that defines how Enterprise Pricer prices the transaction, PeopleSoft SCM and PeopleSoft CRM use the system differently. We discuss these differences so that you can determine the best method to use for pricing.

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Enterprise Pricer

Page Name

Definition Name

Navigation

Usage

All Price-by Key Fields

EOEP_KEYFLDS

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, All Price-by Key Fieldnames

Set up price-by key fields for all Enterprise Pricer implementations. These values are delivered as system data during installation.

Transaction Code

EOEP_APP_CODE

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Price Transaction Code

Set up transaction code options, which set up the data entry pages for each transaction code and relate the transaction to another transaction.

Click to jump to top of pageClick to jump to parent topicSetting Up Price-by Key Fields

Access the All Price-by Key Fields page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, All Price-by Key Fieldnames, All Price-by Key Fields).

Note. Adding data here is considered a customization.

Record

Select the transaction record name for the price-by key field.

When adding a new record, click the Look up Record button to add new values.

Field Name

Select the transaction field name for the price-by key field.

If a new Record is added, click the Look up Field Name button to add corresponding fields.

Click to jump to top of pageClick to jump to parent topicSetting Up Transaction Code Options

Access the Transaction Code page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Price Transaction Code).

Parent

If you want to use the options from another transaction, select that transaction as the parent. For example, Buying Agreement uses the same options as Sales Order. Therefore, you would select Sales Order as the parent of Buying Agreement, and no options would be set up under Buying Agreement.

Note. Returned material authorization (RMA), buying agreement, and batch pricing are delivered with the sales order transaction that is defined as the parent.

Pricing Data Used

Select a value that indicates if the price rule should be inherited by child transactions. Values are:

System Default: Child application uses pricing data of parent application. This is the default option.

Parent Application: A child application uses the pricing data of the parent application; however, a child application is allowed to flag price rules set up for the parent application so that they cannot be used in the child application.

Note. An RMA will be set up as a child application of a sales order. Set the Pricing Data Used flag to Parent Application so that it will selectively use price rules set up for sales orders.

Price Rule Usage Processor

Enter the name of the application class that returns and displays price rule usage for the transaction. The application class implements interface EOEP_API:RuleUsageChecker to return the price rule usage data during the pricing calculation and to display the price rule data on the Price Rule page. For example, SCM_OM_PRICER:EOEP_API:SORuleUsageChecker is used for sales order.

This value is required if the transaction uses these types of price rules: one-time only, maximum quantity, period-to-date.

Valid Action Types

Select valid price action types for the transaction and limit the available options during price rule and arbitration plan entry. The values that you select are available for the price rule price action type. Values are:

Discount/Surcharge: Applies a discount or surcharge to the line.

Min/Max Margin: When the price rule has a match, the order is put on hold, as in the case of PeopleSoft Order Management. A schedule is on hold if it hits any Min/Max Margin price rules. The hold is removed automatically when repricing occurs if the order schedule no longer matches any of the Min/Max Margin price rules.

Min/Max Target Discount:Compares the total discount adjustment and, if it is outside the specified amount, applies a target discount.

Min/Max Target Price: Compares the price adjustment and, if it is outside the specified range, applies a target price.

Min/Max Target Surcharge: Compares the total surcharge adjustment and, if it is outside the specified range, applies a target surcharge.

Price List Only Condition: Attaches price lists to a transaction. The formula does not specify price breaks.

Note. We recommend that you use the price list-related objects if you do not require a complex price rule condition.

Price Override: Applies a new price.

Pricing Base: Selects the base or the starting point for pricing calculation. The pricing base action type does not have associated formulas, but it has a flag that indicates the base used if the transaction line matches this price rule.

Product Add: In previous releases, this was a giveaway action type. Now, you can indicate the discount, surcharge, or price in addition to the quantity of the giveaway. The list price of the giveaway product is used to calculate the net price. For online sales orders in PeopleSoft Order Management, the product adds (or giveaways) appear on a separate page or grid so that you can choose the ones to add to the order. For batch orders, the product adds are added to the order automatically.

Rollup Only Rule: Rolls up the quantity or amount. Only conditions are used for this type of rule (no breaks are needed). This type of price rule is used by other price rules, such as Discount/Surcharge price rules, to select price formulas.

Total Order Discount/Surcharge: Applies a discount or surcharge to the entire order.

Valid Adjustment Methods

Select how the system applies the adjustment for the Discount/Surcharge price action type from these values:

Cascading: Applied as they are found. A second discount is applied to the previously discounted price, a third discount is applied to a price that already was discounted twice, and so on. For example, if the system encounters two discounts, 10 percent and 20 percent off the list price of 100.00 USD, then the system applies the discounts in this manner: 10 percent off of 100.00 USD and 20 percent off of 90.00 USD. Thus, the unit price for the order schedule line is 72.00 USD.

Summed: When the system finds multiple discounts, it adds them together and applies the discounts once. Thus, for the summed example, the system would apply discounts in this manner: the 10 percent and 20 percent discounts for 30 percent off of 100.00 USD, which results in a unit price for the order schedule line of 70.00 USD.

Note. Summed adjustments are applied after all Cascading adjustments are applied.

Valid Price Types

Select the price types whose values you want to price by. Choose from: Extended Price, Quantity, Weight, and Volume.

Transaction Code Options

Select the features that the transaction supports. These options will control the pricing data setup pages and the pricing process. Possible values are:

No Price List Auto Conversion: Select this option to disallow price list in base currency from being used if no price list in transaction currency is found. If this option is not selected, price list in base currency will be converted to transaction currency and used if no matching price list in transaction currency is found.

Use Alt Cost Based Pricing (use alternate cost based pricing): Select to indicate whether or not the specified transaction uses the Alter Cost Based Pricing feature. Enabling this option results in the Applicable to Alternate Cost Base option appearing on the Conditions page when you define a price rule.

Alternate cost and product cost are different. For example, in Order Management, the alternate cost is product cost with an alternate cost adjustment factor applied.

Use Buying Agreement: Select to indicate whether or not the specified transaction uses the Buying Agreement feature. When this option is selected, the transaction can set up price rules that are applied to the buying agreement price, and the Applicable to Buying Agreement option appears on the Conditions page when you define a price rule.

Use Cost Based Pricing: Select to indicate whether or not the specified transaction uses the Cost Based Pricing feature. Enabling this option results in the Applicable to Cost Base option appearing on the Conditions page when you define a price rule.

Use Exclusive Pricing: Select to indicate whether or not the specified transaction uses the Mutually Exclusive pricing feature. With multiple exclusive price rules, if one or more of these rules is matched, then only one of them is applied and all other rules, whether they are mutually exclusive or regular rules, are ignored.

Use External Application Class: Select to indicate whether or not the specified transaction enables user-defined application classes to calculate the net price.

Use KVI/NDP Products: (use known value items/nondiscountable products): Select to indicate whether or not the specified transaction supports KVI/NDP products. For KVI products, Enterprise Pricer does not apply any adjustment to the price of the product. For NDP products, Enterprise Pricer does not apply discounts to the product price that would result in a net price that is less than the starting price (for example, list price or cost plus the first surcharge). In addition, you can select to exclude them from the price rule rollup for price formula matching.

Use mathematical Expression: Select to indicate whether or not the specified transaction enables Enterprise Pricer to create adjustments using user-defined mathematical expressions on the Price Formula page. You must set up pricing variables so that the system knows what variables are used in the pricing calculation.

Use Maximum Quantity: Select to indicate whether or not the specified transaction supports the ability to define price rules that are used until the applied quantity specified is reached.

Use Mutually Exclusive Rule: Select to indicate whether or not the specified transaction supports the ability to define price rules that are mutually exclusive. With multiple exclusive prices rules, if one or more of these rules is matched, only one of them is applied and all other rules, whether they are mutually exclusive or regular rules, are ignored.

Use One-Time Only Price Rule: Select to indicate whether or not the specified transaction supports the ability to define limited use price rules. On the Price Formula page, you can indicate that the rule is valid only for one time per rule or one time per customer. This option is valid only for Discount/Surcharge, Price Override, Giveaway/Product Adds, and Total Order Discount/Surcharge price rules.

Use Payment Terms on Formula: Select to indicate whether or not the specified transaction supports the ability to define price rules that select the payment for each adjustment that has the longest day or month increment from the list of values on the Payment Terms page in PeopleSoft Billing. If the order or schedule has more than one price rule with a payment term that qualifies for the order, then the system selects the most favorable terms for the customer.

Use Period-to-date: Select to indicate whether or not the specified transaction uses the Period-to-date Pricing feature. Enabling this option will result in the system using period-to-date pricing to calculate price adjustments based on transactions across a predefined time frame, rather then individual transactions.

Use Price Index: Select to indicate whether or not the specified transaction uses an index, such as the Consumer Price Index (CPI), from an external source for price calculations. The price index feature uses the pricing variables and mathematical expression.

Use Quantity in Price List: Select to indicate whether or not the specified transaction is allowed to use quantity breaks within the price list.

Use Rule Distribution Accounts: Select to indicate whether or not the specified transaction is allowed to view and create accounting distribution details for the adjustments in the price rule.

Use Tiered Pricing: Select to indicate whether or not the specified transaction supports the tiered pricing feature. With tiered pricing price rules, you can set up price rules that apply different adjustments to different ranges in the same transaction line.

Note. This option is supported only for price types of Quantity and Price.

Use Trade Promotions: Select to indicate that the transaction supports the Trade Promotion feature.

Click to jump to parent topicEstablishing Pricing Options

This section provides an overview of pricing options, lists common elements, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Pricing Options

Enterprise Pricer pricing options are defined by pricing managers and other users who control and manage the pricing setup for the organization. Pricing options will be created and updated at implementation and possibly occasionally as the pricing requirements change. The things defined here are used to support those who will define the arbitration plans and price rules for the organization. Enterprise Pricer allows you to create custom variables, mathematical expressions, and dates.

Pricing Variables

Variables are used to establish the fields to use for calculating the net price using mathematical expressions.

The actual expressions are added to the price formula. The expression is validated by the system and tested before the formula is saved.

This table describes the pricing variables that are supported for both Contracts and Order Management:

Contract

Sales Order

Weight and Volume Pricing

  • Index End Value

  • Index Start Amount

  • Index Start Value

  • Alternate Product Cost

  • Base Price

  • List Price

  • Current Net Price

  • Order Extended Base Price

  • Order Extended Product Cost

  • Order Extended List Price

  • Order Extended Net Price

  • Product Cost

  • Rollup Amount

  • Rollup Quantity

  • Rollup Volume

  • Rollup Weight

Mathematical Expressions

This table lists the only operators and functions that are supported by Enterprise Pricer for use in creating customized mathematical expressions:

Operator/Function

Description

Example

Notes

+

Add

1 + 2 = 3 or 2 + –1 = 1

If you use negative numbers, do not enter a space between the negative sign and the number.

Subtract

2 – 1 = 1

 

*

Multiply

2 * 3 = 6

 

/

Divide

6 / 3 = 2

 

**

Exponential

2 ** 3 = 8

 

( )

Parenthesis

(1 + 2) * 3 = 9

You can use operation grouping.

Truncate(a,b)

Truncate

Truncate(123.45,1) = 123.4

You must enter a value for both a and b, and b cannot be a negative number.

Round(a,b)

Round

Round(123.45,1) = 123.5

You must enter a value for both a and b, and b cannot be a negative number.

In this example, variables are set up for list price (LIST_PRICE), product cost (PROD_COST), rollup quantity (ROLLUP_QTY, sum of the quantity of the schedules that match the price rule), and current net price (NET_PRICE). This table lists and describes examples of valid mathematical expressions:

Mathematical Expression

Description

1000

Replace price with 1000.

LIST_PRICE * 0.95

Apply a five percent discount to the list price. This expression is also valid but not as efficient: LIST_PRICE * (100 – 5) / 100.

NET_PRICE - 10

Reduce the current net price (amount) by 10.

TRUNCATE(ROLLUP_QTY / 3, 0)

For a product add, calculate the quantity as buy 3 and get 1.

ROUND(PROD_COST * 1.30 * (1 - TRUNCATE( (ROLLUP_QTY – 900) / 100, 0) * 0.05), 2)

This formula defines a break between 1000 and 1500 units. The net price is calculated as:

  • Add 30 percent markup to the product cost and use that result as the base for the discount.

  • Give a 5 percent discount if the quantity is 1000 through 1099 and a 10 percent discount if the quantity is 1100 through 1199.

  • Round the result to 2 decimal points.

This kind of expression can reduce the need to create multiple formulas. However, you should set the formula break so that the calculation is valid. For example, if this example is applied to quantities greater than 2900, then the result can become negative.

Note. Enterprise Pricer does not allow a negative net price. If the calculation results in a negative, it is set to 0.

Pricing Dates

Pricing dates are the dates that Enterprise Pricer uses to select price lists and price formulas. They are set up by application. This table describes the dates used for Contract and Order Management:

Contract

Sales Order, Weight, and Volume Pricing

Effective Date

  • Requested Arrival Date

  • Effective Date

  • Order Date

  • Price Date

  • Schedule Ship Date

  • System Date

Note. If you add a new pricing date, as long as it is not a user-defined date, (for example, you are simply changing the label of the date) then it is not considered a custom date and, therefore, does not require additional custom coding.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Transaction to be Priced

Determines the appropriate list of price-by keys to use to price transactions. Values are:

BA (buying agreement): Used to price buying agreement transactions in PeopleSoft Order Management.

CA (contract): Used to price contact transactions in PeopleSoft Contracts.

OC (order capture): Used to price transactions in PeopleSoft Order Capture.

Note. This transaction does not appear in PeopleSoft Supply Chain Management.

SO (sales order): Used to price online sales order and quote transactions in PeopleSoft Order Management.

SOBT (sales order batch): Used to price batch sales orders and quote transactions in PeopleSoft Order Management.

LP (weight and volume pricing): Used for weight and volume pricing on the sales order and quote in PeopleSoft Order Management.

LPBT (weight and volume batch): Used for batch weight and volume pricing on the sales order and quote in PeopleSoft Order Management.

RMA (customer returns): Used to price customer returns in PeopleSoft Order Management.

Click to jump to top of pageClick to jump to parent topicPages Used to Establish Pricing Options

Page Name

Definition Name

Navigation

Usage

Price-by Key Field

EOEP_APPKEY_FIELD

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Transaction Price-by Keys, Price By Key Field

Select the price-by fields that are used to price the transaction.

Price List Fields

EOEP_APPLIST_FLDS

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Transaction Price-by Keys, Price List Fields

Select valid price-list-related business objects that are used when creating price lists and when defining the price list lookup method.

Pricing Dates

EOEP_DATE_VAR

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Pricing Dates

Set up dates used for pricing process.

Pricing Variables

EOEP_PRICE_VAR

Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Pricing Variables

Set up variables that are used in price rule formulas when defining mathematical expressions.

Click to jump to top of pageClick to jump to parent topicSelecting Price-by Keys

Access the Price-by Key Field page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Transaction Price-by Keys).

Price-by Key Fields

View the current price-by fields for the transaction. You can delete fields from this list to remove them from use in pricing the transaction.

Build Price-by Key Fields

Click to add fields to the Price-by Key Fields grid after selecting them from the Select Price-by Key Fields grid.

Note. If a price-by field is currently assigned to a price rule or an arbitration plan, you cannot remove it from the list of values assigned to the pricing transaction.

Select Price-by Key Fields

Select additional price-by fields.

Note. The number of pricing keys that you can define is not limited; however, system performance slows when the number of keys increases. In addition, you might need to change the application code to pass the value to the Enterprise Pricer. For example, if you add a new field for sales orders, you must add code to the sales order to pass the value of the new field when calling Enterprise Pricer. You must perform this customization for both online and batch pricing.

The RMA transaction uses the same pricing keys as the Sales Order transaction. Therefore, there is no need to set up pricing keys specific to the RMA transaction.

Click to jump to top of pageClick to jump to parent topicSelecting Price List Fields

Access the Price List Fields page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Transaction Price-by Keys, Price List Fields).

Price List Lookup

Select how you want the system to perform price list lookup. Values are:

Consider all prices: The system considers all matching price lists based on the related business objects and price rules that you have attached to the price lists. It then selects the lowest price for the product.

Lookup in priority order: The system establishes the order for the price list lookup based on the values in the Price-by Key Fieldnames Priority section. Use this method to establish a hierarchical method for selecting the list price for the transaction. If Lookup in priority order is used, the price list with the higher priority will be used. If there are multiple price lists with same priority, the one with the lowest price will be used.

Note. If the price list and related objects do not require the definition of a complex price condition, we recommend that you use the price list related objects.

Key Field Code

Select price-by keys to define the valid related business objects for a price list. These values are available as related business objects on the Price List Related Object page. They are a subset of the Price-by Key Fields for the transaction.

Priority

Establish a hierarchical order to price list lookups by entering a numeric value. This field is available only if you select the Lookup in priority order option in the Price List Lookup field.

Click to jump to top of pageClick to jump to parent topicSetting Up Pricing Dates

Access the Pricing Dates page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Pricing Dates).

Date Name

Enter a date variable name. The name must:

  • Begin with an alpha character (for example, A through Z).

  • Consist of only alphanumeric characters (for example, A through Z, 0 through 9) and "_".

  • (Optional) Begin with &.

Date Type

Select the date type. Values are:

Requested Arrival Date: The date that the customer wants the order to arrive on site. This option is used only by PeopleSoft Supply Chain Management installations.

Effective Date: The date the transaction takes place, for example, the order date in OM.

Order Date: The date that the order header is created. The system uses the current date as the default date on a sales order header, but you can enter another date.

Price Date: The date specified on the arbitration plan. For example, on the price formula, you can specify Price Date <= January 1, 2005. If the arbitration plan used specifies Price Date = Scheduled Ship Date. When the price formula is evaluated, Scheduled Ship Date <= January 1, 2005 is evaluated.

Schedule Ship Date: The date the order line is scheduled to ship. The system calculates this date from the requested arrival date, using the transit lead time and exception ship dates. You can, however, enter another date. This option is used only by PeopleSoft Supply Chain Management installations.

System Date: The current server date, that is, the system variable %Date.

User Date: A customer-defined date.

Note. This PeopleSoft application does not automatically support a defined User Date. Implementation requires that the transaction pass the value for each user date when Enterprise Pricer is called. For example, if you add a user date for sales order, then you also must add code in sales order to pass the values. For sales orders, we have created an API for you to easily implement required logic. See example implementation class SCM_OM_API:Sample:SamplePricerInputLine for more information. The same API is used to pass customer-defined pricing variables.

Description

Provide a description for the pricing date. Used when selecting the pricing dates.

Record

Select the record from which you wish to pull the date value. Applies only when the pricing variable selected is User Date.

Field Name

Select the field from which you want to pull the date value. Applies only when the pricing variable selected is User Date.

Note. Enterprise Pricer does not use Record and Field Name to automatically retrieve the value for the user date. These fields are only for the convenience of the implementation of user dates. For example, you can use the values in these fields to automatically retrieve the value for the user date and pass them to the Enterprise Pricer.

Click to jump to top of pageClick to jump to parent topicSetting Up Pricing Variables

Access the Pricing Variables page (Set Up Financials/Supply Chain, Common Definitions, Pricing Registration, Pricing Variables).

Pricing Variable Name

Enter a variable name. The format of the name is the same as pricing dates.

Pricing Variable Type

Select a variable type. All of the variable types, except User Variable, are Pricer variables whose values are known to Enterprise Pricer, either because the values are computed by the Enterprise Pricer (for example, the current net price) or because they are explicitly passed from the transaction (for example, the product cost by sales order). The variable types are:

Alternate Product Cost: The alternate product cost of the transaction line. If not provided, value of Product Cost is used.

Base Price: The base price used in the pricing calculation. Select from list price, product cost or alternative product cost, buying agreement price.

Index Start Value: Price index start value. It is automatically retrieved by Enterprise Pricer based on the index start date specified by the transaction.

Index End Value: Price index end value. It is automatically retrieved by Enterprise Pricer based on the index end date specified by the transaction.

Index Start Amount: The start amount to apply the index adjustment. The amount is passed from transaction (for example, Contracts). If it is not provided, then the value of Base Price is used.

Net Price: The current calculated net price (running net price).

List Price: The list price of the transaction line.

Product Cost: The product cost of the transaction line.

Buying Agreement Price: The buying agreement price is used in the pricing calculation.

Rollup Quantity: The rolled-up quantity of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Amount: The rolled-up amount of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Weight: The rolled-up weight of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Rollup Volume: The rolled-up volume of the transaction lines that match the price rule. This value is used to select the price formula breaks.

Note. Index Start Amount, Index Start Value, and Index End Value are currently only used by Contracts.

Trans Extended Base Price: Sum of the extended base price for the entire transaction.

Trans Extended List Price: Sum of the extended list price for the entire transaction.

Trans Extended Net Price: Sum of the extended net price for the entire transaction.

Trans Extended Product Cost: Sum of the extended product cost for the entire transaction.

User Variable: Customer-defined variable.

Note. Not all variables are available in all situations.

Record

Select the record from which you want to pull the variable value. Applicable only when the pricing variable selected is User Variable.

Field Name

Select the numeric field from which you want to pull the variable value. Applicable only when the pricing variable selected is User Variable.

Note. Enterprise Pricer does not use Record and Field Name to automatically retrieve the value for the user variable. These fields are only for the convenience of the implementation of user variables. For example, you can use the values in these fields to automatically retrieve the value for the user variable and pass them to the Enterprise Pricer.