Summit Group Software Blog

Yes, the 941 form is changing AGAIN (and AGAIN after this).  If you print the 941 form out of Microsoft Dynamics GP (onto the pre-printed government form), you may notice that the form has changed, effective for the Q1 2010 filing (which is due the end of April, 2010).  If you have not done so already, you will need to load the latest Microsoft Dynamics GP service Pack in order to have these changes update the printing of the 941 form.   The links to the service pack and its instructions are listed below:

Microsoft Dynamics GP 10.0:

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgptu10.htm?printpage=false

  

Microsoft Dynamics GP 9.0:

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgptu9.htm?printpage=false

 

If you choose to install this service pack, IT WILL NEED TO BE INSTALLED ON EVERY SINGLE WORKSTATION RUNNING MICROSOFT DYNAMICS GP.  After installation, the version will read 10.00.1424 for version 10 or 9.00.0375  for version 9.

In addition to the changes to the 941 for Q1, there will be additional changes in Q2, 2010.  There are also a couple of employer credits that the system will need to track.  Microsoft will be releasing the Service Pack for the Q2 changes in mid June.  Again, this service pack will need to be installed on every single workstation running Microsoft Dynamics GP.

If you typically fill out the 941 form “manually” (and do not print it out from GP), you may be able to skip the installation of the Q1 service pack altogether.  For the Q2 changes, however, it may benefit you to apply this service pack, since it is actually tracking new information.  The information on the Q2 changes is listed below:

2010 U.S. Payroll Tax Update for Microsoft Dynamics GP 9.0 and 10.0

Microsoft will release a mid-year tax update in June 2010 that will comply to the recent Hire Act changes required for Quarter 2 reporting.  This will be supported for the following versions: Microsoft Dynamics GP 9.0, 10.0, GP 2010, and SBF 9.0.

The following items are anticipated changes:

1.  There will be a data model change on the Payroll Tax Information Master (UPR00300) to add a checkbox to mark an employee qualified.

2.  The 941 quarter end report will be modified to comply with the Q2 reporting and will include the changes needed to apply the payment for qualified employees from Q1.

3.  Another impact of this change is the W2 and W3 forms.  These changes will be released in the 2010 year end update later this fall.

Link to the IRS website regarding the changes:
http://www.irs.gov/newsroom/article/0,,id=220326,00.html

*Note:  Before performing ANY of the following, please ensure you have a good Database Backup!

On occasion, we have had customers whose payroll print and post checks process bombs.  More often than not this is due to a corrupt Reports.dic.

From the front end of Microsoft Dynamics GP 10, it is difficult (if not impossible) to get the interrupted posting cleaned up, because there are so many things that may or may not have hit the various UPR tables.  Here is a way you can correct this from MS SQL:

1. Take a backup of the Company Database– take note of Vacation Information so that you may be able to return this to where it needed to be after performing all of these steps.

2.  Recreate the Reports.dic (if this is what appears to be causing the problem… you will know this if your Payroll Batch bombs every time it gets to the posting state and reports won’t print out of the system)

3.  Remove all of the Work information with the following delete statements:

Delete UPR10200

Delete UPR10201

Delete UPR10202

Delete UPR10203

Delete UPR10204

Delete UPR10205

Delete UPR10206

Delete UPR10207

Delete UPR10208

Delete UPR10209

Delete UPR10213

Delete UPR10301

Delete UPR19900

Delete UPR19901

(Note, our payroll batch was no longer in the “posting mode” but it also did nothing to print out the gl posting reports.) 

To correct all of the “jumbled mess” in the UPR tables and the Checkbook Register:

1.  Find the audit trails of the pay run that bombed  (In our example we’ll use the following:  UPRCC00001144).

 2.  Run the following MS SQL statements individually against the Dynamics GP company database (the select statement is there so you can see if there is data in that table that relates to the failed pay run):   

select * from dd30100 where auctrlcd=’UPRCC00001144′

delete dd30100 where auctrlcd=’UPRCC00001144′

select * from upr30100 where auctrlcd=’UPRCC00001144′

delete upr30100 where auctrlcd=’UPRCC00001144′

select * from upr30200 where auctrlcd=’UPRCC00001144′

delete upr30200 where auctrlcd=’UPRCC00001144′

select * from upr30300 where auctrlcd=’UPRCC00001144′

delete upr30300 where auctrlcd=’UPRCC00001144′

select * from upr30400 where auctrlcd=’UPRCC00001144′

delete upr30400 where auctrlcd=’UPRCC00001144′

select * from upr30401 where auctrlcd=’UPRCC00001144′

delete upr30401 where auctrlcd=’UPRCC00001144′

 

After running these scripts run Reconcile on all of the Employees with GP Tools>Utilities>Payroll>Reconcile

Check the Employee Summary to see if everything looks ok (as it would have been prior to running this pay run)

Rebuild the batch and going through check printing again. 

You will also need to take steps to correct any Checks that have hit the Bank Rec module.

 

Closing the payroll module at year end does not have to be done in a certain order with the other modules in Microsoft Dynamics GP.  More importantly it has to be done before your run your first payroll for the next year.  Example if you are closing 2009, you must close 2009 payroll before running your first 2010 payrun.

The order of closing all other modules in Dynamics GP is important.  The modules need to be closed in the folllowing order:  Inventory, Receivables, Payables, Fixed Assets and General Ledger.

For 2009, there have been very few form changes to the w-2.  This is great news for Dynamics GP users!

Below are the detail changes around 2009 year end for payroll.  If you are affected by these changes, then you should install the latest GP update.

• 1099-R - New Distribution Code U, for distributions under IRC 404(k), has been added
• 1099-R - Distribution Codes B and U are a valid combination. (not required to be used together)
  • Add country code Kosovo - KV
    • Add country code St Barthelemy - TB
    • Add country code St Martin – RN
      • Updated country code Serbia, changed from RB to RI

The question has been raised:

Does the Dynamics GP W-2 Electronic File format conform to individual State format requirements?

The answer:

The Dynamics GP W-2 Electronic File conforms to Federal filing requirements only.  BUT… if you check with your State, ask them if they will accept the Federal Filing Format.  If they will, then the answer is YES!