Category Archives: GP 2010

GP 2010 Item last sold: Including BOM components

Starting with the SQL view for last sale by customer and item by Victoria Yudin with a couple modifications.  I created some queries to recursively capture all of the components associated with the items sold as well and where they are … Continue reading

Posted in GP, GP 2010, GP SQL | Leave a comment

Connector for Microsoft Dynamics: GP2010 to CRM 2011 just getting it set up

First off I needed to install the connector, but before I could begin I needed to install the Web Services for GP.  And the Web Services Runtime also had a list of requirements… Make sure you use the correct Install … Continue reading

Posted in CRM, CRM 2011, Dynamics, GP, GP 2010 | Leave a comment

Dynamics GP 2010 Removing or changing access of existing users generic errors…

I have always been intrigued with the approach taken for the Dynamics GP security model.  It creates an actual sql user for each user that is added to the GP system.  This is  great for debugging or tracking what a … Continue reading

Posted in Dynamics, GP, GP 2010 | 3 Comments

Dynamics GP 2010 Word Templates Revealed

GP word templates: things you should know I have worked with the word templates in GP a couple of times now.  Our company has not fully committed to the new functionality, mainly because I found them near impossible to modify.  … Continue reading

Posted in Dynamics, GP, GP 2010 | 2 Comments

Dynamics GP 2010 “You dont have security privileges to…”

When you upgrade from any previous versions of GP to 10 or 2010 you will find that security is the biggest thing to change.  Many of my users panic when they see this message pop up. I have found a … Continue reading

Posted in Dynamics, GP, GP 2010 | 2 Comments

Upgrade Aftermath: Update Compatibility to SQL2005

One of the requirements for the GP 2010 upgrade is to upgrade the compatibility level on the SQL database to 2005.  We did the upgrade to SQL2005 from 2000 a while back, but we left the compatibility level as 2000.  I have … Continue reading

Posted in Dynamics, GP, GP 2010 | Leave a comment

Upgrade Aftermath: GP2010 Word Template Reports

After upgrading to GP2010 one of the first things we wanted to take advantage of was the word template reports.  The flexibility is amazing, but there are few thing that you need to know to get started. First the supported version … Continue reading

Posted in Dynamics, GP, GP 2010, Uncategorized | 7 Comments