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?