Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Amount in words to be in Arabic
Hello All;
Is it possible to make the function of "Amount in words" to be in Arabic ??
"CASE WHEN {total}=0 THEN 'ZERO' ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({total}, 0), 9, '0'), 'FF9' ), 'FFSP') || (CASE WHEN {total}-TRUNC({total}, 0) > 0 THEN ' AND ' || (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) ELSE '' END) || ' ONLY ' END"
Thanks