Since I have posted a lot of Dynamics GP table information and SQL code, I often get asked the question “what table holds ____ “? Sometimes I just know the answer off the top of my head (yeah, I think that’s scary, too), but once in a while I have to look it up. I have various […]
Continue reading
Tag Archives: GP table information
Awesome resources available from Mark Polino
June 17, 2010 
0 Comments
Mark Polino, one of the very first Dynamics GP bloggers and someone who has personally inspired me often with his writing, has done some spring cleaning on his blog. There is a ton of great content, but I would like to point out these two great resources: SQL Scripts – one location with descriptions and links for many […]
Continue readingSQL view with security resource details for Dynamics GP
March 20, 2009 38 Comments
As a corollary to my view showing the Dynamics GP security roles and tasks assigned to users, I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave detailing how to populate the SY09400 table in SQL which holds […]
Continue readingDynamics GP Bank Rec table information
January 16, 2009 4 Comments
A new page is now available with table information for the Bank Reconciliation module. I have reorganized all the pages a little so they are now alphabetized on the sidebar to the right and hopefully easier to find. All of the available pages as well as other resources for GP Reports are listed on my GP […]
Continue readingDynamics GP Fixed Assets table information
November 20, 2008 1 Comment
I have posted up a new page with Dynamics GP Fixed Assets table information. This is part of my ongoing library of Dynamics GP reporting information. A directory of all the information I’ve posted up so far is on the main GP Reports page.
Continue readingDynamics GP Inventory table information
October 23, 2008 0 Comments
I’ve posted up a new page with GP Inventory table information. You can see the entire list of modules available so far on the main GP Reports page. That page also has links to additional resources and the GP SQL views I’ve posted recently. I’ve gotten some requests for other modules, so I’ll work on putting those together next. Is there […]
Continue readingDynamics GP GL table information
October 13, 2008 0 Comments
A new page has been posted up with the General Ledger table information. A list of all the various pages available can be seen on the main GP Reports page. I have also included links there to some additional reporting resources published by fellow Dynamics GP bloggers.
Continue readingDynamics GP POP table information
October 10, 2008 2 Comments
There is a new page with information now available for Purchase Order Processing tables. I have also updated the Company/System Tables page with more data. As always, you can see a list of all the information available so far on the main GP Reports page, which will also show the dates the individual pages have […]
Continue readingDynamics GP SOP table information
October 7, 2008 0 Comments
I have posted up a new page for SOP Tables to help with reporting on GP Sales Order Processing data. I also have a complete list with updated dates on my main GP Reports page so that you can see what has new content and what is coming in the future. If there is any information you’d […]
Continue readingGP Table Information
October 3, 2008 1 Comment
We have been collecting a lot of information while creating reports with GP for all these years. Some of it is stored in our overworked and under-rested brains (well, most of it)…but a bit here and there we’ve actually committed to some sort of electronic format. I will be adding to it over time, but […]
Continue readingMy Last Book
Dynamics GP 2013 Implementation
My Previous Book
Dynamics GP 2010 Implementation
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail in GP
-
Year end close in Dynamics GP
- SQL view with AR apply detail
-
Granting access to a new SmartList in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
SQL view for unposted checks in Dynamics GP
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP
-
Dynamics GP sales amounts and quantities for rolling 12 months
-
Updating Dynamics GP data directly in SQL
-
Did you know you can change Void dates on Payables transactions?
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
-
SQL code to show top X percent of vendor data
-
Discount from Packt Publishing
-
Refreshable Excel report for historical GL trial balance in Dynamics GP
-
Refreshable Excel report for monthly GL budget in Dynamics GP
-
Victoria Yudin: Hi Stephanie, I just tested setting it up in my G...
-
Stephanie Crawley: Yep, works like a dream when i do that. Our worka...
-
-
-
-
-
-
-
Lenny: Thank you so much for sharing all this info, espec...
-
Victoria Yudin 
Recent Blog Comments