After requesting or entering an exemption certificate for a customer in NetSuite, you need to confirm that AvaTax is applying the exemption correctly. This article explains how to test exemption certificates in the Avalara for NetSuite connector, whether the certificate is stored in Exemption Certificate Management (ECM) or entered directly as an exemption number on the customer record.
Quick answer
- Create a sales order or invoice for the customer with the exemption certificate, and verify that the tax amount is zero or reduced.
- Check the transaction detail in AvaTax to confirm which exemption certificate or number was applied.
- If AvaTax applies the wrong certificate or still calculates tax, verify your exemption settings under AvaTax > Settings > Advanced Settings > Exemption Handling.
- AvaTax prioritizes the Exemption Certificate No. field in NetSuite over certificates stored in ECM, so ensure the field is blank if you want to use ECM certificates.
Before you test
Confirm that the exemption certificate is in place. If you are using ECM, verify that the certificate status is valid by going to Lists > Relationships > Customers, selecting Edit next to the customer, opening the Address tab, and selecting Retrieve Certificates Status. If you are using an exemption number instead, confirm that the Exemption Certificate No. field on the AvaTax tab of the customer record contains the correct number.
Ensure that your AvaTax connector settings allow the type of exemption you are testing. Go to AvaTax > Settings > All Settings > Advanced Settings, and check the Exemption Handling section. If the setting is configured to accept only Invoice Level Exemptions, AvaTax will ignore certificates stored in ECM. To use ECM certificates, change the setting to accept both Invoice Level Exemptions and Certificate Level Exemptions, and enable the Use Certificates on File option.
Create a test transaction for the exempt customer
- In NetSuite, go to Transactions > Sales > Enter Sales Orders or Create Invoices.
- Select the customer with the exemption certificate.
- Add one or more taxable items to the transaction. Use items that would normally be subject to sales tax in the customer's ship-to state.
- Select the Address tab and confirm that the ship-to address is in a state where you have nexus and where the item is taxable.
- Save the transaction without posting it yet.
Verify the tax calculation
After saving the transaction, check the Tax field on the transaction. If the exemption is working correctly, the tax amount should be zero. If AvaTax calculated tax, the exemption is not being applied.
If tax was calculated, go to the AvaTax tab on the transaction and review the Tax Calculation Summary or AvaTax Messages section for errors or warnings. Common messages include "No valid exemption certificate found" or "Exemption certificate expired."
Check which exemption AvaTax applied
To confirm which exemption certificate or number AvaTax used, review the transaction detail in the AvaTax web application.
- Log in to the AvaTax web application.
- Go to Transactions > Transactions.
- Search for the transaction by customer name, document code, or date.
- Select the transaction to open the detail view.
- In the Exemptions section, verify that the correct exemption certificate ID or number is listed.
If the Exemptions section shows a certificate number that does not match the certificate stored in ECM, AvaTax is using the Exemption Certificate No. field from NetSuite instead of the ECM certificate. This happens when that field contains a value, because AvaTax prioritizes it over certificates on file in ECM.
ECM certificate versus exemption number
AvaTax can apply exemptions in two ways: by retrieving a certificate stored in ECM based on the customer code, or by using an exemption number entered in the Exemption Certificate No. field on the customer record in NetSuite.
| Method | Where the exemption is stored | What AvaTax uses | What to check |
|---|---|---|---|
| ECM certificate | Avalara Exemption Certificate Management | Customer code and ship-to address | Leave the Exemption Certificate No. field blank on the AvaTax tab. AvaTax retrieves the certificate automatically. |
| Exemption number | NetSuite customer record | The number entered in the Exemption Certificate No. field | Enter the exemption reason or certificate number on the AvaTax tab. AvaTax applies the exemption based on that field. |
If you want to test an ECM certificate, confirm that the Exemption Certificate No. field on the AvaTax tab of the customer record is blank. If the field contains a value, AvaTax will use that value instead of retrieving the certificate from ECM.
Common issues and fixes
AvaTax calculated tax even though the customer has a valid ECM certificate. The Exemption Certificate No. field on the AvaTax tab may contain a value. If that field is populated, AvaTax uses it instead of the ECM certificate. Clear the field and test again.
AvaTax applied an exemption, but it is the wrong certificate. Check the Exemptions section in the AvaTax transaction detail. If the exemption certificate ID does not match the ECM certificate, AvaTax is using the Exemption Certificate No. field from NetSuite. Verify that the field is blank if you want to use the ECM certificate, or update the field to the correct certificate ID if you are using the exemption number method.
The exemption certificate status in ECM shows as expired or invalid. Go to Lists > Relationships > Customers, select Edit next to the customer, open the Address tab, and select Retrieve Certificates Status. If the certificate is expired, request a new certificate by selecting Add Exemption and choosing a communication mode.
Post the test transaction or void it
Once you have confirmed that the exemption is working correctly, you can either post the test transaction or void it. If you are testing in a production environment, consider voiding the transaction to avoid creating a recordable sale. If you are testing in a sandbox or non-production NetSuite account, you can leave the transaction in place or delete it.
Expert tip: Download test transaction certificates for recordkeeping
After confirming an exemption works correctly, download a copy of the certificate from NetSuite for your records. Go to Lists > Relationships > Customers, select Edit next to the customer, open the Address tab, select Retrieve Certificates, then View Image and Download. This ensures you have documentation if the certificate status changes or expires later.
How Galvix can help with exemption certificate management
Testing exemption certificates in NetSuite requires checking settings across multiple screens, troubleshooting priority conflicts between ECM and manual entries, and creating test transactions for each state and customer scenario. If you manage exemptions for dozens or hundreds of customers, that testing and ongoing maintenance adds up quickly.
Galvix's compliance team handles exemption certificate collection, verification, and renewal tracking as part of its managed service. When a customer qualifies for an exemption, Galvix requests the certificate, verifies it meets state requirements, stores it, and monitors expiration dates so you don't have to track renewals manually or troubleshoot why an exemption didn't apply. Book a demo to know more.
FAQ
Can I test an exemption certificate without creating a full sales order?
Yes. You can use the Tax Calculator feature in the AvaTax web application to test a transaction manually. Enter the customer code, ship-to address, and line items, and AvaTax will return the tax calculation and show which exemption certificate, if any, was applied.
What happens if a customer has both an ECM certificate and an exemption number in NetSuite?
AvaTax prioritizes the Exemption Certificate No. field on the AvaTax tab of the customer record. If that field contains a value, AvaTax uses it and ignores the ECM certificate. To use the ECM certificate, leave the Exemption Certificate No. field blank.
How do I know if my exemption settings are configured to use ECM certificates?
Go to AvaTax > Settings > All Settings > Advanced Settings, and review the Exemption Handling section. If the setting is configured to accept only Invoice Level Exemptions, AvaTax will not retrieve certificates from ECM. Change the setting to accept both exemption types and enable the Use Certificates on File option.
Can I test exemptions for a customer in multiple states?
Yes. Create a test transaction for each ship-to state where the customer has an exemption certificate. AvaTax matches the certificate to the ship-to address, so the exemption must be valid in the destination state.
