Page 1 of 5112345678910...2025303540...Last »

How to update the Inactive status for a Benefit/Deduction in mass in Human Resources

Hi Guys..

Occasionally we come across a situation where we have to inactivate/activate deductions and benefits in mass. Gladly i stumbled upon an article in the kb that does the task marvelously.

check it out..
Cheers..

How to update the Inactive status for a Benefit/Deduction in mass in Human Resources

When you run the HR Reconcile utility for ‘Update Benefit Setup’ and “Update Benefit Enrollment’, the gets created on the HR side even for Benefit and Deduction codes that are Inactive  on the Payroll side. If you want to also set them to be inactive on the HR side, the only current functionality is to mark the code inactive in the HR Enrollment window one employee at a time. The ‘main’ setup for the code does not have an Inactive field that to roll down, so there is not functionality to do this in mass.  How can you also set the Benefit/Deduction codes to be inactive on the HR side all at once?
Current design to only update one employee/code at a time.
Current design to only update one employee/code at a time.
To inactivate the benefit and deduction codes in mass, run the below SQL scripts…
To inactivate the benefit and deduction codes in mass, run the below SQL scripts below against the company database in SQL Server Management Studio for the scenario that fits your needs:

*Before running any update script, it is always recommended to make a current backup copy of the company database first!

Scenario 1: DEDUCTIONS ONLY: The first script below will ‘find’ where the status code on the deduction on the HR side does not match the status code on the same code in the Payroll Deduction Master table, so you can view what codes do not match.  Then run the second script to ‘update’ the status on the HR side and the End Date, to match the status and End Date as stored on the Payroll side. Run these scripts against the company database to affect deduction codes only:

DEDUCTIONS:
—————————————
Select a.EMPLOYID, a.deducton as ‘Deduction’, b.inactive as ‘HR_Active’,
a.inactive as ‘Payroll_Active’, a.DEDENDDT as ‘DED End date’
from UPR00500 a
join BE010130 b
on a.EMPLOYID = b.EMPID_I
and a.DEDUCTON = b.BENEFIT
where a.INACTIVE <> b. inactive
—————————————
update a set a.inactive = b.inactive, a.BNFENDDT = b.DEDENDDT
from BE010130 a
join UPR00500 b
on b.EMPLOYID = a.EMPID_I
and b.DEDUCTON = a.BENEFIT
where b.INACTIVE <> a.INACTIVE
——————————-
IMPORTANT NOTE: The benefit and deduction codes may have the same code ID, and are stored in two different tables on the Payroll side (UPR00500 and UPR00600), however, they are stored together as one record in only one table on the HR side (BE010130). So take note what script you ran last as it will overwrite the status and End Date on the record in HR, and will apply to both the benefit and deduction on the HR side. So if you have any instances where the deduction is inactive, but the benefit is active (or visa versa), you will need to pay attention to what script you ran last. It is recommended for these situations to view the code in the front-end and activate back the one needed in the front-end.

Scenario 2: BENEFITS ONLY:  The first script below will ‘find’ where the status code on the benefit on the HR side does not match the status code on the same code in the Payroll Benefit Master table, so you can view what codes do not match. Then run the second script to ‘update’ the status on the HR side and the End Date, to match the status and End Date as stored on the Payroll side. Run these scripts against the company database to affect benefit codes only:

BENEFITS:
—————————————
Select a.EMPLOYID, a.BENEFIT as ‘Paycode’, b.inactive as ‘HR_inactive’,
a.inactive as ‘Payroll_inactive’, a.BNFENDDT as ‘BEN End date’
from UPR00600 a
join BE010130 b
on a.EMPLOYID = b.EMPID_I
and a. BENEFIT = b.BENEFIT
where a.INACTIVE <> b. inactive
—————————————
update a set a.inactive = b.inactive, a.BNFENDDT = b.BNFENDDT
from BE010130 a
join UPR00600 b
on b.EMPLOYID = a.EMPID_I
and b.BENEFIT = a.BENEFIT
where b.INACTIVE <> a.INACTIVE
—————————————
IMPORTANT NOTE: The benefit and deduction codes may have the same code ID, and are stored in two different tables on the Payroll side (UPR00500 and UPR00600), however, they are stored together as one record in only one table on the HR side (BE010130). So take note what script you ran last above as it will overwrite the status and End Date on the record in HR, and will apply to both the benefit and deduction on the HR side. So if you have any instances where the benefit is inactive, but the deduction is active (or visa versa), you will need to pay attention to what script you ran last. It is recommended for these situations to view the code in the front-end and activate back the one needed in the front-end.

