Version | 2.80 and up(Country configuration) |
---|---|
Version | 2.116 and up(State configuration) |
Applying VAT/GST to your Media Campaigns within ADvendio is an automated, synchronised process. VAT can be set up for a number of different situations (Country to Country, State to State within a country), State to State across borders) and requires a few configuration steps before it can be used.
All steps below must be completed before VAT can be used and applied within your org.
Steps to follow
In order to set up the correct calculation of VAT for your Media Campaigns and Invoices you have do the following steps:
If you've updated from an older version of ADvendio, you need to make sure that picklist values are connected to object record types. For the new VAT Calculation we need the picklist "Taxable Amount Type".
The field will be used at the objects:
If you don't perform these steps, the new VAT Calculation won't work and will give you an error in the Media Configuration.
The Salesforce update logic unfortunately doesn't create this connection automatically. The ADvendio default has three different for the object Campaign Item. So you need to perform the following steps for all the record types of Campaign Item and if you are using custom Record Types for any of the Objects listed above:
If you set the Default of these picklists to none you can alternatively use the following Feature Setting to set a Standard value:
Feature Setting Name | Feature Name | Template Name | Value |
---|---|---|---|
Defaults | Finance | TaxableAmountType | N2 or N3 |
Activating 'Use New VAT Calculation' will check the field 'New Vat Calculation' on all newly created Media Campaigns. It will not update already existing Media Campaigns to use the new VAT calculation. If you want to do this, you will need to also check this field on older Media Campaigns. This would not be advised for Media Campaigns which have already been invoiced. If you have existing Media Campaigns (which were, for example, created during the set up of your VAT settings), where New VAT Calculation was active but no VAT settings were configured to match at the point of creation (between step 2 and 3/4), then you will need to trigger the VAT calculation again. This can be done either through unchecking and checking new VAT Calculation on Media Campaign level or changing some VAT matching relevant information, such as one of the Media Campaign Accounts or Legal Entity. |
As mentioned above, VAT settings can be created to cover a number of different situations. You can create VAT settings on a country or state basis, depending on your business needs. Based upon the number of countries or states that you operate in, you need at least one VAT setting for each combination.
To create or edit a custom VAT setting do this:
Please make sure that the entered values for Country Buyer and Country Seller are identical to those in the VAT Debtor and Company Profile / Legal Entity. Otherwise the system will not be able to match the correct VAT Rate! |
Country to Country (Germany to Germany):
State to State within a Country (Canada):
The default 'Buyer' as per the VAT matching will the Debtor of your Media Campaign. However, as of of 2.117, it is possible to configure the Buyer for your Media Campaign in terms of VAT matching and to create fallback logic in case this field is not filled in your Media Campaign.
You only have to do this step, if the VAT laws of your Country require the VAT 'Buyer' to be someone other than the person/company paying for the service. Otherwise proceed with 4.b |
For example, you operate in a country where the applicable VAT is decided by the location where the service will be 'consumed', not the location of the person paying for the service. You have a Media Campaign which will be paid for by a Holding (the debtor) for one of their daughter companies/associates in a different location (beneficiary of the Media Campaign). The default VAT matching would incorrectly apply the VAT relevant for the Debtor location. Through use of a feature setting, you can ensure that your VAT is always matched to the beneficiary of a Media Campaign
In most cases the Debtor of a Media Campaign will also be the beneficiary of the service, meaning you would want the VAT matched to your Debtor location, unless a Beneficiary is set. In this situation, you would configure your Feature Setting as below (Beneficiary, Debtor). In this configuration, the matching would first look at the Beneficiary, if nothing is set on Media Campaign level, it would then look at Debtor.
The Feature Setting can be configured for all account types related to your Media Campaign.
Makes sure that all your customers records have the Billing Country and Billing State field filled.
You only have to do this step, if you are using legal entities. Otherwise proceed with 4.b. |
Navigate to Overview - Object Legal Entities. Open all your records and enter the
If you are not using Legal entities please make sure that you have entered a country in your Salesforce Organisation as the system will choose your Salesforce Org's country/state as Seller Country and/or Seller State. You will find this under Setup - Company Profile - Company Information. Make sure to fill the Address field Country with the 2 digit Alpha ISO Code of your country. List can be found here: http://data.okfn.org/data/core/country-list
Make sure your Adspecs have the VAT Type set to either 1 or 2. This should match the type in the Custom Setting VAT.
You might need to extend the custom setting Mapping BA. This mapping is used to create a new pre-invoice out of your Media Campaign when you push the "create pre-invoice records" button or do a pre-invoice billing run. Get more information here: 7.6.1 Configure Mapping BA
If you have upgraded your ADvendio Version to > 2.80 from a prior version, you need to manually update the Mapping BA entry for the field:
If you have upgraded your ADvendio Version to > 2.114 from a prior version, you need to manually update the Mapping BA entry for the field:
Please check out the following page for more information: 7.6.1.1 Version Changes for Custom Setting: Mapping BA. |
To show VAT on your Invoices and Quotes, please check the field Show Gross Campaign Costs in the relevant Quote and Invoice Preferences.
Note: if VAT rate B has been used in the applied VAT of a Media Campaign, the external names of VAT A and B will show on the invoices. Additionally, if the field external name VAT Classification has been filled, this will show on your Quote or Invoices and will show VAT A and B combined.
For further information, read 7.5.2.4 Show the Gross Value (B3) and VAT on an Invoice and 7.5.1.3 Show the Gross Value (B3) and VAT on a Proposal.
To use the reverse charge mechanism please check the field within the media campaign record. More details can be found here: 6.1.5 Reverse Charge Mechanism.
Change the layouts for Media Campaign, Invoice, Campaign Item and Invoice Item to show the fields you need. Please refer to the list here: 7.6.2.2 VAT fields Overview.
Version 2.96 and up
If you cooperate with countries where VAT rates do not need to be calculated please take note that the checkbox 'VAT charged (non-valid VAT Id number)' in your VAT Custom Setting (see above) leads to the following behavior:
If the Debtor has a VAT Id entered and the 'VAT charged' checkbox is checked the Media Campaign and Invoice will not set a VAT rate
Debtor VAT Id No. (ADvendio__VatIdNumber__c) | VAT charged (non-valid VAT Id number) | VAT Rate % | Seller Country | Buyer Country | Result |
---|---|---|---|---|---|
DE123456789 | false | 19% | DE | DE | 19% |
- | false | 19% | DE | DE | 19% |
FR123456789 | true | 19% | DE | FR | 0% |
- | true | 19% | DE | FR | 19% |
**The VAT Charged mechanism test whether the ADvendio field: ADvendio__VatIdNumber__c is filled! Therefore non-valid means empty, there is no validation on the values entered in this field. |