Sage 100

 View Only

  • 1.  This document is already committed in the Avatax database

    Posted 03-05-2024 20:00

    Has anyone seen this with Avalara / AVATAX and Sage 100. The customer was doing repetitive invoices int he Accounts Receivable module and gets this error when they go to update.

    I have tried the "Recalc Tax"

    I have tried removing the Sales Tax Schedule "AVATAX", replacing it with "NONTAX", saving the invoice and then opening the invoice and replacing NONTAX with AVATAX.

    I get the same error

    My WAG is that Avalara has some type of invoice already in their main processing and is warning that this one is a duplicate? 

    I have been completely unsuccessful with finding anything in the Sage KB or the Avalara KB.

    Thoughts and suggestions?



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


  • 2.  RE: This document is already committed in the Avatax database

    Posted 03-06-2024 08:54

    My understanding is that "committed" means the invoice is already on a tax return. 
    https://knowledge.avalara.com/bundle/dqa1657870670369_dqa1657870670369/page/Transaction_status_in_AvaTax.html  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 3.  RE: This document is already committed in the Avatax database

    Posted 03-06-2024 09:09

    Thanks, Madeline. The customer emailed that they see this same invoice in their Avalara dashboard as a voided invoice with a past date. 

    I advised that there were probably two ways to correct this

    1. Within Sage, delete the unposted invoice and create a new one with a unique invoice number
    2. Within Avalara, edit the existing voided transaction by appending an "A" to make that invoice unique.

    I'll update here if there is anything else they tell me they had to do to make this work. Thanks!



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

    Original Message


  • 4.  RE: This document is already committed in the Avatax database

    Posted 03-06-2024 09:16

    Yes, invoice # exists in Avalara.



    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------



  • 5.  RE: This document is already committed in the Avatax database

    Posted 03-06-2024 10:20

    I'm sure there is a better solution somewhere, but I had that same issue with repetitive invoices, and ended up deleting the Invoice with the Avatax error, and re-entering it manually.   I'm curious to see if there is a "real" solution out there somewhere though.

     

    Sue Bennett/President

    P. 503.620.3484 / E. sue@benpor.com

     

    Bennett/Porter & Associates, Inc.
    12559 SW 69th Ave / Tigard, OR 97223
    benpor.com / facebook / instagram

     

     

    A black background with a black square Description automatically generated with medium confidence

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     




    Original Message


  • 6.  RE: This document is already committed in the Avatax database

    Posted 03-06-2024 10:26
    Committed means it’s been updated by a sales register. Locked means it’s been reported on a tax return.

    You may also get a “not on file “error message if the invoice is in Avalara that has been removed from AR invoice history.

    ---------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ---------------------------------





Related Content