Sage 100

 View Only
Expand all | Collapse all

AVALARA not totaling

  • 1.  AVALARA not totaling

    Posted 06-30-2020 11:58
    Anyone having intermittent issues with Avalara?  Did a Sage v2020 and a Sage 2019.3 update this week. Both are having issues where we have to recacl 'sometime's to get the totals to update.  Otherwise, $0.00 Sales Order and prints out of Balance.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------


  • 2.  RE: AVALARA not totaling

    Posted 06-30-2020 12:09

    Is this in Sales Order? I had a customer where we had an issue where the Sales Order History totals were not updated properly.

    I believe @Brett Zimmerman reported something similar to: 

    Basically, if the ship-to address on the sales order is invalid, it does not properly write to the S/O History file (e.g. nontaxable and taxable are $0, although freight for example does show) – and the S/O Entry file is fine.

    My customer did not have that exact issue. Similar but we could not trace it to an invalid ship-to:

    We had a couple of issues: 

    1. If we did not go to the TOTALS tab during SO Entry then Avalara ( when using AVATAX sales tax code ) was not computing totals
    2. We received an error message during VI jobs when Avalara was enabled


    I would not bother to call Avalara until you've downloaded the latest connector from DSD. In each interaction we had with Avalara updating the connector was always the first 10 things suggested.....

    And the connector seems to be updated frequently so even if you installed an update yesterday you'll be installing another today during your support call.

    All support first goes through Avalara. I did not have especially good luck working with them.




    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: AVALARA not totaling

    Posted 06-30-2020 12:13
    Thanks Wayne, it is the latest rev...  I have a case with Avalara.  Like you, agree..  it's likely the beginning of a chase.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 4.  RE: AVALARA not totaling

    Posted 06-30-2020 15:53
    Edited by Thomas Rogers 06-30-2020 16:08
    I've got a similar problem going on with a client.   Went to download the latest version of the 6.10 (2019) connector and my anti-virus is claiming it is virused?  Anyone else seeing that?

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------



  • 5.  RE: AVALARA not totaling

    Posted 06-30-2020 16:25
    Similar situation last week.  Client downloaded the Aatrix quarterly forms.  Installed on her workstation and the network AV kicked her off the network.  IT said a virus signature presented itself. Sounds like the heuristic aspect of the AV is running overtime.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 6.  RE: AVALARA not totaling

    Posted 07-08-2020 20:33
    Has this issue been resolved @John Wilder?​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 7.  RE: AVALARA not totaling

    Posted 07-08-2020 20:49
    Hey there, not yet... I have at least two Sage 2019.3 w Avalara still having issues. I do have a case with Tier 3 at Avalara plus a case logged with Sage.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 8.  RE: AVALARA not totaling

    Posted 07-09-2020 15:10
    Please post any status updates or fixes you receive form Avalara or Sage.  Thank you.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 9.  RE: AVALARA not totaling

    Posted 07-13-2020 14:40
    @John Wilder any updates from Sage?  One of my colleagues is experiencing this issue with a client with 2019.3​.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 10.  RE: AVALARA not totaling

    Posted 07-13-2020 14:58
    No update... waiting on Tier 3 Avalara support to get back to me.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 11.  RE: AVALARA not totaling

    Posted 07-13-2020 15:54
    Can you share the case #, so we can reference it when we open our case with Sage?​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 12.  RE: AVALARA not totaling

    Posted 07-13-2020 17:13

    Sage Case#8008269285

    Avalara Case# 19822350 



    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 13.  RE: AVALARA not totaling

    Posted 07-13-2020 17:21
    Thanks John!

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 14.  RE: AVALARA not totaling

    Posted 08-07-2020 11:43
    Update from my end.   Once I got the latest Avatax installer successfully download and installed.  Problem went away.

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------



  • 15.  RE: AVALARA not totaling

    Posted 08-07-2020 11:53
    What release date did you find this fixed in?

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 16.  RE: AVALARA not totaling

    Posted 08-09-2020 20:36
    @John Wilder - What exactly do you see on tab four?  Had a client call last week (v2019 PU3)​​ 0 for both the taxable and nontaxable values on tab four.  Pressing recalc did not work but deleting one line and readding it did get Avalara to calculate a sales tax amount.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 17.  RE: AVALARA not totaling

    Posted 08-09-2020 21:01
    That's exactly the issue.  2019.3 and one on 2020 (to be fair I have another on 2020 w no issues). It's intermittent, yes, if you delete a line or what I do is change the qty on the SO lines and then it'll recalc. Be sure you have the latest revision from DSD 8/5 I think.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 18.  RE: AVALARA not totaling

    Posted 08-09-2020 21:21
    Just downloaded the 8/5 EXE.  Windows Defender kept deleting it from the laptop.  Had to download it using Chrome to my server as workaround.  Installed at client.  Fingers crossed.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 19.  RE: AVALARA not totaling

    Posted 08-09-2020 23:46
    This is not a fix but rather than deleting lines and re-adding them you can change the Tax Schedule on the Header to anything and then change it back again. This will force a recalc.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------



  • 20.  RE: AVALARA not totaling

    Posted 08-10-2020 12:41
    Not positive about the release date.  I believe it was about two weeks ago.

    And I had the issue with the virus scanners not liking it as well.  Eventually it downloaded successfully.

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------



  • 21.  RE: AVALARA not totaling

    Posted 08-10-2020 15:03
    Most recent download for v2019



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 22.  RE: AVALARA not totaling

    Posted 08-18-2020 10:52
    Message moved to Sage 100 community.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 23.  RE: AVALARA not totaling

    Posted 09-04-2020 11:51
    Anyone still having issues on the Avalara and SO not totaling? I have two customers, still a lingering issue.   reopening a case with avalara in progress.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 24.  RE: AVALARA not totaling

    Posted 09-04-2020 18:02
    Edited by Bob Pfahnl 09-04-2020 18:16
      |   view attached
    Yes.  2020 Premium.  Only happens from a workstation and/or Sage User, not the Server. 
    User changes the Discount Amount but Totals don't recalculate. Workaround is changing the Discount Amount to force the correct total but this only works from the server.
    Prior version was 2016 Standard. 
    2 users reported the problem.  For one user, removed the local Avatax folder and unregistered the Avatax DLL. (this was a longshot)
    Created 2 new Users and assigned Role with "everything" permissions.
    Still happens intermittently for the User where I removed Avatax on the local.  The other User seems to be working.
    Script and screen customization on the Totals tab.  Something looks funky with the screen refresh.  Exploring that now.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 25.  RE: AVALARA not totaling

    Posted 09-04-2020 18:41
      |   view attached
    HL - thanks for not letting me remove my video.
    Here's a better one.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 26.  RE: AVALARA not totaling

    Posted 10-06-2020 04:36
    Bob, any luck on this one?  Still having issues, little (if any real) response from Avalara so far. Tell me I'm the only one 'experiencing this issue'.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 27.  RE: AVALARA not totaling

    Posted 10-06-2020 10:42
    New build for Avalara just released and installed this past weekend. Still waiting to see if it’s resolved. Download from DSD. Issue addressed was memory handling.

    ---------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ---------------------------------





  • 28.  RE: AVALARA not totaling

    Posted 10-06-2020 11:26
    Good news. I'll get this on my two troubled customers too.   Hope its' the answer.  Curious, how'd you learn what the underlying issue is\was?

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 29.  RE: AVALARA not totaling

    Posted 10-06-2020 11:54
    We logged an Avalara Case which enabled us to work directly with Joe DeMaria of DSD.  He observed the issue and updated LMAV.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 30.  RE: AVALARA not totaling

    Posted 10-06-2020 17:28
    Wow, three months of dealing with Avalara tech support and then a quick connection with Joe D and he sees the issue, understands the issue and fixes the issue???  Wow, just simply wow!!!   Why even bother with Avalara when you can go right to the developer and get things fixed.  Go figure!!!

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 31.  RE: AVALARA not totaling

    Posted 10-06-2020 17:47
    You MUST open a case with Avalara first because it is their product.  Then Joe can work on it.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 32.  RE: AVALARA not totaling

    Posted 10-06-2020 20:41
    So are you saying @Bob Pfahnl that once you open a case with Avalara, you can skip Avalara tech support and go directly to Joe D?  Or do you have to suffer for three months first?   ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 33.  RE: AVALARA not totaling

    Posted 10-06-2020 20:44
    In this case, Joe just needed the Avalara Case#.  He then jumped on it.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 34.  RE: AVALARA not totaling

    Posted 10-06-2020 22:08
    It appears there is still a problem.  They Accept the Order, exit SOE, re-open the Order, then change something on the order (in this case they are entering something in the Discount Amount field to trigger the sales tax calculation, then it totals.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 35.  RE: AVALARA not totaling

    Posted 10-07-2020 17:26
    I have a similar issue going on right now.  AVATAX schedule yielding incorrect taxable and non-taxable totals.  NONTAX or other old state tax schedule is correct.  What is even weirder is it seems to be tied to use of specific "/" item codes.

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 36.  RE: AVALARA not totaling

    Posted 01-12-2021 11:23
    Issue is happening with our customer on Premium 2019 SP4. Customer has opened ticket with Avalara support and the recommendation to the customer was to upgrade to Premium 2020. My customer does not have that as an option at this time. Does anyone know if this issue has been fixed in 2019?

    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ------------------------------



  • 37.  RE: AVALARA not totaling

    Posted 01-12-2021 15:57
    We ended up working with both Avalara and DSD on this.  The issue was resolved with a patch.  The client is still using 2015 Advanced (don't ask :) ).

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 38.  RE: AVALARA not totaling

    Posted 01-13-2021 09:09
    Edited by John Wilder 01-13-2021 09:10
    We are still having issues. Most recently with some 2019.4 (1099 update). According to Sage as of this week, still no resolution.  Hoping for more engagement, but as of now still open, no real resolution.

    some other info:  SO totals incorrect (v2020.0)
    Sagecity remove preview
    SO totals incorrect (v2020.0)
    We have two different customers who've recently upgraded to v2020, and they are having the same issue: new Sales Orders are being created with bad totals (often zero). The Lines tab "Total Amount" is shown correctly, but the Totals tab's non-taxable amount and order totals are zero.
    View this on Sagecity >
     

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 39.  RE: AVALARA not totaling

    Posted 02-02-2021 08:54
    Sage has released two hot fixes.  2019.2-2019.4 * 2020.0-2020.1
    Sage version 2019.2-2019.4 -Sage KB 109078
    Sage version 2020.0-2020.1 - Sage KB 97707

    I have one installed as of last night on a 2020.1 - others to follow as we see details over the next few days.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 40.  RE: AVALARA not totaling

    Posted 02-02-2021 09:24
    The fix is unrelated to AVATAX.

    ------------------------------
    Bob Pfahnl
    General Manager - Silicon Valley Office
    DSD Business Systems
    CA
    408-641-0922
    ------------------------------



  • 41.  RE: AVALARA not totaling

    Posted 02-02-2021 09:30
    Edited by John Wilder 02-02-2021 20:47
    Correct, from my interactions with both Sage and DSD it was not exclusive to Avalara.  The customer i installed on is in fact an Avatax Customer.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 42.  RE: AVALARA not totaling

    Posted 02-03-2021 10:37
    Does Avalara have to be reinstalled after applying the hot fix SO-6005T?

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 43.  RE: AVALARA not totaling

    Posted 02-03-2021 11:11
    According to DSD - NO.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 44.  RE: AVALARA not totaling

    Posted 02-03-2021 11:49

    Perfect – thanks.

     

    Alan

     

    Alan Niergarth
    Principal Consultant
    O: 513-334-0736