Has anybody been able to create the PA100 report straight from the Lawson tables.
Our HR dept runs the PA100 everyday to update personnel actions. The PR dept needs this report but in a different format and sorted not by employee but in a different way. The problem in creating this report is changes to an employees record is stored as current on HR11 or the employee table and the previous value is tored in the HR history table. For every personnel action which may be about 70-100 changes each personnel action is stored as a separate field number in the hr history table and difficult to recreate.
Thanks in advance for sharing any ideas,
Ruma.
I agree with Char - this is not a simple plug and play report. There was an example somewhere on how to pull a report in crystal with current value and the previous value. (searched the site but I did not find it....) We needed to do this for locations, cost centers, and job codes so we created a database view that pulls the HRHISTORY value twice in one query to put the current and previous value on one line. (link back to grab max record dated less than the parent record.) This works well for us. We can create a report with these database views. If we use too many values it gets a bit slow to run.