• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

HR/PR Add In Query

 8 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
6/1/2011 3:46 PM
Hi-First time poster here & just getting familiar with the Add Ins.

I've been able to set up my query to capture most fields out of Lawson for purposes of budgeting. However, I'm stumped on this:

We have numerous employees whose time is split amongst mutiple departments on a permanent basis & when they are paid it is being coded in this fashion.

However, when I go to run my query I can only seem to find their home department in the download.

Are there fields within the tables I should be looking for to find this information so that I will see certain employees listed multiple times in my data extraction?

Hope this makes sense & thanks in advance

Jeff
sleow
Basic Member Send Private Message
Posts: 15
Basic Member
6/1/2011 4:11 PM
Jeff,

I think the records for the split are coming from the PR23 and you would need to get the split from there. If you are looking for future you would need to use the EMPDISTMAST field in the PR table. Not sure where you are starting to get the relationship.


Sally
John Henley
Send Private Message
Posts: 3351
6/1/2011 4:18 PM
If you are using the AddIns, you can query directly to EMPDISTMAST, or pick it as a related table from the EMPLOYEE table.
Thanks for using the LawsonGuru.com forums!
John
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
6/1/2011 4:37 PM
Sally & John, Thanks! Sally-I started with the HR/Employee section & then dug into the relationships from there. I just cant seem to get the query to return data that would show an employee multiple times-Am I expecting too much? For example, let's say George works in 4 departments evenly split. I'd like to capture each of the 4 departments he worked in & the hours/gross dollars for each of those departments. Right now all I can get is the department he is assigned to as his home department in HR-While you'd normally use the PR23 to set up the splits, we use an internally developed form-KP23.1 for our use to set these up-could I be encountering an issue because of this? Thanks again
Karen Ploof
Veteran Member Send Private Message
Posts: 118
Veteran Member
6/1/2011 4:55 PM
Jeff, are you trying to get info about payments that have already been made or info about the 4-department split that will be made in future payments? If you're trying to get data on past payments, then try PRDISTRIB; if you're trying to get data on future splits then you'll have to get the file name for your KP23.1 from your IT department.
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
6/1/2011 5:01 PM
Karen-I'm trying to get past payments-I will try PRDISTRIB and see what I get. Thanks for the suggestion.
sleow
Basic Member Send Private Message
Posts: 15
Basic Member
6/1/2011 5:05 PM
Jeff,

Karen is correct PRDISTRIB would work for past payment information.

Sorry sent you the wrong way. (were you limiting your Maxium OTM Values to return?)
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
6/1/2011 5:16 PM
Ahh-that is a new term-what are the OTM values? Mine is set to 1.....
sleow
Basic Member Send Private Message
Posts: 15
Basic Member
6/1/2011 5:42 PM
Jeff,

This is where you select the one to one relationship or one to many... with the 1 here that is why you are only getting the 1 change this to 999 and all records should display.