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) / General Ledger To Acco...
Microsoft Dynamics GP (Archived)

General Ledger To Accounts Receivable Difference

(0) ShareShare
ReportReport
Posted on by Jeff Garrison 2,485

Everyone -

We have an issue where the General Ledger to Accounts Receivable is off by X amount.  We have gone through every possible report/Smartlist that we possibly can.  We ran the Check Links on the Financial series this morning and we only cam up with 2 errors.  They are as follows:

GL_TRX_HDR_WORK

The reporting ledger for 814805 is not valid;  it has been assigned the BASE reporting ledger.

Transaction Batch Headers

The transaction batch headers for batch  has been added.  Please reconcile batches.

The batch has a blank description.  If I go to Series Post under Financial, there is a Batch with not Description with no transactions in it.

We have not run the Check Links on the other modules yet, due to the number of transactions that have to be checked.

Does anyone have any suggestions?

Thank you.

Jeff

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    If you haven't done the Reconcile to GL routine under Financial >> Routines I would suggest trying that and see if that displays any issues under Unmatched or Potentially Matched.  

    Other than that, what I would do is find when it went out of balance and check the transactions for that day.  I'd run my Gl trial balance for 1/31 and compare it to the Receivables TB for 1/31.  If it doesn't, I'd jump back to 1/15 and see if it's in balance.  If not, go back even further.  If it does, jump ahead a week.  And keep it going until I find the specific day.  Then compare all transactions in those modules for the day.  

    It's tedious but if you've tried all other options, then not much else you could do.

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    Hi Jeff,

    There will be a number of reasons why the amounts will be off.  Like what Matt mentioned, you can use the Reconcile to GL routine for RM.  

    It is likely that there will be differences that will come out of the report.  You can then use the following KB article to determine the reasons:

    support.microsoft.com/.../866570

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    Matt and Tristan have given you the same advice I would. I see you are on GP2010 so you do have the reconcile tool in GL. The Excel spreadsheet that routine creates might appear hard to understand, but it will expose to you where the differences are. If it were me, I'd go back to the last date everything balanced and set that as my 'From' date. I'd set the current date as my 'To' date. Run the utility. On the spreadsheet produced by the utility, I'd initially ignore the 'matched' transactions and concentrate on the Unmatched and Potentially matched transactions.

    Let us know how it works out.

    Kind regards,

    Leslie

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