Sage 100

 View Only
Expand all | Collapse all

Remote AP Check Processing

  • 1.  Remote AP Check Processing

    Posted 07-15-2020 08:31
    We have a client working remotely on Sage 100 that wants a better way to print AP checks remotely.  We could add a signature to the Crystal form but that is not secure enough for them.  Anything over $2,500 needs two signatures.  Are there any enhancements, solutions or service providers we should consider to better automate printing AP checks remotely and enhancing the work flow?  Would Beanworks be a solution?

    ------------------------------
    Steve Engmann, MBA, CMA
    Competitive Strategies, Inc.
    Appleton, WI
    920-993-1077
    ------------------------------


  • 2.  RE: Remote AP Check Processing

    Posted 07-15-2020 09:59
    I have a customer that uploads a files to their bank's web portal.  The bank prints and mails checks to the vendors.  You may see if their bank offers this service.

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



  • 3.  RE: Remote AP Check Processing

    Posted 07-15-2020 11:44
    Have you thought about Sage AP Automation - Ray Scarborough - ray.scarborough@beanworks.com

    I have a small(ish) private school that just went with this. Too early to give feedback, I sat in on the demo and it looks really cool. I understand that there used to be issues with PO and invoice matching. Not sure if those are 100% solved. For this customer they only needed GLAPAR so seems like a pretty good fit.

    Free "no salesperson will call" demo - https://www.youtube.com/watch?v=vJDsS8AU63w&feature=youtu.be

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 4.  RE: Remote AP Check Processing

    Posted 07-15-2020 12:10
    Along with implementing electronic signatures into your Sage 100 Check forms, you can include some form of security.  For example, you can have a drop-down list of signatures to choose from, along with password-protection in order for the signatures to actually print. You can also have the option of controlling when one signature prints vs. two, including restrictions related to the check amount.

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



  • 5.  RE: Remote AP Check Processing

    Posted 07-15-2020 12:21
    Yeah we've done some things with custom forms and embedded signatures (filtered by the user printing, or set up to require UDF flags to be enabled, which can only be set by specific approved users running a button script in the data entry screen...).

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



  • 6.  RE: Remote AP Check Processing

    Posted 07-15-2020 20:04
    Don't quite understand how outsourcing AP to Beanworks or uploading information to the bank for check printing mitigates the company's desire for two signatures on the checks.  What is at the heart of this internal control requirement?  I assume it is a small company with limited separation of duties?  I surmise that company is also not interested in going to ACH DD payments then.

    I have used a variant of Kevin's suggestion with PO's prior to printing via a UDF that only a supervisor could access.  If the PO exceeded the set limits and did not have a second approval, the PO would print with "NOT APPROVED" verbiage.  Client used Sage Alerts (or in Kevin's situation - Visual Cut) to send an email to the second "signer" for action.

    Other internal control processes come to mind that might help the owner sleep better at night.  Good luck!

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



  • 7.  RE: Remote AP Check Processing

    Posted 07-16-2020 08:03
    How are you safeguarding access to the Crystal Form itself? Have you been able to successfully set network security limitations to form access which doesn’t result in a Sage error?

    The problem today is most customers ( or their staff ) are savvy enough to Google these types of issues and someone who wanted to circumvent a modified form could probably do so.

    Beanworks will cut and mail the check and enforce security over who can approve. This happens outside Sage.

    That plus positive pay seems like reasonable assurance. If the customer wants a cut and paste sig with some script that’s their call so document it and let them decide.

    The other concern is that all 3rd party ISVs are marketing heavily. This is only going to increase.

    If you don’t at least mention the ISV in the conversation the odds are good someone at the customer finds the solution and investigates on their own.





    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 8.  RE: Remote AP Check Processing

    Posted 07-16-2020 08:12
    @Jeff Schwenk  two signatures aren't necessary if the bank prints and mails the checks.  The bank "signs" the check. ​  There still may be an internal control issue pertaining to invoice approval for payment, which Sage 100 doesn't handle off-the-shelf.

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



  • 9.  RE: Remote AP Check Processing

    Posted 07-16-2020 09:19
    So @Doug Higgs​​​​, what is the real issue with having two signatures?  Or is the reality they don't want to process payments at all and some type of AP outsourcing is the end goal?  This still leaves them with the question of large payments.  Sage can accommodate these issues but it does require some internal process change.

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



  • 10.  RE: Remote AP Check Processing

    Posted 07-16-2020 09:24
    @Jeff Schwenk  My customer(s) don't have an issue with two  ​signatures.  I was commenting on Stave Engmann's post.  Steve's customer is requesting a method to print checks remotely.  I mentioned what one of my customers uploads a file to it's bank portal and the bank handles check printing and mailing.  Just an option, and it may not solve all of the approval process internal control issues.

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



  • 11.  RE: Remote AP Check Processing

    Posted 07-16-2020 09:28
    Realized that after I posted but didn't take the time to edit it.  Sorry.  But it is important to get to the bottom of the needs.  I am sure we have all had clients ask for something and we end up delivering something completely different once we asked the 20 questions.

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



  • 12.  RE: Remote AP Check Processing

    Posted 07-16-2020 13:54
    We have a customer who has two signature requirements and requires things to be very restrictive. For this customer we use to use the Troy enhancements where you have a key to unlock the Printer and it will unlock the signatures and other fonts to print correctly. Otherwise, it shows void and other fonts indicating that the print was not done correctly. This also had a driver on the computer that worked with it so you had to be on the right computer and be the right user and have the right key all for it to work. This was great until the .net change with Crystal and all of it broke. We had to do some workarounds to get it to work similar to how it worked before.

    They still had the printer with the key but it only unlocked it to allow for printing or access to the paper tray. Then we setup a USB stick with the signatures that you must have mapped to a specific drive on the workstation. The path to this is kept in a UDT that is referenced in the Crystal report. If you do not have that image it defaults to a VOID image. We also setup font substitution so that only the machines setup to print will have the correct fonts. Not as good as the Troy when it worked but still gave some great security features. (Not like the bank even cares. I have had banks cash unsigned checks with no issues, I have seen checks cashed that state for amounts over x that there must be two signatures and it only had one.)

    For them, all checks must have two signatures. But if you need it to be one or the other then you could have two USB sticks and require them to both be on the system for it to sign. It will suppress the second if it isn't over a specific amount. This way if you know that all your checks will not require the second signature then just one USB will do it. Otherwise, you have to have the second USB to sign the checks correctly.

    This worked great for that customer and one or two others that liked the idea a well.

    ------------------------------
    Todd Martin - President
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------



  • 13.  RE: Remote AP Check Processing

    Posted 07-16-2020 14:53
    Thanks for all of the feedback.

    ------------------------------
    Steve Engmann, MBA, CMA
    Competitive Strategies, Inc.
    Appleton, WI
    920-993-1077
    ------------------------------