Skip to main content
Microsoft Dynamics GP forum
Answered

Duplicate Check Number on Checkbook Register

editSubscribe (0) ShareShare
ReportReport
Posted on by 235

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

Attachments
  • Ramanan Profile Picture
    Ramanan 235 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 235 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 235 on at
    RE: Duplicate Check Number on Checkbook Register

    Hi Andrea,

    Awaiting for your reply.

    Regards,

    Ramanan

  • Ramanan Profile Picture
    Ramanan 235 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

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans