PR14

Hello. How do I run a report for PR14 in add-ins? We key all out 401k LOANs only in the PR14 screen. I need to run a report of everyone who has a Loan in this screen but I can't seen to figure out how to do it. Thank you in advance!

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

unknown

Using Database Tables as query source,

Select System Codes=PR, Table=EMDEDMASTR, and all fields you want to see. Then, define data selection usingdeduction code and amount as criteria as below.

DED-CODE=(your deduction code for 401K LOAN)

and NEXT-AMOUNT=! ""

Above criteria will look for all employees with 401K LOAN deduction code assigned in PR14.1 only if amount field is not null.

karin-jensen

I hadn't done it with add-ins till I tried a quick query just now, but I didn't have any problems when I set it up using the EMDEDMASTR table. What I've done in the past is run a PR214 report on that deduction code and export the results to excel. Unfortunately, the PR214 doesn't let you choose a date range, so you have to check your effective begin and end dates. It gives you as much information as you could want about the set-up for each person's PR14 record without you having to build a query.

Copyright © 2025 Infor. All rights reserved.