PR85 Reconcile payroll checks using MS Addins

Matthew, Are you still working on this or have you solved your issue? I had implemented a process at a previous client, I might be able to help you if i can find my notes...

Lawson support gave me a layout with the following fields:
bnk-acct-nbr f14, line-fc1 f41:0, pt-check-nbr, f33, amount f44:0, check-date1 f45:0, recon-date1 f46:0, check-type1 f47:0, company1 f23, employee1 f25, check -id1 f34.
This will change the records however it's extremely slow and has caused the system to crash a couple times when it was tried with a large number of records.

Does anyone else upload to pr85 without these problems?

 

Matthew,
PR165 is a slick process for reconciling payroll checks. I have found it to be more efficient. Have you looked at this as an option, rather than an Add-ins upload?
-Robby

No we haven't. We have checks from 2009 forward that we want to give Finance the ability to reconcile in Lawson. The upload Lawson previously gave me is very slow. I've been trying to tinker with it to see if I can speed it up but haven't had any luck yet. I'm thinking about going to pr165. I should be able to build a flat file from Lawson information and upload that to reconcile, right?

Matthew,
If all you want to do is mark every open check as reconciled, yes. Get the PR165 flat file layout, dump what you need from PRCHECK, and set that data up in the flat file to put into PR165. When do you need this done? I have some great notes somewhere - I did exactly this for a client a while ago.
-Robby

Robby any notes you have would be appreciated.
When do I need this done...sooner than later.
Unfortunately I don't want to mark every open check as reconciled, Finance wants a way to take their spreadsheet information on reconciled checks at least monthly and upload them into Lawson. There are a lot of old checks to reconcile but this will be an on going process.

Matthew,
Send me a direct email: RLESCAULT@COMCAST.NET