Hi All,
Recently one of the checkbook check number got duplicated and showing the duplicate number under the Checkbook Register, even though the Allow Duplicate check numbers options under the checkbook maintenance is untick.
Both the check numbers are originated from different modules one from Payables and other from bank transaction.
Please advise how this happened and how to rectify this.
Hi,
Can you verify the exact version of GP on which this occurred?
Also, which check was posted first (the one in Bank Rec or the one in Payables)?
Was the payables check entered in the 'Manual Payables Payments' window or was it a computer check?
Thanks,
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
Please find below the details
Dynamics GP 2015 Version 14.00.0661 (RTM)
Payables First on 24/09/2020 & then Bank Trans on 29/09/2020
Manual Payables Payments
Regards,
Ramanan
Hi Andrea,
Awaiting for your reply.
Hello Ramanan,
Historically, the 'allow duplicate check number' option only pertained to the 'Payables 'module. With this option unmarked, you would not be able to post a computer check and manual check with the same check number in Payables. However, you can still use that check number when you key the check in Bank Rec. Changes were only recently made to GP 2018 R2 to also extend the option to include Bank Rec.
So if you test this on GP 2015, you will find that you can reuse the same check number if you key the check in Bank Rec back on that version. This should be fine since they are coming from different modules. If this is not acceptable, then you would have to upgrade to get the new functionality.
Thanks
Cheryl Waswick
Microsoft Support
Hi Cheryl,
Noted with thanks, but the check number in the transaction are not entered manually. it uses the next check number from the check book maintenance window.
In the above case, the payables manual payment entry was made on 24th with check number "XXX221"
so the next number should have to be updated as "XXX222". But, After 5 days when user did bank transaction, the next number number was taken as "XXX221" any reason why the next number didn't get changed.
Thank you for the clarification. It is designed to increment when the next check number is used, so this is definitely unusual behavior. Is this something you can recreate or make happen at will? If not, then it likely was due to something within the environment, such as a connection loss, or running out of resources, or something like that that would cause an intermittent issue. If you can make it happen, then you can find the cause, but if not, then it would be difficult to know for sure what happened.
Hope that helps.
Cheryl
Microsoft Dynamics GP support
Noted with thanks.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,004
André Arnaud de Cal... 857 Super User 2025 Season 2
Sohaib Cheema 548 User Group Leader
