Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

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

Sort:
You are not authorized to post a reply.
Author
Messages
MatthewD
Veteran Member
Posts: 53
Veteran Member
8/21/2012 12:46 PM
    Currently the payroll file passed to Finance for the g/l is giving them a department level break down of dollars.  The want to see the break down to a department/job code level.  We've looked into creating job code specific pay codes that use the job code as the sub account however PR20.4 has a 9,999 record limit and we have a lot more codes than that.  Has anyone done anything like this or have a custom process in place?
    BarbR
    Veteran Member
    Posts: 306
    Veteran Member
    8/21/2012 5:43 PM
      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.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      8/21/2012 6:31 PM
        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.

        Thanks for using the LawsonGuru.com forums!
        John
        MatthewD
        Veteran Member
        Posts: 53
        Veteran Member
        8/23/2012 11:43 AM
          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?
          John Henley
          Senior Member
          Posts: 3348
          Senior Member
          8/23/2012 12:49 PM
            Have you looked at having your finance staff run PR295 and/or query against PRDISTRIB with Excel Addins?
            Thanks for using the LawsonGuru.com forums!
            John
            You are not authorized to post a reply.