Scenario 3: ALL: Use this script if you know a code (benefit and deduction) is inactive on the Payroll side for ‘all’ employees, and you just want to update the status for all the employees enrolled in it on the HR side too: (The first script will find all records for that code, whether a benefit or deduction, where it is not inactive on the HR side, and the second script will update the status for that code to be inactive for all employees enrolled in it on the HR side.)

Select * from BE010130 where BENEFITSTATUS_I <> ‘2’ and BENEFIT = ‘xxx’
—————————————————————
update BE010130 set BENEFITSTATUS_I = ‘2’ where BENEFIT = ‘xxx’
–update the xxx placeholder for the benefit or deduction code that you would like to mark as inactive on the HR side. Note that this script just sets the INACTIVE status and does not update the Benefit/Deduction End Date on the HR side. Also refer to the note above in Scenario 2.

Benefit Status values mean:
1=active
2=inactive
3=waived

Applies to
  • Microsoft Dynamics GP 2015
  • Microsoft Dynamics GP 2013
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0, when used with:
    • Human Resources
    • Human Resources Management

View article:
How to update the Inactive status for a Benefit/Deduction in mass in Human Resources

April 16, 2015 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 91

Pro Power Tools for Microsoft Dynamics GP

David Musgrave is looking at revamping, and recharging the amazing, but awfully named Support Debugging tools. My suggestion to David has been to name them Pro Power Tools – what do you think about the name ? Tell David Directly at Where is the Support Debugging Tool for Microsoft Dynamics GP 2015?

If you have been living under a rock and don’t know what the SDT is read all about it here – Support Debugging Tool for Microsoft Dynamics GP (SDT).

Read More:
Pro Power Tools for Microsoft Dynamics GP

February 20, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 120

Dynamics AX – Purchase Order Cycle & Accounting Process (Order, Receipt & Invoices)

Fawad has written a nice and simple post explaining the purchase order process and its accounting entries in Dynamics AX. This really helps for the basic understanding.
Read the complete step by step accounting entries & their effect by each journal on his details post by clicking the link below

Happy Dynamics & Enjoy Learning!

Taken from:
Dynamics AX – Purchase Order Cycle & Accounting Process (Order, Receipt & Invoices)

December 13, 2014 · Waqas Butt · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 157

Dynamics AX 2013 – Royalties Management Step By Step Process

While working on some requirements I came across a very nicely written article on how to use & step royalties management in Dynamics AX 2013 .  
Fawad has written a very detailed post on his blog ( http://fawadb.blogspot.com) on the steps and usage of royalties management in Dynamics AX 2013.
Enjoy reading the completed post by click the below link

Happy Dynamics & Enjoy Learning!

More:
Dynamics AX 2013 – Royalties Management Step By Step Process

December 12, 2014 · Waqas Butt · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 106

eOne’s release plans with Microsoft Dynamics GP 2015

We have been getting requests already for the 2015 builds of the eOne products now that Microsoft has released Microsoft Dynamics GP 2015. So, we wanted to let you know our plans around the releases.

We are hard at work on getting everything ready in all of our products for Microsoft Dynamics GP 2015. We want to be able to add some great new features for you and make sure everything is working

More:
eOne’s release plans with Microsoft Dynamics GP 2015

December 10, 2014 · Nicole Albertson · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 121

MDGP 2013 R2 Feature of the Day: Default Sort Order … – azurecurve

The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them …

Visit site:
MDGP 2013 R2 Feature of the Day: Default Sort Order … – azurecurve

May 27, 2014 · Ian Grieve · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 145

MDGP 2013 R2 Feature of the Day: Workflow User … – azurecurve

The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them …

More here:
MDGP 2013 R2 Feature of the Day: Workflow User … – azurecurve

May 24, 2014 · Ian Grieve · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 133