To Set Up Integration With AvaTax
- Set up the connection on the Tax Providers (TX102000) form.
- Enable the Address Validation Integration feature on the Enable/Disable Features (CS100000) form and configure address verification on the Countries/States (CS204000) form.
- Set up a tax agency to be used for the AvaTax integration on the Vendors (AP303000) form.
- Create a tax zone on the Tax Zones (TX206000) form that will be used with this special tax agency.
- Create tax categories to be associated with the AvaTax tax codes on the Tax Categories (TX205500) form.
- Specify appropriate settings for the customers on the Customers (AR303000) form.
- Assign tax categories to stock items and non-stock items on the Stock Items (IN202500) and Non-Stock Items (IN202000) forms.
These subprocedures are described below.
Before You Proceed
Before you configure the integration with Avalara AvaTax in MYOB Acumatica, make sure of the following:
- Your Avalara AvaTax account is configured. For details, see To Configure Your AvaTax Account.
- The External Tax Calculation Integration feature is enabled on the Enable/Disable Features (CS100000) form.
To Set Up the Connection Between MYOB Acumatica and Your AvaTax Account
- Open the Tax Providers (TX102000) form.
- On the form toolbar, click Add New Record.
- In the Provider ID box of the Summary area, type the identifier to be used for the provider.
- In the Description box, enter a description of the provider.
- In the Plug-In (Type) box, select the built-in Avalara plug-in.
- Select the Active check box to activate the connection.
- On the Plug-In Parameters tab, in the Value column for the Account Number parameter, type your account number in AvaTax.
- In the Value column for the License Key parameter, type the license key your company uses for connecting to AvaTax.
- In the Value column for the URL parameter, type the URL to be used to connect to AvaTax.
- In the Value column for the Request Timeout (sec) parameter, type the number of seconds for the connection timeout.
- In the Value column for the Send Sales Account and Check Address Before Calculating Tax parameters, select the check boxes; also, if required, in the Value column for the Inclusive Tax parameter, select the check box.
- In the Value column for the Log Trace parameter, select the check box, if you want the system to save the requests and results of the calls to the trace logs.
- On the form toolbar, click Test Connection to test the
connection. Note:If the connection is successful, you will see a Test Connection message confirming the validity of your credentials.
- On the Company Code Mapping tab, click Add Row on the table toolbar to add a new row.
- In the Branch column of the new row, select a branch by its ID to map it to the corresponding company that you have created in the AvaTax account.
- In the Company Code column, type the company name that you have created in AvaTax for this branch.
- Repeat Steps 13–15 for each branch.
- Click Save.
To Set Up an Address Validation Provider
- Open the Address Providers (CS103000) form.
- On the form toolbar, click Add New Record.
- In the Provider ID box, type the identifier to be used for the provider.
- In the Description box, enter the description of the provider.
- In the Plug-In (Type) box, select the built-in Avalara address validation plug-in.
- Select the Active check box to activate the connection.
- On the Plug-In Parameters tab, in the Value column for the Account Number parameter, type your account number in AvaTax.
- In the Value column for the License Key parameter, type the license key your company uses for connecting to AvaTax.
- In the Value column for the URL parameter, type the URL to be used to connect to AvaTax.
- In the Value column for the Request Timeout (sec) parameter, type the number of seconds for the connection timeout.
- On the form toolbar, click Test Connection to test the connection. Note:If the connection is successful, you will see a Test Connection message confirming the validity of your credentials.
- Click Save.
To Set Up Address Verification
- Open the Countries/States (CS204000) form.
- In the Country ID box of the Summary area, select US.
- In the Address Verification Plug-In box, select the Avalara address validation plug-in you set up in the previous subprocedure.
- Click Save.
To Set Up a Tax Agency
Note:
In MYOB Acumatica, a tax agency is defined as a vendor.
- Open the Vendors (AP303000) form.
- In the Vendor ID box, type AVALARA (or another name that complies with the formatting rules defined by the VENDOR segmented key).
- In the Vendor Class box, select a vendor class that has been defined for tax agencies (if you have defined such a class) or any other appropriate class.
- On the General tab (in the Account Address section), in the Country box, select US.
- In the Vendor Properties section, select the Vendor Is Tax Agency check box. (Notice that the Tax Agency tab appears.)
- On the GL Accounts tab, specify the general ledger
accounts and subaccounts that will be used for this vendor. Note:Default accounts and subaccounts are displayed if they have been specified for the vendor class that you have selected in the Summary area; however, you can select other accounts and subaccounts.
- Click Save.
To Create the Needed Tax Zone
- Open the Tax Zones (TX206000) form.
- Type AVALARA in the Tax Zone ID box, and then type a description.
- Select the External Tax Provider check box; the Provider ID and Tax Agency ID boxes appear on the form.
- In the Provider ID box, select the Avalara tax provider.
- In the Tax Agency ID box, select the tax agency you created for this integration.
- Click Save.
To Create Tax Categories for Tax Codes
- Open the Tax Categories (TX205500) form.
- On the form toolbar, click Add New Record.
- In the Tax Category ID box, type an AvaTax code, and in the Description box, provide a description.
- Click Save.
- Repeat Steps 2–4 for each required tax code.
To Specify the Needed Settings for Each Customer
- Open the Customers (AR303000) form.
- Select a customer for which sales taxes should be calculated by AvaTax.
Note:Each customer has at least one automatically created location.
- On the Locations tab, click the link of one of the listed customer locations (or the only customer location, if only one is listed).
- On the Shipping tab of the Customer Locations (AR303020) form, which opens in a pop-up window, in the Tax Zone list, select Avalara.
- In the Tax Registration ID box, enter the customer's tax registration number.
- If this customer location is tax exempt, in the Tax Exemption Number box, enter the tax exemption number.
- In the Entity Usage Type box, select the option that corresponds to this location usage.
- On the form toolbar, click Save, and close the pop-up window.
- For each additional location, repeat Steps 4–8.
To Assign Tax Categories to Each Stock Item or Non-Stock Items
- Open the Stock Items (IN202500) or Non-Stock Items (IN202000) form.
- Select the stock or non-stock item by its inventory ID.
- On the General tab, in the Tax Category box, select the appropriate tax category for the selected item.
- Click Save on the form toolbar.