Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Alpha/numeric check numbers?

Posted on by Microsoft Employee

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

  • 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).

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans