Share
ReportWHere can I find a GP sample database?
*This post is locked for comments
You’re offline. This is a read only version of the page.
125
WHere can I find a GP sample database?
*This post is locked for comments
There is table that holds the balances, you have to calculate them. From http://victoriayudin.com/gp-reports/gl-tables/:
Summary Views:
GL11110 - Open Year Summary Master
GL11111 - Historical Year Summary Master
[Note: These views show debits, credits and net changes per period per account, they do not show the period balances. The reason to use these and not the corresponding GL10110 and GL10111 tables is that these views also include the Account Description.]
I am new to GP, and loaded the demo for first time, then will get MSDN licence and want to do contract work. Just getting the hang of this forum ... .
For the TWO database, you could download the demo. Since you have a license, you should have rights to this. The file is GP10.0Trial.exe (1.68 gb) and unzip the whole thing to a folder you create (2.42 gb, 508 files) (but don't continue with install). In there you will find two files: GPSTWODat.mdf (317 mb) and GPSTWOLog.ldf (122 mb). I believe you can then load this with SQL Server but you need to get the how to from an MS SQL Server techy which I am not there yet). I did notice on my install that these flashed by when they were being loaded.
The link for demo download is here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=01fb6157-0a4d-407a-afe0-de03af95c6b6&DisplayLang=en
My advice: do all this experimentaton on a totally separate stand-alone machine - not your production environment. Too risky to monkey with SQL back-door tricks etc with prod.
Cheers, Dave
Here is a link to the GL tables page on my blog: http://victoriayudin.com/gp-reports/gl-tables/ for future reference and additional information.
If you're looking for all posted transactions you'll need to union GL20000 and GL30000.
I don't think the Microsoft licensing agreements allow us to just send this to someone, sorry. If you are a current GP customer, you can get this from your GP partner. Also, you're talking about a 380MB database here, even zipped, doubtful that you can do this over e-mail.
I don't think there is any way to do this unless you can find another install and get a SQL backup of the TWO (that's always what is used for the sample company) database from it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (