Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Duplicate Check Number on Checkbook Register

(0) ShareShare
ReportReport
Posted on by 239

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.

Checkbook-Master.jpg    Checkbook-Register.jpg

Categories:
  • Ramanan Profile Picture
    Ramanan 239 on at
    RE: Duplicate Check Number on Checkbook Register

    Hi Cheryl,

    Noted with thanks.

    Regards,

    Ramanan

  • RE: Duplicate Check Number on Checkbook Register

    Hello Ramanan,

    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

  • Ramanan Profile Picture
    Ramanan 239 on at
    RE: Duplicate Check Number on Checkbook Register

    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.

    Regards,

    Ramanan

  • Verified answer
    RE: Duplicate Check Number on Checkbook Register

    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

  • Ramanan Profile Picture
    Ramanan 239 on at
    RE: Duplicate Check Number on Checkbook Register

    Hi Andrea,

    Awaiting for your reply.

    Regards,

    Ramanan

  • Ramanan Profile Picture
    Ramanan 239 on at
    RE: Duplicate Check Number on Checkbook Register

    Hi,

    Please find below the details

    Can you verify the exact version of GP on which this occurred?

    Dynamics GP 2015 Version 14.00.0661 (RTM)

    Also, which check was posted first (the one in Bank Rec or the one in Payables)?

    Payables First on 24/09/2020 & then Bank Trans on 29/09/2020

    Was the payables check entered in the 'Manual Payables Payments' window or was it a computer check?

    Manual Payables Payments

    Regards,

    Ramanan

  • Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Duplicate Check Number on Checkbook Register

    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

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans