1. Advanced Pricing Implementation Guide
  2. Setting Up Pricing Constants

Setting Up Pricing Constants

To set up pricing constants:

  1. Choose one of the following navigations:

    • Sales Order Management Setup (G4241), Branch/Plant Constants.

    • Procurement System Setup (G43A41), Branch/Plant Constants.

  2. Select Price Constants from the Form menu on the Work With Branch/Plant Constants form.

  3. On the Pricing Constants form complete the following fields as required:

    Advanced Sales Pricing (Y/N) (advanced sales pricing (yes/no))

    Indicate how the system determines the price of items within the system. If your system includes the JD Edwards EnterpriseOne Advanced Pricing system, you may use this feature. Values are:

    Y: Yes, use the JD Edwards EnterpriseOne Advanced Pricing system.

    N: No, do not use the JD Edwards EnterpriseOne Advanced Pricing system.

    Advanced Procurement Pricing (Y/N) (advanced procurement pricing (yes/no))

    Specify whether to apply advanced pricing to the purchase price. Values are:

    Y: Apply advanced pricing to the purchase price.

    N: Apply standard price adjustments to the purchase price.

    Require Price Approval (Y/N) (require price approval (yes/no))

    Enter the value that specifies whether all price changes are provided through price approval workflow. Values are:

    Y: Yes, apply price approval workflow.

    N: No, do not apply price approval workflow.

    Adjustment Retrieval Method

    Enter a value to specify how the pricing calculation program selects the price adjustments. Leave blank to select a named price adjustment schedule. Blank is the default.

    Enter 1 to select the pricing address number.

    Enter 2 to select both a schedule and the address number.

    Sales Pricing on Override Price

    Specify whether to apply additional adjustments when overriding pricing on sales order detail lines. Values are:

    Y: Yes, apply adjustments for an override price.

    N: No, do not apply adjustments for an override price.

    Procurement Pricing on Override Price

    Specify whether to apply additional adjustments when overriding pricing on purchase order detail lines. Values are:

    Y: Yes, apply adjustments for an override price.

    N: No, do not apply adjustments for an override price.

    Structure Type for Sales Pricing

    Enter a UDC, (01/TS) that identifies a type of organizational structure that has its own hierarchy in the JD Edwards EnterpriseOne Address Book system (for example, e-mail). When you create a parent/child relationship for the JD Edwards EnterpriseOne Accounts Receivable system, the structure type must be blank.

    Use Ship To Address?

    Select to use the ship to address book number to retrieve direct price adjustments. The system uses this address number as the starting point for processing through the buying structure to find direct price adjustments. Clear to use the sold to address number.

    Symbol to Identify Variable Tables

    Specify the character the system uses to identify a variable table in the JD Edwards EnterpriseOne Advanced Pricing system. When you precede a table name by this character, the system recognizes the name as a table name for formula pricing calculations, such as alphabetic, numeric, and mathematical functions. For example, the +,−,×, and ÷ symbols are not valid in this field.

    Symbol to Identify UOM (symbol to identify unit of measure)

    Specify the character the system uses to identify a unit of measure in advanced pricing formulas. When you precede a unit of measure by this character, the system recognizes the entry as a unit of measure for formula pricing calculations, such as alphabetic, numeric, and mathematical functions. For example, the +,−,×, and ÷ symbols are not valid in this field.

    Symbol to Identify Currency

    Specify the character the system uses to identify a currency code in advanced pricing formulas. When you enter a precede a currency code by this character, the system recognizes the entry as a currency code for formula pricing calculations, such as alphabetic, numeric, and mathematical function. For example, the +,−,×, and ÷ symbols are not valid in this field.

    Symbol to Identify Data Fields

    Specify the character the system uses to identify database fields in advanced pricing formulas. When you precede a database field by this character, the system recognizes the entry as a database field for formula pricing calculations, such as alphabetic, numeric, and mathematical function. For example, the +,−,×, and ÷ symbols are not valid in this field.

    Symbol to Identify Test Result Name

    Enter a character to identify a test result name in an advanced pricing formula in your system. When you enter a test result name preceded by this character, the system recognizes the name as a test result name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) symbols are not valid in this field.

    Note: When you set up test result names, it is recommended that you do not use a user-defined character in the Test Result Name field. For example, do not use any user-defined characters that you set on the Pricing Constants form or special characters, such as &,%,!,?, @, $, | or #. When you use a test result name with an advanced pricing formula, the system does not interpret this symbol in both the formula and the test result name. For example, you want to reduce the purchase price of grapes by 10 percent for every Brix test result below 23. A Brix test result of 22 reduces the price by 10 percent, a Brix test result of 21 reduces the price by 20 percent, and so forth. For example, the advanced pricing formula might be:((23 − @BRIX) × −.1) × #UPRCIn this example, the @ symbol is part of the formula to determine the price of the grapes based on the Brix test result. If you use a symbol in the formula and add a test result name with a symbol, the system does not distinguish between the two symbols.
    Symbol to Identify Function Name

    Enter a character to identify a function name in an advanced pricing formula in your system. When you enter a function name preceded by this character, the system recognizes the name as a function name for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.

    Symbol to Identify Func. Arg. Separator (symbol to identify function argument separator)

    Enter a character to identify a function argument separator in an advanced pricing formula in your system. When you enter a function, the system recognizes the arguments of the function based on the function argument separator. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.

    Symbol to Identify Adjustment Detail Ref (symbol to identify adjustment detail reference)

    Enter a character to identify an adjustment detail reference sequence in an advanced pricing formula in your system. When you enter an adjustment detail reference preceded by this character, the system recognizes the sequence as an adjustment detail reference sequence for formula pricing calculations. Alphabetic, numeric, parenthesis, and mathematical function (for example, +,−,×, and ÷) values are not valid in this field.

    Promotions System Flag

    Enter a UDC, (40P/PS) to use an internal or third-party promotion package.

    Values are:

    0: No promotions system.

    1: JD Edwards EnterpriseOne promotions system.

    2: Third-party promotions system.

    Multiple Promotions Resolution Flag

    Enter a UDC, (40P/PR) to specify which promotion to use when multiple promotions are in effect for an item or customer.