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 […]
Read more
Archive | GP 10.0 RSS feed for this section
Change GP fiscal period names using SQL Server
January 27, 2011 
14 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 […]
Read more Dynamics GP build numbers and service packs
September 11, 2010 9 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. […]
Read moreSQL view with security and SmartList details in GP
May 13, 2010 17 Comments
Robert Cavill from Emeco in Australia has sent me an amazing update to my Security Roles and Tasks in GP 10 SQL script that includes SmartList objects. I have tested this script with both GP 10.0 and GP 2010 and for both versions to get the most out of this you will want to populate the […]
Read moreService 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 […]
Read moreDynamics GP Windows 7 and Server 2008 R2 compatibility announced
August 10, 2009 6 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 […]
Read more Dynamics GP Trial Balance in Excel using FRx
July 17, 2009 40 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 […]
Read moreSQL view with security resource details for Dynamics GP 10
March 20, 2009 24 Comments
As a corollary to my view showing the Dynamics GP 10.0 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 […]
Read moreSQL view to show security roles and tasks in Dynamics GP 10
March 12, 2009 13 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 […]
Read more 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 […]
Read more Using credit cards to pay vendors in Dynamics GP
January 4, 2009 104 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 […]
Read more Payables Return transactions in Dynamics GP
December 30, 2008 27 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 […]
Read more Sales Transaction Entry GL distributions in Dynamics GP
December 8, 2008 47 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 […]
Read moreMy Book
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view for sales by item by month
-
SQL view for sales quantities by item by site by month in Dynamics GP
-
SQL view for SOP sales by customer by month
-
Assign sequential numbers in SQL Server
-
SQL view for current Receivables aging detail in Dynamics GP
-
SQL view for current Payables aging detail in Dynamics GP
-
Changing part of a string in SQL Server using REPLACE
-
SQL view for sales quantities by item by site by year
-
SQL view for Fixed Allocation Accounts in Dynamics GP
-
Happy New Year – 2013
-
How to add a sparkline to a report in SSRS
-
Victoria Yudin: Luis, not sure what to tell you - my out-of-the-bo...
-
Luis: Victoria, Thank you for your help. I tried the m...
-
-
Patrick: With the database I inherited I don't know how or ...
-
-
-
-
-
zgar: Great, thanks so much. I got the SOP info on what...
-
