Payroll Tax Round 2 for GP2010 for year 2011 UPDATE

The KB article announced on January 26th (KB2477921) is still a no-show. That means the GP2010 Round 2 (aka, we’ve fixed the 4.2 – 6.2 FICA problem) is not available. The version 10 code is available, but that seems to be all.

We all wait with anticipation for the release of the real code update.

Stay tuned!

Find anything GP thank you Mark Polino!

MVP Mark Polino is at it again. As if it wasn’t enough to write the ultimate tips and tricks book in Microsoft Dynamics GP 2010 Cookbook, he has developed a new web search called My GP Search. This is an amazing piece of work! Find it HERE. It’s a simple one-stop search engine for GP related information. I do not know where he finds time to do so much. Just three years ago we didn’t have blogs or communities or all the sites we rely on today for GP information. Today we can find nearly anything. So much information is now available that it is hard to find everything. Well, those days of going from blog to blog are over! Check it out!

How is FICA/S wages and withholding calculated?

It’s that time of year again! W-2s are due out early next week and we are just now looking at the numbers. You know who you are!

Have you ever noticed a difference between the Social Security Wages and withholding reported on the Form W-2 and the amounts in the Employee Summary record?

Understanding the relationships between the components listed below can be challenging. This post intends to clarify the inter-relationship between these items and the amounts recorded as Social Security wages and Social Security tax withheld.

Below are the components I discuss:

• The Year-end Wage Report
• The W-2 Validation Report
• The amounts displayed in the Edit W-2 window
• The amounts that print on the W-2
• The amounts that print on the W-3

Payroll Year-end close

1. When the year is closed the year-end wage file is created. The system captures the actual amounts from the employee summary record. The FICA limit and percentage in effect when the year-end wage file is created are also captured.

2. The Year-end Wage Report reads from the year-end wage file, so it shows the actual amounts withheld regardless of the limits

3. The Validation Report does two things

a. Compares the FICA wages recorded in the year-end wage file to the FICA wage limit that was captured when the year-end wage file was created

b. Calculates what FICA withholding should have been in accordance with the FICA wage limit and percentage captured when the year-end wage file was created

c. Any differences are reported on the Validation Report

4. The W-2 form that appears in the Edit W-2 window is reading the year-end wage file, so it shows the actual amounts withheld

5. The amount that appears in the Social Security Wages W-2 box is the lessor of:

a. The Social Security Wages from the year-end wage file or,

b. The FICA limit captured when the year-end wage file was created.

6. The amount that appears in the Social Security Withheld W-2 box is the lessor of:

a. The amount actually withheld as captured in the year-end wage file or,

b. The amount of the FICA limit in the year-end wage file times the FICA % captured in the year-end wage file. This amount is calculated without regard to the amount recorded in the year-end wage file as Social Security wages.

7. The amounts appearing on the W-3 are the sum of the amounts on the W-2s. The W-3 amounts are not the same as the Year-End wage report amounts.

Have fun with it!
Until next post!

v 9.00.0386 Upgrade Path to GP2010 Gone

Microsoft announced yesterday that currently there is NO upgrade path to GP2010 from version 9.00.0386 (2010 Canadian Payroll Year End Update & 2011 Round 2 Tax Update KB 2492902) until the release of the 2010 Canadian Payroll Year End Update & 2011 Round 2 Tax Update for Microsoft Dynamics GP 2010.

Click HERE to get the latest update document.

Click HERE to download the latest patch for Microsoft Dynamics GP2010.

Payroll Tax Round 2 for GP2010 for year 2011

Microsoft announced that the much anticipated Round 2 for GP2010 is out. The update filename is MicrosoftDynamicsGP11-KB2477921-ENU.msp (for U.S. English).

Read about it here: https://mbs.microsoft.com/partnersource/downloads/taxupdates/usgptu10.htm?printpage=false

The Tax Tables themselves are here: TX.cab Round 2

Here is an excerpt from the U.S. 2011 January Payroll Tax Update For Microsoft Dynamics ® GP Round 2

“Installation is divided into two portions: the tax table update and the program code update. Installing the tax table update is required for all states included in the Round 2 update.

To install the tax table update:

You can run the tax update installation from any workstation. The update installs payroll tax table data on the server computer where your existing Microsoft Dynamics GP application data is located. You need to install the tax table update only once.

To install the program code update:

You need to install the update on the server as well as every workstation that runs Microsoft Dynamics GP.

Installation instructions vary, depending on the release you are using. Follow instructions for the release you are using:

Installing the program code update for Release 9.0 (links to a different part of the document)

Installing the program code update for Microsoft Dynamics GP 2010 or Release 10.0 (links to a different part of the document)

Before you begin, ask all Microsoft Dynamics GP users to exit the application until the update is complete. Exit all other applications, turn off the screen saver, and back up important data (including Forms.dic, Reports.dic, and Dynamics.vba if they exist) before you proceed with the installation.

Note: The Payroll Update Engine, which is used to install the tax table update, is not supported on 64-bit operating systems when running Release 9.0, or Release 10.0 prior to Service Pack 3. For more information, refer to the Knowledge Base article at

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;947191

(https://mbs.microsoft.com/customersource/support/downloads/servicepacks or https://mbs.microsoft.com/customersource/support/downloads/taxupdates/.

Microsoft Dynamics GP 10.0:

The update filenames are:

MicrosoftDynamicsGP-KB2477916-v10-ENU.exe (for U.S. English) and

MicrosoftDynamicsGP-KB2477917-v10-ESLA.exe (for Latin American Spanish).

Microsoft Dynamics GP 2010:

The update filename is MicrosoftDynamicsGP11-KB2477921-ENU.msp (for U.S. English) and

MicrosoftDynamicsGP11-KB2477922-ENU.msp (for Latin American Spanish).

The file incorporates all previous code updates, including Microsoft Dynamics GP 2010 and Release 10.0 Service Pack 5, the 2010 U.S. Payroll year-end update, and all recent hotfixes. If you are using Canadian Payroll, it also includes the Canadian 2010 Year-End Update/2011 Tax Update, as well as all previous Canadian Payroll tax updates.”

Stay tuned for upgrade path changes.

Until next post!