Sage 100

 View Only

  • 1.  Zombie AR Payments

    Posted 11-09-2023 14:27
      |   view attached

    I know that I have fixed this before, but the solution has fallen out of my brain.  For some reason 4 old payments have reappeared on the Account Receivable Statement for a client.  When I go into the Accounts Receivable Aged Invoice Report they don't show up on that report.  When I inquire on any of the 4 invoices that these payments should apply then choose the "Current" button the "Current A/R Balance Data" dialogue box shows the Invoice Total, the Total Payment/Deposits, and then it also shows an Invoice Balance that is a negative of the invoice amount.  The A/R Invoice History Inquire shows a zero balance.

    Again, these are six year old invoices whose payments have just now "come back to life."

    Any thoughts?



    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------


  • 2.  RE: Zombie AR Payments

    Posted 11-09-2023 14:38

    If AR_OpenInvoice shows a zero balance, you can probably play around with the dates in AR_TransactionPaymentHistory until you silence the false report results.  Weird things can happen when the dates don't make sense (like applying a payment that is dated before the invoice...)... where the "exclude future..." report filters don't know how to handle the weirdness.



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



  • 3.  RE: Zombie AR Payments

    Posted 11-09-2023 14:55

    Thanks, Kevin.  I looked at that file and the "Invoice" half of those payments had vanished for some reason.  I was able to get things fixed.



    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------

    Original Message


  • 4.  RE: Zombie AR Payments

    Posted 11-09-2023 14:55

    I had something similar a couple of weeks ago.  The AP aging had 5 invoices that didn't appear on the AP trial balance.  the issue was some strange control characters in the invoice number in the immediately preceding records to those missing in AR_TransactionPaymentHistory.



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



Related Content