Price Lists

The Price List table in the JOP extension defines how service prices are calculated based on combinations of items, materials, services, quantities, and custom properties. It supports highly flexible pricing structures to meet the needs of customer-specific or rule-based production workflows.

Price List Lines are evaluated based on the structure defined in the header and apply when their matching condition aligns with the current JOP order context.

General Section

The following fields are used to define the basic behavior and characteristics of the price list:

  • No. — Unique identifier for the price list
  • Description — Descriptive name of the price list
  • Valid from — Start date for the price list validity
  • Valid to — End date for the price list validity
  • Quotation — Indicates that the price list is only used for quoting purposes and will not be applied in actual orders
  • Missing Property Handling — Determines how the system reacts when a required property is missing during price evaluation.
    • Set zero — The system sets the property value to zero and continues with pricing.
    • Error — The system throws an error, preventing price determination.
  • Allow General Surcharges — Enables the use of center-wide, predefined markups that are automatically added to the unit price when specific conditions are met (e.g., re-coating, type of material). These surcharges are typically defined via rules and applied during pricing.
  • Allow Line Discount — Specifies whether line-based discounts are calculated when this price list is applied.
  • Price Factor Formula — If specified, the resulting Unit Price will be multiplied by this factor. The formula allows for dynamic adjustments based on custom pricing logic.
  • Price Factor Formula — If specified, the resulting Unit Price will be multiplied by the result of this formula. A formula must contain at least one property that is evaluated when the price is calculated during order processing.

    Examples:
    • {LENGTH} — Uses the property "LENGTH" as a multiplier
    • 3.141 * {DIA} — Calculates a circular area based on diameter
  • Currency Code — Currency used for the prices in this list
  • Status — Defines the current lifecycle state of the price list.

    Available options:
    • New — Initial state; not yet in use
    • Under Development — Actively being configured or tested
    • Certified — Finalized and approved for use in sales orders
    • Closed — No longer active; archived or deprecated

Applies-to Section

The Applies-to section in the Price List defines the matching criteria that determine when this price list should be selected during order processing. These criteria may include specific customers, JOP items, products, materials, or service combinations.

Matching conditions include:

  • Customer No. and Customer Group Code
  • JOP Item Code
  • Product Code and Product Group Code
  • Material Code and Material Group Code
  • Service Code and Service Group Code
  • Responsibility Center and Production Department Code

When multiple price Lists match an order, the system uses the Search Priority table to determine which price list to select. This table defines a ranked evaluation order for the matching fields to ensure consistent and predictable selection logic.

Price List Structure

This section defines the dimensional structure of the price matrix and how prices are calculated:

  • Incremental Price Search — If activated, the system will search for matching price list lines by evaluating the decimal columns one after the other (incrementally). If not activated, the system applies all decimal column filters simultaneously, requiring a match across all decimal dimensions.
  • Code Column Type — Specifies the source of the classification used in the price matrix column.

    Available options:
    • <blank> — No classification applied
    • Property
    • Customer No. and Customer Group Code
    • JOP Item Code
    • Product Code and Product Group Code
    • Material Code and Material Group Code
    • Service Code and Service Group Code
    • Production Department
    • Price Category
  • Column Property Code 1—3 — Specifies which property is used for each code column if applicable
  • Decimal Column Caption 1—3 — Caption label for each decimal input column (e.g., Length, Diameter)
  • Decimal Column Formula 1—3 — Calculation formula for each decimal field if values should be derived or converted
  • Quantity Column Type — Defines the basis for quantity-based pricing in the price list.

    Available options:
    • Quantity — Uses the quantity value from the sales or process order
    • No. of Items — Uses the number of individual items being processed
  • Unit of Measure Code — Defines the unit in which the price applies (e.g., piece, kg)

Price List Lines

Actual pricing is defined in the Lines subpage. Each line contains pricing conditions for a specific combination:

  • Code Column 1—3 — Value for each selected Code Column (e.g., "HSS")
  • Decimal Column 1—3 — Values for the related physical dimensions or characteristics
  • Quantity — Quantity range or threshold for this line
  • Starting Date — Optional start date for this specific line
  • Unit Price — Calculated or fixed price per unit
  • Flat Rate Amount — If specified, the Unit Price is transferred directly to the Amount field in the order line. It is used for pricing scenarios where a total price is agreed regardless of quantity or unit price.

Surcharges

Surcharges are evaluated during order pricing. If the associated Rule Condition is fulfilled, the specified Surcharge % is applied on top of the existing price.

In the Surcharges section, you can define markups that are conditionally applied to the unit price based on business rules. These surcharges support flexible pricing strategies by allowing cost adjustments tied to materials, services, properties, or customer-related conditions.

Fields

  • Code — Unique identifier for the surcharge
  • Description — Descriptive name of the surcharge (e.g., "Recoating Fee”, "Material Surcharge”)
  • Rule Condition Code — Reference to the Rule Condition that controls when the surcharge applies
  • Rule Condition Active — Indicates whether the associated rule condition is currently active
  • Rule Description — Text explaining the logic or purpose of the rule
  • Surcharge % — Percentage value to be added to the calculated unit price