Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

AR Trial Balance is off

  • 1.  AR Trial Balance is off

    Posted 5 days ago
    We posted a payment to client A in March.  Two months later discovered it should have been posted to  client B.
    The Original payment was voided from client A and a new payment entered for client B- seemed pretty smooth.
    The AR Trial balance is showing an amount due for client A and the total AR Trial Balance does not match the GL by this amount.  the inquiry screen for client A does not show anything balance due.
    I have run Check links with no positive results.
    Any suggestions?

    Connie Miller
    Finance Manager
    Portage MI

  • 2.  RE: AR Trial Balance is off

    Posted 5 days ago
    Have you tried to run the Sales - Utilities - Reconcile on this customer?  There are 5 different types in there but you can restrict it to your Customer A to see if it resets the summary record and the outstanding doc amounts.
    In the Options, you can choose to Print Report without choosing Reconcile just to see the before and after effects you'll find if you DO choose Reconcile.
    In the range, choose your customer A.
    If customer B is also off, you can run for it afterwards.

    Lisa Simpson
    Emergence Corporation
    Hamilton Bermuda

  • 3.  RE: AR Trial Balance is off

    Posted 4 days ago
    I suggest reprinting the void journal and checking the void date and the posting date.  If they are in different periods it can cause an EOM variance.

    Lou Spevack
    Systems Accountant | Dynamics Credentialed Professional
    American Council on Education
    Washington DC