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:
Join 3,139 other subscribers
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 to show AP apply information in GP October 22, 2008
-
SQL view for Payables payment apply detail in GP October 22, 2009
-
Year end close in Dynamics GP November 14, 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: Hi Stephanie, I just tested setting it up in my G...
-
Stephanie Crawley: Yep, works like a dream when i do that. Our worka...
-
Victoria Yudin: Hi Stephanie, Very strange. Are you able to run i...
-
Stephanie Crawley: Victoria, I did run the grant script. The weirde...
-
Victoria Yudin: Hi Stephanie, Did you make sure to give DYNGRP pe...
-
Stephanie Crawley: Victoria, thank you so much for the quick response...
-
Victoria Yudin: Hi Stephanie, In SmartList Builder you first have...
-
Stephanie Crawley: I created this view to use in Builder. The view i...
-
Lenny: Thank you so much for sharing all this info, espec...
-
Victoria Yudin: Hi Denise, There is nowhere in AP you can see thi...
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 SQL view with security resourc… | |
Stephanie Crawley on SQL view with security resourc… | |
Victoria Yudin on SQL view with security resourc… | |
Stephanie Crawley on SQL view with security resourc… | |
Victoria Yudin on SQL view with security resourc… |
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