Duplicate payroll check number

(0) Share

Report

Posted on by Community Member

We had some payroll problem and created a couple payroll checks to employees with the same check number. Of course we need to void some of the duplicates, but GP won't even display duplicates in the payroll void transaction screen. Can I simply change the check numbers in UPR30100 and UPR30300, then void them via GP?

It seems to work in a test, but I want to ensure I'm going to mess anything else up.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Terry R Heley Microsoft Employee on at

Like (1)

Report

Hi George,

Thanks for the forum question on payroll duplicate checks today. That void window can be picky with duplicate checks.

Some good news on this front as it is common for customers to have this issue is in GP 2013, our next release due to release December 2012, we are going to warn you if there are duplicate checks and allow you to over-ride it and print a report of the duplicates, so this should help immensely with this problem.

For now, I'm not sure I would recommend to change the check number, but that is up to you. If you run this script, you will see check number is in other tables. We may also have a disconnect with Bank Rec and General Ledger if you change it in payroll.

select * from sysobjects o, syscolumns c

where o.id = c.id

and o.type = 'U'

and c.name = 'cheknmbr'

order by o.name

What customers may do in this case is do a negative manual check to back out the payroll, like a void.

Here is a article as well around this.

support.microsoft.com/.../864992

Thanks

Terry Heley

Microsoft

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Terry,

Thanks for the info. I had already run my version of that script and could not find any other references to check number that were applicable to me and payroll. However, I also know column names are not always constant in GP. I was hoping someone would have a definitive answer.

I had also found the KB article about a negative manual check. Not really my first choice. Void is cleaner and everyone will instantly know what happened. The negative check, while having the same end results, is not as obvious.

I am glad to hear this will be fixed in a future version.

Was this reply helpful? Yes No
Jeff Rowles 500 on at

Like (1)

Report

Hi George,

There are a couple of cash management module tables that you need to also review if considering removal. CM20100 & CM20200 column name='CMTRXNUM'.

Best Regards,

Jeff Rowles

L. Kianoff & Associates, Inc.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (1)

Report

For what it's worth,

I have done this and it worked.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Just to clarify, which this did you do?

Was this reply helpful? Yes No