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
-
SQL view for Payables payment apply detail in GP
-
Year end close in Dynamics 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 Jon, Some of these have started to be added as...
-
Jon M: Hi Victoria. I see you have provided a decoder for...
-
-
Steven: Hi Victoria, I'm fairly new to GP and I'm trying ...
-
-
Don Carver: Talking about dates, sometimes overriding the User...
-
-
Jim Woodin: broken record here - thanks so much for this site ...
-
Howard: Hi thanks foor sharing this...
-
Recent Blog Comments
 | Victoria Yudin on Fixed Assets Tables |
 | Jon M on Fixed Assets Tables |
| Victoria Yudin on Company/System Tables |
 | Steven on Company/System Tables |
| Victoria Yudin on What’s with all these dates? |
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