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
Just to clarify, which this did you do?
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (