Sage 100

 View Only

  • 1.  Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 03-18-2021 12:22
    I have not yet obtained further details from this customer. They are on Sage 100 2019 Premium and sent me a register which seems to show their electronic payment selecting and paying a $5,000 invoice for $10,000 ( which transfers to their bank ).

    This also appears to have created an out of balance for the $5,000

    So far they are denying any issues ( power failure, etc ) and claim this was all entered by hand as opposed to any type of integration.

    I am only aware of BeanWorks which is in use and they claim that BeanWorks doesn't manage the payments,

    At this point - prior to opening a Sage case - I'm wondering if this rings any bells?

    I briefly searched the Sage KB and there didn't appear to be any relevant articles.​​

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


  • 2.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 03-18-2021 12:26
    Update: 

    Invoice being paid was $5,000

    The ACH file correctly generated a $5,000 payment
    The invoice of  $5,000 was correctly paid off

    Sage recorded the cash credit as $10,000 which threw the DTR OOB​

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



  • 3.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 03-18-2021 12:27
    @Wayne Schulz - I've had it happen before MOSTLY on checks, but I have had an ACH also be incorrect.  No idea why or how on any of them.  Seems rarer now than it used to be, but obviously still happens once in a blue moon.​

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



  • 4.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 03-18-2021 12:31
    Any idea how to correct? They think they want to reverse and re-issue but it won't allow it because the invoice was only paid for $5k yet cash disbursed $5k.

    It sounds like a one-side entry which frankly for a larger sized customer with audit requirements is not going to go over well at all.

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

    Original Message


  • 5.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 03-18-2021 13:07
    If it created an out of balance in the first place.... you're going to have to make a one-sided entry anyway.  You could do the reversal but add another line on the reversal that goes straight to AP account - I think that might make you one-sided the other way and take care of the OOB.

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

    Original Message


  • 6.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 05-06-2021 18:24
    Here's the check register they sent me. It appears to show an ACH for $5,000 and also a negative check for $5,000? 
    Not too sure what to make of it
    The customer is pushing for a Sage case # but without the steps to recreate I doubt Sage is going to do much other than shake their head and shrug


    ​

    ------------------------------
    Wayne Schulz - Schulz Consulting -
    ------------------------------



  • 7.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 05-06-2021 18:33
    Dear (customername),
    If you'd like to open a case with Sage, you don't need me to do that for you.  Here is the phone number (###), and when they ask for your account number, that is found by clicking Help - About Sage 100.

    /walk away... don't look back... don't you ever look back...

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

    Original Message


  • 8.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 05-06-2021 19:27
    I had the same thing last week with Sage 100 Std.  I fixed the files and reinitialized the check printing files to make sure they were clean. 

    <mc type="body">

     

    ----------------------------


    The information (including any attachments) contained in this document is confidential and is for the use only of the intended recipient. If you are not the intended recipient, you should delete this message. Any distribution, disclosure, or copying of this message, or the taking of any action based on its contents is strictly prohibited.

    CliftonLarsonAllen LLP

     

    ----------------------------

     

    </mc>



    Original Message


  • 9.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 05-07-2021 09:01
    I have quite a few customers using ACH and this is the first time I've run into this issue. I suspect there is a specific number of steps required to recreate this issue ( ie - it's a bug but not easily reproduced ).

    Unfortunately, the employee who created the issue left the company so there's not an easy way to know what steps led up to this issue.

    The only thing that I can see which looks weird is the -5,000 check and then the register shows no checks printed and one ACH.

    ------------------------------
    Wayne Schulz - Schulz Consulting -
    ------------------------------



  • 10.  RE: Sage 100 Premium v2019 - ACH Posts OOB - Pays vendor 2x amount of invoice

    Posted 05-12-2021 07:47
    I called Sage on this ( at customer insistence ).

    Sage had no words of wisdom.

    One observation is that it looked like the customer initially selected to pay $10k then reduced it to $5k.

    No explanation as to how this resulted in an overpayment and an OOB DTR.



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





Related Content