Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Check number on MICR line is having extra digit

Posted on by 45

Hello All,

We are having an issue with Check number on the MICR print line while printing a check. Here are some key information

a) Length of Check number is specified as "9"

b) Leading zeroes check box is enabled so if my check number is of 5 digits, system would add 4 zeroes upfront

c) No issues with spacing everything seems perfect

Problem :

For example my check number current series is 12347, so when i generate a next check i would expect it to be 000012348, However the reality is that 00001234581 and if i continue to generate new checks the trailing number gets incremented by 1 upto a maximum of 9 and then resets back to 1

i.e. it will increase from 00001234592 ..to ..00001234679 and then resets to 1 on the next increment 00001234681

Any clues/guidance  would be of great help. Please note that i do not receive any errors during this process. Until now banks did not had any issue with that but now they are forcing to remove the extra digit

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Check number on MICR line is having extra digit

    Good morning Ravi,

    I noticed 'CAD' in your screenprints and had a look at LCS where I found the following hint:

    Solution 3577964MICR font on checks will not print. Problem: Canadian checks are not printing the MICR line.

    fix.lcs.dynamics.com/.../Details;dbType=0&qc=23a2e54448e0e4b130d1a491b1a7f89b9f387706ae47fdf3f4c1d820214f7a19

    The mitigation provided there says:

    In the Properties window, one of the properties you will see is “Hidden“ and it’s value will be “=iif(Fields!ChequeNumMethod1.Value ="Yes",True,False)”

    Open Visual Studio

    Expand the SSRS Reports node

    Expand the Reports node

    Find Cheque_CA and right-click and choose Edit

    Once the Cheque_CA project is open, expand the Designs node

    Right-click on Report and choose Edit Using Designer

    If the Properties window is not visible on the right, click the View tab on the top of the page and choose Properties Window

    Click on the MICR line text box (not the MICR text itself, but the box around it), which I believe should say textbox38 in the Properties window

    In the Properties window, one of the properties you will see is “Hidden“ and it’s value will be “=iif(Fields!ChequeNumMethod1.Value ="Yes",True,False)”

    Click the drop-down arrow on the value box and choose False.

    When this is complete, save the change and at the top of the page, click Build >> Deploy Solution

    Once this is complete, the MICR line should show on the checks.

    Can you go through this solution provides on LCS and test whether it fixes your issue?

    Best regards, 

    Ludwig

  • RE: Check number on MICR line is having extra digit

    56045.2.jpg56045.2.jpg7536.3.jpg

    I am more concerned about the MICR line text highlighted in RED. Ideally it should retrieve the Cheque number, overall 9 digits with leading zeroes to help maintain 9 digits. But now when you try to print it, an extra character is displayed as shown in RED below

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Check number on MICR line is having extra digit

    Hello Ravi,

    Have saved the screenprints as pictures and uploaded them via the button in the rich formatting window?

    A simple copy & paste won't work.

    Best regards,

    Ludwig

  • RE: Check number on MICR line is having extra digit

    I am not sure why but i am unable to submit any screen shots or word documents even though i try it using rich formatting

  • RE: Check number on MICR line is having extra digit

     

    I am more concerned about the MICR line text highlighted in RED. Ideally it should retrieve the Cheque number, overall 9 digits with leading zeroes to help maintain 9 digits. But now when you try to print it, an extra character is displayed as shown in RED below

  • RE: Check number on MICR line is having extra digit

    Hi Ludwig,

    Thank you for your reply. We are using AX 2012 R3 CU9. Below is a document with couple of screenshots which might help you understand the setup

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Check number on MICR line is having extra digit

    Hi,

    Can you share a screenprint of your setup and also let us know what AX2012 version you operate?

    Many thanks and best regards,

    Ludwig

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans