My current Check number on the MICR String is 5 digits, the bank requires it to be 6 or more, how can I alter the XML code to show that extra 0 in front of the check number without altering the Document Number at the DB Level
Thanks for any help in advance
I added the following pl/sql functions to my rdf and passed it thru the xml data
function XXNS_MICR_STRINGFormula return Char is
l_micr_string := '/'||to_char(:C_CHECK_NUMBER)||'/ &'||:C_ROUTING_NUM||'& '||
you can probally use the concat() function in XMLP and do the same if you don't know how to edit the rdf......
I am working on checks. I am evaluating E13B ID Automation MICR fonts. ID Auto offers many fonts like IDAutomationMICR.TTF, IDAutomationSMICR.TTF etc.
I would like to know which is the most widely accepted font for checks and what is the font size to use for printing checks.
Did you resolve the issue, if fixed please share the answer.
wondering you could use "lpad" and "concat" functions to add 0s infront of check number and then you could concatenate those mean check number, routing number and account number by using xsl xdofx scripting format.
lpad function syntax lpad(string,length,padding value) /* probably you know this*/
hope this give some idea