logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
Joe Payne2  
#1 Posted : Wednesday, June 1, 2022 3:41:52 PM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
After having done a full implementation of nationwide sales tax collecting and reporting utilizing Avalara in AC9, there are a number of improvements AC9 needs to make it feasible for a merchant:

Order Recalculation
While it was just recently added that Avalara gets updated when an order is recalculated, the admin should not be required to initiate the recalc in the first place. Order recalc should be automatically done at every touch point where the order can be changed. This includes editing the shipping address, edit/delete line items and adding line items.

Doing this ensures that Avalara transactions are always in sync the AC9 orders. Not doing this leaves the door open for massive user error that costs real cash from the merchant's pocket.

Order Recalc Sequence
Already discussed in forum post but needs mentioning here. Taxes should always be the last thing calculated, because other components of an order (ex shipping) can be considered taxable. You don't want to calculate taxes, then calculate shipping, because a change in the shipping charge could easily result in a different sales tax amount.

Discounts Recalculation
This has never been written and I'm shocked nobody has ever brought it up in 15 years. If the store has a volume discount rule that kicks in at qty 10, editing an existing order item qty 5 to qty 15 will not automatically invoke the quantity discount for the order. Discounts need to be included in order recalculation.

Tax Exemption By Province
A B2B business can easily have a customer that ships to different states. So while the B2B business may be tax exempt in Georgia, they're shipping an order to Florida where they are taxable. A single 'tax exemption type' at the user level no longer works. AC9 needs the ability to specify all the tax exemption attributes by state/province at the user level. In addition, Avalara wants to know tax-exempt start date and tax-exempt expire date for each tax exemption definition. There is no provision for any of this in AC9 today.

Exemptions Import
In the internet sales tax world, there is a collective group of US states that are known as 'SST' states. These states all agree to operate and remit internet sales tax through a common set of onboarding forms and tax remit forms. For orders shipping to these SST states, Avalara will ignore the TaxExemptionType value sent via the API. For the customer to be tax-exempt, that customer must already be set up within Avalara itself as tax-exempt and have a tax exempt certificate on file. There is no API to electronically register these tax-exempt customers in Avalara. But there is an import page. AC9 needs a way to generate an export file (Excel format) that can be imported on a regular basis into Avalara.

Not all US states are a part of the SST program. Avalara does not require this customer setup within Avalara for states that are not a part of SST. For non-SST states the value of TaxExemptionType sent via the API is respected.

Order Exemption Type
There is no mechanism to change the order tax exemption type. This is sorely needed for customers who placed an order as taxable, but submit their tax exemption prior to filling the order. The current Recalculate feature populates the order TaxExemptionType value, not the order user's current TaxExemptionType.

Avalara Transaction ID
The design of storing the Avatax document ID in the sku of the tax line item is terribly flawed. If the tax line item is ever deleted by the admin user, the connection between the AC9 order and the Avatax transaction is permanently broken. Ideally the Delete button should be disabled on the Items tab for items that have the Avatax ID on them.

Onboarding Avalara Transaction Import
It would immensely helpful to provide an export routine that dumps Able order data (by date range) into Avalara's transaction import file format. This allows a merchant to onboard with Avalara, import YTD sales data and then know exactly where they stand with nexus thresholds in every state. Otherwise the merchant will easily draw attention to themselves at the state level and risk a state demand for tax audit. State tax auditors are looking for merchants like that because it's free money for the state. And it's hard cash right out of the merchants pocket if the merchant winds up on their radar.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Katie S  
#2 Posted : Friday, June 3, 2022 1:08:59 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 421

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hi Joe,

Thanks for the detailed feedback. We are already working on upgrading AvaTax to the newer REST API, so this is a good opportunity to make some additional improvements.

We will discuss each of these points and see what we can do in the next release.

Thanks for your support!

Katie
Secure eCommerce Software and Hosting
thanks 1 user thanked Katie S for this useful post.
Joe Payne2 on 6/3/2022(UTC)
judy at Web2Market  
#3 Posted : Monday, June 6, 2022 11:19:18 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 286

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
We did extensive customizations to a Gold R9 site for Avalara and one big one was that the tax had to be calculated on the shipment and not the order because the order could have several shipments. Also, the commit happened when the shipment was shipped, not when the order was placed. Maybe 9.0.6 already has some of this.
shaharyar  
#4 Posted : Monday, June 20, 2022 6:08:06 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 703

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Hi Judy,

Current AC9 Avalara integration is handling the tax calculation based on each shipment address. We send the order item details as an Avalara line item and we append the line ShipFrom address as shipment warehouse and ShipTo address as shipment address.

Once the transaction is being created in Avalara we can see each line item with its own address in the transaction details. Avalara calculates the tax amount based on each line item address value, if not present it will use the default address value.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.