Archive for November 17, 2011

Working with My Reports in Dynamics GP 2010

Date: November 15, 2011

The number one enhancement request to Dynamics GP is reporting. Users want tailored, intelligent reporting to fit their business needs. One way to receive tailored reporting in Dynamics GP is through the My Reports feature. During this demo, Christina Phillips, BKD supervising consultant, shows users how to get started and create reports in the My Reports list in Dynamics GP.

Watch Webinar

Visit link:
Working with My Reports in Dynamics GP 2010

November 17, 2011 · Christina Phillips · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 571

2011 U.S. Payroll Year-End Update Releases!!

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

2011 U.S. Payroll Year End Update for Microsoft Dynamics GP 10.0 Download Page

****New for the 2011 year, there is a Year-End Video!!!!****
Check it out….SO COOL!

Many times in support we get asked can we install this update now even though I have not finished my 2011 payrolls.  YES YOU CAN!  This is why we release the update early so you have more time to install the update and a LESS stressful year end for all.
It is the 2012 tax update that gets tricky and we would recommend you install that when you are ready to process 2012 payroll and the 2011 year end wage file is created.

Please review all documentation in detail to prepare you for the year-end close, specifically around what has changed for this year.

If you use Personal Data Keeper (PDK), and install this update, you will need to install the latest Service Pack for Personal Data Keeper too.

Note if you are on Microsoft Dynamics GP 10 regards to Lifecycle:
Microsoft will provide a 2012 Year-End Update to all U.S and Canadian Microsoft Dynamics GP 10.0 Customers.  Microsoft will also provide Round 1 U.S. tax tables for the 2013 Payroll reporting year.  Following these releases, no additional code update will be released for Microsoft Dynamics GP 10.0, due to end of Mainstream Support in the Support Lifecycle for Microsoft Dynamics GP 10.0.  Technical support for Microsoft Dynamics GP 10 will continue to be provided through the Extended Support phase which will end on 10/10/2017.  If you are currently using Microsoft Dynamics GP 10.0, you must upgrade to Microsoft Dynamics GP 2010 or Microsoft Dynamics GP 12 (Due to release in December 2012) to receive any further regulatory and or code updates following the January 2013 Round 1 Tax Update.  

Detail of the changes
W2 and W3 changes, EFW2 changes, (magnetic media)
1099-R changes for pension payroll
1099 Payables Dividend changes
Fixed Assets luxury depreciation changes

Table changes to hold the new Employer Kind data: company and dynamics databases: (these are required on W3 and Electronic file)

Dynamics (it is a magnetic media table)      W200006 added column employerkind, will default in a 1

Company (Setup and year end table)
UPR40100 added column employerkind, will default in a 1
Year End wage table
UPR10100 added column employerkind, will default in a 1

**This update will be all inclusive of prior updates for 10 and GP 2010.

Good Luck, I know the 2011 Payroll Year-End close will be a breeze for you!


Read the original post:
2011 U.S. Payroll Year-End Update Releases!!

November 17, 2011 · Terry Heley MSFT · No Comments
Tags: , , , ,  · Posted in: Blogs I Follow Total Views: 569

Codename GP "12" Preliminary Features Series – 1 of 4

DISCLAIMER: These features are subject to change.

I am only repeating what I have heard so please don’t shoot the messenger. With GP “12” to be released “sometimes next year” – and yes, December 31, 2012 is still within that time frame – there may still be features on the following list that may not make the cut. However, it was fairly clear that the boys and girls on the Microsoft Dynamics GP development team in Fargo are working their rears off to get the feature list to a state where they feel pretty comfortable, meeting the demands on the shopping list.

Straight out of GPUG Summit’s closing session, comes some of the top features being worked on, based on the traditional 4 pillar goals:

4 Core Design Pillars

Each pillar allows the engineering team to showcase a list of features that will support the objectives behind pillar.


The PM Reprint Check Remittance, for instance, will allow users to re-print the check remittance without having to generate the check.

