Skip to Content

Amount in word formula 174.90

I have applied this

if right(Towords({Invoice_Detail.After_Invoice_Discount_Total}),2 * 100)="00"
then
Lcase(ToWords({Invoice_Detail.After_Invoice_Discount_Total},0))+" "+"only"
else
Lcase(ToWords({Invoice_Detail.After_Invoice_Discount_Total},0))+" dollar and "+Lcase(ToWords(tonumber(right(Totext({Invoice_Detail.After_Invoice_Discount_Total}),2)),0))+" "+"cent only"

***********************************************I want amount in word this Answer *****************************************

(One hundred seventy four dollar and ninety cent only)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 29, 2018 at 10:42 AM

    Hi Zahid,

    Try this formula:

    local numbervar x := {Invoice_Detail.After_Invoice_Discount_Total};
    local numbervar ipart;
    local numberVar decpart;
    ipart := int(x);
    decpart := x - ipart;
    Propercase(Replace(towords(ipart)," and xx / 100","")) & " dollar" &
    if decpart = 0 then "" else " and " & Propercase(Replace(towords(decpart*100)," and xx / 100","")) & " cent only";

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2018 at 06:14 AM

    very much help full thanks

    Add comment
    10|10000 characters needed characters exceeded