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