Function-13: Add Invoice grand total in words with the click of a button

Welcome back everyone!

Last week, we learnt how to add pre-defined notes in a click. This week, let's look at a custom function that helps you add the invoice grand total in words with the click of a button.

Business scenario:

Countries across the globe follow different numbering formats with comma and decimals being used interchangeably:

• In the US, comma (,) is used as thousands separators where as in Germany, period (.) is used. 
  
• In the US, period (.) is used as decimal separator where as in Germany, comma (,) is used. 
  

Thus, three thousand fifty-five and eight tenths is displayed as 3,025.8 in the US and 3.025,8 in Germany. For cheques, the practice of writing the amount in words not only helps avert malpractice, but also clears any discrepancies associated with number format. If you are dealing with multi-national clients, it is best to extend this practice to your client invoices, and this weeks custom function helps you achieve just that with the click of a button.

Getting started with the custom function:

1. Go to Setup > Automation > Actions > Custom Functions > Configure Custom Function > Write your own .
   
2. Provide a name for the button. For example: “Total in words”. Add a description(optional).
   
3. Choose the module as " Invoice ".
   
4. Click “ Free flow scripting ”.
   
5. Copy the code given below.
   
6. Click “ Edit arguments ”.
   
7. Enter the name as “ invoiceId ” and select the value as “ Invoice Id ”.
   
8. Save the changes.
   
9. Click Save to create the button.
   

The script:

Code for Version 2.0 API:

 

invoiceDetails = zoho.crm.getRecordById("Invoices", input.invoiceId.toLong()); 

val_s = ifnull(invoiceDetails.get("Grand_Total"),"0").toLong();

//val_s=input.val.toString();

th = {"", "thousand", "million", "billion", "trillion"};

// uncomment this line for English Number System

// th = {"","thousand","million", "milliard","billion"};

dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"};

tn = {"ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen"};

tw = {"twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety"};

x = val_s.length();

if (x > 15)

{

info "too big";

}

else

{

s = val_s.replaceAll("(?)",",",false).removeFirstOccurence(",").removeLastOccurence(",").toList();

str = "";

sk = 1;

bypass = false;

for each index i in s

{

cur = (s.get(i)).toLong();

info cur;

if (!bypass)

{

if (((x - i) % 3) == 2)

{

if (cur == 1)

{

next = (s.get((i + 1))).toLong();

info next;

str = (str + tn.get(next)) + " ";

bypass = true;

sk = 1;

}

else if (cur != 0)

{

str = (str + tw.get((cur - 2))) + " ";

info str;

sk = 1;

}

}

else if (cur != 0)

{

str = (str + dg.get(cur)) + " ";

info str;

if (((x - i) % 3) == 0)

{

str = str + "hundred ";

sk = 1;

}

}

}

else

{

bypass = false;

}

if (((x - i) % 3) == 1)

{

if (sk != 0)

{

str = (str + th.get(floor(((x - i - 1) / 3)))) + " ";

info str;

sk = 0;

}

}

}

info str;

}

upperstr = str.toUpperCase();

mp = map();

mp.put("Grand_Total_in_Words", upperstr);

update = zoho.crm.update("Invoices", invoiceId.toLong(), mp);

info mp;

info update;

Code for Version 1.0 API:

invoiceIdStr = input.invoiceId.toString();

invoiceDetails = zoho.crm.getRecordById("Invoices", input.invoiceId);

val_s = ifnull(invoiceDetails.get("Grand Total"),"0");

//val_s=input.val.toString();

th = {"", "thousand", "million", "billion", "trillion"};

// uncomment this line for English Number System

// th = {"","thousand","million", "milliard","billion"};

dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"};

tn = {"ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen"};

tw = {"twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety"};

x = val_s.length();

if (x > 15)

{

info "too big";

}

else

