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

    • Commerce Order as Invoice instead of Sales Order?

      I need a purchase made on my Commerce Site to result in an Invoice for services instead of a Sales Order that will be pushed to Books. My customers don't pay until I after I add some details to their transaction. Can I change the settings to make this

    • Import data into Multi-Select lookup field from CSV/Excel

      How to import data into a multi-select lookup field from the CSV/Excel Sheet? Let's say I have an Accounts multi-select lookup field in the Deals module and I want to import the Deals with Accounts field. Steps:- 1. Create/edit a multi-select lookup field

    • 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:

    • Script that deletes a record?

      We're using WP Plugin "Integration for WooCommerce and Zoho Pro", and have created a couple of Feeds to send data to Zoho. We are trying to create Contact records, but only based upon condition. Tried to make it with small Deluge function and Workflow,

    • A formula that capitalises the first letter of each word

      Hi all, is there a zoho formula that can capitalise the first letter of each word in a string? INITCAP only capitalises the first letter of the first word.

    • Quotes in Commerce?

      In Zoho Ecommerce, I need to be able to generate quotes, negotiate with customers, and then generate invoices. Currently, I plan to integrate Zoho CRM to generate quotes. After negotiation and confirmation, I will push the details to Zoho Ecommerce to

    • Zoho Commerce - Mobile Application

      Does Zoho Commerce have a mobile application for customers to place an order?

    • Register user through Phone Number by Generating OTP

      In zoho commerce , I am developing website on online food store Inilialy the user get verification code to their email for registering there account for login. But I need to login using phone number by generating OTP automatically rather than verification

    • Unable to change sales_order status form "not_invoiced" to "invoiced"

      I am automating process of creating of invoice from sales_orders by consolidated sales_orders of each customer and creating a single invoice per customer every month. I am doing this in workflow schedule custom function where i create invoice by getting

    • Custom Buttons for Mass Actions

      Hello everyone, We’ve just made Custom Buttons in Zoho Recruit even more powerful! You can now create Bulk Action Buttons that let you perform actions on multiple records at once, directly from the List View. What’s new? Until now, custom buttons were

    • Zoho Vault Passwords

      Is there a way to consume Zoho Vault Manager passwords using the API? Thanks in advance.

    • Is the ChatGPT Assistant integration capable of recognizing WhatsApp voice messages?

      I was wondering: if a visitor sends me a voice message on WhatsApp, would the assistant be able to transcribe it and reply to them?

    • Zoho Creator to Zoho CRM Images

      Right now, I am trying to setup a Notes form within Zoho Creator. This Notes will note the Note section under Accounts > Selected Account. Right now, I use Zoho Flow to push the notes and it works just fine, with text only. Images do not get sent (there

    • 【Zoho CRM】レポート機能のアップデート

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、レポート機能のアップデートをご紹介します。 目次 1. レポートのエクスポート時のレコードIDの表示について 2. 通貨項目の表示について 3. レポートの削除の監査ログへの反映について 1. レポートのエクスポート時のレコードIDの表示について これまで、レポートをエクスポートするとファイルにレコードIDが必ず含まれていました。レコードIDが識別子として役立つ場合もありますが、実際には多くの企業で参照されることはありません。

    • Translation in zoho bookings

      We cant translate zoho booking emails. The general text we can change. But what about text like: ""Here a link to join the meeting online:"" and "Add to Zoho Calendar" and "Add to Google Calendar"? No professional business have mixed languages. Its looking

    • Is there any way to bill one client in different currencies on different invoices?

      I have some customers who have their currency set as USD and most of their billing is done in USD.   However, from time to time I have a need to bill them in my base currency GBP for some specific invoices, but there seems to be no way of doing this that I can see. The only workaround that I can see is to create two client records for the same client, one for USD billing and one for GBP billing, but this is not an ideal situation. Is it likely that the (hopefully!) soon to arrive multi-currency support

    • API name for all fields in Zoho Project (Standard or custom)

      Hi! I struggle to find easily all API name of all field in Zoho Project to build my API rest with other services. We can find them very fast in CRM but not in PRoject.   Could you share a function to get the list of all API Name of any field of an App

    • Disappearing Mouse cursor in Zoho Mail / Windows 11 (Chrome + Edge)

      I'm seeing an issue when writing mails with the light theme with the mouse cursor being white and the document area also being white - making it nearly impossible to see the mouse cursor. I see the problem on Windows 11 under Chrome and Edge. (Yet to

    • Zoho Assist not rendering NinjaTrader chart properly

      Hi everyone. Just installed and testing Zoho Assist. I want to display my laptop' screen (Windows 11) on a monitor connected to my Mac mini. The laptop is running a stock trading program called NinjaTrader. Basically, when running, this program displays

    • 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

    • 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

    • Link(s) between Notes

      Hello Everyone, It would be great if links could be created between notes. Let's say we have 5 Notes A, B, C , D, E. I would like to be able to link Note A to Note B but not in other way, so no link appears in Note B linking to Note A. An so on, linking

    • Option to Hide Project Overview for Client Profiles

      In Zoho Projects, the Project Overview section is currently visible to client profiles by default. While user profiles already have the option to restrict or hide access to the project overview, the same flexibility isn’t available for client profiles.

    • Zoho Books | Product updates | August 2025

      Hello users, We’ve rolled out new features and enhancements in Zoho Books. From the right sidebar where you can manage all your widgets, to integrating Zoho Payments feeds in Zoho Books, explore the updates designed to enhance your bookkeeping experience.

    • Regex in Zoho Mail custom filters is not supported - but it works!

      I recently asked Zoho for help using regex in Zoho Mail custom filters and was told it was NOT supported. This was surprising (and frustrating) as regex in Zoho Mail certainly works, although it does have some quirks* To encourage others, here are 3 regex

    • Feature Request: Assign Documents to Already Entered Bills, Expenses, Invoices, etc.

      Hi Zoho Team, We are regular users of the Documents module in Zoho Books and appreciate its ability to keep financial records well-organized. However, we’ve noticed a limitation: There is no way to attach a document from the "Documents > Files" section

    • I don't see any WITHDRAWL transaction at all

      Hi I manually imported my bank statement to Zoho books today and I am a complete newbie. I have been reading the knowledgebase but unable to fix this. I only see "Uncategorized 91 DEPOSIT transactions". I don't see any WITHDRAWL transaction at all. Also,

    • Shared inbox unable to see replies

      Hi we are a small company me and someone else, we have a shared inbox for our sale@ and contact@ however we have this issue where by if i reply to an email or the other person reply to the email, it does not show it to them and therefore we end up replying

    • Kaizen #136 - Zoho CRM Widgets using ReactJS

      Hey there! Welcome back to yet another insightful post in our Kaizen series! In this post, let's explore how to use ReactJS for Zoho CRM widgets. We will utilize the sample widget from one of our previous posts - Geocoding Leads' Addresses in ZOHO CRM

    • 404 error at checkout

      Our customers are getting a 404 error at checkout. Anyone else with the same problem?

    • FONT Sizing in Notebook

      Hi Kishore - What is the status of adding font sizing to the application? I have several things that I have pasted directly into Notebook and the fonts are HUGE! I would like the ability to highlight them and reduce the font to a legible size. Nothing

    • Can managers Upload documents to their direct rapports?

      Admin employees have the ability to upload documents to employees' files; however, managers do not have add/manage button - is it possible for managers to upload their direct reports' documents, such as absence documents or 121 documents. Is there something

    • Leave balance display for next year

      Is there a way to not have a rollover or not limit the leave balance depending on the date. For example an employee has 10 days leave balance and wants to apply for January leave in December. They cant because the rollover doesnt show the leave balance

    • Please add an “Auto-Apply Unused Credits” toggle

      Hello — please add a simple org-level option to automatically apply unused credits (credit notes, excess payments, retainers) to new invoices and/or bills. An ON/OFF toggle with choices “invoices”, “bills”, or “both” would save lots of manual work for

    • Zoho Books not working/loading

      Hi! I haven't been able to access/load Zoho Books for the past hours. I get a time out (and it is not due to my internet connection). Could you please check this asap? Thank you!

    • Custom Fields with Data Types for Expense and Payments Received in Zoho Books

      Hi all, We are glad to present to you, the option to create Custom Fields for the Expense and Payments received modules in Zoho Books. This also comes with an icing on top of it - Yes, the custom fields can now be created with different data types. Types like Text, Number, Decimal, Amount, Auto Number and Check Box are supported as of now. Rush to the gear icon at the top right corner, select 'More Settings', choose 'Preferences' in the left pane. Click the Expense/Payment preferences where you can

    • [Webinar] Automate sales and presales workflows with Writer

      Sales involves sharing a wide range of documents with customers across the presales, sales, and post-sales stages: NDAs, quotes, invoices, sales orders, and delivery paperwork. Generating and managing these documents manually slows down the overall sales

    • Zoho Cliq - Incident alert (Server outage - IN DC) | August 28

      We've received server down alerts and are currently investigating the issue (IN DC) to find the root cause. Our team is actively working to restore normal operations at the earliest. Status: Under investigation Start time: 09:44:21 AM IST Affected location:

    • Claude + MCP Server + Zoho CRM Integration – AI-Powered Sales Automation

      Hello Zoho Community 👋 I’m excited to share a recent integration we’ve worked on at OfficehubTech: ✅ Claude + MCP Server + Zoho CRM This integration connects Zoho CRM with Claude AI through our custom MCP Server, enabling intelligent AI-driven responses

    • How can I see content of system generated mails from zBooks?

      System generated mails for offers or invices appear in the mail tab of the designated customer. How can I view the content? It also doesn't appear in zMail sent folder.

    • Next Page