Make delivery note
NO. Item. QTY AMOUNT. DELIVERY 1. Red Roses
Receipt not attached on Expense API in Zoho Books
I am trying to upload a file for expense using this API : https://www.zoho.com/books/api/v3/expenses/#add-receipt-to-an-expense I have converted my file to Byte64 string and uploaded the file. I have got the successful response status that file has been
How to get customfield_id of the Items in ZohoBooks?
I'm working with ZohoBooks API for integrating with an WebApplication, I've tried finding but failed, from where Can I get the customfield_id of items created in my zohobooks account, As i Need to create products with Custom Fields from my Application
How to get deleted entity detail by a last_modified_time for zoho books entity ?
Hello, We need to get the details of deleted entities such as chartofaccounts,contacts,invoice/bills,payments,credit/debit notes,item,taxes,journals etc. By calling the respective entity API based on last_modified_time as query parameter. As of now able
Item update VAT on creation
Hi all, I'm looking to auto update the VAT field upon creation of a new item, I've written the following Custom Function, however it doesn't appear to work... Any ideas appreciated! itemID = item.get("item_id"); organizationID = organization.get("organization_id");
GST E-Invoice Custom Function
@1_Hari Prasad Kunchapu @Anand Prakash B Require Custom function codes to generate gst e-invoice and update to IRN and QR to invoices
Einvoice custom function
@Nandhini Require Custom function codes to generate gst e-invoice and update the IRN and QR to invoices @Pheranda Nongpiur
Status Change of Purchase Order via Workflow
Hello i have created a workflow where an approved Purchase Order automatically releases Purchase Order to respective vendor. I need a function to change the status of that PO to be marked as Sent.
Workflow Rule - Field Updates: Ability to use Placeholders
It will be great if you can use placeholder tags to update fields. For example if we want to update a custom field with the client name we can use ${CONTACT.CONTACT_FIRSTNAME}${CONTACT.CONTACT_LASTNAME}, etc
Invalid Value Passed for Phone
Each time we try to signup for Books w/our acct, we receive the following error: "Invalid Value Passed for Phone" Thanks in advice for your help, Craig We have a phone # input into our acct info, so not sure why this is happening? Additionally, when trying
Invalid_client when using zohobooks API
API reference: OAuth | Zoho Books | API Documentation I want to do invoice automation using Zoho APIs and for that, I needed an authentication token. I followed the steps mentioned in the above documentation. 1) Create a client to get the client id and
Function #29: Auto-populate Expiry date on Quotes
Greetings everyone! A quote (Formerly known as an estimate) is a document sent to customers containing a detailed overview of items and their prices for potential purchase. The quoted prices usually have a specific validity period, after which the proposal
Error "Zoho Books says "Invalid Element is_user_approval_needed" when creating Project from Zoho Flow
Even though the user approval is a drop down in flow, regardless of what I select (True or False) I get this error .. "Zoho Books says "Invalid Element is_user_approval_needed"
Function #51: Transaction Level Profitability for Quotes
Hello everyone, and welcome back to our series! In a previous post, we shared a custom function that could determine the profitability of a Sales Order. Today, we are presenting a similar function that calculates the profitability of a Quote. The setup
Zoho Books Create Invoice API - Cannot enter account type for line items
Hi, I am trying to create invoice via Create Invoice API and select different sales account types for the invoice line items, but this doesn't seem to be possible via Create Invoice API. I don't see any way to select "Account" for line items when creating
Function #52: Automatically associate Price Lists to customers based on currency
Hello everyone, and welcome back to our series! Businesses operating globally often need to invoice in different currencies based on the customer's location. In such cases, maintaining item rates in multiple currencies becomes essential. This is where
Zoho API CORS
Hello, I'm trying to use Zoho books API. I have registered "Client-based application" and set my JS domain to http://127.0.0.1:4200, but when making requests to API I get CORS error. Am I doing something wrong? Maybe problem is with using ip/port d
Function #42: Show the actual rate of items on invoices
Hello everyone, and welcome back to our series! In Zoho Books, you have the ability to create Price Lists, wherein you can mark up and mark down the item rates by a specific percentage or set custom rates. Generally, when you apply a price list to an
Zoho and Avalara - Marketplace Order Handling
Hi, we currently utilize the Zoho Books and Avalara connector to extract transactions and track taxes in AvaTax (Avalara). As it currently stands, our marketplaces, (Etsy, Amazon, Walmart), are directly integrated with Zoho for order fulfillment. Somehow
Line Item Description - Line Breaks | Deluge
Hi, I'm trying to update a line item's description and cant figure out how to add line breaks. If I get an existing line item's description with line breaks, I can see that they are set as the regular "\n" (As this is a JSON). But, when I try to insert
Change Status of Approved Purchase Order to Issued after via Work flow
I have created to issue or send approved purchase order via a workflow, work flow is working fine but now i need to update the status of Purchase Order from approved to Issued once this work flow is initiated. Please let me know how can i do this using
Function #36: Mail item list to customers using Custom button
Hello everyone, and welcome back to our series! In response to ever-changing market conditions, inflation, and cost fluctuations, businesses often find it necessary to revise item rates to sustain profitability. Following the changes, it also becomes
automation taxe new troubleshooting
i have selected the new automation taxe the error message says 11 659 clients don't have the address correct. It is cause when we create a client, we don't put the province. then the automatic taxe selected is the one just for canada. how to skip to have
One Sale Order to Many Purchase Orders
Hi ! We are exploring Zoho Inventory (+ CRM Plus) and cannot find the following feature We are selling packages to our customers, these packages usually contains : - Software we buy from Supplier A - Hosting we buy from Supplier B - Configuration that in done at our place by a technician When we sell this package to customer (in one Sale Order), we would like to create the corresponding Purchase Orders (one purchase order for each of the product, to the corresponding supplier) Does Zoho CRM + Inventory
Script error
Is there any reason why this isn't working as we are getting this error message. https://www.zohoapis.com.au/books/v3/salesorders/XXXXXXXXXXXX?print=true&accept=pdf&organization_id=XXXXXXXXXX might be having issues, or it may have moved permanently to
API or Deluge script for Zoho Books Attachment Custom Field
I have created a Custom Field with field type as Attachment (Not the default Attachments) for Contact module in Zoho Books. This field should be populated whenever a record is created or the Image (Attachment field) shall be updated from external system
Get Sales Order Template (PDF) and send to printer via Custom Button
Hi, I'm trying to click a custom button which sends a specific PDF template to a printer but I'm stuck! The API documentation says it's possible but I'm unsure how to implement. Any help appreciated ----------- Code I have for the PDF after I've set the
You are not authorized to perform this operation
I am trying to create an invoice from postman by following steps mentioned in postman collection. But I got struck with the following message { "code": 57, "message": "You are not authorized to perform this operation" } I have entered organization
Can I merge 2 bank accounts?
The bank downloads were not working, so we had to create new bank account name (for the same account) and new link. How to I get transactions for the "old" account into the "new" account?
In-App Notification When an Item is Removed/Reduced from an Invoice
Hi! I want to create an in-app notification for when any item is removed from an invoice after it has been created. However, when I try to do this through Custom Workflow, I do not see an option for "Item" under the Workflow Trigger Options. Is there
Where to find the new zohoapis details for API calls?
We recently got an email about an upcoming change of your Zohobooks API URLs, to be done before April. But why on earth have you not published it anywhere? Will it be a simple matter of URL changes only for our OpenCart Zohobooks Integration software?
Apply Vendor Credits On Bill Zoho Books
Hello Team, Several developers are encountering difficulties when applying credits to bills. If you refer to the Zoho Books API documentation, there is a body error, and the data we need to pass is not very clear. In this article, I am providing the correct
Function #45: Automatically convert billable expense to invoice
Hello everyone, and welcome back to our series! Zoho Books allows you to easily charge your customers for expenses that you have incurred on their behalf. You can achieve this by marking the relevant expense as billable and then manually converting it
Late fee custom script in Zoho Books
Hi New to Zoho and trying to set everything up. I want to add a late fee on my invoices. I found this script: https://www.accountexnetwork.com/blog/2016/08/zoho-books-continues-automate-custom-functions/ //create a variable to get invoice total and add a 5% discount
latefee = invoice.get("total").toDecimal() * 0.05;
//display the value stored in the latefee variable
info latefee ;
//add late fee and adjustment and store the total amount in the variable 'adjustment'
adjustment = invoice.get("adjustment").toDecimal()+
How to create a journal with Deluge?
Im trying to create a journal with a custom button from a custom module. Some of the info on the code looks like this: LineItem1 = Map(); LineItem1.put("account_id",CuentaCredito); LineItem1.put("amount",ImporteDepreciado2); LineItem1.put("debit_or_credit","credit");
using zoho books API for retainer invoice in zapier
hello, I have to create a retainer invoice when a estimate is accepted and i got everything set up but I cant seem to figure out what the good format for the api request is for the line items, I dont see what im doing wrong can someone help me with this
Zoho Books TimeSheet API Date Filter Format
I didn't see this documented anywhere and it took me an hour to figure out. In order to filter the time sheet list using: zohoapis.com/books/v3/projects/timeentries? You must also send the following parameters in this example: filter_by = Date.CustomDate
How to pull in custom fields in a Zoho Books Related List (invoice module)
I have custom fields for Zoho Invoices. How do I reference them into columns within my related list? I tried using their API name but it doesn't seem to work. I'm not sure if it matters but they are date fields.
Get more records from Zoho Books
Hello There, I have 200 above records in Zoho Books.I want to get those records and push to Creator .we need sample syntax for this.
Make an Invoice out of an Recurring-Invoice via the API?
Hello, i need to activate the Books intergrated Function to make an Invoice out of an Recurring-Invoice via the API. I have several Recurring-Invoices in Books and i am building a function, that read Zoho Desk Tickets and they Timeentrys to generate Books Item in Invoices, but if i only have an Recurring-Invoice i must generate the Invoice of it. Here is the Button in Books on an Recurring-Invoice, upper right corner, the button in the Middle (Create Invoice) :D Thanks for every help.
Next Page