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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / how to find the ABA/r...
Microsoft Dynamics AX (Archived)

how to find the ABA/routing number for checks

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have created a query that gives me a listt of checks  from the BankChequeTable. However I also need to display the ABA/routing number in my query, and that field is not in the BankChequeTable. Which table can  I find the ABA/routing number information and how is that table linked to BankChequeTable?

Thanks for your help.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: how to find the ABA/routing number for checks

    Hi  Zvika,

    Thank  you for your patience. It turns out that I did not completely understand what the ABA  is, after all.  I now understand that if it is from my company's check then it will be the same for all checks paid out  to vendors.

    And as I understand your comment, it seems that this information is  not stored anywhere in Ax database, just on the MICR printing where it cannot be separated from other text.

    I will keep that in mind for future purposes.

  • Verified answer
    ZvikaR Profile Picture
    ZvikaR 152 on at
    RE: how to find the ABA/routing number for checks

    At this point I am not sure I understand your question.

    Whose ABA number you are trying to print? the ABA of the payee (vendor) or the ABA of your company?

    ABA of the payee is only relevant if make an electronic payment to your vendor, not print a check. Hence it does not show up in BankChequeTable or in any other table for that matter, not under ABA number label or under any other label.

    The ABA of your company (the one making the payment), is only relevant if you need to print MICR, and in any case only populated on the bank table (for other purposes)

  • Community Member Profile Picture
    Community Member on at
    RE: how to find the ABA/routing number for checks

    Hi  Zvika,

    Thank you for your response.

    No I do not need the ABA routing number to print a check. I am creating  a report that lists all checks paid out to vendors, thereby I need the ABA routing number. I have  not found that information in  the BankChequeTable. Is there any place where it is stored? Is it called by another name?

    Regards,

    Jimm

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 152 on at
    RE: how to find the ABA/routing number for checks

    I assume the reason you need the ABA is because you are printing on blank check paper and you need to print the MICR line that includes the ABA, the check number and the bank account number?

    If that's the case,  out of the box, MICR is printed based on a text configured on the bank's check setup form. However, this is a single field of text that does not separate the ABA from the other 2 fields

    The field name from which the MICR is printed is "(BankCheckLayout).MICRLine" )

    So there isn't a simple way for you to figure out what part of the value in this field is actually the ABA.

    Depending on how your system is configured, it might be that the same ABA number is also populated on the bank record (BankAccountTable).RegistrationNum

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

#1
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans