Sage 100

 View Only
  • 1.  The Technology of Avalara

    Posted 06-25-2019 15:46
    A customer's in-house programmer / IT person wants to know what technology Avalara uses to integrate with Sage 100.  Is there any published technical information, or do any 90 Minders know how the integration works?  My best guess is there is the Avalara program that gets installed on the Sage 100 server that calls the Avalara API.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: The Technology of Avalara

    Posted 06-25-2019 16:03
    Check with @Nicole Ronchetti - I think DSD wrote the Avatax connection



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



  • 3.  RE: The Technology of Avalara

    Posted 06-25-2019 16:54
    Thanks @Wayne Schulz


    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 4.  RE: The Technology of Avalara

    Posted 06-25-2019 18:11
    Edited by Alnoor Cassim 06-25-2019 18:12

    Probably all / any whitepapers would come directly from Avalara since official communication stems from them. But for the in-house programmer / IT person, something like this may work:
    ____________________________________________

    Using Sage 100 as an example (but not limited to that at all as Avalara has integration with many ERPs), the AvaTax DLL / API is physically installed and registered on the Sage server in \mas90\AvaTax folder. When you select S/O Entry in Sage and the business object for it gets instantiated, so does the AvaTax DLL / API. While in S/O Entry, when you hit a spot that would run an AvaTax function such as Sales Tax calculation when clicking the Totals tab, a secure https based web services call / request is made to their RESTful web service (located somewhere in North America) . At that point it creates a "request file" for sending, the contents of which includes data like Ship To info for the customer, exemption info, etc. The payload (contents of the file) is formatted as either XML or JSON. Avalara's web service receives the request, processes the Calc Sales Tax function, then sends back a response file of data formatted the same way (XML or JSON). When response is received, the integration programming parses that payload and sets the data (taxable amt, nontaxable amt, sales tax amt, etc) into the correct places. The actual payload size of the request and response files are extremely small and the connection is secure. There is usually a minimum of 2 requests / responses per sales order.

    ____________________________________________
    Hope that helps.



    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 5.  RE: The Technology of Avalara

    Posted 06-25-2019 19:12
    Thanks @Alnoor Cassim.  You provided a nice explanation of how the API works.   ​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 6.  RE: The Technology of Avalara

    Posted 06-26-2019 10:44
    When a customer buys AvaTax for Sage 100, apparently they also get the rights to use the Avalara API. The customer should be able to learn more about this through their Avalara account manager.

    If I were you, I'd push to understand what problem they're trying to solve (meaning talking 1 or 2 levels above the programmer) and propose a small project to address that. We all know that it is unlikely that the programmer is looking at the underlying business need. 


    ------------------------------
    Jerry Norman
    Smartbridge Partners
    Austin TX
    512.419.1444 x112
    ------------------------------



  • 7.  RE: The Technology of Avalara

    Posted 06-26-2019 11:16
    That's a great point @Jerry Norman  I have a meeting on site tomorrow with the owner and I will bring up the business need topic before I get into specifics with the programmer. ​​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------