Tag: amount in words

Convert Amount to Words

Create a Transaction body field and uncheck the store value check box In the Validating & Defaulting Add the Formula in the Default Value column by checking the formula checkboxFormula : CASEWHEN {payment} = 0 THEN ‘ZERO’ELSECASEWHEN FLOOR({payment}) = {payment} THENTO_CHAR(TO_DATE(TO_CHAR(TRUNC({payment}, 0)), ‘J’), ‘JSP’) || ‘ ONLY’ELSETO_CHAR(TO_DATE(TO_CHAR(TRUNC({payment}, 0)), ‘J’), ‘JSP’) || ‘ AND ‘ ||TO_CHAR(FLOOR({payment}… Continue reading Convert Amount to Words

Convert Total to Words in PDF

Solution Create a custom text field and apply formula for converting the amount to wordsThe formula is given below CASE WHEN {total}=0 THEN ‘ZERO’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),’J’),’JSP’) || ‘ ‘ || ‘AND ‘ || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”))) = 1 THENTO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)*10),’J’),’JSP’) || ‘ ONLY’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)),’J’),’JSP’) || ‘  ONLY’END)END Then… Continue reading Convert Total to Words in PDF