web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Missing Check Numbers in the Checkbook Register Report

(0) ShareShare
ReportReport
Posted on by

What would be the cause of missing check numbers in the Checkbook Register Report.  The report includes Reconciled, Unreconciled, and Voided checks.  There are no filters on the report.  The check numbers could later be printed, since the missing check numbers were never used.  Is there a reason that the sequencing of checks would be off, besides someone manually changing the next check number?

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Missing Check Numbers in the Checkbook Register Report

    You may need to take all the transactions for a specific check book id, change the sorting criteria to "Filter by Date". Now, even if the numbers have no sequence or have been manually adjusted, all the transactions for this specific checkbook should show on the report.

    Your feedback is highly appreciated,

  • Verified answer
    Heather Roggeveen Profile Picture
    9,146 on at
    RE: Missing Check Numbers in the Checkbook Register Report

    Hi

    In general, the next number sequence for any field works in the same manner.

    If you start entering a transaction and decide that you don't want it anymore (for whatever reason) and you delete the transaction, the numbers are still available for use.

    However, if you have created a batch of transactions that has already been saved and you then delete a transaction from within the batch (or the entire batch), the next available number won't reset back to the original.

    So this scenario could easily have happened:

    Entered a batch of 10 manual checks using the default numbering rather than a specific range (started at say check 10).  Realised and deleted the batch (hadn't printed anything, so didn't need to void).

    Numbers do not reset and next available number is now 20.

    Do a check payment batch later on, enter the starting check number as one earlier than the new number but not all the way back to the start e.g. 15 - print the checks without issue as the numbers have not been used.  Next available number would now be say 25.

    Checks 10 - 14 have never been used.

    Hope this helps.

    Cheers

    Heather

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans