Check printing seems to be the hot topic right now ... I have seen far too many requests for a check print template out in the publisher-sphere. Its a little complex with the cheque or check (depending on your version of English) at the top. It then repeats the invoices to be paid twice allowing 10 rows (this is adjustable) for each. If it spills to a second page then the check portion is not printed.
It also has some conditional formatting around the check signature images - this is a soft image solution but could easily be used with the 'hard' solution I blogged last week from Dustin and Keith from the National Lime & Stone Company.
In the zip file that contains the template, data, PDF output and signature images there is also an annotated version of the template that attempts to explain how the thing actually works under the covers.
Its delivered as is - its actually based on an Oracle Report XML output from EBS so apologies to non EBS folks but it should be enough to get you up and running at least.
And before you try, not that you would, but you might, thats a random routing and account number :0)
Comments (8)
In reference to "If it spills to a second page then the check portion is not printed." I thought I would add if the company desires to use pre-printed check stock then you can do as we have done here at National Lime & Stone Co. and program the xmlp to insert a VOID image in the signature section for multi-page checks so that your perferated alignment is not thrown off. Also another helpful hint for internal processors is if you use one of the copies of the Invoices for "Internal Purposes" then it is also very easy to embed a watermarked image in the duplicate section of Invoices.
Posted by Keith A. Preston | November 29, 2007 10:26 AM
Posted on November 29, 2007 10:26
Hi Tim -
Thank you for sharing all this valuable info.
Is there a way to print out a message in case the rows (invoices)execeds a certain number?
for example if the invoices in the stub exceeds 15 invoices then instead of printing the invoices, it must only print a one-line sentence.
Posted by Ravi | March 27, 2009 6:01 PM
Posted on March 27, 2009 18:01
Hi,
Thanks for sharing the info. The standard template from Oracle is good but not enough.
I just want to get your guidance on locking the check portion to the bottom of the page without the relation to the paystub info.
I am using 2000 msword RTF template and set the table position using 'Text Wrapping positioning Vertical' setting relative to the page. But XMLPublisher 10.1.3.3 is not reading this setting.
I am trying to display earnings and deductions side by side. I want to find out a way to use two 'for-each' loops in a single row of a table. It didn't work without inner table but I am having issue lining up the data. It always writes the data from the bottom row. If earnings have 5 rows and deductions have 2 rows then both won't start at the same location. Let me know how you can solve this issue.
I really appreciate your feedback..
Regards,
Posted by Srini Reddy | April 1, 2009 9:03 AM
Posted on April 1, 2009 09:03
Hi Tim,
I was trying to implement your logic into my template and i get the following exception when i try to upload the template. It works fine if i remove the changes. It would be great if you can help me with this issue
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01001: invalid cursor
ORA-06512: at "APPS.XDO_TRANS_UNITS_PKG", line 446
ORA-01403: no data found
Rao
srkolluri@yahoo.com
Posted by rao | May 11, 2009 3:02 PM
Posted on May 11, 2009 15:02
I really appreciate a check template that is available, so that I don't have to start from scratch. Our check stock, however, has the check at the bottom of the page and the detail at the top. I have tried moving the tables around on the template and just can't seem to get it right. Any help would be greatly appreciated.
Posted by Mark Garrett | May 18, 2009 2:22 PM
Posted on May 18, 2009 14:22
We get some requests for MICR check templates and the one you provide above is helpful. Printing your own checks with MICR Toner is an even better way to automate payroll. Most people don't realize that blank check stock is about 80% cheaper than pre-printed checks.
Will be adding a link to this post. Thanks.
Posted by MICR | May 27, 2009 12:25 PM
Posted on May 27, 2009 12:25
Using GnuMICR font just like your Check Print Nov 2007 blog example, but when previewing from BIP Template Add-on in Word, the PDF preview is not showing the MICR line in that font, but previewing your example rtf and xml data it works, what did are you doing that I am not?
Posted by Carl Hubscher | October 12, 2009 11:01 AM
Posted on October 12, 2009 11:01
Hi Carl
You have probably not loaded the font to the server and referenced it in the xdo.cfg file. Now if you are previewing it, the font is there in the windows/font directory but you will not have the font reference in the cfg file. Its under Publisiher_HOME/Template Builder for Word\config for me, its here, D:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config
The entry needs to be:
...
Now, my example is probably working because I have embedded the font reference in the template itself. Check File > Properties > Custom tab. This approach is covered in the user guide.
Regards
tim
Posted by Tim | October 12, 2009 11:11 AM
Posted on October 12, 2009 11:11