ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Payroll >> where is the check number
http://www.istechforum.com/YaBB.pl?num=1238621875

Message started by cathyh on 04/01/09 at 14:37:54

Title: where is the check number
Post by cathyh on 04/01/09 at 14:37:54

We just ran a payroll and it was filled with user errors! The worst thing that happened was that the payroll clerk hit ESC in the middle of printing checks ( she wanted to get out ) and the checks were recorded as printed and disappeared from the current register, but weren't really printed. Our solution was to void the checks and then re-enter the payroll and print again. I did a search of the forum after the fact and found a much easier way but by then we had accomplished the deed.

Now however, I am trying to run an access report to print the pay date, employee, pay amount and check number. I know I could go to the GL and get this info but I am trying to make these reports centralized and limited to PR only. I know the check number is somewhere because in PR-I I see both a voided payroll and a second payroll with a check number. But if I look at the BKPRHIST file I see "VOIDED" in the check number for both payrolls.

Where can I find the check number?

additional note:
I just looked in the BKPRHIST file in Maintain database, and I see the Voided one and the one with the check number. But when I link to the database in Access, I see voided in both and think the second voided is the first payroll that was entered (and voided) because of one employee that we changed in the second run- the pay amount is the same in the two records but it should be different.
Can anyone tell me why access can not see the record I am looking for?

Title: Re: where is the check number
Post by deburr on 04/02/09 at 14:16:20

Cathy

Your data seems fine. That is normally what happens when we void a PR check. The program replaces the check number with VOIDED. Then all the other reports ignore that check. It has to be an Access thing.

Another glitch in PR "check voiding" is that one of the user defined deduction amounts, (can't remember for sure but I think it is an employer amount) does not back out correctly. This is a very old problem that no one seems able to determine why and fix. I just do a credit memo in accounts payable to straighten that out each time.

Title: Re: where is the check number
Post by cathyh on 04/08/09 at 10:46:59

I don't think we had the backout problem because our voided totals in the GL were the same as the original payroll.
In Maintain database I see tow records for each employee for the same pay date and one has check # 'Voided" and the other has a valid check number.

But in access I definitely have two records for each employee for the same pay date but with "Voided" in both check # fields.
This is a big problem because I am relying on that information to run quite a few reports. I am stuck on how to deal with it-- any suggestions access users?

Title: Re: where is the check number
Post by cathyh on 04/08/09 at 11:33:39

I figured out that I needed to add the check number to the key fields (along with emp # and PR date) for the PR history table. That fixed the check field data.

Now I am looking for the department Name- does anyone know where that field can be found?

Thanks!