Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 2
	Overall: 5210

	People Online:
	Visitors: 362
	Members: 0
	Total: 362

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

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

4 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

MatthewD

Veteran Member

Posts: 53

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

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

Posts: 3353

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.

MatthewD

Veteran Member

Posts: 53

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

Posts: 3353

8/23/2012 12:49 PM

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