Avatax: How can you credit an invoice for tax only to an SST state?

SUGGESTED

I know what you're thinking -- ask Avalara. I have created multiple cases for this question and they just email me a link to a KB article that tells me how SST states work and don't answer the question. Then they close the case. They will not answer the question.

For non-SST states, we follow the Sage procedure. One line taxable, one line non-taxable using TX and NT respectively. For SST states, as soon as you use an NT line, the whole thing goes to $0.00. You are apparently not supposed to use NT lines when you use AvaTax in SST states.

So I've been just overriding the tax amount in both Sage 100 AND then I have to go into Avatax and manually override it there too. But you're not supposed to do that either with SST states. But I don't know what else to do to make it credit sales tax.

Anyone else use Avatax with Sage 100 and have an answer for me?

Parents
  • 0
    SUGGESTED

    It is a little more work.  You have to fully reverse the invoice and reenter it.

    Create a return of the items on the invoice.  You will end up with a credit memo with the tax on it..  This should balance out with the invoice you want to fix, so the customer is now showing 0 due. 

    Then, if you have non taxable items, enter them in AVATAX.  You can upload a spreadsheet or enter them individually.   Avalara has a spreadsheet that you can reference to get the tax code that they will see as non-taxable.  Some codes on that spreadsheet are not usable in SST states.  Those have a note about that. 

    Or, if the customer is exempt, go enter them in certcapture.  For Sage, a key for this operation is despite the documentation telling you to enter the customer number exactly as it is in Sage or it won't work, Avalara considers a Sage customer number to have the Division number in front ot it.  no periods, no dashes, just immediately in front.   We use 7 digit customer numbers.  Our customer numbers in certcapture are all 9 digits.  On the third support call, we found that out from a support rep who happened to have someone sitting next to them that had figured that out the week before and was so proud, had bragged.  Glad she did. It is a total PITA that is undocumented.  

    With the items exempt entered in AVATAX or the customer in CertCapture, when you put through the invoice now, it should go with no tax, and the customer has the correct bill amount.  

    If you have an old invoice to fix, you have to fix it in this month, you don't go back and fix it in the previous month as it will not get reported correctly.  

    Hope that helps.  Avalara is a very frustrating system that has a Sage integration, but NOBODY at Avalara understands Sage.  I had one rep tell me they only concentrated on modern software and did not get into knowing about the esoteric ones like Sage 100.  The documentation is poor at best.  Our go live person did not have time prior to going live, so we were really on our own.  They will assign someone to your account.  They will work with you for two months, then you are not go live anymore, your only help will be the support queue.  The go live person's first appointment available might not be for 3 to 4 weeks, so if you do get assigned someone, get an appointment as soon as possible.  IF you have nothing, then just cancel.  Support takes an hour or two to answer.  We thought our SOP should be to call Avalara first thing, get in hold queue and then start working.  If we had no questions, just hang up.  If you came up to a question, and there were many, it was a long time on hold to get through to anyone.  

    Good luck,

    Chris

  • 0 in reply to Beevet
    SUGGESTED

    We are aware that the customer ID is Division+CustomerID even if you are not using Divisions.

    To credit out the entire invoice and re-bill it is just as much extra work as just crediting the tax manually.

    I will agree with you that Avalara is very frustrating. I feel like now that I have gone through everything, I wish I could to back in time and things would have been much smoother. We started on our own in May and didn't get an implementation person until July and she was not very helpful. We didn't even get on the SST program until November even though we signed our documents back in July.

    However, if anyone else on this forum is planning on implementing Avalara, I feel I could answer many of their questions and/or write a "how to with Sage 100" after all the experiences I've had.

Reply
  • 0 in reply to Beevet
    SUGGESTED

    We are aware that the customer ID is Division+CustomerID even if you are not using Divisions.

    To credit out the entire invoice and re-bill it is just as much extra work as just crediting the tax manually.

    I will agree with you that Avalara is very frustrating. I feel like now that I have gone through everything, I wish I could to back in time and things would have been much smoother. We started on our own in May and didn't get an implementation person until July and she was not very helpful. We didn't even get on the SST program until November even though we signed our documents back in July.

    However, if anyone else on this forum is planning on implementing Avalara, I feel I could answer many of their questions and/or write a "how to with Sage 100" after all the experiences I've had.

Children
No Data