web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 10

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

I have the same question (0)
  • Zohaib Asghar Profile Picture
    Zohaib Asghar 250 on at

    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)

  • Rosemary Profile Picture
    Rosemary 10 on at

    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

  • Rosemary Profile Picture
    Rosemary 10 on at

    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

  • Suggested answer
    Zohaib Asghar Profile Picture
    Zohaib Asghar 250 on at

    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

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans