Sage 100

 View Only

  • 1.  Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 14:27
    Hi - one of our customers is experiencing a strange result on paperless emailing from Sales Order Invoices.  on one customer (according to them) the customer will get anywhere from 1 to 5, and sometimes up to 20 copies of the same email from Sage, with the same invoice number.  They put an internal email address on the customer as well, and the same thing is happening on the internal email address, so it is nothing to do with the customer's email system.  On some invoices to the customer it works correctly and some it does not, even in the same batch.

    Has anyone seen or heard of anything like this ?

    5.30.5 (2016 SU5) advanced.

    Thanks

    Jeff F

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------


  • 2.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 14:56
    Terminal server connection or a workstation?  Does it happen with all workstations?

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



  • 3.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 15:04
    Did the modify the group 1 field / sort order in the report?

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

    Original Message


  • 4.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 15:38
    I like your direction, but they only made cosmetic changes to the standard form.

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 5.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 16:41
    Check the email addresses for anything odd.  EG. if someone copy / pasted an address from Excel, there could be an extra CRLF, which could throw off the data sent to the email program.

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

    Original Message


  • 6.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 15:16
    Workstation and it happens on multiple workstations.

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 7.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 17:21
    Use DFDM and look at AR_CustomerDocumentContacts  to compare the "bad" customer record to a known good customer record.

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



  • 8.  RE: Multiple Emails being sent (up to 20 !) on invoices - Sage2016 Advanced.

    Posted 03-18-2019 20:25

    This is far-fetched but what if the SO_InvoiceWrk.m4t table in SOxxx folder is bad? As you know this is the base worktable and when the invoice worktable gen occurs it creates and populates SO_InvoiceWrk + SessionID file instead. Maybe duplicate records are getting created b/c the base table is bad. Also along lines of what @Doug Higgs said, in the Invoice printing scenario, email addresses are potentially read from: SO_InvoiceHeader, AR_Customer, and AR_CustomerDocumentContacts. You could compare good to "bad" records.

    ​

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

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

    Original Message


Related Content