• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Data extract field

 5 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
7/18/2011 4:15 PM
I'm currently trying to use MS Add-In to extract data from the Payroll system.  Specifically I am looking to get employee information including those employees whose bi-weekly hours are set to a fixed distribution.  I've looked high & low and cant seem to find a field.    HM-ACCT-UNIT is no problem, I get their home department but I cant find the other field I've mentioned.  Does such a field exist & if so where?  Thanks Jeff
Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
7/18/2011 4:33 PM
PR23 / EMDISTMAST ?
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
7/18/2011 4:36 PM
Fomr PR23
stephanie
New Member Send Private Message
Posts: 0
New Member
7/18/2011 4:37 PM
Not knowing how you're set up I'm just tossing this out - perhaps try querying EMPDISTMAST?
Jeff in PA
Basic Member Send Private Message
Posts: 7
Basic Member
7/18/2011 4:46 PM
Stephanie-Thanks, tried using that & am getting closer. By using a field in EMPDIST MAST I am now able to get one of their allocated departments, but we have many employees who are in more than one. Is there a way to return multiple departments? I have my OTM set for 10 but I'm not sure how I can accompplish getting more than one allocation...thanks!
stephanie
New Member Send Private Message
Posts: 0
New Member
7/18/2011 5:01 PM
Maybe you can start with the EMPLOYEE table, then tie EMPDISTMAST and maybe PAEMPPOS if needed? We don't use the distributions functionality here, so I'm pulling from my (a very small) memory pool.... Do you know an individual who has multiple distributions? Sometimes the fields can be cryptic, but if you know at least one ee nbr, you can just query them to get what you need, then open it up for others after that. Sorry I can't be more definitive!