Sage 100

 View Only

  • 1.  Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 08-28-2019 13:00
    Customer is on 2018 and using Avalara as well as ScanForce. They import orders using visual integrator. 

    They were having a problem where the AVATAX related imported orders weren't computing the total order
    When I turn ON the computation of tax during VI then this error appears to have come up but only for AVATAX orders imported


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


  • 2.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 08-28-2019 15:53
    I believe you can go into AR Utilities and choose Sales Tax Calculation and just select S/O Invoices to get them calculated correctly. I know importing in with AVATAX as the schedule can be time consuming.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 3.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 08-28-2019 16:08
    Thanks, @Therese Logeais - they have been entering through this and apparently it works, however, they are also using Scanforce and apparently some portion of the ScanForce import either stops or stalls making this more than a minor annoyance.

    We did reach out to ScanForce and they recommended updating the Avalara ( the ERP equivalent of ' take two aspirin and call me in the morning' )

    I'm going to update tonight and see if that fixes the issue.

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



  • 4.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 08-29-2019 09:45
    I updated this customer site to Avalara for Sage 100 2018 dated 8/27 and will see if that fixes the issue. If it does NOT I'll report back.

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

    Original Message


  • 5.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 08-29-2019 09:56
    Update: Error persists 



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



  • 6.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 09-03-2019 14:58
    Turned off the computer Avalara during VI and now we don't get the error but the totals aren't calculated - they stay at zero unless the customer recalcs. This is probably not as bad for a little small shop doing an invoice every two hours .... but when you have batches and a hundred orders it gets really old. For the most part the customer reached out to Avalara who by the looks of the cc: emails I've gotten seems mostly non-responsive.

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

    Original Message


  • 7.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 09-03-2019 21:14
    Error 95 could indicate a bad object handle.
    Is the VI import being ran on a workstation that has Avalara's workstation components installed/registered?

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 8.  RE: Avalara: Error 95 in program SY234_AVA_SALESTAXCALCULATION)_BUS.PVC Line 0219

    Posted 09-04-2019 08:15
    Do you mean the register_for_com.bat file? The user is on premium and the instructions seem to say that Advanced and Premium shouldn't have to run the registration? 

    I think they are all on TS so expect that everyone might have this issue as well and it's only appearing during VI imports.

    https://www.dsdinc.com/instal-configure-sage-100-erp-sales-tax-avalara/

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

    Original Message


Related Content