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 I’ve got a few pages ready for public consumption that list out some commonly needed codes in GP tables:
Leave a Reply Cancel reply
Search this blog:
GP Reports Viewer Newsletter
Sign up for the GP Reports Viewer Newsletter to get reporting tips via email
articles
awards
Bank Reconciliation
book
Crystal Reports
Dynamics GP
Excel reports
Extender
featured
Fixed Assets
FRx
General Ledger
GP 8.0
GP 9.0
GP 10.0
GP 2010
GP 2013
GP 2015
GP Reports code
GP Reports Viewer
GP SQL stored procedure
GP SQL view
GP table information
Integration Manager
Inventory
Management Reporter
Microsoft
Microsoft MVP
Miscellaneous
MSDynamicsWorld
Payables
Purchase Order Processing
Receivables
Sales Order Processing
security
service pack
SmartList Builder
SQL code
SQL Server
Support Debugging Tool
support lifecycle
version
Vista
Windows 7
year end close
-
Using credit cards to pay vendors in Dynamics GP January 4, 2009
-
SQL view for Payables GL distributions in Dynamics GP November 28, 2008
-
SQL view for all posted GL transactions in Dynamics GP August 11, 2009
-
Sales Transaction Entry GL distributions in Dynamics GP December 8, 2008
-
SQL view for Payables payment apply detail in GP October 22, 2009
-
Year end close in Dynamics GP November 14, 2008
-
SQL view to show AP apply information in GP October 22, 2008
- SQL view with AR apply detail February 15, 2010
-
Granting access to a new SmartList in Dynamics GP October 8, 2008
-
SQL view with all SOP line items in Dynamics GP May 17, 2009
-
SQL view for unposted checks in Dynamics GP August 29, 2017
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP April 20, 2017
-
Dynamics GP sales amounts and quantities for rolling 12 months March 14, 2017
-
Updating Dynamics GP data directly in SQL January 17, 2017
-
Did you know you can change Void dates on Payables transactions? September 20, 2016
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP May 25, 2016
-
SQL code to show top X percent of vendor data March 21, 2016
-
Discount from Packt Publishing September 15, 2015
-
Refreshable Excel report for historical GL trial balance in Dynamics GP August 13, 2015
-
Refreshable Excel report for monthly GL budget in Dynamics GP April 28, 2015
-
Victoria Yudin: I don't believe this is possible in out-of-the-box...
-
goinscd: is there a way to see who is creating vendor ID? W...
-
Victoria Yudin: Hi Merri, I will email you directly about this. ...
-
Merri Gorrell: That makes sense! I'll have to check with the dec...
-
Victoria Yudin: Hi Merri, That code took me an incredibly long ti...
-
Merri Gorrell: Hi Victoria; You mention you have code for an AR a...
-
Victoria Yudin: Hi Casey, My understanding is that any doc attach...
-
Casey: Thanks Victoria for all of your blogs/ post about ...
-
Ren: Hi Albert, I too have run into a situation where I...
-
Victoria Yudin: Hi Arslan, I don't have anything that combines ve...
Links
Blogroll
- Aaron Berquist
- Amber Bell
- Beat Bucher
- Constance Quigley
- David Musgrave
- Developing for Dynamics GP
- Devon Southall
- Dwight Specht
- Dynamics GP Engineering Team
- Dynamics GP Land
- Dynamics GP Support and Services Blog
- DynamicsCare
- eOne Dynamics GP and CRM Blog
- ERP Software Blog
- Frank Hamelly
- Gloria Braunschweig
- GSL Blog
- Ian Grieve
- Ian Stewart
- Jan Harrigan – FRx and MR
- Janakiram M.P.
- Jen Kuntz
- Jim Hummer
- Jivtesh Singh
- John Lowther
- Jonathan P Cox
- Les Wright
- Leslie Vail
- Mariano Gomez
- Mark Polino
- Michael D. Johnson II
- Microsoft MVP Blog
- Microsoft Team Blogs
- Mohammad R. Daoud
- MS Dynamics Partner Blog
- Official Dynamics GP Blog
- Ron Wilson
- Rose Business Solutions
- Shawn Dorward – GP Life Hacks
- Sivakumar Venkataraman
- Steve Endow
- Tim Wappat
- Vaidy Mohan
Most Clicked Links
Recent Blog Comments
Victoria Yudin on PM Tables | |
goinscd on PM Tables | |
Victoria Yudin on Receivables SQL Code | |
Merri Gorrell on Receivables SQL Code | |
Victoria Yudin on Receivables SQL Code |
Trackbacks/Pingbacks
[…] on October 6, 2008 by Mark Polino Victoria Yudin has a nice post with table info and codes (1=Sales/Invoice, 3=Debit Memo, etc.) for Receivables Management, Payables Management and […]
LikeLike