Each digit of Amount in words in RTF Report

Ankit Kumar-91304

Summary

Each digit of Amount in words in RTF Report

Content

Hi Everyone,

 

I am working on check print report in fusion and I have requirement from business as to convert each digit of amount in words.

For Example : 6978.09, it should be print like "SIX NINE SEVEN EIGHT PERIOD ZERO NINE".

Anyone have idea regarding this as how to convert each digit in word.

 

Thanks in Advance.

 

Regards,

Ankit

Ankit Kumar-91304

Thanks Brajesh !!

But its not printing each digit in words, Its printing whole amount in word.

I have to print "One Two Five Two Period Eight Nine" for 1252.89 amount.

Brajesh Shukla-95078

You can use <?xdoxslt: toWordsAmt(1252.89)?> but not sure amount format fulfill your requirement

Dir_Pal

select to_char(to_date(floor(6978.09),'J'),'Jsp')||' and '||

to_char(to_date((6978.09-(floor(6978.09)))*100,'J'),'Jsp') from dual

Pieter Breugelmans-Oracle

Your requirement of printing out each digit of the check amount individually is highly unusual in the context of a "check print report". A standard practice for checks is for the amount to be spelled out in words. Are you absolutely sure that the requirement is clearly understood as I've never came across such myself before?

Arti Sangar

Thanks !!

But its not printing each digit in words, Its printing whole amount in word.

Sketz

I would assume that you should do that in the data model and not inside of a template.

A relatively simply PLSQL-Loop where you extract one digit after another and "translate" it should be enough

Arti Sangar

Hi Pieter

I am sure about requirement that I have to print each digit in word.

Thanks

Ankit Kumar

ZZHAO2022

Hi Ankit,

 

Did you get this problem solved? I am encountering the same issue. For example, I need to print 123 as One Two Three where one is under the Hundred digit, two is under the tens digit and three is under the unit digit. Is it doable in RTF template?