Microsoft Dynamics AX (Archived)

Check number on MICR line is having extra digit

(0) Share

Report

Posted on by Ravi Kiran Valluri

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

I have the same question (0)

All responses (7)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ravi Kiran Valluri 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ravi Kiran Valluri 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ravi Kiran Valluri 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ravi Kiran Valluri 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No