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__c	Version 2.106 and up - Percentage gets applied first!
2.2	+ CPM / Sales Price Surcharge		ADvendio__SurchargeSalesPrice__c	Might be used to set a premium for targeting e.g. country, region, city
3	x Quantity
4	x Frequency
5	= Gross Amount (B3)	ADvendio__Gross_amount_B3__c	ADvendio__Amount_B3__c
6	x (1 + Surcharge B2 Abs. %)		ADvendio__SurchargeB3__c	Percentage gets applied first!
7	+ Surcharge B3 Abs.		ADvendio__SurchargeB3Abs__c
8	= Gross Amount (B2)	ADvendio__Gross_amount_B2__c	ADvendio__Amount_B2__c
9	x (1 + Surcharge B2 %)		ADvendio__SurchargeB2__c	Percentage gets applied first!
10	+ Surcharge B2 Abs.		ADvendio__SurchargeB2Abs__c
11	= Gross Amount (B1)	ADvendio__Gross_amount__c	ADvendio__Amount__c
12	- 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 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__c	ADvendio__Rate_Discount_1__c
17	x (1 - Customer Discount (%))	ADvendio__Rate_Discount_2__c	ADvendio__Rate_Discount_2__c
18	x (1 - Agency Discount (%))	ADvendio__Rate_Discount_3__c	ADvendio__Rate_Discount_3__c
19	x (1 - Special Discount (%))	ADvendio__Rate_Discount_4__c	ADvendio__Rate_Discount_4__c
20	= Customer Net (N1)	ADvendio__Discounted_Amount__c	ADvendio__Amount_net__c
21	x (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__c	ADvendio__Amount_net_net__c
23	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
24	= Amount Net3 (N3)	ADvendio__Amount_net3__c	ADvendio__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.