Open Forum

Expand all | Collapse all

Negative ACH

  • 1.  Negative ACH

    Posted Dec 09, 2019 11:49 AM
    Using NAV 2017 - has anyone ever sent a negative ACH by accident.  If so how did it happen and how did you fix it?

    ------------------------------
    Xan
    Katy TX
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Negative ACH

    Posted Dec 10, 2019 11:21 AM
    Yes, this has happened to me before.  The reason it happened is that when I ran the Suggest Vendor Payments report to populate the Payment Journal, each document to be paid was listed out separately - both Invoices and Credit Memos.  When each document is listed on its own line and are paid via ACH, then NAV creates 1 payment for each line of the journal instead of 1 payment for the sum of all lines.  So, when it gets to a Credit Memo line then it sends a transaction code to withdrawal money from the bank account instead of depositing money.  After this happened, we discovered that we needed to run the Suggest Vendor Payments with the Summarize per Vendor option checked.  This will allow NAV to send only 1 payment line, but when the remittance is printed it will show all of the applied documents.



    ------------------------------
    John Hawkins
    Senior Consultant
    Oilfield Software Solutions, LLC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Negative ACH

    Posted Dec 10, 2019 12:09 PM
    Thanks for the reply, John.  I suspected that was what happened, but since I was not there when it did, I cannot say,  At least it has happened to someone else before.  Were you able to fix it and how?

    ------------------------------
    Xan
    Katy TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Negative ACH

    Posted Dec 10, 2019 05:28 PM
    When it happened to me before, the bank processed the invoice lines that were depositing to the other account and only rejected the credit memo lines that tried to withdrawal money.  Since it was only the credit memo lines, we were able to go to the Check Ledger Entries and void & unapply just those entries.  Then we were able to use the credits on the next payment.

    ------------------------------
    John Hawkins
    Senior Consultant
    Oilfield Software Solutions, LLC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Negative ACH

    Posted Dec 12, 2019 05:01 PM
    Thanks so much, John.  So your saying it's User error and not a NAV glitch, right?

    ------------------------------
    Xan
    Katy TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role