401k Strikes a match (Microsoft 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.

Originally Posted 5/7/2011

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.

Continue reading “401k Strikes a match (Microsoft Dynamics GP Benefit to Deduction)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 4 of a 4-Part Series

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) in Power BI (Video)

This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 3 of a 4-Part Series

This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)

This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.

Part 2 of a 4-Part Series

This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) in Power BI (Video)

Last week a Microsoft Dynamics GP user asked a question in the user group form http://www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 1 of a 4-Part Series

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

This 8-ish minute video reviews the Pros and Cons of 3 different method of obtaining the employee head count.  I review the method the initial user (who asked the question) used and the two recommendations that another user and I provided.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) in Power BI (Video)”

Microsoft Dynamics GP 2017 Payroll tax update information

Here is an update of the latest Payroll Tax Update information from Microsoft’s own Terry Heley for Microsoft Dynamics GP.

Here is an update of the latest Payroll Tax Update information from Microsoft’s own Terry Heley for Microsoft Dynamics GP.

Continue reading “Microsoft Dynamics GP 2017 Payroll tax update information”

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!

Originally Posted on August 9, 2013

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!

Continue reading “How to track changes in Payroll in Microsoft Dynamics GP (with video)”

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. 

 

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.

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.

Continue reading “Build Check Exception Report in Microsoft Dynamics GP Payroll”

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.

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.

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.

Continue reading “Removing the Social Security # on the Payroll Check Register in Microsoft Dynamics GP”

Controlling when to use Payroll Deductions in Microsoft Dynamics GP

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 in Microsoft Dynamics GP so that they are only associated with one of the pay types/cycles?

Puppet

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 in Microsoft Dynamics GP so that they are only associated with one of the pay types/cycles?

Originally Posted 07/29/2013

Continue reading “Controlling when to use Payroll Deductions in Microsoft Dynamics GP”