Sage 100

 View Only
  • 1.  Information sent to Avalara

    Posted 09-24-2025 15:02

    HI All

    Client asked these questions.   Personally I would think it would be the date the transaction is done but I don't want to guess.  If it was a date in the past I would think that would require filing an amended return.. 

    1. For credit memos with an apply to invoice, would those feed to avalara with the invoice date or the transaction date..?

    I want to be sure everything is based on transaction date otherwsie it makes the returns misaligned.

     

    1. Also, invoice corrections if we list an older date i would not want the transaction going to avalara with the invoice date. I would want it going with the transaction date


    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------


  • 2.  RE: Information sent to Avalara

    Posted 09-24-2025 22:00

    Am very interested in their response



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: Information sent to Avalara

    Posted 09-25-2025 00:44

    Avalara has no concept of a Transaction Date.  Transactions are recorded by Invoice Date, regardless of type, i.e.  IN, CM, DM, FC, etc.  Avalara has over 1,200 connectors (ERP, shopping carts, marketplaces, etc) and they all are captured in the same database. 

    Invoice Date versus Transaction Date is a routine challenge of reconciling Avalara reports/Returns to Sage.  I use AR Invoice History Inquiry ALE to locate mis-matches which almost always results in solving a reconciliation difference.

    Invoice Dates prior to a previously reported period would still be selected by Avalara Returns if being used because they would be Committed but not Locked.  If only using AvaTax and self-filing, they could be missed when reporting on the current unreported month.  I always recommend against back-dating an Invoice Date for those reasons, although the Transaction Date could be back-dated for book purposes.

     

     

    Bob Pfahnl

    Sr. Business Analyst (GM Silicon Valley) 

    e:

    bobp@dsdinc.com

    p:

    800-627-9032 x 220

    s:

    Sage100Support@dsdinc.com

    Unlocking Sage 100 Connections: Streamline, Simplify, Succeed: On-Demand

     

     






  • 4.  RE: Information sent to Avalara

    Posted 09-25-2025 09:55

    @Bob Pfahnl - Excellent explanation.  Thank you!



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 5.  RE: Information sent to Avalara

    Posted 09-25-2025 10:05
    Hi Bob
       Thanks for the info.   Pretty much what I suspected but really glad you could confirm.  

     
    Bob Osborn
    ,
    MCSE
    Sr. Consultant, Sage 100
    e:
    p:
    w: