Properties

The Property table in the JOP extension defines custom characteristics that can be assigned to JOP Items, Products, Materials, or used in rule conditions and pricing. Properties are highly flexible and support both manual and system-calculated values.

General Section

  • Code — Unique identifier of the property
  • Description — Concise description or name for the property
  • Data Type — Defines the format or input type for this property. Available options:
    • Decimal — Floating point numbers (e.g., 12.5)
    • Integer — Whole numbers only
    • Rational — Fractional values, displayed as numerator/denominator
    • Rational/Decimal — Accepts either rational or decimal input
    • Boolean — True/False or Yes/No input
    • Code — Coded values, typically selected from a list
    • Text — Free-text input
    • Options — Defines the selectable values for properties with Data Type = Option. These are entered as a comma-separated list.
    • Date — Calendar date (e.g., 2027-05-25)
    • Time — Time of day
    • DateTime — Combined date and time value
  • Options — If Data Type is Option, this field lists the available option values

    Example: ,OK,Not OK — This defines three options: a blank entry, "OK", and "Not OK".
  • Mandatory Test — Specifies whether and when the property must be confirmed as part of the order or production flow. Available options:
    • None — No confirmation required
    • Finish Position — The property must be entered before the process order is generated. This refers to the order line function "finish position".
    • Post Shipment — The property must be confirmed before the item has been shipped
  • Test Property Value — Specifies, if the property value entererd must be setup in the property card
  • Decimal Places — Defines the number of decimal places used for displaying and rounding numeric values of the property.
    For technical details, see Microsoft's documentation on the DecimalPlaces Property in AL.
  • Property Relation — Specifies whether the property value applies to a single unit or the total quantity in the order line.

    Available options:
    • <blank> — No specific relation; treated as a general property
    • Unit — The property refers to one unit (e.g., piece weight, length per item)
    • Quantity — The property refers to the total quantity (e.g., total weight, total surface area)

System Calculation Section

  • System-calculated — Indicates that the property value will be automatically calculated using a formula. This field is only available for properties with Data Type = Decimal.
  • Formula — Defines the expression the system uses to automatically calculate the property value when the process order is generated.
    You can reference other numeric properties from the same order line by enclosing their property code in curly brackets.

    Example: {LENGTH} * {WIDTH} — Calculates the surface area using the values of two other properties.

    This field is only applicable if System-calculated is enabled and the property's Data Type is Decimal.
  • Formula Rounding Precision — Specifies how the automatically calculated value should be rounded. The value represents the precision step.

    Example: 0.01 will round the result to two decimal places; 1 rounds to whole numbers.
  • Formula Rounding — Specifies the rounding direction applied to the calculated property value. Used together with Formula Rounding Precision.

    Available options:
    • Nearest — Rounds to the nearest value based on the specified precision
    • Up — Always rounds up to the next higher value
    • Down — Always rounds down to the next lower value
  • Missing Property Handling — Defines behavior when required inputs for the formula are not available (Set Zero or Error)

Printing Section

Print On — These fields define whether the property should appear on specific documents by default, such as:
  • Blanket Order
  • Quote
  • Blanket Order Confirmation
  • Shipment
  • Invoice
  • Credit Memo
  • Process Order
  • Process Folder
These are initial default values. They can be individually overridden at the JOP Item or Sales Order Line level.

Allowed Values Section

If you want to restrict entries to specific predefined values, you can configure allowed values per context.

  • Responsibility Center — Scope restriction based on the center
  • Production Department Code — Further limits the allowed values per department
  • Sell-to Customer No. — Enables customer-specific allowed values
  • Value — The allowed input value
  • Description — Explanation or label for the value