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 »

Handling Text Wrapping with Fixed Rows in BI Desktop Publisher

After seeing Tim Dexter post about fixed line and row filler decided to post about the handling string wrapping in the template.

Ok let me start explaining how I handle the string wrapping. Before that let me let me tell you the requirement.

1. Need to display fixed lines.

2. If there are only few lines and the page is not filled then we need to print blank lines to fill the page.

3. At the end of the report we need to display the summary as shown above.

4. At the end of the rows including the rows with values and blank rows we need to print a line to end the box.

Read more »

Check Amount not printing the Units and Subunits

Some of you must have noticed the check amount that is getting printing words may not be printing the units and subunits of the amount.

For example, if you have the check currency code in USD, then the amount in words will be printing some thing like "One Thousand Four Hundred Twenty-Two Dollars And Eighty-Two Cents*****"

Read more »

How-To: Disable the preference menu from SSA page

Today I remembered one my task which I had done few days ago. The actual given to me is to disable the Preferences menu option from few responsibilities which is actually a Self Service Application page. So as-usual I started searched metalink and google and found three solutions for this. Let me list all the three type of solutions for this.

Solution 1:

Updating the profile option "General Preferences Show Flag" value to 'No'.

Read more »

Getting the application URL

In some cases you might be having the access to the application database but not the URL to access the application. If you had come across any of this situation then no worries here is a table ICX_PARAMETERS which gives you the information of the application URL. But keep in mind you need the username and password for the application ;)