Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Alpha/numeric check numbers?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Can A/P check numbers include letters instead of just numeric

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Alpha/numeric check numbers?

    I do not get that message when I enter an alpha check number on that screen but I did not have a payment selection batch ready so, perhaps, it comes not upon data entry but when you process the screen.  Regardless, having the other screens not allow an alpha check number is still an issue.  If the void check screen will not allow an alpha check number then you really do not want to use such a check number.

    You could use another scheme where your ACH checks are either very high numbers or very low numbers.  both have the risk of colliding, at some point, with paper check numbers so that scheme is not ideal either.

    Sorry for misleading you on this.  I based my response from looking at the input mask on the check number fields on the various screens and did not try a test case.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Alpha/numeric check numbers?

    Thanks for the info. I did try to use ACH001 in the AP check entry screen 03.620 but got the message "Item must be numeric, please reenter".

    Guess I'm out of luck.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Alpha/numeric check numbers?

    When I responded to your question I was thinking you were asking about the AP Check screen (which does allow alpha characters in a check number) but based on what you just said, I am know thinking you might be talking about the voucher and adjustment screen and the manual check tab which does not allow alpha characters in check numbers.  What is interesting is the input mask on that field uses UUUUUU which allows for alpha characters but you get the error message if you attempt to use them which probably means that they add some code on that field on the check event to limit you to numeric input.

    So, there is an inconsistency between the voucher and adjustment screen and the check screen (as well as the manual check screen) for allowing the use of alpha characters.  There is no way to change this even with Customization Manager.  So, unless you can do your ACH runs through the regular check process, it looks like you are out of luck.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Alpha/numeric check numbers?

    Thanks for the info. We have begun making ACH payments to vendors and we will be signing up for the SKSoft eBanking. Until we get the program I was going to have a separate GL acct number and have checks starting with ACH001 the ACH002, etc. but I get an error message that said the check number must be numeric. Is there a way to change that field to accept letters?  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Alpha/numeric check numbers?

    Yes they can but you need to be aware of the side effect of doing so.  The AP check screen displays the next available check number and it does that by looking at the highest used check number in APDoc.  So, if you use letters for some of your check numbers, it may effect the calculation of the next available check number that is displayed.  Of course, you can always change that field to whatever the next real check number is (always a good idea to cross-check what is displayed anyway).

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans