MAS90 4.4 Sales Tax recalculated between order and invoice

We sell nationally via Amazon Marketplace, and because our parent company has locations in all 50 states, we are required to collect taxes on all 50 states. 

When we get an order from Amazon, it already has the correct sales tax for State, County, City, and Special Districts included as one amount. 

We do not have these set up as tax schemes, we only have the state levels. So when the order arrives, at SO/Sales Order Entry the tax schedule is loaded for the state, and the calculated amount is overridden and replaced with the correct amount from the invoice. However, when we go to invoice, the amount that was entered is deleted, and a new, incorrect amount is calculated based on the tax schedule the customer is set up for. 

My questions are as follows:

1) For those of you who sell nationally, how do you handle taxes for all locations?

2) Why is the sales tax amount entered originally in the order not being followed to the invoice, but instead recalculated at the time of invoice? Is there any way to fix this?

Thank you in advance. 

  • 0
    Part of your issue is that when you fill out your sales tax reports for the various states you do have to break it down by jurisdictions (state, city, county, etc.). Or is Amazon taking care of that for you?

    Avalara Avatax can do this as well for all of the states, but if Amazon is already getting you that info I don't think you would want to pay for that.

    If my assumptions are correct then the issue is how keep it from trying to recalc the tax. My best thought at this point would be to enter the sales tax as a line item instead of using the sales tax calculations. (Once again this assumes that Amazon is providing you with the jurisdictional break downs).
  • 0 in reply to TomTarget
    Tom,
    Amazon provides us the total amount of the tax in the invoice, but it's not broken down.
    And I cannot imagine manually maintaining every jurisdiction in the U.S. into the tax tables.

    Thank you for your answer.
  • 0
    Your solution is to setup the States as one combined rate so that it matches what Amazon gives you. Your issue of course will be states where cities and counties do not have the same rate. Your only best solution is to setup all taxing jurisdictions or go with something like Avalara.