Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Sage sending wrong invoice PDFs to customers

  • 1.  Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 14:26
    Kinda freaking out here because Sage 100 2020.2 Premium has sent some customers invoices for other customers. The PDF will have the correct invoice number in the subject line but when you open the attachment it is a completely different invoice for a different client so now customers are seeing the pricing for other customers and it is a huge and sensitive issue. The only thing I can see is that the two SO invoice batches may have been printed/updated at the same time by two different users. Has anyone else seen something like this? I'm trying to confirm if the PL_AdvancedOptions_ui "use lockfile" checkbox is checked for the users who printed the invoices but I know that field is often unchecked because otherwise they get the Error -30 when trying to PDF. Any help would be appreciated!

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------


  • 2.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 14:30
    If they use a terminal server, it is critical to use the Lockfile setting, otherwise the temp data can get muddled in memory.  We've seen journals and registers with merged data... messy.

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



  • 3.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 14:32
    Thank you @Kevin Moyes - is there another way to get around the error -30/-40 when printing to PDF on the terminal server?
    ​​

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------

    Original Message


  • 4.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 15:14
    Try a local print object (on the TS), not redirected printer.  I believe the -30 is a timeout, and printing without accessing the client's print object / print spooler should be faster.  There are other things to check too... the registry key is so temperamental.

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

    Original Message


  • 5.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 15:17

    I've seen the -30 with terminal servers when you have redirected printers on. One testing step is turn off Redirected printers and see if that makes it stop. Sometimes the load speed is too slow with redirected on and it bombs out. I've run into this personally working from home when my kids are all gaming lol.




    Original Message


  • 6.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-18-2021 14:51

    I've seen this happen on older versions of Sage if you check the box that says print invoices already printed. Note – back in the day, the work around for this was not to check that box.


    We did see this on Sage 2020 Premium (no product update) as well but I believe the check box I mentioned above was actually checked so we modified some of the work flow to get around that issue.




    Original Message


  • 7.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-19-2021 01:10
    Take a look at this article which should have some useful info regarding printing on Terminal Servers:

    https://support.gotomyerp.com/portal/en/kb/articles/addressing-paperless-office-printer-problems

    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 8.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-19-2021 08:06
    Thank you, @George Khairallah!​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------

    Original Message


  • 9.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-24-2021 10:28
    Well done @George Khairallah
    ​

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

    Original Message


  • 10.  RE: Sage sending wrong invoice PDFs to customers

    Posted 06-24-2021 19:09
    Thank you everyone - The client has reported that this issue stopped with the checking of the "use Lockfile" checkbox. This issue can be moved from urgent.

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------

    Original Message


  • 11.  RE: Sage sending wrong invoice PDFs to customers

    Posted 10-27-2021 12:20
    I have a v2017 Adv client who has some Paperless customer invoices going to the wrong customer (no errors though from what I'm told).  However, this is not in a Terminal Server/Citrix environment and there was only a single user performing Paperless e-mailing at the time - although the 'lockfile' setting is currently enabled.  One thing that's really strange is that the customer who received the wrong invoice didn't even have an invoice for them in this batch of Paperless e-mailing.  So where the heck did it get the wrong customer's e-mail address from?  Something else I noticed, the e-mail that was sent shows both the correct and wrong e-mail addresses.  Is that normal/expected when this type of issue occurs?  Also, they send these e-mails via the Paperless Customer Viewer as opposed to S/O Invoice Printing, so I'm not sure if that has any bearing.

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 12.  RE: Sage sending wrong invoice PDFs to customers

    Posted 10-27-2021 13:44
    I know we had a customer who had this happen quite a while ago and the issue was that the end user had the "Keep window open after printing" check box selected. Unselect it and the problem goes away. Just my .02.

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


Related Content