How can I get total for journal entry with amount in total function

Hello All;

I got the function of Amount in words

“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”

So, how to make body field with the previous formula to get the total debit or credit ?

 

Thanks

Rookie Asked on February 19, 2020 in Administration.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor