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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AP Check Number Duplic...
Microsoft Dynamics GP (Archived)

AP Check Number Duplicated - One Check in WORK Status

(0) ShareShare
ReportReport
Posted on by Jim Lines 4

Got a strange one here - the same check number was used for two vendor payments. 
-GP2013 SP2
-Running Mekorma MICR
-Checkbook is set up to NOT allow duplicates. 
-Checkbook set to allow overrides

From my research, it looks like a user cut a check on 6/2/2014 which as of now shows a status of WORK.  On 6/4/2014 a check was cut to a different vendor using the same check number (HIST).  Does GP look at the work tables when it attempts to validate if a check number has been used or not? 

I don't see any batches open which makes me wonder where the where the un-posted check is living right now.  I'm getting a copy of my DB restore in to my test server and will see what happens when I run a reconcile and check links.  Any advice is welcome.  Thanks in advance. 

Oh, and the checks have been printed, sent and cashed.  :)

Jim

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Hello Jim

    I believe that the only reason for such a case is to have the checkbook configured " to allow duplicate numbers", although, you have already mentioned that it is not allowed to do so. 

    I can replicate your case simply by unchecking this option on the checkbook maintenance window as shown below;

    Is it possible that the other "work" document is stock and can't be reached through GP windows ? Would it be possible that the user have allowed duplicate numbers on the checkbook level before entering this payment ?

    Keep us posted, 

  • Jim Lines Profile Picture
    Jim Lines 4 on at

    Hi Mahmoud,

    Turns out one batch errored out and the user didn't inform us about it.  The batch was in Batch Recovery and they could not recover it without getting an error.  My guess is that they didn't realize the batch when into recovery until it was too late.  Strange that GP still let both numbers be used regardless of the document status.  I updated the batch in SY00500 and advised them "reprint checks" from the check posting window and modify the check number (i.e. add a -1 or alpha) and post.  This took care of the problem.  I'll cross my fingers and hope it doesn't happen again.  I don't have much spare time to re-create the issue, but my instinct would be to print the check, crash the batch, print another check using the same # and see where it leaves me.  

    Thanks for testing it on your side, I appreciate your time.  I'm going to mark this as answered.  Have a great weekend.

    Jim

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans