'Fix- It's' are automated solutions that you can run to help troubleshoot various common issues and error messages in Microsoft Dynamics GP 2010.  Just use the link below to sign into CustomerSource to view a list of Knowledge Base (KB) articles that contain 'Fix-It' solutions.  Within the KB article, there are alternate resolutions given where one method will show you how to do it yourself, and the other method will have you click a "Fix-It" button.  The "Fix-It" button will just run the SQL scripts for you to locate the problem records and does not actually resolve the…

I'm excited to post the Microsoft Dynamics GP 2010 and 10 U.S. Payroll Year-End update has released for the 2011 reporting year! 

Here are the 2011 Year-End pages which provides you with documentation and installs you need for a successful year-end.

2011 U.S. Payroll Year End Update for Microsoft Dynamics GP 2010 Download Page
https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2010.htm?printpage=false
https://mbs.microsoft.com/partnersource/downloads/taxupdates/usgpye2010.htm?printpage=false

2011 U.S. Payroll Year End Update for Microsoft Dynamics GP 10.0 Download Page
https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye10.htm?printpage=false
https://mbs.microsoft.com/partnersource/downloads/taxupdates/usgpye10.htm?printpage=false

****New for the 2011 year, there is a Year-End Video!!!!****
Check it out....SO COOL! 
http://www.microsoft.com/showcase/en/us/details/91697dc7-4926-4144-8626-ca0eb8e284da

Many times in support we get asked can we…

It is getting close to that time of year where we have to start thinking about Year-end processing, specifically around Payroll.

There will be a guaranteed year end update this year, below are the tentative timeline, very similar to prior years:

Microsoft is anxiously watching to see…

It is getting close to that time of year where we have to start thinking about Year-end processing, specifically around Payroll.

There will be a guaranteed year end update this year, below are the tentative timeline, very similar to prior years:

Microsoft is anxiously watching to see what may be approved with the recent changes the President announced, if passed we will have more change yet for the 2011 year.
Please, no repeat of last year. :-)

Updated 11/17/2011

Check out the newer blogs around year end!  Good luck.

Announcing release of 2011 U.S. Payroll Year-End Update
http://blogs.msdn.com/b/dynamicsgp/archive/2011/11/17/2011-u-s-payroll-year-end-update-releases.aspx

****New for the 2011 year, there is a Year-End Video!!!!****
Check it out....SO COOL! 
http://www.microsoft.com/showcase/en/us/details/91697dc7-4926-4144-8626-ca0eb8e284da

Install tips for year-end
http://blogs.msdn.com/b/dynamicsgp/archive/2011/11/15/microsoft-dynamics-gp-payroll-year-end-release-instal…

After installing the Microsoft Dynamics GP Add-in for Microsoft Word, you will need to add the Developer tab in Microsoft Word. The Developer tab is not added automatically and must be added through…

During my Interactive Discussion at Convergence over GP Security it became clear that I need to post what I do with my customers to help with administering and maintaining their GP security.  This will only focus on GP 10 and later.

There are many very well designed reports buildt into the product which are great for documenting, however, they fall short in helping to analyze or maintain your security.  To do security analysis you need something more interactive, something you can slice-n-dice or drill into. 

Here are two tools that I use:

• SQL View (that I can import into Excel)

• Support Debugging Tool

SQL View:

There is a great SQL View on MPV Victoria Yudin’s blog site called “SQL View with Security and SmartList details in GP”.  Be sure to read her entire post as the SQL View is dependent on the Security Resource Descriptions table being populated, but not by default.  The (counter intuitive) Clear Data method that she describes to populate the table only populates descriptions for Forms and Reports.   The SQL view will return every security setting, but only Forms and Reports will have descriptions.   Since 90% of security analysis and debugging is related to Forms and Report, this view is a great place to start.

Once you have the view in place, there are many ways to get the data into Excel. I am going to give you my favorite method through SmartList Builder.  With SmartList Builder you can point directly to the view, and once you have built and deployed your SmartList, the true slicing-n-dicing can begin!

PowerUser – The access that PowerUsers have will not show up in this SQL View.  Why? Because the PowerUser Role is not really a Role at all--it is a hard coded feature that exempts the user from ALL security.  What this really means is that there are no security tasks or operations created, so I don’t recommend the use of PowerUser in any environment.  If a user needs PowerUser…

Year end is now over and it is time to start thinking about planning the upgrade for Microsoft Dynamics GP!  New features and functionality are waiting for you in the current release of Microsoft Dynamics GP 2010 and more exciting capabilities are right around the corner with a brand new release available at the end of this year!  Start your planning meetings now to get a jump on your project plan for the upgrade of Microsoft Dynamics GP and all your integrating applications that you use today!
Take advantage of the upgrade resources and information below to learn everything you need to know about the current release of Microsoft Dynamics GP and the steps involved in the upgrade process that you can apply to any release of Microsoft Dynamics GP!

Important Note: Several links on this page go to CustomerSource. Learn more about CustomerSource and how to signin.

What is an Upgrade?
An upgrade is the process of moving your current release of Microsoft Dynamics GP and all integrating products such as Business Portal, Web Services, Workflow, ISV integrating products and your customizations to a new release.  For example, if you are currently using Microsoft Dynamics GP 10.0 with Business Portal 4.0, you can upgrade to the current release of Microsoft Dynamics GP 2010 and Business Portal 5.1.  There will be an upgrade path from Microsoft Dynamics GP 10.0 and Microsoft…

The Microsoft Dynamics GP Technical Account Preview Team is seeking a pool of candidates that accurately represent the Microsoft Dynamics GP users, from which we can select participants for the Microsoft Dynamics GP 2013 Technical Adoption Program (TAP).  The top priority is, as always, enthusiastic participants with the resources and support which will…

The following information should help to assist with resolving the ADO error message that users encounter in Integration Manager.

First, review the following KB to see if any of the cause and resolutions apply.

KB 954632, “Error message when you run an integration or when you preview the source query in Integration Manager for Microsoft Dynamics GP 10.0: “ADO Field is nothing””
http://support.microsoft.com/default.aspx?scid=kb;EN-US;954632

Next, review the following additional steps individuals have done to resolve the error message:

• If using an Excel spreadsheet as your source file, instead of saving as comma delimited file to use try changing your source file to a tab delimited text file.
• Remove any columns in your source file that are not being used that IM could detect or restrict those columns from…

You may have noticed a recent change to the way kits and components are handled when you transfer a backordered kit item from an order to an invoice. Prior to Microsoft Dynamics GP 10 SP4 and GP2010, when you marked the "Allow all Back Ordered Items to Print on Invoice" and you transferred an order to an invoice with a kit that had backordered components, you would see the kit item on the invoice. Now on Microsoft Dynamics GP 10 SP4 and GP2010 you see the component items instead.

The reason for this change is that we cannot allow the Kit Item itself to be transferred to the Invoice. The reason for this is Kit quantities cannot be changed after they are added as a line item.…