Exception Certificate Management: General Information

In 43 states across the United States, economic nexus laws require businesses to collect and remit sales taxes based on their activities within each state. These laws require businesses to manage tax-exempt transactions for various customer types, such as healthcare organizations, governments, universities, and nonprofit organizations, which are exempt from tax payments. Therefore, companies must have current and correct versions of their customers' tax exemption certificates to accurately apply valid certificates to transactions.

In MYOB Acumatica, you can configure tax-exemption functionality through Avalara integration. This gives you the ability to request the tax exemption certificates from eligible customers and keep the certificates updated. As a result, you can manage tax-exempt transactions seamlessly through Avalara's exemption certificate management (ECM) service.

Learning Objectives

In this chapter, you will learn how to do the following:

• Add multiple MYOB Acumatica customers to the Avalara ECM account
• Add a single MYOB Acumatica customer to the Avalara ECM account
• Request an exemption certificate from a customer
• Retrieve an exemption certificate in MYOB Acumatica
• Update a customer's information in the Avalara ECM account

Applicable Scenarios

You configure Avalara exemption certificate management in MYOB Acumatica in the following cases:

• Your company has customers across various states in the US, and some customers are qualified for tax exemptions.
• You want to use an online service to easily manage tax-exempt transactions for various customer types and keep the tax exemption certificates up to date.

Exemption Certificate Management in Acumatica ERP

MYOB Acumatica provides built-in support for seamless online integration with Avalara, covering both online sales tax processing services and the exemption certificate management solution.

Once integration with Avalara's ECM service is configured, you can add MYOB Acumatica customers tothe Avalara ECM account. Within MYOB Acumatica, you can request tax exemption certificates from eligible customers, which are then uploaded to the Avalara ECM account. In MYOB Acumatica, you can also retrieve, view, update, and print certificates as needed. With Avalara ECM service configured, tax-exempt transactions are efficiently managed within MYOB Acumatica.

Workflow of Exemption Certificate Management Configuration in Acumatica ERP

1. You enable the Exemption Certificate Management feature on the Enable/Disable Features (CS100000) form.
2. You specify the Avalara ECM provider on the Tax Providers (TX102000) form.
3. You specify the Avalara ECM provider in the ECM Provider box on the Tax Preferences (TX103000) form.
4. You add the MYOB Acumatica tax-exempt customers to the ECM provider account.
5. You request the exemption certificates from the eligible customers.

These tasks are described in details in the following topics of this chapter Exception Certificate Management: Configuration Prerequisites and Exception Certificate Management: Implementation Activity.

Adding Customers to the ECM Provider Account

In MYOB Acumatica, you can add MYOB Acumatica customers to the Avalara ECM provider account. You add customers to this account before requesting exemption certificates from them. You can add either a single customer or multiple customers at once. A customer added to the Avalara ECM account can have any number of company codes assigned to it. Each company code represents a company that has been created in Avalara and linked to one or more MYOB Acumatica branches.

To add a particular customer to the Avalara ECM account, you open the customer in MYOB Acumatica on the Customers (AR303000) form. On the More menu, you click the Create Customer in ECM Provider command. The system opens the Select Company Code dialog box, which shows all company codes available for the customer. You can select any number of company codes for which the customer record must be created in the Avalara ECM provider account. Then you click OK, which closes the dialog box. Note that if only one company code is linked to MYOB Acumatica, the system does not open the dialog box; instead, it adds the corresponding customer record to the Avalara ECM provider account for the only available company code.

To create multiple customers at once in Avalara ECM account, you do the following on the Manage Exempt Customers (TX505000) form:

1. In the Selection area, you specify the following settings:
   • Action: Create Customer in ECM Provider.

     When you select this option, the table shows all the active customers defined in MYOB Acumatica. The customers that you select for processing will be added to the Avalara ECM provider account.

   • Company Code: The company code you want to assign to each customer added to the Avalara ECM provider account.
     Note:

     If only one company code is available, the system inserts it by default, and the box is unavailable for editing.
2. You do one of the following:
   • To add only the selected customer records in the Avalara ECM account, select the unlabeled check box in the rows of the customers that must be added to the Avalara ECM account. Then on the form toolbar, click Process.
   • To add all listed customers to the Avalara ECM account, on the form toolbar, click Process All.