Improvements have also been considered for the FA Calendar Setup feature. In this case, the Fixed Assets calendar does not have to match the fiscal calendar. You can now have multiple calendars, for example, having an asset depreciate on a fiscal year for tax purposes, if tax year and fiscal year are different, and depreciate calendar year for financial reporting purposes.
The Journal Entry History Inquiry will see enhancements too. In today’s world, the existing window only looks at the open tables. The plan for GP “12” is to have it look at both open and/or history.

In the reporting area, you will be delighted to know that you will now be able to choose a printer at print time. This feature was only 20 years in the making, but it’s finally here! Hey, I remember like if it was yesterday, when Windows True Type fonts became a standard part of Report Writer reports. Before that, we only had 4 fonts to play with. Challenge: name the 4 fonts available prior to the introduction of True Type fonts.

SSRS Simplicity

In addition to the printer at print time, one of the most awaited features is the ability to print SSRS reports from right within Microsoft Dynamics GP, this is, you will no longer need to wait for the Internet Explorer browser to load Report Server to display the report and will rather see the report from within GP as if you were looking at a Report Writer report in the report layout window… ah, and before I forget, Report Writer will eventually be phased out as the predominant options to render reports.

I don’t know how this plays with all that Word Template functionality released fairly recently, but I am sure a lot of you will jump on one feet in happiness knowing that you no longer will need to suffer through the tortuous process of customizing a report. My instinct tells me, that Report Writer will mainly subsists as a data delivery mechanism for XML files needed for your beloved Word Templates. If history and memory serve me well, Microsoft rarely gets rid of a working function within its products, except it becomes as annoying as the Office Paperclip Assistant. Now that I come to think, Report Writer is got to be up there for a lot of you.

I will continue tomorrow with the Productivity pillar.
Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

More here:
Codename GP "12" Preliminary Features Series – 1 of 4

November 17, 2011 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 464

2011 US Payroll Year End Updates for GP 10 and GP 2010 are now available!

David Meego - Click for blog homepageThe English downloads for the 2011 US Payroll Year End Updates for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 are now available. Thanks to all the development and support team members who worked on this.

The following product have been update for GP 2010 and v10.0:

Product  GP 2010  v10.0  
Microsoft Dynamics GP  11.00.1860  10.00.1779 
Dexterity  11.00.354  N/A 
Project Accounting  11.00.1856  10.00.1776 
Fixed Assets  11.00.1835  10.00.1768 
Manufacturing  11.00.1832  10.00.1775 
Field Service  11.00.1834  N/A 
Extender  11.0.43  N/A 

Below are the download links: 


Microsoft Dynamics GP 2010




Microsoft Dynamics GP 10.0




Make sure you watch out the Microsoft Dynamics GP Year End Closing Tips Video.

To keep up to date with all the latest news check out the Dynamics GP Support and Services Blog, they already have articles about the Year End release:



More here:
2011 US Payroll Year End Updates for GP 10 and GP 2010 are now available!

November 17, 2011 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 896

ERROR: A valid exchange rate could not be found. Choose Continue to open the Exchange Rate Entry window, where you can enter or select a valid date.

The following was the message one of the users received when she tried entering a Receiving Entry.

The currency was GBP and there was indeed a valid exchange rate that’s been uploaded on a daily basis. The rate validity duration is set to “Week”. That means, I have a rate which is valid till 23-Nov-2011.

The user mentioned to me that when she uses a particular batch, this message is thrown up. If any other batch is used, it picks up a rate without any issues.

When I checked the batch, I found the reason behind the issue.

Posting date of that batch was in future. This user had created a batch with the last day of this month as posting date, for which I don’t have a valid rate in the system. When I select this batch and then enter the currency, GP does not find a valid rate and throws above error message.

By default, the exchange rate for a transaction is taken from either the transaction date OR the batch posting date, if a batch is assigned before the currency is entered.

The user do not post the batch itself and always post individual transaction. Keeping this on mind, I had to recommend her in changing the posting date of that batch as first date of the month, so we always have a valid exchange rate for all currencies.

It’s quite a simple concept, but is very VERY critical.


See the original post:
ERROR: A valid exchange rate could not be found. Choose Continue to open the Exchange Rate Entry window, where you can enter or select a valid date.

November 17, 2011 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 868