Mark Polino’s book, titled Microsoft Dynamics GP 2010 Cookbook, is out ahead of schedule! I think that’s the first time I have ever heard of something like that happening. I’ve already got my copy and as soon as I get a few minutes I am going to start reading it. In the meantime, you can read a […]
Continue reading
Archive | Dynamics GP RSS feed for this section
Updates to SQL view to show all GL distributions for AP transactions
June 25, 2010 
9 Comments
I have made a number of updates to my SQL view to show all GL distributions for AP transactions since I first published it. Some of these were in response to comments asking for additional fields, others were added when I came across new data to test with. Rather than publish another post with the latest revisions, I have updated the […]
Continue readingAwesome resources available from Mark Polino
June 17, 2010 0 Comments
Mark Polino, one of the very first Dynamics GP bloggers and someone who has personally inspired me often with his writing, has done some spring cleaning on his blog. There is a ton of great content, but I would like to point out these two great resources: SQL Scripts – one location with descriptions and links for many […]
Continue readingCrystal Reports is not going anywhere
June 2, 2010 1 Comment
Are you using Crystal Reports with Dynamics GP? Are you starting to hear rumors that Crystal Reports is not supported with GP anymore? Don’t worry, Crystal Reports is not going anywhere. For more on this, take a look at my latest article for MSDynamicsWorld.com, The Good News for Users of Crystal Reports with Microsoft Dynamics GP.
Continue readingMicrosoft Dynamics Top 100 Most Influential People of 2010
May 26, 2010 2 Comments
Earlier this week DynamicsWorld.co.uk announced their annual Microsoft Dynamics Top 100 Most Influential People. Thanks to your votes I made it to # 51 on this list, joined by many names you will recognize. You can see a short bio for each person on the list by clicking on the heading for the section they are in. Thanks again […]
Continue readingDecisions, decisions
May 18, 2010 0 Comments
The new era of trade shows is here. Virtual trade shows. No more leaving the office for a week, trying to work from the road, all to see what’s happening with Dynamics GP. And no more paying for travel and registration fees. Decisions 2010, brought to us by MSDynamicsWorld.com, starts tomorrow and is free! There is a […]
Continue readingSupport Debugging Tool new build released
May 17, 2010 1 Comment
Developed by David Musgrave, known to the entire GP community as the king of all things Dexterity, the Support Debugging Tool for Dynamics GP has been around for quite a while, but I have only recently started to see the benefits of it and I wanted to share one cool feature in some detail. One of […]
Continue readingSQL view with security and SmartList details in GP
May 13, 2010 27 Comments
Robert Cavill from Emeco in Australia has sent me an amazing update to my Security Roles and Tasks in Dynamics GP SQL script that includes SmartList objects. This script was originally written for GP 10.0 and GP 2010, but will also work with GP 2013 and GP 2015. To get the most out of this script […]
Continue reading GP 2010 Cookbook
May 6, 2010 1 Comment
Dynamics GP MVP Mark Polino has been an amazing contribution to the entire Dynamics GP community for many years now with his blog, advice on forums and fabulous presentations, like 50 Tips in 50 Minutes and 50 More Tips in 50 Minutes. Now we’ll be able to get even more of Mark’s great advice in his upcoming […]
Continue readingIt’s here!
May 4, 2010 8 Comments
GP 2010 is now available for download on both CustomerSource and PartnerSource. According to the poll I have had on this blog for about two months, almost 60% of those who responded have plans to upgrade to GP 2010 and another 5% are already on it. 11% chose “What’s GP 2010?” – not sure if they’re joking, stumbled upon my blog […]
Continue readingSQL view for Fixed Assets depreciation in Dynamics GP
April 7, 2010 21 Comments
Below is a view I have put together to get the monthly Fixed Assets depreciation amounts in Dynamics GP. For more detail on the Fixed Assets module, please visit my Fixed Assets Tables page. If you’re looking for more SQL code, you can find it on my GP Reports page. ~~~~~ CREATE VIEW view_FA_Depreciation AS /******************************************************************* view_FA_Depreciation Created on […]
Continue readingThere’s a new blog in town
March 24, 2010 5 Comments
Ron Wilson, who you may have seen posting on various Dynamics GP forums and newsgroups, has recently started a blog called Real Life Dynamics User. Ron has been busy posting tips and tricks, sharing his experiences with Dynamics GP and posting useful SQL scripts and views. Keep up the great work, Ron! For the Office Space fans out there, […]
Continue readingWhen will you be upgrading to Dynamics GP 2010?
March 16, 2010 0 Comments
There are only 23 votes so far, but as of now the leading answer is a plan to upgrade to GP 2010 by the end of the year: And a special shout out to the person who took me up on my joke and answered ‘What’s GP 2010?’! If you are looking at GP 2010, […]
Continue readingDynamics GP polls
March 12, 2010 2 Comments
I had a poll on the sidebar of this blog for about a year asking what version of Dynamics GP my visitors were using. Here are the results: I admit to being a little surprised by this, I thought that GP 9.0 would be much closer to GP 10.0, not less than half. And a total of 14% […]
Continue readingSQL view with AR apply detail
February 15, 2010 92 Comments
This has been a hot topic in the newsgroups lately and several people have asked me if I have any code for Receivables (AR) apply information in Dynamics GP. Below is a view that should help you get started if you’re building a report to show AR apply information in Dynamics GP. For more views like this, check out […]
Continue reading SQL view with all GL distributions for AR transactions
February 10, 2010 48 Comments
As a corollary to my SQL view with all posted Receivables transactions, below is a view that will add all the General Ledger distributions to the AR transactions. I made a few changes to the original AR transactions view, primarily to remove some columns that are typically not needed and add underscores to the column names so […]
Continue readingMaximizing Dynamics GP online resources
February 2, 2010 4 Comments
I have joined the ranks of many fellow Dynamics GP MVP’s and experts and got an article published on MSDynamicsWorld.com. It’s called The “Right” Way to Maximize the Growing Number of Online Resources for Microsoft Dynamics GP and talks about how to get the most out of the many fabulous online resources available now for […]
Continue reading Happy New Year
January 2, 2010 19 Comments
I found out yesterday that I have been awarded with the Microsoft® Most Valuable Professional Award for Dynamics GP for another year. I first became a Dynamics GP MVP in 2005, so this will be my 6th year to receive the award and I could not have done it without the support of all of you reading […]
Continue readingMy 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
-
SQL view for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information in GP
-
Year end close in Dynamics 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 Matthew, This is a limitation in GP. "Why" is ...
-
Matthew: Why does "Sales" type distr...
-
-
Kevin Mackol: Does this still work on new...
-
-
Alex: Hi Victoria, Hi Victoria, Hi Victoria,Thank you so mu...
Victoria Yudin 
Recent Blog Comments