Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AR Trial Balance not t...
Microsoft Dynamics GP (Archived)

AR Trial Balance not the same as GL Trial Balance

(0) ShareShare
ReportReport
Posted on by Rosemary 2

Hi,

An AR Trial Balance was done as at November 30th, the GL Trial Balance was also done, but the totals do not match for the AR account. We had an issue with a batch, the batch was posted with the wrong dates so the batch was being voided when the machine hung, the user ended the job. A TB was done relative to the accounts and we saw where some of the documents were voided therefore we were seeing the documents on the accounts. There was no batch in the GL, that's why a Check links and Reconcile was done, the GL totals and the TB still don't balance. The difference between the two reports is the same as the batch that had the issue.

Not sure what direction to go in to determine why there is a difference, any advice would be appreciated.

Regards

Rosemary

*This post is locked for comments

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: AR Trial Balance not the same as GL Trial Balance

    Hi Rosemary

    If a batch was interrupted while posting, then you may have hung transactions in the tables that are not visible in the front end.  Check links and reconcile will not always pick these up and manual intervention may be needed.

    Often a key way to know is to drill into the transactions in AR - do any error messages crop up?

    You may need to search through the tables for transactions to either complete or delete.

    If you are not getting errors, then manually fixing in the front end may be your best bet.

    Cheers

    Heather

  • Suggested answer
    Zohaib Asghar Profile Picture
    Zohaib Asghar 250 on at
    RE: AR Trial Balance not the same as GL Trial Balance

    Hi,

    This is what i understand from your statement:

    1) Some credit memos were entered in the receivables module.

    So they were supposed to:

    Cr Receivables

    2) When you voided the transaction, the entry would be :

    Dr Receivables

    3) But the voiding process was interrupted.

    4) You ran check links and Reconcile in AR, some documents returned in customer account.

    (Screenshot will help)

    5) For 'missing transaction', you entered debit memos for reversing the credit memos entries.

    Dr Receivables

    You have to use reconcile to GL routine and see the reconciliation spreadsheet again. It will clearly show which transactions are missing for corresponding journal entries in the GL. Hopefully manual adjustment will do it for you.

    There is another possibility. A few months back i faced a similar issue in a POP transactions. The situation got tricky and we had to update values in tables.

    You can email me any spreadsheets for review as well.

    zohaib.asghar94@hotmail.com

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: AR Trial Balance not the same as GL Trial Balance

    Ok, thanks for your input, I am looking at the edit list where the documents were entered, it was done via Receivables as a credit memo.

    Is this correct?

    Regards

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: AR Trial Balance not the same as GL Trial Balance

    My apologies, the transactions were entered and posted in October when it should have been the end of September. This is the information from Accounts Department. The batch was voided to be re-entered with the correct date. It was during the voiding of the batch that the machine hung and the session was ended. A trial balance was done for the customer account and we saw some of the transactions there.

    This was being compared with the edit list of the initial AR transactions. The void of the AR batch would have generated a batch in the GL but there was none. Before we did the check links and reconcile a TB was printed of the customers account and there we saw some of the documents returned to the account. The ones that did not were re-entered into the customer account via a debit memo.

    I did the Reconcile to GL this is also showing where the actual TB is more than what the AR GL account has.

    The transactions we supposed to be contras.

    Hope this makes sense

    Regards

  • Zohaib Asghar Profile Picture
    Zohaib Asghar 250 on at
    RE: AR Trial Balance not the same as GL Trial Balance

    Hi,

    "the batch was posted with the wrong dates so the batch was being voided when the machine hung, the user ended the job. A TB was done relative to the accounts and we saw where some of the documents were voided therefore we were seeing the documents on the accounts."

    Can you explain it further? Did you void the transactions? What does it mean to see the documents on the accounts?

    Did you review the journal entries for original and voided transactions posted in Trial Balance?

    Moreover, you can reconcile AR transactions with GL using 'Reconcile to GL' routine. (Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans