Page Comparison

List Price

= Sales Price

ADvendio__Sales_Price__c

= List Price if not manually changed

    x (1 + Sales Price Surcharge %)

ADvendio__SurchargeSalesPricePct__c

Version 2.106 and up - Percentage gets applied first!

    + CPM / Sales Price Surcharge

ADvendio__SurchargeSalesPrice__c

Might be used to set a premium for targeting e.g. country, region, city

x Quantity

x Frequency

= Gross Amount (B3)

ADvendio__Gross_amount_B3__c

ADvendio__Amount_B3__c

x (1 + Surcharge B3 %)

ADvendio__SurchargeB3__c

Percentage gets applied first!

+ Surcharge B3 Abs.

ADvendio__SurchargeB3Abs__c

= Gross Amount (B2)

ADvendio__Gross_amount_B2__c

ADvendio__Amount_B2__c

x (1 + Surcharge B2  %)

ADvendio__SurchargeB2__c

Percentage gets applied first!

+ Surcharge B2 Abs.

ADvendio__SurchargeB2Abs__c

= Gross Amount (B1)

ADvendio__Gross_amount__c

ADvendio__Amount__c

- Quantity Discount Abs. Custom

ADvendio__RateDiscount1AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount1Abs__c which is automatically calculating the absolute amount for you. 

- Customer Discount Abs. Custom

ADvendio__RateDiscount2AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount2Abs__c which is automatically calculating the absolute amount for you. 

- Agency Discount Abs. Custom

ADvendio__RateDiscount3AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount3Abs__c which is a automatically calculating the absolute amount for you.

- Special Discount Abs. Custom

ADvendio__RateDiscount4AbsCustom__c

Version 2.105 and up
Absolute Amount gets subtracted first

Don't mix those up with ADvendio__RateDiscount4Abs__c which is a automatically calculating the absolute amount for you. 

x (1 - Quantity Discount (%))

ADvendio__Rate_Discount_1__c

ADvendio__Rate_Discount_1__c

x (1 - Customer Discount (%))

ADvendio__Rate_Discount_2__c

ADvendio__Rate_Discount_2__c

x (1 - Agency Discount (%))

ADvendio__Rate_Discount_3__c

ADvendio__Rate_Discount_3__c

x (1 -  Special Discount (%))

ADvendio__Rate_Discount_4__c

ADvendio__Rate_Discount_4__c

= Customer Net (N1)

ADvendio__Discounted_Amount__c

ADvendio__Amount_net__c

x (1 - Agency Commission (%))

ADvendio__AgencyEarnings__c/
ADvendio__Agency_Commission__c

• AE will only be part of calculation if AC checkbox is set to TRUE

• You can either use the picklist or the number field to enter a AE%, the number field always wins if both are filled

• The Media Configuration automatically sets AE AC Checkbox, if the Media Campaign has an Agency

= Agency Net (N2)

ADvendio__Amount_net_net__c

ADvendio__Amount_net_net__c

x (1- Third Party Commission (%))

ADvendio__Third_party_commission__c

ADvendio__ThirdPartyCommissionCustom__c

• TPC will only be shown if the checkbox "show third party commissioning" is TRUE

• TPC is always part of item calculation (Amount N3) even if the checkbox is false

= Amount Net3 (N3)

ADvendio__Amount_net3__c

ADvendio__Amount_net3__c

(+ Non Media Costs)

= Taxable Amount (total)

ADvendio__TaxableAmountTotal__c

You can either use Agency Net (N2) or Amount Net3 (N3) as taxable amount, depending on the configuration.