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

      • Send Email From the ZeptoMail BY API

        What is Zeptomail:- Transactional email service with reliable and fast delivery How we can Create a Connection for Zeptomail in Zoho CRM Go to the Setup Click on Connection Enter Connection Details:- Generate Consumer Key & Consumer Secret Using Zoho

      • Customer email on Opencart 3

        When I place an order, 2 emails are sent: 1) administrator 2) to the user The administrator receives a beautiful letter, but the user receives a damaged letter (see screenshot). What could be the problem?

      • [Announcement] Insert image from URL changes in Zoho Writer

        Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from

      • Dynamic Signature - Record owner

        Hi everyone, I’m using Zoho Writer merge templates from Zoho CRM and have two questions: Owner signature: How can I automatically insert the CRM record owner’s signature in the merged document? I’m not sure where this signature is stored or how to reference

      • Writer sing up problom

        Zoho writer sing up prolom face

      • Unable to copy into a new document

        Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you

      • [Webinar] Live demos and user Q&A with Zoho Writer product experts

        Join us on June 12, 2025 for live demos based on your use cases and real-world scenarios raised via form. This is also an opportunity to get your questions answered directly by product experts from the Zoho Writer team. Webinar agenda Live demos based

      • Zoho Writer's built-in citation and bibliography generator

        Hey researchers and writers! Do you manually format citations and bibliographies, spending hours jumping between apps and tabs? If so, then check out Zoho Writer's built-in "Citations and Bibliography" feature. Imagine you're writing a thesis on the future

      • Single and group checkboxes in Zoho Writer's fillable forms

        Hey Writer Fam, Are you making the most out of single and group checkboxes in fillable forms in Zoho Writer? Here is a handy tip to optimize your use of checkboxes, both single and group, and enhance your data collection process. Single checkboxes: Single

      • Collaborate efficiently with Zoho Writer's track changes feature

        Hi Zoho Writer Community, Zoho Writer's track changes feature is a simple, built-in solution that helps you and your team work together efficiently. Instead of juggling multiple versions of a document or building up a long email chain of comments, each

      • Zoho Writer's WordPress extensions

        Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window

      • Time-saving table hacks

        Hey Zoho Writer Community, Do you find yourself using a lot of tables in your documents? We're here to share some of our time-saving hacks that will help you work more efficiently, organize your data, and make your documents look neat and professional.

      • Automating document approval and signing with Zoho Writer and Zoho Sign

        Hey Zoho Writer Community! Here's another automation tip to make your processes more efficient! Question: Can I send a document for client approval first, then automatically send it for signing with Zoho Sign if they approve? Since it's the same person

      • Customization hacks in Zoho Writer - Part 2

        Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating

      • Simplify your tax calculations with Zoho Writer

        Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income

      • Enhance document navigation with headings and TOC

        Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents

      • Use and download in PDF format of Zoho wirter Merge template using deluge

        Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface

      • Customization hacks in Zoho Writer - Part 3

        Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge

      • Daytime saving timezones messing up writer pdf

        Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months

      • Issue with locked content in Writer

        Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't

      • Deprecation of certain URL patterns for published Zoho Writer documents

        Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their

      • Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

        Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"

      • Problem with Writer and Workdrive

        Hi team, I’m the super admin for our Zoho One org. WorkDrive is active, and Zoho Docs is deprecated for our org. However, Zoho Writer cannot connect to WorkDrive at all — we’ve cleared cache, tried incognito, and restarted several times. I was able to

      • Set to Review for all

        We are testing the use of Writer as part of an internal review process for statement of work documents and have found that when the document is changed from Compose to Review by one person, that is not reflected for all others who view the document. Is

      • I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.

        These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho

      • stock

        bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem

      • SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET

        TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO

      • Zoho sheet for desktop

        Hi is zoho sheets available for desktop version for windows

      • Tip #18: 6 Trendlines and when to use them in your spreadsheet data?

        Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that

      • Perform customized calculations with the new LAMBDA functions!

        We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs

      • No chat option

        Chat option is not supported.

      • Tip #17: Easily share spreadsheets with non-Zoho account users

        With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not

      • Work seamlessly with Sheet's shortcuts without affecting the browser

        Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. What

      • Zoho Sheet for iPad: Improved UI, external keyboard support, and more!

        The portability and capabilities of the iPad have made it an essential device in the business world. With this in mind, we had launched an exclusive Zoho Sheet app for iPad, with device-specific improvements and enhanced usability. Now, we're improving

      • The new Zoho Sheet for Android: Seamless UI and advanced features

        At Zoho Sheet, we know mobile apps have become the go-to platforms for creating, sharing, and storing information. And we understand the importance of an efficient and seamless app experience. We've been working hard on improving the overall user experience

      • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

        Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,

      • VBA attached to button no longer works on external shared sheet

        Hi - we have a Sheet that our clients use, which requires them to press a button once they've entered data. The button then triggers a flow via a webhook. The button works fine when editing within Zoho Sheet - however when shared externally it no longer

      • can I use zoho sheet for survey?

        Hi I wanna use zoho sheet for my ARY to know consumer better so i wanna have permission to do so

      • How to Avoid Impacting Other Users When Hiding Columns in Zoho Sheet

        Hi Team, We’re experiencing a challenge with the column-hiding feature on Zoho Sheet during collaborative sessions. When one user hides a column, it becomes hidden for all users working on the file, which disrupts others' workflows. In comparison, Excel

      • What are the benefits of procurement software in a growing business setup?

        I’ve been exploring tools that can help automate purchasing and vendor-related tasks. I keep hearing about the benefits of procurement software, especially for businesses that are scaling. I want to understand how it helps in streamlining operations,

      • Next Page