Versions Compared

Version Old Version 18 New Version Current
Changes made by

Phu Nguyen (Unlicensed)

Phu Nguyen (Unlicensed)

Saved on

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 added 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 Child 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

rounddiscount

omitEmtpyDecimalPlacesOnQuantityColumns

true / false

Recalculate opportunity products before syncing them to quote

Option switch

CopyOppsItemsNull

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

Cf. Formula columns

Opportunity Product Sync: Do not Scale Product's UnitPrice

Option switch

doNotScaleOpportunityLineItemUnitPrice

true / false

If active, UnitPrice on Opportunity Products will not be half-even rounded to 2 Decimals

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

. 

When

If this setting is

enabled

activated, quote

position

items of type

sum will

Sum use exact values for calculation

. Otherwise

, otherwise they

will

use values rounded to

two digits.

Omit empty decimal places in quantity columns

Option switch

omitEmtpyDecimalPlacesOnQuantityColumns

true / false

If omitEmtpyDecimalPlacesOnQuantityColumns = true, empty decimal places in quantity columns are not displayed

the second decimal place.

Use rounded values to calculate product values

Option switch

useRoundedValueForProductCalculation

true / false

Default: false

When

If this setting is

enabled

activated, quote

position

items of the type

product will

Product use values rounded to two

digits

decimal places for calculation

. Otherwise

, otherwise they

will

use exact values.

Reset Discount (%) via Button

Opportunity Product Sync: Do not Scale Product's UnitPrice

Option switch

resetDiscountButton

doNotScaleOpportunityLineItemUnitPrice

true / false

Default: false

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

If active, 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

CopyOppItemsNull

true / false

Default: false

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

If this setting is

true

active, manually changed prices and discounts in Bricks are transferred unchanged to the quote

. Changes to the Pricebook Entry are ignored

.