Taxation in SAP Business ByDesign with third party vendors
There have been many queries from customers and partners on how to manage taxation for United States as the tax rules are very complex and rates change very frequently.
Incase you have a business involving lot of products coming under exemptions and have business in many states its recommend to user third party vendors for tax calculation to get up to date tax rates with Vertex or Avalara .
Please note, for Avalara we are are currently in pilot phase and it will be very soon be generally available.
As taxes in United States change very frequently, both in terms of law and also tax rates in each postal code if you have complex tax scenarios(eg webshop) and business in multiple states we recommend to use out of the box integration offered in Business ByDesign and Vertex/Avalara.
Current Capabilities (uptill 1805)
For latest capabilities please refer to
We support Vertex and Avalara for fetching the latest tax rates for the postal code associated for the seller and buyer in all documents in ByD which attract taxes for example Sales Orders, Purchase Orders, Contracts, Invoices, Manual Tax Entries, etc..
SAP Business ByDesign offers out-of-the-box integration capabilities making sure that a key user can set up the integration seamlessly and with easy.
Real-Time Tax rates in every document
SAP Business ByDesign makes real time call to Vertex/Avalara for every document which attracts taxes making sure that all documents have the latest tax rates
As both Vertex and Avalara charge on volume SAP has buffers built on its side to make sure unnecessary/superfluous calls to are not made. For example, incase a sales order if 1000 lines items are added, even though taxes are applicable for each item SAP buffers items with same postal code data and makes minimal calls to Vertex/Avalara to save on cost of the customer.Incase all items have the same delivery address then only one call is made to Vertex/Avalara.
Ease of Returns
The tax report generated from ByD can be downloaded and uploaded directly to Vertex to use Vertex file your Tax Returns.
Planned Innovations – 1711
SAP Business ByDesign Address harmonization with Vertex
During the course of usage we observed lot of customers had addresses in SAP Business ByDesign with incorrect combination of State and postal code.
This would lead to inconsistent data as vertex would be returning tax rates based on postal code while tax reporting structures have region as a key field.To avoid save of inconsistent data ByD would terminate the process essentially causing a show stopper to avoid any further usage of such addresses.
With 1711 , incase such situation is encountered SAP ByD would indicate the incorrect address and still stop the processing of the transaction but not terminate it. Customers can the correct the combination and proceed with the document processing.
List as per ranking of feature
Following are the features we are in discussion to enable as part of the interface.Please do provide feedback incase you feel that this ranking can be improved or if you have a feature request which is not part of the backlog.
Enhance the interface to include Product Type and other necessary product details to enable more accurate tax rate determination to include exemptions for Products
Location Code Based Taxes
Enhance the interface for more accurate tax rates by passing additional address information to contain location code. This will enable determination of correct Situs for correct “Sales” or “Use” tax determination
Exemption Certificate Management
Bulk upload exemption certificates or upload them one at a time, set effective and expiration dates, store the certificates, and manage customer exceptions.
Vertex verifies address information to target the specific Tax Area ID for the most accurate rate.
This will be provided first for the accounts and supplier address data. This will be further extended to also validate address if overwritten in sales/purchase documents.
General Availability of Avalara
Currently pilot testing of Avalara integration is happened with selected customers. After the pilot phase this integration feature would be open for General Availability.
We have lot of enquiries for Canada and given the tax request structures would be similar to US this would be a country we would like to explore
Supporting other third party vendors
We are exploring possibilities to make integration also with other third party offerings like OneSource to enable ByD to support larger customer base.