Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The admin area "Calculation" controls - partly together with corresponding product properties - the calculation logic in the editor.

...

Setting

Type

Parameter Name

Parameter Textblock

Note

Use Gross totals as

Settings for Product Properties, Type Pricecalculation

Apply price matrix to list price

totals

Option switch

GroupTotalDiscount

matrixSetListPrice

true /

false

Outputs in gross-sum-elements the sum of the list price instead of the price incl. VAT

Position number for child product items

Picklist

  • X.

  • X.X.

addSubPos

sub / subsub / nor

This parameter defines what kind of structure is used for position numbers of products.

Position number for added product items

Picklist

  • X.

  • X.X.

addOnSubPos

sub / subsub / nor

This parameter defines what kind of structure is used for position numbers of addonproducts.

false

Default: false

If this setting is active, the price calculation product property is applied to the list price.

See https://factory42.atlassian.net/wiki/spaces/apperoquotedocumentation/pages/3340143789/Pricecalculation

Apply price matrix to

list

sales price

Option switch

matrixSetListPrice

matrixSetEndPrice

true / false

Cf. Product property "Price calculation"

Apply price matrix to sales price

Option switch

matrixSetEndPrice

true / false

Cf. Product property "Price calculation"

Default: false

If this setting is active, the price calculation product property is applied to the end price.

See Price Calculation

Apply price matrix to lower price limit

Option switch

matrixSetLowSell

true / false

Cf. Lower price limit

Multiply Listprice (before Discounts)

Option switch

multipliyOnListprice

true / false

Discounts are deducted from the total list price instead of the individual list price.

Multiply packing

Default: false

If this setting is active, the product property Price calculation is used to calculate lower price limits.

See Lower Price Limits (via Product Property Price Calculation)

Quantity Settings

Multiply packaging unit in calculation

Option switch

CalculatePackingunit

true / false

default_standard: false,
default_newInstallation: true

Parameter defines the

Calculation for Line Item Sum with PackingUnit.

sum calculation with packaging unit:

  • true =

Value from Packing Unit is multiplied with Quantity and calculates the Sum
false = Packing Unit is for information only
  • The number in the packaging unit is multiplied by the quantity and is included in the grand total

  • false = The packaging unit is only displayed for information purposes and has no influence on

Sum
  • the grand total

Use Column Quantity Multiplier

Option switch

CalculateQuantityMultiplier

true / false

Default: false

This parameter activates an additional quantity column

for unit calculation only

.

Quantity limited to integers

Option switch

roundquant

true / false

Default: false

This parameter

defines

controls whether

the field "amount" will

the numbers entered in the quantity fields should be limited to integers

or allows fractions

.

  • true =

Amount is always displayed as integer
  • Limitation to integers activated

  • false =

Amount
  • Limitation to integers deactivated, numbers with decimal

digits
  • places can be entered

Discount rounded to integers

Omit empty decimal places in quantity columns.

Option switch

rounddiscountCf. Formula columns

omitEmtpyDecimalPlacesOnQuantityColumns

true / false

Formula of xColumn1

Input field

formularXColumn1

Cf. Formula columns

Formula of xColumn2

Input field

formularXColumn2

Cf. Formula columns

Format of xColumn1

Picklist

  • Currency

  • Number

  • Percent

  • Integer

  • Text

formularXColumn1Formatter

no formatting / Currency / Number / Percent / Integer / String

Cf. Formula columns

Format of xColumn2

Picklist

  • Currency

  • Zahl

  • Prozent

  • Ganzzahl

  • Text

formularXColumn2Formatter

no formatting / Currency / Number / Percent / Integer / String

Default: false

If omitEmtpyDecimalPlacesOnQuantityColumns = true, empty decimal places in the quantity columns are not displayed, i.e.

  • 1.00 is displayed as 1

  • 1.500 is displayed as 1.5

  • 1.230 is displayed as 1.23

Rounding Behaviour

Discount rounded to integers

Option switch

rounddiscount

true / false

Default: false

If this setting is active, discounts at product level are rounded to whole numbers.

Use exact values to calculate sum values

Option switch

useExactValueForSumCalculation

true / false

Default: false

If this setting is activated, quote items of type Sum use exact values for calculation, otherwise they use values rounded to the second decimal place.

Use rounded values to calculate product values

Option switch

useRoundedValueForProductCalculation

true / false

Default: false

If this setting is activated, quote items of the type Product use values rounded to two decimal places for calculation, otherwise they use exact values.

Opportunity Product Sync: Do not Scale Product's UnitPrice

Option switch

doNotScaleOpportunityLineItemUnitPrice

true / false

Default: false

If active,

UnitPrice on Opportunity Products will not be half-even rounded to 2 DecimalsUse exact values to calculate sum values

the UnitPrice is no longer rounded during opportunity sync.

Omit Emtpy Decimal Places On Currency Columns.

Option switch

omitEmtpyDecimalPlacesOnCurrencyColumns

true / false

Default: false

If active, empty decimal places in currency columns are not displayed.

Calculation Trigger

Recalculate opportunity products before syncing them to quote

Option switch

useExactValueForSumCalculation

CopyOppItemsNull

true / false

Default: false

When this setting is enabled quote position of type sum will use exact values for calculation. Otherwise they will use values rounded to two digits.

Reset Discount (%) via Button

Option switch

resetDiscountButton

If active, the opportunity products are reset to the original price book entry when synced to the quote, product properties are applied and sum discounts are adjusted if a discount matrix exists.

Do Not Update Brick Calculation

Option switch

doNotUpdateBrickCalculation

true / false

Default: false

Enables the Reset-Button for Discount 1 in Product-Detail-Dialog

If this setting is active, manually changed prices and discounts in Bricks are transferred unchanged to the quote.