{

s = val_s.replaceAll("(?)",",",false).removeFirstOccurence(",").removeLastOccurence(",").toList();

str = "";

sk = 1;

bypass = false;

for each index i in s

{

cur = (s.get(i)).toLong();

info cur;

if (!bypass)

{

if (((x - i) % 3) == 2)

{

if (cur == 1)

{

next = (s.get((i + 1))).toLong();

info next;

str = (str + tn.get(next)) + " ";

bypass = true;

sk = 1;

}

else if (cur != 0)

{

str = (str + tw.get((cur - 2))) + " ";

info str;

sk = 1;

}

}

else if (cur != 0)

{

str = (str + dg.get(cur)) + " ";

info str;

if (((x - i) % 3) == 0)

{

str = str + "hundred ";

sk = 1;

}

}

}

else

{

bypass = false;

}

if (((x - i) % 3) == 1)

{

if (sk != 0)

{

str = (str + th.get(floor(((x - i - 1) / 3)))) + " ";

info str;

sk = 0;

}

}

}

info str;

}

upperstr = str.toUpperCase();

mp = map();

mp.put("Grand Total (in Words)", upperstr);

update = zoho.crm.updateRecord("Invoices", invoiceIdStr, mp);

info mp;

info update;

This is how the result looks like:

 

Note:

• Create a custom field named 'Grand Total (in Words)' in your invoice module. Note that this is part of the code (mp.put("Grand Total (in Words)", upperstr);). Just in case you use a different field name, update the code accordingly.
  
• The above code adds the grand total in words in your invoice record.
  
• Use merge fields to reflect the same in the invoice templates to be sent to your clients
  
• This custom function handles up to 15 digits and rounds-off to the nearest whole number.
  

Found this useful? Try it out and let me know how it works! If you have questions, do not hesitate to ask! Share this with your team if you find it useful. Do check out other custom functions shared in this serieshere.

See you all next week with another interesting custom function. Ciao!

Update: As you must be aware, API V1.0 will be deprecated and support for version 1.0 API will be available only till Dec 31, 2018. Version 1.0 compatible Functions will continue to work until Dec 31, 2019. You're advised to migrated to API Version 2.0 at the earliest. Check this announcement for more. We've updated the post to include the Version 2.0 compatible Function.

• Topic Participants

• KACO new energy

• Viji Sankar

  

• shrk8790

• VijayaLakshmi N

• Sticky Posts

• Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

  Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such

• User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

  Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.

• Custom Function : Automatically send the Quote to the related contact

  Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow

• Function #50: Schedule Calls to records

  Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM

• Function #37: Create a Purchase Order from a Quote

  Welcome back everyone! Last week, we learnt how to calculate the total number of activities for a lead and further take note of the activity count for particular dates. For instance, from the period of Demo to Negotiation. This week, let's look at a function that lets you create a Purchase Order instantly from a Quote. Business scenario: In any form of business, one of the most important things to do is to document the transactions. Naturally, negotiation, signing an agreement, placing an order,

• Recent Topics

• validation rules doesn't work in Blueprint when it is validated using function?

  I have tried to create a validation rule in the deal module. it works if I try to create a deal manually or if I try to update the empty field inside a deal. but when I try to update the field via the blueprint mandatory field, it seems the validation

• Get Zoho Mail API working (including DRE Connector, Oauth Token, ZUID, ZOID & ACCOUNT_ID)

  Disclaimer: I’m not a professional coder! Do you need to use Zoho Mail API? Me too. It lets you do all sorts of things — like reading the complete header of an email, or forwarding an email with its attachments — which is what I wanted to do. But setting

• Revenue Deferrals

  Does ZOHO books and subscriptions handle Revenue Deferrals?   

• Can I make a website open inside Zoho whenever I log in?

  Hi Zoho Team, Every day, I check a few websites for updates, for example, Rojgar--result, where I see the latest government job results and notifications. I was wondering if there’s any option in Zoho to make a website like that open inside Zoho whenever

• Zoho Analytics & SQL Server - Live connect

  Below are the steps I did Created a fresh database and table in my own virtual server Created a new data source connection with live connect I was able to select the tables and created the data source successfully I am getting the error when I try to

• Kaizen #214 - Workflow APIs - Part 2

  Welcome back to another week of Kaizen! Last week, we discussed how Zylker Cloud Services used the Workflow APIs to discover and audit all the automations in their CRM, listing every workflow, checking triggers, and understanding their automation limits.

