Sage 100

 View Only

  • 1.  Sales Order Invoices not totaling correctly

    Posted 08-11-2020 16:33
    We have a client using Sage 100 2016 Advanced in a virtual environmentwho has had at least two glitches in Sales Order Invoice in past 3 weeks. On two different occasions different Sales Order Invoices have been entered/edited and one item extends properly in the line item record and is properly accounted for in the tax calculations but does not properly add into the total for the invoice. When the invoice is printed, the lines are correct but the subtotal before taxes and the total after taxes is not correct. I one instance the batch of invoices was updated and was out of balance. The other time the error was caught and the invoice was deleted and re-entered correctly.

    As stated above this is Sage 100 2016 Advanced (5.30.1.0 Build 596) with 32 licensed users. All users log in remotely via Remote Desktop. The server and workstation "boxes" are MS Windows Server 2016 Datacenter on Amazon EC2.

    Does anyone have any idea why this might be happening?

    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------


  • 2.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 16:48
    Enhancements?  Avalara?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 17:03
    No enhancements.  No Avalara.

    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------

    Original Message


  • 4.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 19:07
    Edited by Kevin Moyes 08-11-2020 19:09
    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=86023

    Also see KB 99750 which is a similar issue.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 16:56
      |   view attached
    Look at aggressive antivirus.  Are the Sage recommended exclusions in place?  Also, rebuild the sales order header and detail

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------

    Attachment(s)

    pdf
    How to exclude Sage 100 from antivirus scans.pdf   305 KB 1 version


  • 6.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 17:01
    If Avalara is installed, it could be this issue.  Try installing the latest Avalara release from the DSD website.


    https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=121&MessageKey=48529d62-0a2c-495c-8e32-a9d9af88b8b2&CommunityKey=a46f78b7-9da0-4283-a1b3-1411c4d44ef7&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: Sales Order Invoices not totaling correctly

    Posted 08-11-2020 17:11
    Well install AValara so you can solve the problem................

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 8.  RE: Sales Order Invoices not totaling correctly

    Posted 08-12-2020 10:13
    Any miscellaneous charges that somehow have a Qty = 0?

    Is the total off a line item's worth or a certain percentage?

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 9.  RE: Sales Order Invoices not totaling correctly

    Posted 08-12-2020 16:45
    This is one of those intermittent bugs that I have seen for years.   Avalara's recent issues aside, I see this happen a couple of times a year among all of my clients.  Typically the client doesn't notice it immediately so we typically can't isolate it to any specific cause.  :(

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------

    Original Message


Related Content