Sage 100

 View Only
Back to discussions
Expand all | Collapse all

AP check history header doesn't tie to details

  • 1.  AP check history header doesn't tie to details

    Posted 07-27-2020 17:42
    I'm to open a case with Sage tomorrow, but has anyone run into the AP check header (coming from ACH payment) having an incorrect amount that doesn't tie to the lines?  I'm looking at Sage 100 Advanced 2019 and don't see evidence of electronic check numbers being reused.  No enhancements. #sage100​ ​

    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------


  • 2.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 07:28
    I just had a client pay an employee their mileage reimbursement via ACH and the invoice was for 135.13 and the ACH payment was for 270.26.  Looking at the payment record in Sage, it does, indeed, show 270.26 as the Check Amount, with only the 135.13 invoice listed.  Version 2018.4 Premium.

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



  • 3.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 09:55
    Any enhancements?

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

    Original Message


  • 4.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:00
    Edited by Rhonda McNamara 07-29-2020 10:01
    No enhancements.   @Beth Bowers, I saw a KB article on ACH headers being double.  So that's a known problem.  Let me know if you can't find that KB.​​
    Sage recommended re initializing entry files for my situation, which we could not duplicate on demand, but see plenty of evidence of it occurring. I'm waiting for the client to give me the OK.

    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------

    Original Message


  • 5.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:39
    ARGH, what's the KB? I of course can't find it.

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

    Original Message


  • 6.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:45
      |   view attached
    The attached KB isn't exactly the same issue your customer has, but similar.

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

    Attachment(s)

    pdf
    amounts are doubled on PR check forms.pdf   292 KB 1 version
    Original Message


  • 7.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:47
    @Doug Higgs - my client has the issue in AP, not PR...​

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

    Original Message


  • 8.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:50
    Yes I know.  May be a similar solution.  Not the same work files but maybe reinitialize AP_CheckStubWrk and AP_CheckWrk

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

    Original Message


  • 9.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:34
    Nope.  And I've certainly had this happen to other clients, although usually it's with a check, not an ACH payment.

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

    Original Message


  • 10.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:37
    Maybe try reinitializing the Crystal work file.

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

    Original Message


  • 11.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 10:39
    Look for a blank row (no bank code) in GL_Bank and GL_CheckMICR... such blanks cause some weird things to happen.

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

    Original Message


  • 12.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 13:51
    In my case, history records have the duplicated amount, not just the printed form.
    I do have a blank record in AP_Payment History Work ...
    @Beth Bowers, I searched using all the same criteria and can't find the KB either!  Maybe I saw the payroll one, but I'd be surprised, based on how I search.​

    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------

    Original Message


  • 13.  RE: AP check history header doesn't tie to details

    Posted 07-29-2020 11:38
    Your issue was ACH not AP or PR checks so maybe try to reinitialize AP_ACHFileWrk

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

    Original Message


Related Content