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
Management Reporter has a wizard that will create a Balance Sheet and you don't need to know any table names.
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)
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156