Monday, April 20, 2009

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*****"

but if you have the check currecy code in SGD, then the amount in words will be printing some thing like "One Thousand Four Hundred Twenty-Two And Eighty-Two *****"

But some of the bank will be very particular about printing the units (dollar, euro,..) and subunits (cents,..) in the check print.

Ok here is the solution for this, From Release 12.0.2 oracle had defined some messages which we can use to print these units and subunits.

Unit:

IBY_AMT_IN_WORD_UP_[CURR] (for plural eg. Dollars)

IBY_AMT_IN_WORD_US_[CURR] (for singular eg. Dollar)

Subunit:

IBY_AMT_IN_WORD_SUP_[CURR] (for plural eg. Cents)

IBY_AMT_IN_WORD_SUS_[CURR] (for plural eg. Cent)

Here [CURR] is the currency code.

I know this may be a simple known solution for lot of you but this will be a grey area for lots and lot of new commers :)

for more details refer metalink document ID 465244.1


1 comment:

Chandan said...

Dear  AK Lakshmanan,

Thaks for your post it was really helpful. Please do post many more like the above.

Regards,
Chandan

Post a Comment