Zoho Books: Please ensure that the "description" has less than 100 characters.

Zoho Books: Please ensure that the "description" has less than 100 characters.

I have this code written to convert Quote into an invoice and keep getting an error even while saving the code. 

Error: Please ensure that the "description" has less than 100 characters.

  1. // Replace with your actual organization ID and connection name
  2.     org_id = "7004318259";
  3.     connection_name = "zohobooks";

  5.     // Fetch the quote details using the provided quote_id
  6.     quote_response = zoho.books.getRecordsByID("Estimates", org_id, quote_id, connection_name);
  7.     estimate = quote_response.get("estimate");

  9.     if (estimate.isEmpty())
  10.     {
  11.         info "Quote not found for ID: " + quote_id;
  12.         return;
  13.     }

  15.     // Extract key details from the quote
  16.     customer_id = estimate.get("customer_id");
  17.     zcrm_potential_id = estimate.get("zcrm_potential_id");
  18.     if(zcrm_potential_id != "" && zcrm_potential_id != null)
  19.     {
  20.         deals = zoho.crm.getRecordById("Deals",zcrm_potential_id);
  21.         What_type_of_job_is_this = deals.get("What_type_of_job_is_this");
  22.     }
  23.     estimate_id = estimate.get("estimate_id");
  24.     estimate_number = estimate.get("estimate_number");
  25.     currency_id = estimate.get("currency_id");
  26.     line_items = estimate.get("line_items");

  28.     // Initialize lists to hold Supply and Installation items
  29.     if(What_type_of_job_is_this == "Mixed Scope (Supply + Install)")
  30.     {
  31.         supply_items = List();
  32.         installation_items = List();

  34.         // Filter line items based on Item Category
  35.         for each  item in line_items
  36.         {
  37.             // Access the custom field "Item Category"
  38.             custom_fields = item.get("item_custom_fields");
  39.             item_category = "";
  40.             for each  cf in custom_fields
  41.             {
  42.                 if(cf.get("label") == "Item Category")
  43.                 {
  44.                     item_category = cf.get("value");
  45.                     break;
  46.                 }
  47.             }

  49.             // Create an item map for invoice creation, including tax
  50.             item_map = Map();
  51.             item_map.put("item_id",item.get("item_id"));
  52.             item_map.put("quantity",item.get("quantity"));
  53.             item_map.put("rate",item.get("rate"));
  54.             item_map.put("tax_id",item.get("tax_id"));
  55.             // Include tax ID (e.g., GST)
  56.             description = item.get("description");
  57.             if(description.length() > 100)
  58.             {
  59.                 description = description.subString(0,100); // Truncate to 100 characters
  60.             }
  61.             item_map.put("description",description);
  62.             // Optional: from quote, limited to 100 characters
  63.             item_map.put("unit",item.get("unit"));
  64.             // Optional: from quote

  66.             if(item_category.equalsIgnoreCase("Supply"))
  67.             {
  68.                 supply_items.add(item_map);
  69.             }
  70.             else if(item_category.equalsIgnoreCase("Installation"))
  71.             {
  72.                 installation_items.add(item_map);
  73.             }
  74.         }

  76.         // Prepare common invoice details
  77.         current_date = today;
  78.         current_date = current_date.toString("yyyy-MM-dd");
  79.         // Format for API
  80.         due_date = addDay(current_date,30).toString("yyyy-MM-dd");

  82.         // API URL for Zoho Books Invoices endpoint
  83.         base_url = "https://www.zohoapis.com.au/books/v3/invoices?organization_id=" + org_id;

  85.         // Create Supply Invoice if there are Supply items
  86.         if(!supply_items.isEmpty())
  87.         {
  88.             supply_invoice_map = Map();
  89.             supply_invoice_map.put("customer_id",customer_id);
  90.             supply_invoice_map.put("currency_id",currency_id);
  91.             supply_invoice_map.put("date",current_date);
  92.             supply_invoice_map.put("due_date",due_date);
  93.             supply_invoice_map.put("line_items",supply_items);
  94.             supply_invoice_map.put("reference_number","SUP-" + estimate_number);
  95.             supply_invoice_map.put("notes",estimate.get("notes"));
  96.             supply_invoice_map.put("terms",estimate.get("terms"));
  97.             supply_invoice_map.put("invoiced_estimate_id",estimate_id);
  98.             // Link to estimate
  99.             supply_invoice_map.put("zcrm_potential_id",zcrm_potential_id);
  100.             // CRM deal link
  101.             supply_invoice_map.put("ignore_auto_number_generation",false);
  102.             // Auto-generate invoice number
  103.             supply_invoice_map.put("is_inclusive_tax",false);
  104.             // Match your sample
  105.             supply_invoice_map.put("discount",0);
  106.             // From quote
  107.             supply_invoice_map.put("shipping_charge",0);
  108.             // From quote
  109.             supply_invoice_map.put("adjustment",0);
  110.             // From quote

  112.             // Convert map to JSON string for API
  113.             parameters_data = supply_invoice_map.toString();

  115.             // Invoke URL to create Supply Invoice
  116.             response = invokeurl
  117.             [
  118.                 url :base_url
  119.                 type :POST
  120.                 parameters:parameters_data
  121.                 connection:"zohobooks"
  122.             ];
  123.             info response;
  124.         }

  126.         // Create Installation Invoice if there are Installation items
  127.         if(!installation_items.isEmpty())
  128.         {
  129.             installation_invoice_map = Map();
  130.             installation_invoice_map.put("customer_id",customer_id);
  131.             installation_invoice_map.put("currency_id",currency_id);
  132.             installation_invoice_map.put("date",current_date);
  133.             installation_invoice_map.put("due_date",due_date);
  134.             installation_invoice_map.put("line_items",installation_items);
  135.             installation_invoice_map.put("reference_number","INST-" + estimate_number);
  136.             installation_invoice_map.put("notes",estimate.get("notes"));
  137.             installation_invoice_map.put("terms",estimate.get("terms"));
  138.             installation_invoice_map.put("invoiced_estimate_id",estimate_id);
  139.             // Link to estimate
  140.             installation_invoice_map.put("zcrm_potential_id",zcrm_potential_id);
  141.             // CRM deal link
  142.             installation_invoice_map.put("ignore_auto_number_generation",false);
  143.             // Auto-generate invoice number
  144.             installation_invoice_map.put("is_inclusive_tax",false);
  145.             // Match your sample
  146.             installation_invoice_map.put("discount",0);
  147.             // From quote
  148.             installation_invoice_map.put("shipping_charge",0);
  149.             // From quote
  150.             installation_invoice_map.put("adjustment",0);
  151.             // From quote

  153.             // Convert map to JSON string for API
  154.             parameters_data = installation_invoice_map.toString();

  156.             // Invoke URL to create Installation Invoice
  157.             response = invokeurl
  158.             [
  159.                 url :base_url
  160.                 type :POST
  161.                 parameters:parameters_data
  162.                 connection:"zohobooks"
  163.             ];
  164.             info response;
  165.         }
  166.     }
  167.     else
  168.     {
  169.         supply_items = List();

  171.         // Create an item map for invoice creation, including tax
  172.         for each  item in line_items
  173.         {
  174.             // Create an item map for invoice creation, including tax
  175.             item_map = Map();
  176.             item_map.put("item_id",item.get("item_id"));
  177.             item_map.put("quantity",item.get("quantity"));
  178.             item_map.put("rate",item.get("rate"));
  179.             item_map.put("tax_id",item.get("tax_id"));
  180.             // Include tax ID (e.g., GST)
  181.             description = item.get("description");
  182.             if(description.length() > 100)
  183.             {
  184.                 description = description.subString(0,100); // Truncate to 100 characters
  185.             }
  186.             item_map.put("description",description);
  187.             // Optional: from quote, limited to 100 characters
  188.             item_map.put("unit",item.get("unit"));
  189.             supply_items.add(item_map);
  190.         }

  192.         // Prepare common invoice details
  193.         current_date = today;
  194.         current_date = current_date.toString("yyyy-MM-dd");
  195.         // Format for API
  196.         due_date = addDay(current_date,30).toString("yyyy-MM-dd");

  198.         // API URL for Zoho Books Invoices endpoint
  199.         base_url = "https://www.zohoapis.com.au/books/v3/invoices?organization_id=" + org_id;

  201.         // Create Supply Invoice if there are Supply items
  202.         supply_invoice_map = Map();
  203.         supply_invoice_map.put("customer_id",customer_id);
  204.         supply_invoice_map.put("currency_id",currency_id);
  205.         supply_invoice_map.put("date",current_date);
  206.         supply_invoice_map.put("due_date",due_date);
  207.         supply_invoice_map.put("line_items",supply_items);
  208.         supply_invoice_map.put("reference_number",estimate_number);
  209.         supply_invoice_map.put("notes",estimate.get("notes"));
  210.         supply_invoice_map.put("terms",estimate.get("terms"));
  211.         supply_invoice_map.put("invoiced_estimate_id",estimate_id);
  212.         // Link to estimate
  213.         supply_invoice_map.put("zcrm_potential_id",zcrm_potential_id);
  214.         // CRM deal link
  215.         supply_invoice_map.put("ignore_auto_number_generation",false);
  216.         // Auto-generate invoice number
  217.         supply_invoice_map.put("is_inclusive_tax",false);
  218.         // Match your sample
  219.         supply_invoice_map.put("discount",0);
  220.         // From quote
  221.         supply_invoice_map.put("shipping_charge",0);
  222.         // From quote
  223.         supply_invoice_map.put("adjustment",0);
  224.         // From quote

  226.         // Convert map to JSON string for API
  227.         parameters_data = supply_invoice_map.toString();

  229.         // Invoke URL to create Supply Invoice
  230.         response = invokeurl
  231.         [
  232.             url :base_url
  233.             type :POST
  234.             parameters:parameters_data
  235.             connection:"zohobooks"
  236.         ];
  237.         info response;
  238.     }

    • Recent Topics

    • Best way to schedule bill payments to vendors

      I've integrated Forte so that I can convert POs to bills and make payments to my vendors all through Books. Is there a way to schedule the bill payments as some of my vendors are net 30, net 60 and even net 90 days. If I can't get this to work, I'll have

    • Cant update image field after uploading image to ZFS

      Hello i recently made an application in zoho creator for customer service where customers could upload their complaints every field has been mapped from creator into crm and works fine except for the image upload field i have tried every method to make

    • Billing Management: #4 Negate Risk Free with Advances

      In the last post, we explored how unbilled charges accumulate before being invoiced. But what happens when businesses need money before service begins? Picture this: A construction company takes on a $500,000 commercial building project expected to last

    • Zoho Mail CC and BCC not working

      Zoho Mail CC and BCC not working. I have tried multiple combinations amongst my domain aliases but emails sent as CC or BCC never arrive, not even to Spam. I have checked that the DNS is set up correctly in Cloudflare and have even received a DMARC report

    • Is there an equivalent to the radius search in RECRUIT available in the CRM

      We have a need to find all Leads and/or Contacts within a given radius of a given location (most likely postcode) but also possibly an address. I was wondering whether anyone has found a way to achieve this in the CRM much as the radius search in RECRUIT

    • Zoho CRM Inventory Management

      What’s the difference between Zoho CRM’s inventory management features and Zoho Inventory? When is it better to use each one?

    • Cannot Enable Picklist Field Dependency in Products or Custom Modules – Real Estate Setup

      Hello Zoho Support, I am configuring Zoho CRM for real estate property management and need picklist field dependency: What I’ve tried: I started by customizing the Products module (Setup > Modules & Fields) to create “Property Type” (Housing, Land, Commercial)

    • Get Workflow Metadata via API

      Is there a way to get metadata on workflows and/or custom functions via API? I would like to automatically pull this information. I couldn't find it in the documentations, but I'm curious if there is an undocumented endpoint that could do this. Moderation

    • Zoho Projects - Q2 Updates | 2025

      Hello Users, With this year's second quarter behind us, Zoho Projects is marching towards expanding its usability with a user-centered, more collaborative, customizable, and automated attribute. But before we chart out plans for what’s next, it’s worth

    • FSM setup

      So we have been tinkering with FSM to see if it is going to be for us. Now is the time to bite the bullet and link it to our zoho books and zoho crm. The help guides are good but it would really help if they were a bit more in depth on the intergrations.

    • Upcoming Updates to the Employees Module in Zoho Payroll (US)

      We've made a couple of updates to the Employees module in Zoho Payroll (latest version of the US edition). These changes will go live today. While creating an employee Currently, the Compensation Details section is part of the Basic Details step, where

    • Possible to Turn Off Automatic Notifications for Approvals?

      Hello, This is another question regarding the approval process. First a bit of background: Each of our accounts is assigned a rank based on potential sales. In Zoho, the account rank field is a drop-down with the 5 rank levels and is located on the account

    • ZOHO Creator subform link

      Dear Community Support, I am looking for some guidance on how to add a clickable link within a Zoho Creator subform. The goal is for this link to redirect users to another Creator form where they can edit the data related to the specific row they clicked

    • Allow Resource to Accept or Reject an Appointment

      I have heard that this can be done, is there any documentation on how?

    • Create new Account with contact

      Hi I can create a new Account and, as part of that process, add a primary contact (First name, last name) and Email. But THIS contact does NOT appear in Contacts. How can I make sure the Contact added when creating an Account is also listed as a Contact?

    • Custom Fonts in Zoho CRM Template Builder

      Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities if

    • Python - code studio

      Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already

    • Sync desktop folders instantly with WorkDrive TrueSync (Beta)

      Keeping your important files backed up and accessible has never been easier! With WorkDrive desktop app (TrueSync), you can now automatically sync specific desktop folders to WorkDrive Web, ensuring seamless, real-time updates across devices. Important:

    • How To Insert Data into Zoho CRM Organization

      Hi Team I have this organization - https://crm.zoho.com/crm/org83259xxxx/tab/Leads I want to insert data into this Leads module, what is the correct endpoint for doing so ? Also I have using ZohoCRM.modules.ALL scope and generated necessary tokens.

    • Where can I get Equation Editor por Zoho Writer?

      I need to use Math Formulas in my document. Thank you.

    • Filtering repport for portal users

      Salut, I have a weird problem that I just cannot figure out : When I enter information as administrator on behalf of a "supplier" portal user (in his "inventory" in a shared inventory system), I can see it, "customer" portal users can see it, but the

    • I want to add my other zoho account in same pc

      why does zoho restrict me doing many things as i also want to add my second mail account bit its not allowing me to do that

    • Zoho Inventory. Preventing Negative Stock in Sales Orders – Best Practices?

      Dear Zoho Inventory Community, We’re a small business using Zoho Inventory with a team of sales managers. Unfortunately, some employees occasionally overlook stock levels during order processing, leading to negative inventory issues. Is there a way to

    • Sorten the domain of zoho mail ids

      I recently created zoho mail id and am quite excited with the features. But one issue ig nobody wanna type this big zohoaccounts.com I mean silly bold Suggestion zmail.com (sound gmail) (attraction) or some genz words looks cool

    • Request for Creating Multiple Email Accounts on One Mobile Number

      Dear Zoho Team, I am planning to shift all my work-related communication to Zoho Mail because of its reliability and features. For my work, I need to create 3–4 separate email accounts for different purposes. Could you please confirm if it is possible

    • BUTTONS SHOWN AS AN ICON ON A REPORT

      Hi Is there any way to create an action button but show it as an icon on a report please? As per the attached example? So if the user clicks the icon, it triggers an action?

    • Dropshipping Address - Does Not Show on Invoice Correctly

      When a dropshipping address is used for a customer, the correct ship-to address does not seem to show on the Invoice. It shows correctly on the Sales Order, Shipment Order, and Package, just not the Invoice. This is a problem, because the company being

    • RFQ MODEL

      A Request for quotation model is used for Purchase Inquiries to multiple vendors. The Item is Created and then selected to send it to various vendors , once the Prices are received , a comparative chart is made for the user. this will help Zoho books

    • Will zoho thrive be integrated with Zoho Books?

      title

    • Product Updates in Zoho Workplace applications | August 2025

      Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this August. Zoho Mail Delegate Email Alias Now you can let other users send emails on your behalf—not just from your primary

    • Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked

      Hi, I sent few emails and got this: Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked And now I have few days since I cant send any email. Is there something wrong I did? Also can someone fix this please

    • Want to use Zoho Books in Switzerland. CHF support planned?

      Hi, We're a Swiss company using other Zoho suite software and I discovered Zoho Books and other accounting SaaS when looking for an accounting tool. Do you intend to cover Switzerland and CHF based accounting anytime soon? Roy

    • Weekly Tips : Teamwork made easy with Multiple Assignees

      Let's say you are working on a big project where different parts of a single task need attention from several people at the same time—like reviewing a proposal that requires input from sales, legal, and finance teams. Instead of sending separate reminders

    • Best way to share/download presentation files in Zoho without losing formatting?

      Hello Zoho Community, I often work with PPT/PDF files in Zoho Docs and share them with colleagues. While PDFs usually give a direct download option, I’ve noticed that PPT/PPTX files sometimes only open in the viewer without a clear download link. Is there

    • Celebrating Connections with Zoho Desk

      September 27 is a special day marking two great occasions: World Tourism Day and Google’s birthday. What do these two events have in common (besides the date)? It's something that Zoho Desk celebrates, too: making connections. The connect through tourism

    • What is Resolution Time in Business Hours

      HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

    • How use

      Good morning sir I tried Zoho Mail

    • Adding Overlays to Live Stream

      Hello folks, The company I work for will host an online event through Zoho Webinar. I want to add an overlay (an image) at the bottom of the screen with all the sponsors' logos. Is it possible to add an image as an overlay during the live stream? If so,

    • Email Sending Failed - SMTP Error: data not accepted. - WHMCS Not sending emails due to this error

      I have been trying to figure out a fix for about a week now and I haven't found one on my own so I am going to ask for help on here.  After checking all the settings and even resetting my password for the email used for WHMCS it still says: Email Sending Failed - SMTP Error: data not accepted.  I have no clue how to fix it at this point. Any insight would be lovely. 

    • Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

      Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?

    • Next Page