Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Next AP Check Number in Dynamics SL

Posted on by Microsoft Employee

I am working with a client who is not getting the correct AP Check number when running AP Print Checks.  It appears that several years ago a check with a number of 990100 was used as a CK type check, recently they are having trouble getting the real number to go into the system.  The check should be 039609 and it proceeded to pick the 990772 check number and fill in where it could with the next highest check number (becasue they do have 99000 numbers out there the numbers bounced around to the next highest) (I think).  They do use 99000 series for Hand Checks, but I am under the impression that it will not look at HC type for the next reference number.  How can we get the system to recognize 039609 - I did verify that 039609 has not been used in the past but they do have some Alpha check numbers in the system as well.  I have no idea why it would all of a sudden cause issues when the CK types are several years old with the 99XXXX values.  Do I need to change the Check Type to HC for thos CK types numbered as 99xxxx values so the system will increment properly?

Dawn

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Next AP Check Number in Dynamics SL

    it is my understanding that this is determined by a query on the refnbr field of APDoc filtering out hand check documents.  I think I would start by running a sql query against APDoc where refnbr = '990771' as it appears it is finding that as the last used reference number.  Look at the doctype field if it finds it but also look at the rlsed field because you could have an un-released batch using that check number.  If it finds something, look at the BATNBR field and the crtd_prog field to determine where this reference number came from.  Once such a document is found, we can then figure out what to do about it.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans