Open Forum

Expand all | Collapse all

AR Aging Error

  • 1.  AR Aging Error

    Posted Feb 12, 2020 12:23 PM
      |   view attached
    #GeneralLedger
    Hi - Something in A/R has gone bad.  We had an outstanding invoice in the A/R aging..  We entered a Credit Memo and applied it to the outstanding balance.  Then we re ran the aging and it had the credit showing, even though it had been applied to the invoice.  So the clerk did a debit memo and applied it to the credit memo.  Now the GL does not balance to the A/R aging.  I need to reverse the debit memo to make the client account correct, but that will make the aging wrong.  I ran the reconcile to GL function and received a report that the system let us apply two invoices to one credit memo.  Not sure how this happened and not sure how to fix.​

    ------------------------------
    Jodi Ellington
    CFO
    Athens Insurance Services, Inc.
    Concord CA
    ------------------------------

    Attachment(s)

    pdf
    AR Error report.pdf   470K 1 version
    Academy - Online Interactive Learning from Experts


  • 2.  RE: AR Aging Error

    GPUG ALL STAR
    Posted Feb 13, 2020 08:40 AM
    Hi @Jodi Ellington

    I don't think you've given us enough information here.

    Essentially, I would VOID the Debit Memo and the Credit Memo - just VOID them in the Sales Module and it will make the  reversing entries in the GL.

    Now you should be back to the Unpaid Invoice.

    Make sure that it is, indeed, unpaid because if you had used the Credit Memo to apply to the invoice you would NOT have been able to apply it to the Debit Memo.

    If it shows that the Invoice is unpaid - use inquiry and drill in to the blue "Amount Remaining" link to see if it actually was applied to something.

    If it WAS Applied, you likely need to just run Reconcile in Utilities to get the summary tables back in sync to report correctly on the reports (such as the trial balance).

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

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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: AR Aging Error

    Posted Feb 18, 2020 04:32 PM
    Hi Jo

    I was able to un-apply the documents and void the debit memo, but It will not let my void the credit memo.  Some how the amount is doubling.

    The original amount is correct, but the current amount is double.  I am not sure how to fix this.  Also, it will not let me void the credit memo.

    Thank you so much for all your help!
    Jodi

    ------------------------------
    Jodi Ellington
    CFO
    Athens Insurance Services, Inc.
    Concord CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: AR Aging Error

    TOP CONTRIBUTOR
    Posted Feb 18, 2020 07:06 PM
    Hi Jodi,

    Try running a Receivables Reconcile* (Outstanding Document Amount) and see if it recalculates the Amount Remaining / Current Transaction Amount.
    * You may opt to run the report only (leaving the Reconcile checkbox unmarked) to preview the results.

    Once the amounts are corrected, you should be able to void the transaction.


    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: AR Aging Error

    Posted Feb 19, 2020 11:45 AM
    Hi Gerald,  Thank you so much!  That worked.  Now another question.  I went in to void the original invoice instead of doing a credit memo (because it bombed out again) and I received this error message.  Do you know what that means?



    ------------------------------
    Jodi Ellington
    CFO
    Athens Insurance Services, Inc.
    Concord CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: AR Aging Error

    Posted Feb 19, 2020 11:54 AM
    Hi all - I figured the above error out and all is well.  Thank you so much to the GPUG community in helping!!!

    ------------------------------
    Jodi Ellington
    CFO
    Athens Insurance Services, Inc.
    Concord CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


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