• Playback and Management Enhancements for Zoho Quartz Recordings

  Hello Zoho Team, We hope you're all doing well. We would like to submit a feature request related to Zoho Quartz, the tool used to record and share browser sessions with Zoho Support. 🎯 Current Functionality As of now, Zoho Quartz allows users to record

• Implementing a Self-Invoicing/Vendor Portal in Zoho Creator

  Hello Zoho Community / Creator Experts, We would like to build a Self-Invoicing Portal (Vendor Portal) in Zoho Creator for our external contractors. Our goal is to allow approved contractors to log in, submit their invoice details (hours worked, project

• Zoho CRM Community Digest - September P1 | 2025

  Hello Everyone! September's Here! Before we jump into product updates, and community highlights, here's a quick spotlight! Zoho has launched a Professional Sales Rep Certification course on Coursera, tailored for sales professionals to strengthen their

• Upload my theme.

  Hello. I would like to upload my own theme, this one: https://themeforest.net/item/panagea-travel-and-tours-listings-template/21957086 Is it compatible and where I upload it? If not I will hire a developer, what do I have to ask when I search for one?

• Explore the Redesigned Quotes Module in Zoho Billing

  Dear users, We’re excited to introduce a refreshed look for the Quotes details page in Zoho Billing! This update brings you a more efficient user interface experience without changing your existing workflow. We've enhanced layouts with organized tabs,

• Product Updates in Zoho Workplace applications | September 2025

  Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this September. Zoho Mail Attach email as EML file in Compose Effortlessly attach emails as EML file in Compose by simply

• Vehicle Tracking

  we have GPS devices that installed on our vehicles, and we would like to know if it's possible to  get vehicle live location data from the GPS device To Zoho Creator App.   Thank You

• 🤝 Rencontres, partage et inspiration au Zoho Community Meetup de novembre

  Chers utilisateurs, Bonne nouvelle 🎉 : notre Meetup Zoho Community approche, et nous serions ravis de vous y voir ! 📍 Toulouse : le 25 novembre 📍 Lyon : le 27 novembre (🎯 Il ne reste que quelques places !) Que vous soyez débutant ou utilisateur avancé,

• Need Help Mapping GST Registration Number Field Between Zoho Books & Zoho CRM + Slow Sync Issues

  am facing an issue with field mapping between Zoho Books and Zoho CRM. I want to map the GST Registration Number field from the Customer module in Zoho Books to a custom GST field inside the Accounts module in Zoho CRM. However, I am getting a warning

• Notification received when self-assigning tickets

  When I assign tickets in Zoho Desk the relevant agent gets a notification email. When assigning myself a ticket in Zoho Desk, I get a notification email. Now, as I am the person who assigned the ticket to myself, getting a notification in this regard

• Nouveauté dans Zoho Writer - Création de documents et de modèles assistée par l'IA

  Zia, l’assistant IA de Zoho Writer, soutient les utilisateurs dans l’amélioration de leur écriture et la création de contenus : correction orthographique et grammaticale en temps réel, suggestions adaptées au contexte, détection du plagiat, révisions

• Session Expired

  I constantly get "Session Expired" and need to relogin or close and open the application again. This gets really frustrating during the day. Is this something that can be solved? This really makes me want to leave the app as it is no go to need to reopen

• Integrate your Outlook/ Office 365 inbox with Zoho CRM via Graph API

  Hello folks, In addition to the existing IMAP and POP options, you can now integrate your Outlook/Office 365 inbox with Zoho CRM via Graph API. Why did we add this option? Microsoft Graph API offers a single endpoint to access data from across Microsoft’s

• Disable Buttons for Users with Profiles without permission

  Hey, I've noticed that users without permission of setting up things in the marketplace, can still see the icon: On a click, you see this: It would be way better, if they couldn't see this menu icon at all. (Aside from the fact that it completely misplaced

• Link to images

  I have added images in pages. I would like to link those images with linked in URL so that they open in new window. There is an option of image -> link but I am not able to use the same to open URL in new window. Please check the attached image. Can you

• Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

  Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

• Zoho Analytics - Make text clickable in underlying data

  Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on the

• Credit Management: #5 Advanced Refund Policy

  You're subscribed to a well-known SaaS design tool. You've used it to manage your team's projects, create marketing visuals, brochures, and so on. But your needs change over time. Your company may switch to another tool or hire an in-house designer who

• Exported Slide Image Lacks Portion of the Background Image

  This does not always happen, but when I export (or "download") the rendered image of a slide, it sometimes lacks a portion of the background image. I created a sample slide deck to demonstrate it and shared it with the admins. It is also publicly available

• How to create a Zoho Mail extension similar to Outlook's OnSend add-in?

  Hi, I want to create a Zoho Mail extension similar to Outlook’s OnSend add-in. The extension should: Let the user select headers and footers from a taskpane while composing an email. When the user clicks Send, the extension should: Automatically insert

• Effective Inbox Organization: Folders vs Tags in Zoho Mail?

  I'm exploring the best ways to organize a busy inbox, especially when managing multiple clients or project using Zoho Mail. I’d love to know what works best for others: 1. Do you prefer **folders** (possibly with sub-folders) for each client or project?

• Piss poor service in Support in Domains and email

  Srijith Narayanan B contacted me today. Very pleasant fellow. Just didn't want to tell him how bad your support service is. You help the person, but you leave before we can finish the next stage. Which causes a lot of frustration. It's been 8 days now

• Zoho Mail android app update: Block & reject future emails, Report phishing, Spam alerts, Suspicious URL detection

  Hello everyone! In the most recent Zoho Mail Android app update, we have brought in support for the following features: Block & reject future emails Report Phishing Spam alerts in the mail details screen. Suspicious URL detection. Block & reject future

• Zohomail does not support additional fields in mailto links

  Hello, I set up Zohomail as default composer in Firefox according to manual here: https://www.zoho.com/mail/help/defaultcomposer.html#alink2 Later, I wanted to use this functionality to answer in a Linux mailing list thread using mailto link: mailto:xxxxx@kernel.org?In-Reply-To=%3C727o0521-q24p-s0qq-66n0-sn436rpqqr1p@example.com%3E&Cc=xxxxx%example.org&Subject=Re%3A%20%5BPATCH%20v2%28%29

• Emails not being received from a particular domain

  Cannot receive any emails sent from atco.com Domain is in the spam whitelist so should be no reason for it not to be coming through. Have filed a ticket and besides a generic response of we are looking at it - it seems there is no actual support workers

• Email address for forwarding is not saving and there's no confirmation ema

  Steps to reproduce: 1. Enter my forward email in the email forward section of the account 2. Click save 3. See a notification stating saved successfully 4. Refresh the page, no forward email is saved 5. No email confirmation received at the forwarding

• This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

  This is the error i keep getting when trying to use my Zoho Domain Mail. This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details Find attached. I hope this can be resolved very quickly so i can go on and make

• Auto CC - Moving Departments

  We have Auto CC e-mail replies to your support mailbox enabled. We have two departments: Helpdesk (helpdesk@domain.com) Delivery (delivery@domain.com) If we create a Helpdesk ticket, and reply, replies are CC'd to helpdesk@domain.com (OK) We then move

• unable to send message reason 554 5.1.8 Email outgoing blocked

  unable to send message reason 554 5.1.8 Email outgoing blocked

• Mailk got blocked / Inquiry About Email Sending Limits and Upgrade Options

  Dear Zoho Support Team, My name is Kamr Elsayed I created this account to use for applying for vocational training in Germany. As part of this process, I send multiple emails to different companies. However, after sending only 8 emails today, I received

• SMTP email sending problem

  Hello, I've sent emails before, but you haven't responded. Please respond. My work is being disrupted. I can't send emails via SMTP. Initially, there were no problems, but now I'm constantly receiving 550 bounce errors. I can't use the service I paid

• unblock my zoho mail account. outlines@zoho.com

  please unblock my zoho mail account, outlines@zoho.com

• Unable to see free plan option

  Hello Zoho Support Team, I hope you are doing well. I am trying to sign up for Zoho Mail, but I am unable to see the option for the free plan. Could you please guide me on how I can access or activate the free plan? Thank you for your assistance.

• Outgoing blocked: Unusual activity detected.

  I just made payment for my Zohomail Today and have been debited so i will like to be Unblocked because this is what it says (Outgoing blocked: Unusual activity detected) Thank you i await your swift responses

• Next Page