A few versions ago Microsoft introduced the ability to enter a negative payment (Cash Receipt) for a customer in Microsoft Dynamics GP. I have now worked with a number of customers that have these negative payments sitting on customer accounts who needed help getting rid of them. Below is what this typically looks like when you’re […]
Continue reading
Archive | GP 2010 RSS feed for this section
Voiding a partially applied Payables transaction in Dynamics GP
October 11, 2012 
20 Comments
Periodically I get calls or see questions online about how to void a partially applied Payables transaction in Dynamics GP. This is one area where the Payables module differs drastically from the Receivables module and you have to jump through some hoops to actually accomplish this. The issue is that when you go to void […]
Continue reading Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
February 29, 2012 11 Comments
Background / The Problem For many companies a long awaited new feature introduced with Dynamics GP 2010 was the ability to email SOP (Sales Order Processing) invoices directly from GP. Many of our customers have started to offer emailing of invoices to their customers and are seeing an increased number of requests for emailed invoices. However, […]
Continue reading SQL view for SOP email setup in GP 2010
October 24, 2011 9 Comments
I am starting to work with emailing SOP documents using Dynamics GP 2010 and new functionality that we are going to be releasing in an upcoming build of GP Reports Viewer. It’s pretty cool stuff, however, as I am working with customers to set this up, we’re finding that out-of-the box GP does not have any […]
Continue reading Change GP fiscal period names using SQL Server
January 27, 2011 15 Comments
Every time I create a new fiscal year in Dynamics GP or show customers how to do it, I get a little frustrated that I have to manually rename all the periods. Some users may not care that instead of January GP displays Period 1, but I don’t think that is very user friendly. So, for more years […]
Continue reading Dynamics GP 2010 implementation book coming soon
November 15, 2010 22 Comments
My book, Microsoft Dynamics GP 2010 Implementation, is off to the publishing house and should be ready to ship soon. While the primary goal of the book is to help with new implementations of GP in small to mid-size companies, there’s something in it for everyone. Just to highlight part of the content, this book has step-by-step […]
Continue reading Dynamics GP build numbers and service packs
September 11, 2010 34 Comments
I have posted a number of different resources in the past for finding Dynamics GP service pack levels based on build numbers, however, I wanted to put together something where you can check the major service pack builds for the main GP components all in one place. I have also added some helpful links below each version. […]
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 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 reading Dynamics GP Trial Balance in Excel using FRx
July 17, 2009 43 Comments
While I work with SQL and Crystal Reports every day, there are some reports that are just easier created elsewhere. One example is a GL Trial Balance that you want to export to Excel. There are many ways of handling this requirement, I like using FRx for it. Below are steps by step instructions on how to […]
Continue readingSQL view with security resource details for Dynamics GP
March 20, 2009 38 Comments
As a corollary to my view showing the Dynamics GP security roles and tasks assigned to users, I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave detailing how to populate the SY09400 table in SQL which holds […]
Continue readingSQL view to show security roles and tasks in Dynamics GP
March 12, 2009 25 Comments
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]
Continue reading Using credit cards to pay vendors in Dynamics GP
January 4, 2009 187 Comments
There are a number of different ways to record paying vendors with credit cards in GP. This is a topic that comes up periodically in newsgroups and I would like to share what I have personally found to be the most straightforward and comprehensive way. This is a long one but at least there will be […]
Continue reading Payables Return transactions in Dynamics GP
December 30, 2008 51 Comments
There is a little known, but very useful transaction type in the Payables module called Return. Every few weeks or so I see a question in the newsgroups or a call comes in from a customer where the answer is to use the Payables Return transaction. A typical scenario where a Return is needed goes something […]
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
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail 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 Stephanie, I just tested setting it up in my G...
-
Stephanie Crawley: Yep, works like a dream when i do that. Our worka...
-
-
-
-
-
-
-
Lenny: Thank you so much for sharing all this info, espec...
-
Victoria Yudin 
Recent Blog Comments