Extracting G/L detail out of Lawson payroll run for non-Lawson G/L system

gronsman

We are installing Lawson payroll to replace Infor's mainframe payroll system and at this point plan on keeping the mainframe G/L system. We are trying to determine the best method to extract the G/L detail records from the Lawson payroll system to feed into the our legacy G/L system. We run at least four different payroll runs each week and need to extract the G/L detail for each payroll run. We have looked at extracting the G/L details records using the gldetail file out of the PR197 run. We looked at running a Process Flow on a weekly basis (saving the date of the last run to know which records to pull) to read records from the PRDISTRIB file.

We see pros and cons of each method, looking for suggestions on the best method to feed a legacy G/L system with Lawson payroll detail G/L data?

Thanks in advance for any help.

unknown

Hi we run lawson payroll (unix aix) and peoplesoft GL and we use a custom lawson cobol 4GL program that we wrote. Basically we extract unprocessed data (status =1) from the gltrans table and format data on a file that is then ftp'ed to our peoplesoft system. Hope this is helpful and let me know if you want to discuss further - i can be reached at ltourou1@fairview.org