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
Tag Archives: Dynamics GP
Maximizing 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 readingSQL view for inventory items and dates
December 4, 2009 45 Comments
This view is a little bit of a twist on my previous SQL view for inventory quantities on hand. The results of this view will give you a list of your Microsoft Dynamics GP inventory items, current quantities and the last sales and purchase dates along with the vendor. For other SQL views on Dynamics GP data, please visit […]
Continue readingHistory of Dynamics GP
September 30, 2009 2 Comments
Do you still call it Great Plains because you’re so used to it? Or is Dynamics GP the only name you’ve ever used? In either case, you may find looking over the timeline of Dynamics GP that DynamicsWorld UK put together very educational and interesting. I have been working with GP as a customer since the DOS […]
Continue readingWhat’s with all these dates?
September 8, 2009 21 Comments
There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt […]
Continue readingService Pack 4 for Dynamics GP 10
August 25, 2009 16 Comments
Service Pack 4 for Dynamics GP 10.0 has been released. There is quite a long list of fixes, you can see them all in the Service Pack 4 Installation Guide. Starting with GP 10.0 any service pack or hotfix now requires an update of modified forms and reports using GP Utilities. Detailed steps for doing this […]
Continue readingDynamics GP Windows 7 and Server 2008 R2 compatibility announced
August 10, 2009 7 Comments
Just as the Windows 7 and Windows Server 2008 R2 are released, Microsoft announces that Dynamics GP 10.0 is already compatible with them. No service pack required. While my memory is not what it used to be, I do not recall any other new operating system that an existing version of GP was immediately compatible with. We have had […]
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 readingNew policy for Dynamics GP service pack support
June 26, 2009 1 Comment
Microsoft recently announced that the Dynamics products service packs will now be supported for 24 months after a new service pack is released. Previously service packs were supported for 12 months after a new service pack release. The new policy with key dates is outlined on Microsoft’s Longer Support Timelines for Key Microsoft Dynamics® Service Packs page. What this means to […]
Continue readingDynamically change decimal places in Crystal Reports
June 2, 2009 6 Comments
The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of decimal places for each line item in the SOP10200 and SOP30300 tables. Here are the […]
Continue readingHow to use a SQL view in SmartList Builder
April 20, 2009 43 Comments
Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList. I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3: STEP 1 – create SQL view To start […]
Continue reading Where did my transaction go?
April 11, 2009 7 Comments
This is a common question, especially with new users of Dynamics GP, and I was recently reminded of it by a post in the Microsoft Dynamics GP Newsgroup. While every transaction type will be slightly different, there is a basic lesson that is important for all GP users: beware of the Delete button. Most GP actions are updated automatically […]
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 readingGet 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 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 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 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