Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Slow Paperless Office / Emailing Invoices

  • 1.  Slow Paperless Office / Emailing Invoices

    Posted 04-12-2022 17:25
    Sage 100 version 2019 Standard.  This customer emails between 100 and 150 invoices at the end of each day.  It takes between one sixty and ninety minutes every afternoon to email invoices using paperless office.  management is asking for ideas to speed up the emailing process.  I know printing from crystal reports is rendered at the workstation so I am wondering if that is causing the issue: data transmission to the workstation, creating each PDF at the workstation, then writing the PDF back to the server. Repeat 150 times.  It still seems like it takes longer than it should.  Any suggestions will be greatly appreciated.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-12-2022 18:52
    Have they tried from the server?

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



  • 3.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-12-2022 19:23
    Not yet but something I would like to try.  Not sure if that's a permanent solution but it would help determine if the slowness is a network issue.




    Original Message


  • 4.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-12-2022 23:05
    A few years back, we encountered this exact situation.  Nothing we did sped things up.  Since end user already had KnowledgeSync, we wrote an alert to do the heavy lifting in the off hours pulling the invoice data from the AR invoice History and using the set up in the AR_CustomerDocuments and AR_CustomerDocumentContacts tables.  Worked well.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------

    Original Message


  • 5.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 08:34
    Thank you @Jeff Schwenk  Your Knowledgesync solution is a good option.
    ​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 6.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 09:48
    We've used Visual Cut for the exact same issue.  The time consuming part is reproducing the form as a custom report.  Filter is DateUpdated, so be wary if the client uses VI to update invoice data after posting.

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

    Original Message


  • 7.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 10:10
    @Kevin Moyes  This company has VC and uses it to automate emailing some custom Crystal reports.  Can you share how you used VC to link the customer email address with the correct invoice?​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 8.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 10:22
    With Premium / SQL, I wrote a View to reformat Paperless settings. 
    Without SQL, we either use the main customer email address, or a UDF (not the Paperless settings).

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

    Original Message


  • 9.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 10:13
    I've run into this multiple times.
    It's a great way to plant the seed of "maybe we need a new accounting system" into the brain of the CFO

    While workarounds are great - just remember that unless you're working for free there's going to be an initial cost as well as recurring support and maintenance.

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



  • 10.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 10:45
    @Wayne Schulz  Thanks for your feedback.  This company has a history of Sage 100 running slow at the workstations.  I had the IT company run a cat 6 cable from the switch in the server room to one of the slow running computers in the office​.  The new cable improved the speed significantly.  So, they looked at the cabling in the walls and discovered it was cat 5 (not cat 5e) .  Cat 5 is rated at a maximum speed of 100Mbs so it doesn't take advantage of Gigabit network cards, switches etc.

    I had them run the invoice printing / emailing this morning directly on the server.  It took 6 minutes to run and it normally takes an hour to run from a workstation.  I'm contacting their IT company today to get them a quote for new cabling.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 11.  RE: Slow Paperless Office / Emailing Invoices

    Posted 04-13-2022 10:49
    @Kevin Moyes we actually ran into issue resending issue after changing a UDF value in the SO History Header table.  Since we use Access in sending alerts, we created a select query to reassemble the various datasets and used the existing Crystal template by changing the ODBC) .  And we used the paperless tables as the invoices were frequently sent to multiple addresses.  And yes, you run the risk that the CFO has a brain spasm, you accelerate the risk by not having a solution.  Remember that CFO's are not fans of SUBSTANTIAL change (dare I say Sage is quite aware of this).  You run into a greater risk when the NEW CFO takes over and starts asking the WTF questions.
    ​

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------

    Original Message


Related Content