HR/PR Add In Query - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Jeff in PA

Basic Member

Posts: 7

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

Posts: 15

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

Posts: 3362

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.

Jeff in PA

Basic Member

Posts: 7

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

Posts: 118

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

Posts: 7

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

Posts: 15

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

Posts: 7

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

Posts: 15

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.