Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP Report

Posted on by 155

Hi,

I want to create Balance sheet report from Gp Database (because have no access to gp only database is accessible).

Which tables I use from that report.

If anyone have an idea please share with me.

*This post is locked for comments

  • Suggested answer
    cgust Profile Picture
    cgust on at
    RE: GP Report

    Management Reporter has a wizard that will create a Balance Sheet and you don't need to know any table names.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP Report

    The GL20000 and GL30000 tables would be used for drilling down to the details

    >

    > GL10110 and GL10111 would be used for the higher level reports that only show summaries

    >

    > GL00201 would be used for both because it's the only table with budget details

    >

    > GL00100 would be used to get the account description - the GL20000 and GL30000 only refer to the GL account as the actindx - not the full GL account string

    >

    > GL00102 would be used to get the category description

    >

    > GL40200 would be used to get the segment description for each GL account - not all these fields are populated - accounting needs to enter descriptions

    >

    > GL00105 could be used to get the entire GL account number in one field (the 4 segments are combined into one field)

  • Suggested answer
    Josh P Profile Picture
    Josh P 2,895 on at
    RE: GP Report

    What Frank said :)

    Here is a script from my own stash for you to use. This will pull everything from open and history with account categories, segment information, originating info, and notes. It also gives multi-currency info.

    gist.github.com/.../525b61a2285e19a5f02b

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP Report

    The main GL tables are:

    GL00100 Account Master

    GL00102 Account Category Master

    GL00105 Account Index Master

    GL00201 Budget Master

    GL20000 Current year GL posted transactions (sometimes this might be 2 years because a new year would be open and the old year might not be closed yet)

    GL30000 Historical GL posted transactions

    GL10110 Current year GL account summary (just totals by period - no details)

    GL10111 Historical years GL account summary (just totals by period - no details)

    GL40200 Segment description master

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: GP Report

    GL20000 for open year transactions, GL30000 for historical year transactions, GL00105 for GL account string.  Join GL00105 on GL20000 and GL30000 by ACCTINDX.

    Why not just install FRx or Management Reporter and create your balance sheet there?  Would be much easier.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans