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
Archive | Dynamics GP RSS feed for this section
Get Dynamics GP tips from an expert
February 10, 2009 
0 Comments
Mark Polino, fellow Microsoft Dynamics GP MVP and prolific author of one of the most popular Dynamics GP blogs, DynamicAccounting.net, will be presenting at Convergence 2009! Mark’s session is called “Getting More out of Microsoft Dynamics GP, 50 Tips in 50 Minutes” and there are two time slots scheduled: Tuesday, March 10, 2009 | 5:00 PM – 6:00 PM […]
Continue readingSQL view to show items with SOP POP link
February 4, 2009 15 Comments
Here is a view to show all Sales Order Processing line items with the SOP-POP link in Dynamics GP. You can use this with either SmartList Builder Crystal Reports, as I have made sure not to put any spaces in the column names. I maintain a list of all the SQL code I’ve published on […]
Continue reading Why support only part of a solution on SQL Server 2008?
February 3, 2009 30 Comments
This is something that came up as I was reviewing posts in the FRx newsgroup and talking to customers about GP upgrades. I wanted to rant about it a little and see what others thought. Maybe I am over-reacting? Dynamics GP 10.0 is supported on SQL Server 2008. However, FRx Reporter 6.7 is only compatible […]
Continue reading Dynamics GP Integration Manager versions
January 28, 2009 22 Comments
With the help of the wonderful Microsoft support engineers I have been able to get a list of most of the Service Pack versions for Integration Manager 7.5 through 11 (for GP 2010): SP / IM IM 7.5 IM 8.0 IM 9.0 IM 10.0 IM 11 (GP 2010) IM 12 (GP 2013) RTM 7.05.0129 8.0.0.00 […]
Continue readingGreat Plains 7.0 and 7.5 service packs and versions
January 20, 2009 7 Comments
To complete the list I have been asked to publish the Great Plains version 7.0 and 7.5 service pack versions. Check out my GP support lifecycle post to see support end dates for these versions. Here is the detailed list for GP 7.x: Service Pack Version Great Plains 7.0 SP 1 7.00g5 Great Plains 7.0 SP 2 […]
Continue readingGreat Plains 6.0 service packs and versions
January 19, 2009 7 Comments
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 readingDynamics 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 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 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 to show AP apply information in 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 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