Print Page | Close Window

MICR Line Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22954
Printed Date: 28 Apr 2024 at 10:03pm


Topic: MICR Line Formula
Posted By: $$Dr
Subject: MICR Line Formula
Date Posted: 04 Sep 2021 at 5:11am
Am receiving a fail message from Wells on our checks.

Current formula is as follows:

 'c' & right ('000000000' & Trim (( APPB.CMRef )), 9) & 'c' & ' a' & (CMAC.RoutingId) & 'a ' & (CMAC.BankAcct) & 'c'

Can someone explain in English what the formula says, especially the section that says Right ('000000000' ?

Wells is stating the account number is starting at position 32 and is starting at 33. Also stating that the check number is starting at position 44 and should be 45.

Because Wells references the line starting from the right side of the check form, it is confusion to 1) know if the MICR formula is position correction onf the form (since the formula field is position beginning from left of form) and if the MICR formula is the correct length.

Any idea whether the formula is the issue or positioning of the formula field on the check form?


Replies:
Posted By: kevlray
Date Posted: 07 Sep 2021 at 4:36am
Basically the right ('000000000'   is padding the string with zeros from the right side.  I have seen left side padding of zeros and spaces, but not the right side.

Posted By: lockwelle
Date Posted: 07 Sep 2021 at 5:05am
Another way to look at it. The formula is making sure that a number is the same length by adding zeros to the front of the number.


Print Page | Close Window