Even though Great Plains version 6.0 has not been supported for a number of years (you can see specifics on my GP support lifecycle post), there are many companies out there running version 6.0. Questions have come up several times on how to match a version number with a service pack, here is the detailed list: […]
Continue reading
Archive by Author
Dynamics GP Bank Rec table information
January 16, 2009 
4 Comments
A new page is now available with table information for the Bank Reconciliation module. I have reorganized all the pages a little so they are now alphabetized on the sidebar to the right and hopefully easier to find. All of the available pages as well as other resources for GP Reports are listed on my GP […]
Continue readingHow to get rid of the blank page at the end of a Crystal report
January 12, 2009 50 Comments
Here is a tip from the Flexible Solutions GP Reports newsletter: Often when creating a Crystal report for something that needs a new page for each group (like Invoices or Purchase Orders) we use the New Page After option for the Group Footer in Crystal’s Section Expert. This works great, however it prints a blank […]
Continue readingSQL view to show customer pricing
January 7, 2009 18 Comments
Here is a view to show customer specific item pricing in Dynamics GP when using standard pricing. This will work either with SmartList Builder or Crystal Reports as I have made sure not to put any spaces in the names. If you are using SmartList Builder this means you may want to go down the […]
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 Dynamics GP MVP award
January 1, 2009 13 Comments
I just got the news that I have been presented with the 2009 Microsoft® Most Valuable Professional Award for Dynamics GP for another year. This is a great honor for me, as I believe I am the only person who has received the Dynamics GP MVP award each consecutive year since 2005. If you’d like to […]
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 readingNew page with resources
December 22, 2008 2 Comments
I have published a new page called Resources that has links to information I am either frequently looking up or I am being asked for routinely. Stuff like Dynamics GP system requirements, printer compatibility lists, how to translate a build number in GP, FRx or SQL Server to a specific service pack, when support for various versions […]
Continue readingReporting on Extender data in Dynamics GP
December 15, 2008 24 Comments
Dynamics GP Extender is one of those modules that has so much in it, most people don’t use even half of it. One of the most underused features is Extender Views. Anyone that has worked on reports using data entered into Extender windows will tell you that getting data directly out of Extender tables is a challenge. All […]
Continue reading Sales Transaction Entry GL distributions in Dynamics GP
December 8, 2008 108 Comments
The topic of General Ledger distributions for Sales Order Processing transactions has been known to cause a fair amount of confusion for Dynamics GP users. I would like to address some of the typical questions we receive on this. Please click on the screen shots to see them larger/clearer. Just to set the stage, I am talking about the […]
Continue readingHow to show only invoices on the payables check stub in GP
December 3, 2008 9 Comments
Here is a question that is brought up frequently by Dynamics GP users – how do we only show invoices that we are paying with this AP check on our check stub? By default GP will show you everything applied, including credit memos and even non-check payments made between the current check and the last one. There are 2 […]
Continue readingUseful SQL Scripts series from Developing for Dynamics GP
December 1, 2008 0 Comments
The Developing for Dynamics GP blog has started a new Useful SQL Scripts series. This is brought to us by David Musgrave and a very impressive team of Microsoft Dynamics GP support engineers. Many of these engineers have helped us tremendously over the years and I am looking forward to new additions for this series. Important note – the links will […]
Continue reading SQL view for Payables GL distributions in Dynamics GP
November 28, 2008 174 Comments
Here is a view that will return the General Ledger distributions for all posted or unposted payables transactions. Unposted is also called ‘work’ and posted includes any open or historical transactions. If you’re going to use this with SmartList Buidler, make sure to include the section at the end to grant permissions to DYNGRP. Disclaimer: I […]
Continue readingDynamics GP Fixed Assets table information
November 20, 2008 1 Comment
I have posted up a new page with Dynamics GP Fixed Assets table information. This is part of my ongoing library of Dynamics GP reporting information. A directory of all the information I’ve posted up so far is on the main GP Reports page.
Continue readingDynamics GP Integration Manager – vote for product suggestions
November 17, 2008 0 Comments
Beth Gardner, Support Escalation Engineer for Microsoft Dynamics GP, is looking for votes on product suggestions for Integration Manager. GP users ask us all the time how to get their suggestions implemented – this is the way. Microsoft does look at what customers are saying and the way to get the functionality you want included into future versions is to […]
Continue reading Year end close in Dynamics GP
November 14, 2008 102 Comments
Every year we get a slew of phone calls about closing the year in GP. Usually these start in December and I thought I would beat the rush this year. Here are some resources and notes I have compiled over the years on the year end close. I will add to this post as I find more […]
Continue readingMDA is here to stay
November 12, 2008 0 Comments
Thanks to Mark Polino at DynamicAccounting.net for alerting me to Microsoft’s announcement that Multidimensional Analysis (MDA) will continue to be sold and supported for Dynamics GP. Mark’s post has a link to the official announcement, however if you do not have access to Microsoft Dynamics PartnerSource you won’t be able to get to it. The basic gist […]
Continue readingSQL view for Crystal Reports to show open AP invoices from multiple companies in GP
November 10, 2008 0 Comments
In my experience Crystal Reports really doesn’t like it when you have spaces in your field names. I’ve gotten a request for a ‘Crystal’ version of the Multicompany Open AP view I posted up a few days ago, so here it is. Please follow the in-line directions in green to change the generic company names […]
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