Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Interfaces/Conversion
Payroll History removal
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5161
People Online:
Visitors:
219
Members:
0
Total:
219
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Interfaces/Conversion
Payroll History removal
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
bgodwin
Veteran Member
Posts: 143
4/13/2007 4:11 PM
We are in go-live and want to use our current data system as our go-live with the exception of the data created by running a payroll (want to remove any evidence that we ran a payroll). I've reviewed various items in the data file text and technical text in effort to find out what tables would have to be 1) wiped out and 2) what tables would need values reset (i.e. comphist and coda).
Apparently the pr300 purge of hist does not take out everything. Does anyone have the info on this, is it do-able?
So far:
deleted the following table data:
paymastr
paydeductn
prtime
prdistrib
prcheck
pacoments
quartded
quartwage
premdedhst
EMPACHDIST
praudit
Additional tables that may need to be deleted or have the totals adjusted to zero:
comphist
coda
quartwage
quartded
prdeddtl
prempgarn (shows garnishment balances)
onetmded
prtrdadj (check adjustments)
timerecord
taeemaster (pto balances)
vesthours
You are not authorized to post a reply.