# Avalara AvaTax with SAP Business ByDesign: how the integration works

> Source: https://netray.co/stack/avalara-avatax-sap-business-bydesign
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Stack

## Short answer

Avalara AvaTax for SAP Business ByDesign is a prebuilt point-to-point connector listed on SAP Store. ByDesign sends the transaction to AvaTax, and AvaTax returns the sales and use tax to apply. It suits mid-market ByDesign users who do not want to maintain tax rate tables by hand.

## Erp

SAP Business ByDesign

## Erp Key

sap-bydesign

## On Prem

false

## Product

Avalara AvaTax

## Vendor

Avalara

## Category

Sales tax

## Integration

**Method:** Prebuilt point-to-point connector (SAP Store listing)

**Detail:** The connector is delivered as a listed partner solution rather than custom middleware. At document time ByDesign passes ship-from, ship-to, item and amount data to AvaTax and receives tax amounts back for the document. Confirm the exact supported document types and any edition limits with Avalara before scoping.

**Method:** Company and item configuration in both systems

**Detail:** On the Avalara side you maintain the company, nexus and tax codes. On the ByDesign side, items and customers need the attributes the connector reads, such as tax code mapping and exemption status. This part is configuration, not code.

## Data Flows

**From:** ByDesign sales order or invoice

**To:** AvaTax

**Data:** Addresses, items, quantities, amounts, customer exemption

**Trigger:** Document is saved or released

**From:** AvaTax

**To:** ByDesign

**Data:** Tax amount and jurisdiction detail per line

**Trigger:** Response to the calculation request

**From:** ByDesign customer master

**To:** Avalara

**Data:** Exemption certificate status or entity use code

**Trigger:** Customer created or changed

**From:** ByDesign posted invoice

**To:** Avalara

**Data:** Committed transaction for returns reporting

**Trigger:** Invoice posting, if commit is enabled in your setup

## Setup

### Confirm scope

**Detail:** Check that your ByDesign scoping and country setup include the sales tax scenario the connector supports, and which Avalara plan you hold.

### Install the solution

**Detail:** Activate the Avalara solution from SAP Store through your ByDesign tenant or partner, following the vendor guide.

### Create the Avalara company

**Detail:** Set company code, ship-from locations and nexus jurisdictions to match your legal entities.

### Map items to tax codes

**Detail:** Assign Avalara tax codes to product categories so taxable and exempt goods are classified correctly.

### Load exemptions

**Detail:** Mark exempt customers and upload certificates in Avalara, then set the matching flag on the ByDesign customer.

### Test with real addresses

**Detail:** Run orders to several states, including a tax-free state, a home-rule jurisdiction and an exempt customer, and compare to manual tax.

### Reconcile the first period

**Detail:** Compare ByDesign tax revenue accounts to the Avalara transaction report before the first return is filed.

## Pitfalls

- Items without a tax code default to taxable, so exempt goods such as certain materials or resale items are over-taxed until mapped.
- Ship-from address on the document differs from the Avalara location, which shifts origin-based jurisdictions.
- Customer exemption flags set in ByDesign but no matching certificate in Avalara, so audit support is missing.
- Credit memos and partial returns not committed the same way as the invoice, leaving the Avalara return and the ledger out of step.
- Address validation failures on rural or new addresses silently fall back to a zip-level rate.
- Manual tax overrides on a document that the next recalculation overwrites.

## Ai Layer

### Tax variance triage

**Description:** A private assistant compares ByDesign invoice tax with Avalara results and lists documents where they disagree, with the likely cause such as a missing tax code or address.

### Plain-language tax questions

**Description:** Finance asks why a specific invoice was taxed at a given rate and gets the line, jurisdiction and exemption state from both systems with the query shown.

### Exemption gap review

**Description:** Find customers flagged exempt in ByDesign without a certificate on file, and draft a request list for a person to approve and send.

## Alternatives

- Vertex Cloud for ByDesign if you are US and Canada only and prefer an embedded service.
- ByDesign native tax determination if you sell in few jurisdictions and rates rarely change.
- A partner-built integration such as Navigator iConnect if you need return filing automation around Avalara.

## Faq

### Does this need middleware?

**Answer:** The listing describes a prebuilt point-to-point connector, so no separate middleware is described. You still configure Avalara and map items and customers. Check the current SAP Store listing for supported scenarios in your tenant.

### Does AvaTax file returns for me?

**Answer:** AvaTax calculates and records tax. Return filing is a separate Avalara service or a partner-built flow. Confirm which you are buying, because calculation alone leaves filing as a manual job.

### Can I run AI over tax and invoice data privately?

**Answer:** Yes. A read-only assistant can compare ledger tax with the Avalara transaction export on infrastructure you control. Anything that changes a document or certificate needs a person to approve.

## Source

https://www.sap.com/israel/products/erp/partners/avalara-inc-avalara-avatax-for-sap-business-bydesign.html

## Search terms

avalara sap business bydesign integration, avatax bydesign, bydesign sales tax, avalara sap store, bydesign tax calculation, bydesign nexus exemption

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json