Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Check Numbers are being Skipped

Posted on by 2

Good day,

I have a check batch where the user indicated check numbers were skipped, we use preprinted checks so when this happens it can be a nightmare for AP. 

I have read the document on check numbers being skipped, the user as well, and they indicated that that is not what is happening.

I am looking at the check posting journal and the check number and the payment number are consecutive to a point. Then the cheque number changes but the payment number remains consecutive.

All this in the same batch, the edit list was not printed so it was only after all printed the error was observed. The posting journal says 'Actual' is 17, but at the it says '34' checks.

I can't seem to upload the edit list, but has anyone seen this before?

Regards

Rosemary

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Check Numbers are being Skipped

    Thank you very much will take a look.

    Regards

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Check Numbers are being Skipped

    Hi Rosemary,

    Unfortunately there is no magic script that allows to do that, as all of this happens in Dexterity, not SQL, when forms are open on screen.

    SQL only records the transactions happening in the background at the table level, which is often too late when it happens.

    You have some (limited) options in GP by enabling the User Activity Tracking in the system.. This is not an auditing tool by no means, but it can help possibly to find out who did what, where and when.

    For a more detailed tracking of all accessed resources in GP, the tools provided by GPPT From David Musgrave can help a lot, as it shows every form & repot that a user has accessed during a GP session. Check it out on www.winthropdc.com/GPPT

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Check Numbers are being Skipped

    Thank you for your response and references. We have a couple of users who print checks not simultaneously, and I think someone may have been on the Manual Payments window.

    Is there a script where when run can pull the userid as well as the window that is open?

    Regards

    Rosemary

  • Verified answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Check Numbers are being Skipped

    Hello Rosemary.

    There are multiple reasons why a check number could be skipped. Please review the articles below.

    Dynamics GP: Why are Check Numbers Skipped in AP? (crestwood.com)

    Check numbers are skipped - Dynamics GP | Microsoft Docs

    Skipping check numbers in GP | Open Forum (gpug.com)

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer.

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans