Belinda Allen, Smith & Allen Consulting, Inc. (SACI) aka Belinda the GP CSI.  Microsoft Professional, MCT and MVP.describe the imagedescribe the image

Follow Me

MICROSOFT DYNAMICS GP COMMUNITY

If you are not a member of the Microsoft Dynamics GP Community, you should be, I am a member.

There is loads of good information, including a forum that I actively answer.

Click on this link to go to the Microsoft Dynamics Community!

Search this Blog

Loading

Subscribe by Email

Your email:

Need Microsoft Dynamics GP Forms?

Purchase Deluxe Products

Click on the image above to find your compatible Microsoft Dynamics GP forms from Deluxe For Business.

Click HERE to download Brochure.

This is all about how I use GP, based on what I learned in my investigations with clients...

Current Articles | RSS Feed RSS Feed

Microsoft Dynamcis GP 2013 US Payroll Year End Update has RELEASED!!!

  
  
  
  
  

Email From: 

Terry Heley - Escalation Engineer - Microsoft Dynamics GP

Download W-2 Wage and Tax Statement and Data Source Guide HERE

 

Download U.S. 2013 Year-End Update guide HERE


GP 2013 year end is ready to release, yeah!

It will be on the site below in about an hour

Here is the direct link to get it now

MicrosoftDynamicsGP12-KB2897363-ENU.msp

https://mbs2.microsoft.com/fileexchange/?fileID=15d9edac-266c-48d8-95e2-37d68a1588dc

GP 2013 SP 2 Translations are ready to release for French and Spanish, I will get that notice out tomorrow.

We now need to work on Canadian Payroll releases in mid-December and the changes their agency provides (we are still waiting for notice)

Belinda, of Smith & Allen Consulting in New York, NY shares Year End payroll information for Microsoft Dynamics GP.

Happy to announce ahead of schedule the US Year-end changes have released for GP 2010 

Below are the sites that list all the changes, the pages below will synch shortly and you will see it listed.

This update is all inclusive of prior updates for Microsoft Dynamics GP 2010 and GP 2013.

You can start to install and get the MSP via the link below for 2010 now:

https://mbs2.microsoft.com/fileexchange/?fileID=d85e8ceb-e263-49ac-bd6a-39b08025ba1e

Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2010

Once you install the update, your version for GP 2010 will be    11.00.2292

(Also changes to Project Accounting, Fixed Assets, Human Resource, Field Service, Payroll Extensions, Advanced HR)

Microsoft Dynamics GP 2013

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2013

Once you install the update, your version for GP 2013 will be    12.00.1538

(Also changes to Project Accounting, Fixed Assets, Manufacturing, Human Resource, Field Service, Cashbook, Analytical Accounting,
Payroll Extensions, Advanced HR)

2014 US Payroll Round 1 Tax Update (due to release week of 12/16)

Changes so far: (circular E not final)

FICA Social Security limit, California, Kansas, Maryland, North Carolina

Please Note: The 2013 Year-End Update and 2014 Tax Updates will not be available for Microsoft Dynamics GP 10.0 and prior versions.

IMPORTANT TO NOTE THIS YEAR IF YOU USE BUSINESS PORTAL HRMSS:

 

If you are using Microsoft Dynamics GP 2013 SP 2 or above AND you use Business Portal Human Resource Self Service Suite you will need to install the BP Hotfix.

There were table changes made in GP 2013 Service Pack 2 around Payroll Direct Deposit affected Business Portal Human Resource Self Service functionality.

Please refer to my blog 'Microsoft Dynamics GP 2013 Service Pack 2 does not seem to play NICE with Business Portal Human Resource Self Service Suite 6.0' for further details around this:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/11/05/microsoft-dynamics-gp-2013-service-pack-2-does-not-seem-to-play-nice-with-business-portal-human-resource-self-service-suite-6-0.aspx

If you have employees that make over $200.000 you should install the year end update, this is also noted in the changes section.

If you do not install the year end update, when the year end file is created, it will grab an incorrect Medicare limit in the year end file.

If the Year End Update is not installed prior to closing Payroll:

W2 Medicare Taxable Wages may be incorrect on printed W2's (Box 5) for employees making more than 200,000.
Workaround this by updating the FICAMWLM field in the UPR10100 table as follows:
UPDATE UPR10100 set FICAMWLM=' ' WHERE RPTNGYR ='2013'
If you install the year end update you will not have this issue, if you do not have employees that make over 200,000 you also will not see this issue.

The Connect has been changed for year-end and we have a blog featured each week for different modules, check it out!

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/11/07/back-by-popular-demand-microsoft-dynamics-gp-year-end-closing-blog-series-for-2013.aspx

Once US is out the door, we will focus on Canadian Payroll 

We are currently waiting changes for Canadian Payroll
The recent change to the ROE file submission will be in the year end update when it releases.

****Translations for GP 2013 SP 2 should release this week as well for French and Spanish.*****

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: 

How to track changes in Payroll in Microsoft Dynamics GP (with video)

  
  
  
  
  

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked.  In this video, I show you how!

 

Belinda, from Smith & Allen Consulting, Inc. in New York City shows how to use a free utility to track all payroll changes.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: ,

Removing the Social Security # on the Payroll Check Register in Microsoft Dynamics GP

  
  
  
  
  

For those who want to remove the Social Security Number from the (US) Payroll Check Register in Microsoft Dynamics GP, this video is for you.

Belinda, from Smith & Allen Consulting, Inc. in New York City provides an answer to a question from a GPUG class.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Build Check Exception Report in Microsoft Dynamics GP Payroll

  
  
  
  
  

During a GPUG (Microsoft Dynamics GP User Group) training class, a student shared that their biggest issue was in not receiving an error message when there is a posting account missing. 

In this video I show the new Microsoft Dynamics GP 2013 feature “Build Check Exception” report. 

This is for you Cathy!

Belinda, from Smith & Allen Consulting, Inc. in New York City, shows a new Microsoft Dynamics GP Payroll feature.
Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Changing ID’s in Microsoft Dynamics GP Payroll (with video)

  
  
  
  
  

In this video I show users how to use a new feature in Microsoft Dynamics GP 2013.  I use the “Pay Code Modifier” to change my pay code.  This feature can also be used for Deduction ID’s and Benefit ID’s.

I also use the FREE Professional Service Tools Library to change an employee ID. 

Finally, I discuss the GP Tool “Detail Payroll Activity Tracking” which is for those who want to track all changes made to employee information.

Belinda, from Smith & Allen Consulting Inc. in New York City, shows changing payroll codes in Microsoft Dynamics GP 2013.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: ,

Using Negative Deductions in Microsoft Dynamics GP (with video)

  
  
  
  
  

Question from a Microsoft Dynamics GP Payroll User

Question:  I use manual check entry to re-pay a deduction that was taken in error.  Is there a better way to do that? 

Answer:  Yes, use a negative deduction!

Watch this video and see how I do this in Microsoft Dynamics GP.

 

During a recent GPUG payroll training class I was asked about how to handle negative payroll deductions.  A couple of attendees offered up that they pay the employee a $0.01 pay check.  I took this process a step further in my video by utilizing Piecework. 

Another way around it is to pay the employee for one hour of time and deduct that one hour on the next pay check.  This would be a good method if you are dealing with a TSA (Tax Sheltered Annuity) deduction.

During a recent GPUG payroll training class Belinda was asked about how to handle negative payroll deductions in Microsoft Dynamics GP.
Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: 

Controlling when to use Payroll Deductions in Microsoft Dynamics GP

  
  
  
  
  

Question from a Microsoft Dynamics GP Payroll User

We currently have several employees that are paid both on a biweekly and monthly schedule for different types of pay.  We have to manually stop deductions and benefits on one of the pay runs so they do not show up for both types of pay.   Is there a way to mark the deductions and benefits so that they are only associated with one of the pay types/cycles?

Watch this video and see how I use the Microsoft Dynamics GP “Build Check” window to handle this.

Belinda shows how to use the Payroll Build Check Run Window to control deductions in Microsoft Dynamics GP.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: 

Import of Payroll to Dynamics GP from Outside Payroll Service

  
  
  
  
  

This video shows how I suggest data be imported if you use an outside payroll service like ADP, Paychex, etc. I show an Import I setup Integration Manager and Microsoft Dynamics GP.

I also discuss file layout, wash accounts and balancing.

You can also see me edit the general ledger entry after it has been imported.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Printing from Dynamics GP in Bulk

  
  
  
  
  
In this video I review how to setup Report Groups and Combined Reports. This will help when you need to print multiple reports on a regular basis (e.g. Period End Reports, Audit Reports, etc. using Microsoft Dynamics GP.



Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

401k Strikes a match (Dynamics GP Benefit to Deduction)

  
  
  
  
  
This video shows the Microsoft Dynamics GP Deduction AND the Benefit screens for employees with 401k plans. The Benefit is set to match the Employee’s deduction 100%, with both Benefit and Deduction having a maximum amount.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: 
All Posts