How-TO: Get XML file for AP Check Print Program

Here in this post I would like to tell my way of getting the XML for a Format Payment Instruction Program or other words AP Check Print Program.

For every new Format Payment Instruction program run, the XML is getting stored in IBY_TRXN_DOCUMENTS table (at least in R12.0.6). We need to either query this table and get the last created record column DOCUMENT to get the XML or if you know the payment instruction ID, then you can query by payment instruction ID.

Read more »

How-To: Configure New Font On BI Desktop Publisher

In most of the projects we will come across building a report having Barcode or MICR font.

So once you install your new font under Windows/Fonts/ directory you will still not be seeing that font when you preview PDF output.

What to do in that case?
Here are the steps to follow on installing new font on your PC/Laptop.

Read more »

Cross Tab / Column wrapping

Today got a interesting issue/challenge from good friend and colleague Mr. Pinaaki krishnasharma. Issue is if we use a for loop @column and print the rows as column for say Cross Tab reports, the columns that were not able to fit in the page width is going out of the page. See below for example,

Read more »

Inline If Else Statment

This week I had come across an issue where I had a situation in the template to put 2 inline if statements one after the other.

 

Some statement if@inline:1=2 Result 1 end if if@inline:1=1 Result 1 end if

 

But in the output it printed both results of if statements. I do not know the reason for this. So as usual went for google and landed in our guru Tim Dexter's Dec 2007 post.

Read more »

Printing Check Amount With Decimal Part

Yesterday was not really a good day for me. because a simple fix on the check amount dragged my entire day till 10pm. But it kinda helped me to explore lot of stuff.

Let me come straight to the actual problem.

Currently we are showing the checkamount padded with asterisk(*) like *******1200 (I will use this value for by below examples). Here is how I pad the asterisk

<?xdofx:lpad(PaymentAmount/Value,12,'*')?>

Since there is no decimal part in this value the bank some times considers the last 2 digits from the right as the decimal part. In this case they consider 00 as decimal part and paid only 12 dollar. To avoid this confusion we decided to print the decimal part also so that the amount will look like ****1200.00

Read more »