Have a customer who spent 6-8 months agonizing about how to automate their sales tax. Without my involvement ( other than filling out order paperwork ) they bought Avalara.
Apparently they somehow chose the “we will implement ourself” option to which Avalara basically replied “good luck” and here’s a list of the prices for what they term their implementation services but appear to be a variety of support plans.
Avalara assigns an implementation guide - though from appearances if the customer didn’t buy a higher level of support that persons role is basically to guide them to but support.
This company sells rare books through a variety of means - catalog, in person shows and marketplaces.
Most of the configuration appears pretty straightforward except I’m not sure how they setup the marketplaces since almost all the ones they sell through collect and remit the sales tax for them. The “trick” is that they still ship that book out from their main office but just don’t collect sales tax.
Has anyone set this up with Avalara before? And, if so, how?
If I never see another Avalara rep again it will be too soon.
UPDATE - 11/3/2021 - HERE'S WHAT I LEARNED ABOUT AVALARA MARKETPLACES AND THE SAGE CONNECTOR
Sample Marketplace
Location Code: MP = marketplace
Use Item MARKET to test trigger of custom rule to try to flag a transaction coming in via the Sage 100 connector as marketplace.
TESTING OF MARKETPLACE
- Avalara seems to pick up the warehouse code from Invoice HEADER as the Location Code
- Location Code ( In Avalara ) is also used at the Marketplace Location
- Make your Sage 100 warehouse code on the HEADER of your invoice match your marketplace code in Avalara
- You can change the warehouse codes on the lines tab to match your actual warehouse - this won't impact your Avalara transaction ( which only uses the header warehouse code )
I am not able to test that this works and carries to returns that are filed by Avalara.
However, using the above method the amounts do appear on the Sales Tax Summary By Marketplace Location report within Avalara.
I was unable to get the Avalara Connector to work in conjunction with any Avalara Advanced Rules.
Avalara help indicates you use Advanced Rules to automatically flag a marketplace transaction. This may be an inherent issue with the Sage 100 connector and integration to Avalara.
I WAS able to get the Advanced Rules to work if I manually entered a transaction into the Avalara dashboard and told the rule to look for an item code "MARKET" on the lines and when found to flag the location as MP..
It's possible there is some issue with the Custom Rules in Avalara as I can see a column labeled "Execution" and below it for the marketplace rule it says "Before".
For a manual transaction keyed into Avalara there is no warehouse code so therefore it's possible somehow Avalara writes that warehouse/header info after it does the advanced rule and may the warehouse overwrites the advanced rule?
---------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
---------------------------------