AR General ledger VS Receivables Trial Balance

(0) Share

Report

Posted on by GrapeFruit

1,240

Hi,

Our finance manager told me the Account receivables GL Balance never balances with the total we get from the Receivables Trial Balance report and the difference is big.

I am wondering if he is getting the figures from the wrong place.

He is getting the AR GL Balance from "Enquiry->Financial->Summary" and Receivables Trial Balance from a customized Crystal report which looks at the RM00103 table.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Hi,

The customer balance is not automatically updated in table RM00103 as soon as transactions are posted. You can proof the AR GL Balance with the Aged Trial Balance in GP. You can also use Reconcile to GL window (Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Reconcile to GL) to reconcile if you are using GP 10 or later version

You can refer to following KB article for further information

mbs2.microsoft.com/.../KBDisplay.aspx

Rubal,

http://dynamicsgphelp.com/

Was this reply helpful? Yes No
veeyeskay on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Hello

You can check my blog where I have scripts for the Receivables HATB script which provides you with a trial balance for receivables which can be compared to the GL Trial Balance for AR.

msdynamicstips.com

Let us know if you need further assistance.

Was this reply helpful? Yes No
GrapeFruit 1,240 on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Hi Rubal,

The AR trial balance report is run as part of the EOM process (including aging).

Yes, we are on GP 10. When I try to run "Reconcile to GL", I get the following error message:

"Violation of PRIMARY KEY constraint 'PK##0562115'. Cannot insert duplicate key in object 'dbo.##0562115'."

Any thoughts?

The KB is for Solomon which doesnt apply to us.

Was this reply helpful? Yes No
GrapeFruit 1,240 on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Hi Siva,

Thanks for your scripts.

I ran "Receivables HATB Report (using GL Posting Date)" and "GL Reconciliation SQL Script – Receivables" to compare the transaction in GL and AR. 99% of the missing transactions are very old (I think they didnt get imported properly when we first introduced GP).

But if I compare the results of GL Balance from "Enquiry->Financial->Summary" and Receivables Trial Balance from "Report->Sales->Trial Balance->Historical Aged Trial Balance" for the recent months, I can see the gap between GL and AR is increasing.

Any ideas?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

I would start by having a good backup of your company data and then run check links on all of your modules. Then if running GL reconcile continues to give you the duplicate record message you and your GP partner need to look at the GL30000 and GL20000 tables. It sounds like there is bad data in there or perhaps you have a journal entry in both the GL20000 and GL30000.

Was this reply helpful? Yes No
GrapeFruit 1,240 on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Hi Richard,

Thanks for your advise. I had a look into GL20000 and GL30000, but didnt find any duplicates.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

If the gap is increasing it sounds like someone is posting AR documents but the AR account is not included on the transactions. Either that or the GL transactions resulting from the AR transactions are not geting posted to the GL. There are products like The Recociler from Software Index or The Closer to reconcile AR balances to GL AR balances. You must first find what is causing the difference and then eliminate the bad records. You could have both bad historical records and new records going in that are incorrect. This process could be very time consuming.

Was this reply helpful? Yes No
GrapeFruit 1,240 on at

Like (0)

Report

Re: AR General ledger VS Receivables Trial Balance

Thanks Richard,

I think I have found the problem. For some reason the "Voided Trn Maintenance" (payments) and "Receivables Apply Doc" (write offs) are not posted to GL automatically even if we have "Post Through General Ledger Files" checked in the posting setup window.

Any ideas?

Was this reply helpful? Yes No
Dawn 495 on at

Like (0)

Report

RE: AR General ledger VS Receivables Trial Balance

I am now having this issue and wondering if anyone has posted a fix.

"Receivables Apply Doc" (write offs) are not posted to GL automatically even if we have "Post Through General Ledger Files" checked in the posting setup window. "

Thanks!

Was this reply helpful? Yes No