Come talk to us about new features in GP Reports Viewer at MSDynamicsWorld’s Decisions Fall 2011 today. I will be there all day along with our senior developer and SRS expert Mickie Stamm.
3 Responses to “Decisions Fall 2011 – GP Day is today”
Trackbacks/Pingbacks
-
Interesting Findings & Knowledge Sharing » Decisions Fall 2011 – GP Day is today -
December 6, 2011
[…] Reading: Decisions Fall 2011 – GP Day is today VN:F [1.9.11_1134]Please wait while your rating is cast…Rating: 0.0/10 (0 votes cast)VN:F […]
LikeLike
Leave a comment Cancel reply
Search this blog:
Join 2,094 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
-
SQL view for Payables payment apply detail in GP
October 22, 2009
-
Sales Transaction Entry GL distributions in Dynamics GP
December 8, 2008
-
SQL view to show AP apply information in GP
October 22, 2008
-
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 Matthew, This is a limitation in GP. "Why" is ...
-
Matthew: Why does "Sales" type distr...
-
Victoria Yudin: Hi Kevin, Yes, as far as I have tested, all the c...
-
Kevin Mackol: Does this still work on new...
-
Victoria Yudin: Hi Alex, To my knowledge there is no way to contr...
-
Alex: Hi Victoria, Hi Victoria, Hi Victoria,Thank you so mu...
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

December 6, 2011 



Morning,
I need help with joins between GL and Payable tables. My check EXPENSE report I need to add GL account to but I don’t know what join to use between the both of them.
What are common fields to join on between this two business?
Please help…Thanks!
LikeLike
Have you looked at my Payables SQL views page? From what you are describing you may be looking for my Payment Apply Detail and GL distributions view.
-Victoria
LikeLike