Update Age Based Employee Procedure

(0) Share

Report

Posted on by ShawnMD

1,456 User Group Leader

A process runs when the first user of the day logs into a company, everyday. It is driven from the HR Module and pertains to life insurance. The process is called HR_Update_Age_Based_Employee.

When the process is running, it prevents you from switching companies. In our main company, this is not an issue, but everytime I log into our test company to try something quickly, if I am the first of the day (and most times I am), I must wait about 10-15 minutes before I can switch back because this process is running.

This is how it is expected to run, per the printable documentation from the module. so it's not an issue of something "wrong", I just want to know if anyone knows of a way to disable this and/or more this process to a stored procedure that runs on the sql server every morning at like 3am when noone is here?

Thoughts? Suggestions?

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Terry R Heley Microsoft Employee on at

Like (0)

Report

Hi Shawn,

My name is Terry and I can provide assistance today.

Disabling Age Based Life Insurance

While there isn't a way to disable age based life insurance in our system if you choose to set it up, I can give you information about how our system does this so you may create a custom update if you desire. I hope this is helpful:

As long as you keep the table populated with the record so the system thinks it has already calculated this each day, you would be ok:

This update process runs as you stated, when the first user logs into Microsoft Dynamics GP for the day. I ran a dexlog on this and found the following pertaining to our process:

/* Date: 03/06/2010 Time: 13:59:33

stmt(15744008):*/

EXEC TWO.dbo.zDP_SY01401F_1 NULL,NULL,NULL,NULL

/* Date: 03/06/2010 Time: 13:59:33

stmt(15744008):*/

EXEC TWO.dbo.zDP_SY01401SS_1 'sa', -2

/* Date: 03/06/2010 Time: 13:59:33

stmt(15741544):*/

BEGIN UPDATE TWO.dbo.SY01401 SET USRDFSTR = '3/6/2010' WHERE USRDFSTR = '3/2/2010' AND USERID = 'sa' AND coDefaultType = -2 SELECT @@rowcount END

/* Date: 03/06/2010 Time: 13:59:34

stmt(15741544):*/

EXEC TWO.dbo.zDP_ReportPublishersF_1 'sa',-32768,-32768,'','','sa',32767,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'

/* Date: 03/06/2010 Time: 13:59:34

stmt(15703800):*/

EXEC DYNAMICS.dbo.zDP_SY02100SS_1 -1, 414, 10, 0

/* Date: 03/06/2010 Time: 13:59:34

stmt(15744008):*/

SELECT COUNT(BENEFITKIND_I) FROM TWO.dbo.BE010130 WHERE BENEFITKIND_I = 2

/* Date: 03/06/2010 Time: 13:59:34

stmt(15741544):*/

EXEC TWO.dbo.zDP_BE010130F_5 2,'','',2,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞ'

If our code sees that you already have a record in the SY01402 where coDefaultType = -2 and USRDFSTR = today's date, the process does not run. So, you would want to update this table with such a record before any users log in each day and that would prevent the age based update from happening.

In your case, you may just want to do this for the TEST company.

Hope this helps, thanks!

Terry Heley

Online Technical Community

-----------------------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

Hi Terry,

Does this solution also apply to Gp2010 and GP2013?

Thanks,

Was this reply helpful? Yes No
Terry R Heley Microsoft Employee on at

Like (1)

Report

Yes it does. Thanks

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

thanks Terry!

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

Hi Terry, you mention table SY01402, in the log you showed above, there is no table SY01402. Did you mean table SY01401? Also, is there anything that needs to be deleted in table SY01402? I tested using table SY01401 and it doesn't seem to be working. I am only testing table SY01401 though not SY01402 that's why I asked. I tested this in GP2013.

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

I tested in GP2013 -FYI.

Was this reply helpful? Yes No
ShawnMD 1,456 User Group Leader on at

Like (0)

Report

are you testing on Fabrikam? If not, did you change "two" to your company database id? The Sy01402 is a system table located in Dynamics database... Just checking in case that wasn't clear. Let me know and ill be glad to help in case Terry is too busy

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

Thanks! Yes, I am testing in Fabrikam.

Was this reply helpful? Yes No
ShawnMD 1,456 User Group Leader on at

Like (0)

Report

Ok, great! So the 02 table is the system table and the 01 is the company table. This runs on a company level so it's the "-2" and today's date in the company table that you are looking for... Update any user name in that table that already has a coDefaultType = -2 and update it's coUSRDFSTR value to tomorrow's date.... then, tomorrow, log in and it should not run (if noone has logged in today, you can use today's date as a test). This will need to be done in a job that runs every day and all it really needs to do is change the date value to current date. If this job runs at like 2 am, noone will ever pick that process up... Keep in mind, it will also prevent calculations for your life insurance age based premiums.... so doing it in TEST is really the only place you should do this...

Was this reply helpful? Yes No
Regie on at

Like (0)

Report

Shawn, thanks for the info but I am already doing this test. My question is do I need to update the 02 table, from your description and Terry's description, looks like the answer is no, correct?

Was this reply helpful? Yes No

Community site session details

Update Age Based Employee Procedure

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

Update Age Based Employee Procedure

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates