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

        • Zoho CRM Kiosk Upload Files

          Hello all, We are trying out Kiosks at the moment to see where it can fit best in our business. We are still a bit off in the application but lets say we will sort this out. My question is the following - when I create a Kiosk I can add "File Upload"

        • Double opt-in notifications and customizable confirmation messages for your webforms

          Dear CRM Community, We are excited to announce a major upgrade to our Webforms feature. You can now customize the confirmation message shown to your users who double opt-in from your webform and also customize your confirmation emails when they submit

        • Has Anyone successfully integrated Zoho and Sage Intact?

          Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

        • Introducing Image Upload Field

          Hello everyone, In this post we will discuss about the benefits and usage of the Image upload field. The field is available for standard and custom modules.  Usage: This field can be used to upload a gallery of images to a record and share the record with peers or customers. The record can be made accessible to users outside of Zoho CRM via Portals, where they can upload the necessary images. Preview, editing, and deleting images: The uploaded images can be directly edited and saved from the record

        • Trigger a Workflow Function if an Attachment (Related List) has been added

          Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger

        • Free webinar alert on November 19 - Email driven strategies - Master personality based styles

          Hello Zoho Community! Want to make email management easier, smarter, and more you? We’ve got just the session for you! Join our interactive, game-based webinar to discover how Zoho Mail adapts to your personality and work style. Learn practical hacks,

        • AI generated meeting notes associated to Account or Deal

          As our organization works to improve efficiency we are looking for a solution to leverage AI to generate meeting notes and then add those notes to a CRM record such as an Account or Deal. I see Zoho has a Notebook AI offering that talks about the ability

        • due date on cheue

          how to handle cheque in zoho books for customers and vendors including due date

        • Zoho CRM Portal Field Level Permission Issue

          Hi Support Team, I am using the Zoho CRM Portal and configuring field-level editing permissions. However, we are unable to restrict portal users from editing certain fields. We have created a portal and provided View and Edit (Shared Only) access for

        • WebDAV / FTP / SFTP protocols for syncing

          I believe the Zoho for Desktop app is built using a proprietary protocol. For the growing number of people using services such as odrive to sync multiple accounts from various providers (Google, Dropbox, Box, OneDrive, etc.) it would be really helpful if you implemented standard protocols such as WebDAV / FTP / SFTP so that alternative inc clients can be used.

        • 'Statement of Accounts does not exist' error received, when creating PO using api in Zoho Inventory

          Here is request json -- JSONString = { "date": "2019-09-24", "purchaseorder_number": "PO-6-1", "delivery_date": null, "delivery_org_address_id": 36221200000056XXX, "vendor_id": 362212000000564XXX, "attention": "Testing", "line_items": [{ "unit": "Pieces", "account_id": 36221200000003XXX, "quantity": 1, "item_id": 362212000000049XXX, "tax_type": "", "tax_name": "", "name": "One HD", "purchase_rate": 85, "tax_percentage": 0, "item_total": 85.00, "tax_id": "", "warehouse_id": 362212000000564XXX }] }

        • Zoho Projects API 100 requests/2 min. Limit

          Hi Requesting clarification on the API documentation. "You can invoke or call an API for 100 times in a span of two minutes. If you invoke more than 100 times, the particular API request will be locked for the next 30 minutes. " Does this limit apply

        • Unveiling Zoho Sites 2.0 - A new dimension in website building

          Dear Zoho Sites Users, We are thrilled to announce the launch of Zoho Sites 2.0 today! This refresh represents a significant step forward in the capabilities of Zoho Sites and is crucial for creating a lasting and positive impact on our customers' businesses.

        • 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

        • Zoho Projects - Attachments added to Task and Bug emails are not saved

          Hi Projects team, I have been experimenting with emails into projects to create tasks and bugs. I have noticed that attachments added to the emails are not saved to the task or bug. Is this normal behaviour? Thanks, Ashley

        • Zoho Inventory's latest shipping integration updates at a glance.

          Hello Users, We would like to share some important news about our latest improvements in the Shipping integration capabilities of Zoho Inventory that we achieved in 2024 with some of our major integration partners in key editions across APAC, North America,

        • Sorting a list of record acquired from the zoho.crm.searchRecords function.

          This is something for which I'm trying to figure out a straightforward way to do. The searchRecords does a great job fetching me the records that I want. However, in some cases, where it returns multiple records, I want it to sort the returned list by date of creation of that record, so that when I do records.get(0), I get the most recent record.  As an example, here's my sample pseudo code: records = zoho.crm.searchRecords("Clients", "Office_Number:equals:123456"); Now the "records" list above contains

        • Zoho Inventory Custom Field Update

          Hello All, In this post I am describing how can we Update the Custom Field Value in Zoho Inventory. // Get Org ID orgid = organization.get("organization_id"); // Field Value resvp = ifnull(item.get("purchase_rate"),null); // Record ID iid = item.get("item_id");

        • Deprecation of the Zoho OAuth connector

          Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

        • Alphabetically

          How can i arrange alphabetically - (Manage Manufacturer) Field in Item Master 

        • Spotlight series #6: The Show app for Android TV has a new look!

          Hello everyone! We are delighted to introduce our revamped and redesigned Show app for Android TV.  Smart TVs are exploding in popularity. Android TV alone has over 110 million active monthly devices. Zoho Show, as part of a constant effort to improve

        • Can i set a default value for country and state in address field in zoho creator?

          Can i set a default value for country and state in address field in zoho creator?

        • Convert HTML to PDF & Send as Email Attachments in Zoho Creator (Deluge)

          This approach is useful for sending welcome letters, instructions, or promotional offers after order creation. // 1. Define the variables using the submitted input customerName = input.Customer_Name1; orderID = input.ID; customerEmail = input.Email_Address; //

        • Redirect after submission is not working after a few submission

          I have setup redirect url correctly and everything works as expected. However, it seems that there's a limit to the number of submissions before the redirect stops working. After the "limit" is reached, the page redirects to a seemingly zoho hosted page,

        • Enhancement Request for Multi-Asset Work Order Feature

          Hello Latha, Thank you for your continued support. The multi-asset Work Order feature is extremely helpful. I did some testing based on our requirements, and during the process, I noticed a few areas where we need your team’s support to improve the feature

        • Marketing Tip #8: Run limited-time offers

          Exclusive offers that don't last long make shoppers purchase right away instead of waiting. Run a flash sale or limited-time discount to convert interest into sales. Try this today: Set up a "Buy X Get Y" coupon in Zoho Commerce valid for a limited time

        • Add Option to Mass Dispatch by User

          Hello! We are using the dispatch console to dispatch service appointments to our service ressources. Right now, the process is our dispatcher verifies each ressource's route for the day and dispatches it after validation. Sadly, there doesn't seem to

        • Free webinar: Zoho Sign unwrapped – 2025 in review

          Hey there! 2025 is coming to an end, and this year has been all about AI. Join our exclusive year-end webinar, where we'll walk you through the features that went live in 2025, provide answers to your questions, and give you a sneak peek on what to expect

        • Zoho Projects - Email notification relabelling of modules not present on default templates

          Hi Projects Team, I noticed that in the default email template notification, the word "bug" was not renamed to the lable I am using in my system. As many users may used the Bugs modules for various purposes including Changes, Revisions, Issues, etc...

        • Publish to LinkedIn via API

          Hi, Is it possible to publish a job opening to LinkedIn (paid job slots) if creating a job opening via api / deluge function? Or is the user required to manually publish via the job boards process? Many Thanks Adrian

        • Include the "Added Email ID" to the Filters of a Report

          Hi, With a Report and lots of entries, a normal thing is to filter entries by the submitter, but that is not included in the Auto Filter of Reports and you can't add a custom filter to a Report without specifying the actual value. I would like to be able

        • Loops in Deluge

          Hi, Can someone tell me how I do a simple loop in deluge? For example, if i have a variable "X" containing a number of loops to perform, i would like to perform an action X amount of times. X = 10; do while (Y < X){       // ... do something } to further explain, the equivalent in PHP of what i am trying to acheive would be: $X = 20; for($Y = 1; $Y < $X; $Y++ ){       // ... do something } Thanks

        • I am facing a problem with an if-else condition

          If I use if, else if, and else conditions in Deluge with the same variable name, sometimes the variable causes an error because the same variable name is present in every block

        • Zoho Projects - Reply by email to @ mentions posted on the Feed.

          When mentioning someone on the Feed (Status), it would be great if that mentioned person could reply to the email notification to update the Feed thread.

        • Zoho Analytics Bulk Api Import json Data

          HI, I’m trying to bulk-update rows in Zoho Analytics, and below are the request and response details. I’d like to understand the required parameters for constructing a bulk API request to import or update data in a table using Deluge. Any guidance on

        • Record Overseas Transactions Along with CC charges

          Hi All, We receive payments via stripe in multiple currencies and stripe takes around 2.5% fees. The amount is settled in INR into our local bank. What should be the currency of the income account used for Stripe payments? Here is a sample flow that we

        • Product Updates in Zoho Workplace applications | October 2025

          Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this October. Zoho Mail Create Signature from Compose window You can now effortlessly create a Signature using the Create

        • Subform data to Sheets

          I have been trying to setup a Zoho Flow automation to bring any Subform input to a Zoho Sheets but it seems impossible to post the subform entries to a Zoho Sheet. Is there any way to do it via Zoho Sheet API? https://www.zoho.com/sheet/help/api/v2/#CONTENT-Insert-row-with-JSON-data

        • Edit Contact Roles in the Potentials Mod

          New to ZOHO so I need some help. I work the same people on different projects concurrency. Their contact info remains the same but their role changes from project to project. In the Potential Mod you can pick contacts and assign a Role to them. I know

        • Is there a way to disable the Activity Reminders Pop-Up Window every time I log in?

          Just wondering if there is a setting to disable the window from opening every time I open my CRM? Thanks Chris

        • Next Page