Sage 100

 View Only
Expand all | Collapse all

Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

  • 1.  Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-01-2024 10:21

    Has anyone seen this error?  Getting it from a BOI app entering Sales Orders into Sage 100.  It worked fine in the test company but started getting this when we switched to the live company where Avalara is active.  Set up a sandbox and activated Avalara in the test company and now getting this error there.  Happens whether we send AVALARA as the tax schedule or leave it off.  

    Phil



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-01-2024 10:53

    The "234" means it is a DSD program.  Error 88 is Invalid/Unknown property name. 

    Sage does not have a SALESTAXCALCULATION named program that Avalara modified.

    Check with DSD.



    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 3.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-01-2024 11:10

    I have notes that I ran into an error with this program and error number though not the line number. When I ran across this I though it was related to Avalara being down but that's not likely the case here.

    And, as I'm sure you know, you likely can't call DSD directly. First you have to log a case with Avalara and wait for them to reply. Then when you explain to the support tech what Sage 100 is they'll probably advise for you to download and install the latest integration. 

    Only after you re-open that support case will Avalara give the go ahead to get DSD involved.

    At least this was my experience with many/most of my Avalara support inquiries.

    1. Is it working when you hand key a sales order 
    2. External data access enabled? 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 4.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-01-2024 12:22

    @Wayne Schulz  Yes to 1 & 2



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------



  • 5.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 09:02
    Edited by David Speck II 05-02-2024 09:03

    Have you narrowed down which line in your BOI code triggers the error?

    Error #88 can happen when you attempt to call a method or access a property that does not exist for the object your reference, however, it can also happen if you don't pass the correct data type and/or number of arguments to a method.



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 6.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 09:38

    @David Speck II - the code works fine until Avalara is enabled.  The same code works at several other Sage 100 installations.  What does Avalara need that stock Sage 100 doesn't?



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------



  • 7.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 10:04

    Understood, does it throw the error on the during the Write method?  I vaguely recall something similar years ago where either the customer or the order was missing something in a field that Avalara expects a value in, I think it was one of the ship to fields.  See if you can duplicate the error during Sales Order Entry by leaving some fields blank.

    Also, does the error occur via BOI if you use the NONTAX tax schedule or only when using the AVATAX tax schedule?



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 8.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 15:36

    It does work with NONTAX



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------



  • 9.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 15:44
      |   view attached

    Not sure if this is relevant however screen shot of fields added to SO detail below and attached.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 10.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 15:34

    Wasn't there a programming issue because Avalara adds ship-to address lines in the Sales Order detail?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 11.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 16:14

    Phil, try comparing what fields your BOI code is setting compared to what fields are set via Sales Order Entry's UI in the Avalara enabled company.  Since it works when using NONTAX, I bet it is expecting a value in a field and it being blank when passed to one of its methods is what is causing the error.  



    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 12.  RE: Error Code: 88 Line: 00312 Program: SY234_AVA_SALESTAXCALCULATION_BU

    Posted 05-02-2024 22:40

    I had previously dealt with that issue of address fields in the detail line, although they do not appear to actually be used.



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------