October 3, 2008 
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
My 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
-
Year end close in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
SQL view to show AP apply information in 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 Mike, I've not done any specific testing on nu...
-
Mike Hermann: Hello Victoria, great resource that I have used fo...
-
-
Scott Santos: Good morning Victoria, Let me apologize if this ha...
-
-
-
greg baumgardner: can you update this script to show credit memo's ...
-
-
Sitara: Hello there, thank you for all your informative a...
-
Recent Blog Comments
 | Victoria Yudin on SOP Tables |
 | Mike Hermann on SOP Tables |
| Victoria Yudin on POP Tables |
 | Scott Santos on POP Tables |
| Victoria Yudin on SQL view for easier General Le… |
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