LP35 Purge?

chip-bennett

Is there a way to purge all records in LP35 vs. one-by-one?

Adage User Group_October 2020.pdf

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

unknown

LP353 is a mass delete job.

chip-bennett

I just want to clear the LP35 audit entries not the records.

unknown

[View:/cfs-file/__key/communityserver-discussions-components-files/18/LP35_5F00_upload_5F00_sample.xls:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/18/LP35_5F00_DEV_5F00_DELETE_5F00_RECORD.uwf.zip:320:240]

If you have access to your database tables, you can run a query on the TAEEGROUP table, which contains all the records currently sitting in the LP35. Something like this will work to pull all the columns in the table:

select * from DEV.TAEEGROUP (change DEV to match the name of your production database)

Next, build a spreadsheet (similar to the sample attached) to delete the existing records in LP35. Run the attached upload to process the deletes(note: remove the ".zip" off the end of the file, the attach process didn't like the .uwf extension. You may have to modify the upload depending on your version of Lawson. Please test before you process in your production environment.

I hope this helps.

unknown

Also, you'll need to change the database name to match your production database in the .uwf:

So, where it says DEV in the uwf just change that to the name of your test server(or production) so it will open correctly. Leave the rest the same unless you need to modify the fields to match your database.

"DEV~LP~LP35.1~2~18~False~9~A~Left Column Check~0~B~_f4,TGR-COMPANY~2~C~_f6,TGR-EMPLOYEE~2~D~_f10,TO-EMPLOYEE-GROUP~4~E~_f14:0,TGR-EFFECTIVE-DATE1~1~F~_f16:0,TGR-QUALIFY-FLAG1~2~G~_f12:0,TGR-HOLD-FLAG1~2~H~_f11:0,LINE-FC1~4~9UP"

Copyright © 2025 Infor. All rights reserved.