You’re offline. This is a read only version of the page.
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
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
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
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
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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (