Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Using SQL data from MS Dynamics

Posted on by 40

I am trying to find the beginning and ending GL balances in the Sql tables, but can not locate them.  Does anyone know what table I can find this for any given month and period?

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Using SQL data from MS Dynamics

    Beginning and ending period balances for GL accounts are not stored in any SQL tables.  You will need to calculate them yourself.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: Using SQL data from MS Dynamics

    Have you looked at the tables GL11111 and GL11110.. ?  I'm not sure, but it could also be possible that GP is not storing that information anywhere, but rather calculate it any given time when required to display...

  • Nicole Douglass Profile Picture
    Nicole Douglass 40 on at
    Re: Using SQL data from MS Dynamics

    I know that I can use those tables to calculate the beginning and ending balances on my own, but I want to know if the beginning and ending balances for each GL for each period is store in any table.  I am looking to create a report from the SQL data similar to the Reports - Summary - TB report that has beginning and ending balances for specific time periods

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Using SQL data from MS Dynamics

    Look on GL10110 for current open years and GL10111 for historical years

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans