Send add'l detail from P/R to G/L

We have a custom process in place between Lawson and our non-Lawson GL. Our Accounting dept also books payroll to the dept/job code level. Our pre-Lawson payroll system didn't support that (so we had a custom process then) and after an LPS engagement during our implementation it was decided that Lawson didn't support it either. Instead an Accountant accesses the Lawson tables directly and has built a SQL Server database that generates the detail JE's for the non-Lawson GL.

You can also create custom (either Lawson or Crystal or whatever) reports that reach back from GL to PR to get the job codes on the distribution lines.

Finance is looking for something fairly quickly to get this detail into Lawson on the G/L side.  While we are looking at the possibility of reducing the number of prpaycode records that we would have to load into Lawson to make this work I also need a backup plan.  Would it be reasonably possible to create a journal entry from the prdistrib file that could be uploaded into the G/L to provide this sub account (job code) detail?

Have you looked at having your finance staff run PR295 and/or query against PRDISTRIB with Excel Addins?