Tag: amount in words

Formula to display total amount in words which handles both Dollars and Rupees

CASE   WHEN {total} = 0 THEN ‘ZERO ONLY’       WHEN {total} < 1 THEN     (CASE        WHEN ROUND({total} * 100, 0) > 0 THEN         TO_CHAR(TO_DATE(ROUND({total} * 100, 0), ‘J’), ‘JSP’) ||          CASE            WHEN {currencyname} = ‘Indian Rupee’ THEN ‘ PAISE ONLY’           WHEN {currencyname} = ‘US Dollar’ THEN ‘ CENTS ONLY’           ELSE ”         END       ELSE ”     END)… Continue reading Formula to display total amount in words which handles both Dollars and Rupees

Converting Total Amount to Words: A Practical Guide for Transaction Fields

In financial transactions, clarity and accuracy are paramount. While displaying total amounts in numerical figures is standard practice, there are situations where expressing these amounts in words adds clarity and professionalism. This article presents a practical solution for converting total amounts into words within transaction body fields, ensuring transparency and precision in financial documentation. Introduction… Continue reading Converting Total Amount to Words: A Practical Guide for Transaction Fields

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