Archive | GP 10.0 RSS feed for this section
weight

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
weightlifting

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
wrenchguy

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 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 […]

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
button

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 10

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 […]

Continue reading

SQL view to show security roles and tasks in Dynamics GP 10

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
flying-credit-card

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
money-bags

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
YellowOrangeJigsaw

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
officechairguy

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
Follow

Get every new post delivered to your Inbox.

Join 1,474 other followers