Archive | GP 10.0 RSS feed for this section

How to get rid of negative payment transactions in Dynamics GP

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

Voiding a partially applied Payables transaction in Dynamics GP

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

Change GP fiscal period names using SQL Server

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
3d builder

Dynamics GP build numbers and service packs

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 reading

SQL view with security and SmartList details in GP

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

Service Pack 4 for Dynamics GP 10

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 reading

Dynamics GP Windows 7 and Server 2008 R2 compatibility announced

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

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 reading

SQL view with security resource details for Dynamics GP

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 reading

SQL view to show security roles and tasks in Dynamics GP

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
question mark

Why support only part of a solution on SQL Server 2008?

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

Using credit cards to pay vendors in Dynamics GP

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

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 reading

Sales Transaction Entry GL distributions in Dynamics GP

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 reading

Year end close in Dynamics GP

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 reading

Service Pack 3 for Dynamics GP 10.0

Service Pack 3 for Dynamics GP 10.0 has just been released.  This service pack is cumulative – it includes all fixes and enhancements that were included in all previous service packs, hotfixes, and compliance updates. It does not include US Payroll tax tables. I have updated my post that details all the GP service pack versions to include […]

Continue reading

Granting access to a new SmartList in Dynamics GP

We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists. Because this is so different from older versions of Dynamics GP, we’ve created a really detailed list to go through it. This may be overkill for some, but it will hopefully cover every needed scenario. (Update: These instructions will work for […]

Continue reading

When does my GP product’s support end?

Here is a list I refer to all the time when I need to find out when a GP version came out and when support will end: Product Version Product Release/Start Mainstream Support End Extended Support End Additional information GP 6.0 03/31/2004 n/a n/a GP 7.0 03/31/2005 n/a n/a GP 7.5 07/01/2003 01/09/2007 n/a Link GP […]

Continue reading