Create a custom field for store the words. In Transaction Body Field record has a subtab ‘validation & Defaulting’. Under this subtab, we have an option to give the formula.
Click the checkbox of the FORMULA and give the below mentioned formula in DEFAULT VALUE text box.
INITCAP(CASE WHEN {total}=0 THEN ‘ZERO’ ELSE replace(‘ ‘ || case when substr(lpad({total} * 100,11,’0′),1,2) = ’00’ then ” else to_char(to_date(substr(lpad({total} * 100,11,’0′),1,2), ‘j’), ‘jsp’) || ‘ crore ‘ end || case when substr(lpad({total} * 100,11,’0′),3,2) = ’00’ then ” else to_char(to_date(substr(lpad({total} * 100,11,’0′),3,2), ‘j’), ‘jsp’) || ‘ lakh ‘ end || case when substr(lpad({total} * 100 ,11,’0′),5,2) = ’00’ then ” else to_char(to_date(substr(lpad({total} * 100,11,’0′),5,2), ‘j’), ‘jsp’) || ‘ thousand ‘ end || case when substr(lpad({total} * 100,11,’0’),7,1) = ‘0’ then ” else to_char(to_date(substr(lpad({total} * 100,11,’0′),7,1), ‘j’), ‘jsp’) || ‘ hundred ‘ end || case when substr(lpad({total} * 100,11,’0′),8,2) = ’00’ then ” else to_char(to_date(substr(lpad({total} * 100,11,’0′),8,2), ‘j’), ‘jsp’) end || case when substr(lpad({total} * 100,11,’0′),10,2) = ’00’ then ” else ‘ and ‘ || to_char(to_date(substr(lpad({total} * 100,11,’0’),10,2), ‘j’), ‘jsp’) || ‘ paise ‘ end, ‘-‘, ‘ ‘) || ‘ only’ END)
Note: { total} => Total amount to be converted