Mass Delete Arrears

Hi there,

As a result of furloughs and reduction in force related to the COVID-19 situation, we are going to have to mass delete one-time deductions for employees that are in arrears.

How do folks do this? I was hoping we could use an Add-In, but the Lawson-provided Add-In template is disregarding sequence number and wiping out all arrears for the given employee. (I even checked with Don Peterson, but it seems as though the PR39 just can't handle the individual deduction delete.) We might be okay with that in some cases, but in other cases we don't want to delete all deduction codes from the employee record, only certain ones.

I understand that the PR139 can also delete deductions, but our Payroll Manager explained to me it can only delete one pay period at a time.

Any other ideas?

Thanks,

Frannie

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Accepted answers

All comments

unknown

Hi Frannie, the PR539 (One Time Deduction Load) looks like it can delete arrears. The file layout shows that D is an option for the function code, and it does allow you to specify a sequence number. I am attaching the v10 layout.

[View:/cfs-file/__key/communityserver-discussions-components-files/18/PRFL_5F00_10.0.9.0.xls:320:240]

unknown

You can use the PR539 Conversion program. Your file should look like this:

OtdFc	OtdCompany	OtdEmployee	OtdDedCode	OtdDedAmt	OtdEffectDate	OtdStatus	OtdCheckGrp	OtdDedPriority	OtdCheckDesc	OtdSeqNbr	OtdEdmSeqNbr
D	100	10434	W010	4.92	8/14/2020					9999

Your job def header should be set to 'Y'

Query pr39 for the deductions you want to remove the arrears for and be sure to get the ‘OtdSeqNbr’ for each record. When you query pr39 this will be the ‘SEQ-NBR ‘.

unknown

Thank you both @pbelsky and @barbara-gutierrez - this worked in our Test environment!

Copyright © 2025 Infor. All rights reserved.