Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Is there a table that only shows the month-end balances for the general ledger for GP 10.0?

Posted on by Microsoft Employee

I know of the one that show the detailed transactions (GL20000 and GL30000) but how about just balances?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Is there a table that only shows the month-end balances for the general ledger for GP 10.0?

    Richard is right on the tables to use.   But you should be aware of the way the data is stored.

    For Example, if you had an expense account and you only have one transaction during the entire year which occured in June.    You will only find one row for the balance and that would be June.   There will not be a row for July thru December.    

    So if you were wanting to see the balance for July, you will get no records returned.

    Warren.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Is there a table that only shows the month-end balances for the general ledger for GP 10.0?

    GL10110 and GL10111

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