How to Display NetSuite Amounts or Currency Values in Words?

To display the amount in words directly on a transaction record, a Custom Transaction Body field can be utilized. This field should be configured as a "Free-Form Text" or "Long Text" type, and the following formula should be entered in the Validation and Defaulting section:

CASE WHEN {total}0 THEN 'ZERO' ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),'J'),'JSP') || ' ' || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, '^[0-9]+.', ''))) 1 THEN TO_CHAR(REGEXP_REPLACE({total}, '^[0-9]+.', '')) || '0/100' ELSE TO_CHAR(REGEXP_REPLACE({total}, '^[0-9]+.', '')) || '/100' END) || ' ' || {currencysymbol} || ' Only' END

This formula will produce a result similar to: FOURTEEN THOUSAND SEVEN HUNDRED FIFTY-EIGHT 23/100 USD Only. Please note that while {currencysymbol} is used here, its direct support in all NetSuite formula contexts may vary; {currency} or {currency.name} are more commonly confirmed for displaying currency information.For displaying amounts in words within NetSuite search results, a Formula (Text) column can be added to a transaction search. Insert the following formula into the Formula (Text) column:

CASE WHEN {amount}0 THEN 'ZERO' ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({amount}, 0)),'J'),'JSP') || ' ' || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({amount}, '^[0-9]+.', ''))) 1 THEN TO_CHAR(REGEXP_REPLACE({amount}, '^[0-9]+.', '')) || '0/100' ELSE TO_CHAR(REGEXP_REPLACE({amount}, '^[0-9]+.', '')) || '/100' END) || ' ' || {currency} || '(s) Only' END

These formulas leverage Oracle SQL functions to convert the numerical amount into words. It is important to test these formulas thoroughly, especially for very large amounts (e.g., exceeding 5.5 million) or specific handling of zero cents, as their behavior may have limitations in such edge cases.