The same customer can be added to the Avalara ECM account for multiple company codes. During each process, however, you can add the processed customers to a single code. If customers have been created for only one of the available company codes, when you select another code in the Company Code box, the whole list of customers will again be displayed when you start to add customers to the Avalara ECM account for another company code.

Once the processing has completed, the processed customers are added to the ECM provider, and the success message is displayed next to each customer on the Processed tab of the Processing dialog box. If any of the customers have already been created in the ECM provider with the company code, the system displays a warning message about this on the Warnings tab of the Processing dialog box. In this case, the system only synchronizes the company code specified for the customer in the ECM account with MYOB Acumatica.

Requesting a Customer's Exemption Certificate

In the Request Certificate dialog box, which opens, you fill in the following boxes:

• Company Code: The company code to which the certificate will be linked. You can select one of the company codes available for this customer. By default, the system inserts the company code that corresponds to the current branch—that is, the branch that is selected in the Company and Branch Selection menu at the top of the MYOB Acumatica screen.
• Email: The email address to be used for sending a request. By default, the customer's default email address is specified.
• Certificate Request Template: The cover letter template that the system will use to send the request. You can use any template that has been created in the Avalara ECM provider.
• Country: The country of the customer. By default, US is inserted.
• State: The state for which the exemption certificate will be issued. The user selects a state from the list of states available for the selected country.
• Reason for Exemption: The reason the customer is exempt from paying taxes. The lookup table contains the list of exemption reasons that have been created in the Avalara ECM provider.

When you click Request in the dialog box, the system sends a request to the provided email address and closes the dialog box. If the request has been sent successfully, a message about its success is displayed in the top-right corner of the Customers form. If the certificate was not successfully requested, then a warning message is shown instead.

Once a customer has received a request, they need to upload an exemption certificate to Avalara by using the link provided in the email. Once the certificate is uploaded, it appears in the ECM account in the customer's list of certificates. After that, the certificate can be retrieved in MYOB Acumatica.

Retrieving, Viewing, and Printing a Customer's Exemption Certificates

Once you click the command, the Exemption Certificates dialog box opens, which shows the list of all of the customer's exemption certificates that are available in the ECM account.

You can check the statuses of the existing certificates (Valid or Invalid) in the Certificate Status column. You can request a new certificate from the customer by selecting a needed row and clicking Request Certificate on the table toolbar.

By clicking the Refresh button, which is also available on the table toolbar, you refresh the list of certificates; the system sends a new API request to Avalara to obtain the latest available certificates.

To open and view a certificate, you click the certificate number (which is displayed as a link) in the Certificate ID column. The system opens the certificate file in a new tab, on which you can save and print the certificate. If a certificate file is not available in the ECM provider, when you click the link in the Exemptions Certificates dialog box, the system displays an error message at the top right corner of the form: The certificate cannot be opened because no certificate file is attached.

Updating Customers in the Avalara ECM Provider Account

Sometimes an update of a customer's information may be required in the Avalara ECM account if any changes have been made to the customer settings in MYOB Acumatica. This may occur, for example, if some changes have been made to the business or the contact's personal details, such as name and address.

Once any changes have been made to a customer in MYOB Acumatica, the Update Customer in ECM Provider menu command becomes available on the More menu of the Customers (AR303000) form (as shown in the following screenshot).

When you click the command, the corresponding customer record is updated in the Avalara ECM provider account, and the following message is shown in the top right corner of the form: The customer has been updated successfully in the Avalara ECM provider. You can check the ECM account to be sure that the customer details have been updated successfully.

To mass-update customers, on the Manage Exempt Customers (TX505000) form, in the Selection area, you select the Update Customer in ECM Provider action (see the following screenshot. Then you update customers in either of the following ways:

• Update only selected customers by selecting the unlabeled check boxes in the table and clicking Process on the form toolbar
• Update all customers by clicking Process All on the form toolbar

When you select the Update Customer in ECM Provider action, the table lists all the active customers whose information has been updated in MYOB Acumatica and that have already been added to the Avalara ECM account for at least one company code.

To update any number of customers in the Avalara ECM provider account, you should do the following on the Manage Exempt Customers form:

1. In the Selection area, you select Update Customer in ECM Provider in the Action box.
2. Then you do one of the following:
   • To update only selected customer accounts: In the table, select the unlabeled check box in each row of the customers that must be updated in the Avalara ECM account. Then on the form toolbar, click Process.
   • To update all listed customers: On the form toolbar, click Process All.

Once the process has been successfully completed, the customer records disappear from the table.