4.2.6.2 Amount Calculation and Discounts

Have you ever wondered how the net and gross values in ADvendio are calculated, here is a brief overview of how the different amount fields in your media campaign and campaign items are working together:


Label

Field API

Media Campaign

Field API

Campaign Item

Comment
1

List Price




2= Sales Price
ADvendio__Sales_Price__c= List Price if not manually changed
2.1    x (1 + Sales Price Surcharge %)
ADvendio__SurchargeSalesPricePct__cVersion 2.106 and up - Percentage gets applied first!
2.2    + CPM / Sales Price Surcharge
ADvendio__SurchargeSalesPrice__cMight be used to set a premium for targeting e.g. country, region, city
3x Quantity


4x Frequency


5= Gross Amount (B3)ADvendio__Gross_amount_B3__cADvendio__Amount_B3__c
6x (1 + Surcharge B3 %)
ADvendio__SurchargeB3__cPercentage gets applied first!
7+ Surcharge B3 Abs.

ADvendio__SurchargeB3Abs__c



8= Gross Amount (B2)ADvendio__Gross_amount_B2__cADvendio__Amount_B2__c

9

x (1 + Surcharge B2  %)
ADvendio__SurchargeB2__cPercentage gets applied first!
10+ Surcharge B2 Abs.

ADvendio__SurchargeB2Abs__c



11= Gross Amount (B1)ADvendio__Gross_amount__cADvendio__Amount__c
12Quantity 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 a automatically calculating the absolute amount for you. 

13- 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 a automatically calculating the absolute amount for you. 

14- 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.

15- 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. 

16

x (1 - Quantity Discount (%))

ADvendio__Rate_Discount_1__cADvendio__Rate_Discount_1__c
17

x (1 - Customer Discount (%))

ADvendio__Rate_Discount_2__cADvendio__Rate_Discount_2__c
18

x (1 - Agency Discount (%))

ADvendio__Rate_Discount_3__cADvendio__Rate_Discount_3__c
19

x (1 -  Special Discount (%))

ADvendio__Rate_Discount_4__cADvendio__Rate_Discount_4__c
20= Customer Net (N1)ADvendio__Discounted_Amount__cADvendio__Amount_net__c
21x (1 - Agency Commission (%))
ADvendio__AgencyEarnings__c/
ADvendio__Agency_Commission__c
  • AE will only be part of calculation if AE 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 Checkbox, if the Media Campaign has an Agency
22= Agency Net (N2)ADvendio__Amount_net_net__cADvendio__Amount_net_net__c
23x (1- Third Party Commission (%))ADvendio__Third_party_commission__cADvendio__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
24= Amount Net3 (N3)ADvendio__Amount_net3__cADvendio__Amount_net3__c
25(+ Non Media Costs)


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