Idea for Function Series - create a related list that shows the dates of when an invoice changed statuses
I would like to add an Zoho Books - Invoice related list that has two columns: Date and Status. The related list would show each time the status of the invoice changed. For example: On 3/1 I create the invoice and save it in "Draft". On 3/2 I send it
Function #44: Notify admin users when expense accounts exceed the safe limit
Hello everyone, and welcome back to our series! Are you finding yourself consistently overspending in certain areas? Do you need a system to keep track of your expenses and receive alerts when specific accounts go over their limit? Today, we bring you
Creating vendor contact via API
We are trying to create vendor contact via API, it is showing error "to enable vendor portal for organisation". Can you please help on this, as we are just trying to add contact as vendor, for which why it is required to get vendor portal for organi
Can I create the Validation Rule using Custom Function in Zoho Books
Hello There, we need to restrict the submission of sales orders in confirm status.when the SO is Confirm Status.by using Validation rule in the SO. rules depends upon SO status.but how we restrict the submit action regarding another field values that
Function #7: Fetch a value from Deal in Zoho CRM to the related Estimate in Zoho Books
We're here with another function for those using the integration with Zoho CRM. You know that potentials can be linked to transactions in Zoho Books. But if you're including additional details about a Deal (potential) in Zoho CRM and you want to inherit
Add Item Rate and Item Quantity to Custom Function
Hi Team - I have a custom function that fetches a product from an invoice and displays it in a related list in the Accounts module. We need to get the item rate and item quantity of the product for that invoice. I tried to do it myself but I am note getting it. Here is the code. Can you tell me what line of code to add to fetch the item rate and item quantity? Thanks in advance for any assistance. invoiceID = invoice.get("invoice_id"); customerid = invoice.get("customer_id"); customername = invoice.get("customer_name");
Create Credit Note via Api with a Shipping Charge
Hi, An Invoice has been created with a shipping charge value via the "shipping_charge" property of the Invoice object. On trying to raise a Credit Note to reverse the Invoice value, the Api for Credit Notes https://www.zoho.com/books/api/v3/credit-notes/#create-a-credit-note
Syncing Zoho Projects and Zoho CRM with Zoho Books
I've set up the integrations with Zoho CRM and Zoho Projects, however it's creating clones of the accounts/customers - if I set both integrations to Overwrite, what happens ? What details are overwritten and is anything deleted ?
how to refund a deposit to a client's credit card using a stripe?
At the moment I see this way: To partially refund an invoice in Zoho Books, I need to create a credit note for the amount you want to refund and apply it to the invoice. Then, I need to go to the Stripe dashboard and find the payment I want to refund.
Function #43: Auto-enable Customer portal
Hello everyone, and welcome back to our series! The Customer Portal in Zoho Books serves as a platform for your customers from where they can accept quotes, view sales orders, monitor shipment statuses, make invoice payments, and manage other related
How to update Contact without Delete
Hi Team, I'm trying to update existing contacts in Zoho without deleting the contact person or address. However, the Zoho documentation states that updating a contact requires removing the contact person from the contact_persons list. When I attempt this
WordPress To Zoho Books Integration
Hi there I'm not sure if this is the correct place to discuss this, but I wanted to find if anyone is interested in a WordPress Plugin that connects your contact page into Zoho Books? What it does in a Nutshell is takes the contact fields from Contact 7 and injects them into a new customer record in Zoho Invoice. but before that it also checks if it's SPAM by testing the phone number, message text and the email address validity and if it passes all those tests then it creates a new record. That's
Getting customer_custom_fields when getting a creditnote (they are available for invoices)
we are working on a Zoho Books integration. When getting a single invoice via the API under https://www.zohoapis.com/books/v3/invoices/:invoiceId, the response includes custom fields added to the customer under the key "customer_custom_fields". However,
Using an API how do I associate an existing project with a recurring invoice?
Using an API how do I associate an existing project with a recurring invoice? Can it be done by adding the project ID to a list item?
Using API "Email multiple estimates" does not create a public link for signing estimates
Hello, I have a workflow associating zoho and integromat (make). I need to create three estimates to send to my clients. -First estimate is sent through the create estimate in integromat. There is an option to directly send the estimate. -Second and third
On User Input like action of Creator/Deluge in Zoho Books
Hi, Do we have any facility available now to update a field by means of adding/multiplying two exisitng fields and populate in the 3rd field in UI? Example: If I have fields size, qty and defaultVal, I want to populate size*qty to defaultVal field upon
Calculate a field on client side using user input
I have 2 custom fields in invoice called Height and Width. I want to calculate Area based on user input on client side. How is this possible?
com.zoho.dre.exception.DREException
Hi, I am getting the following error: Exception : com.zoho.dre.exception.DREException: An error occurred. Check the service and connection details of wixbooks connection and try again. where "wixbooks" is my connection name. I am using a server-application
Invoice Related List - Credit Notes
Hi ZOHO Community! As far as we can see there isn't a way of referencing a Credit Note against an Invoice that is native to Books. You can see it in the Comments & History section and also in the SO byway of the canceled items but not in the body of the
Function #41: Notify users when sales orders exceed the credit limit
Hello everyone, and welcome back to our series! As you're aware, Zoho Books lets you set credit limits for your customers, that can be monitored in both invoices and sales orders. Previously, we shared a custom function that can alert users when an invoice
Payment approval
Zoho Books currently supports three levels of transaction approval for bills: Draft, Submit, and Approved. We are looking to add an additional layer of approval like bill marked for payment before initiating payment requests through HSBC Bank. Can you
Function #40: Notify users when invoices exceed the credit limit
Hello everyone, and welcome back to our series! Businesses tend to offer goods or services on credit to customers, which can, in overtime, lead to the accumulation of significant overdue balances. To address this, Zoho Books allows you to define a Credit
take info from form to do transactions in zoho books
Hello, basically we are doing a form where clients will put their info and everything and I was wondering if there was a way to use the info from the form to make an estimate in their accoutn in zoho books and when the estimate is paid if we can use the
Is there any way to get the invoice preference of a project using Deluge in Zoho Books with getRecordsByID("Projects",organizationID,project_id)
Is there any way to get the invoice preference of a project using Deluge in Zoho Books with getRecordsByID("Projects",organizationID,project_id) or something similar?
Item allocation / deductions
We have many sales orders which cannot be shipped or invoiced perhaps weeks or months in advance but we need to allocate items for these sales from non replenishable stock items. This leads to major problems when we get another order for the same item because we tend to use this item as it's showing sufficient stocks because it hasn't been deducted through the earlier sales order not being invoiced or shipped ! As I've mentioned previously - I'd like to see another mode of stock tracking - "Receives
Function #37: Display list of associated SO on Quote details screen
Previously, in our series, we shared a script to display the list of purchase orders within their corresponding sales order details page as a Related List. We hope you found it beneficial. Similar to that, we bring you another script that can display
Function #39: Schedule Vendor Statements
Hello everyone! As we continue our series, today we bring you a function that automatically sends vendor statements at scheduled intervals, similar to the function we previously shared for sending customer statements. By minimizing the need for manual
Zoho API returns 401 even after providing valid token
My API calls was success , suddenly its returning 401 , after adding space between Zoho-oauthtoken ${access_token} it started workign and still API response is inconsistant Environment: node js Anyone facing same issue ?
Payment refund done with Deluge
Good day, I am a newbie to ZOHO and deluge, and hope someone can assist. Is there a way to create a Payment Refund on a Payment with a deluge script? Thank you in advance
Create invoice from a sales order via Api
Hey there, how do i create an invoice from a sales order via Api?
Function #38: Charge rush fees for invoices
Hello everyone! Rush fees are additional charges that businesses add to invoices when customers request expedited or prioritized services, compensating for the extra resources and effort. The method for calculating these fees can vary across industries
ZOHO Books Manual Journal Entry Failing with error 'The Debits and Credits do not match. Please make sure they're equal'
ZOHO Books Manual Journal entry giving error with 'The Debits and Credits do not match. Please make sure they're equal'. The same is working till 18-July-2022. After that onwards, the manual entry fails. I calculated the entry values and they are matching.
Function #35: Automatically create a Task when a Quote is sent
Hello everyone, and welcome back to our series! A business employs various approaches to boost its revenue, and one such method involves promptly following up with customers to convert Quotes into actual sales. The challenge lies in handling numerous
Function #27: Apply unused credits automatically to bills
Welcome back everyone! In our ongoing series, we previously shared a custom function that automates the application of unused credits to your invoices. We've been listening to your feedback, and many of you have asked for a similar function to be applied
Woocommerce - Incoming webhook
Hello, I've recently explored various methods for integrating WooCommerce with Zoho Books and discovered that utilizing incoming webhooks offers an optimal balance of cost-efficiency and customization flexibility. This prompted me to develop my own webhooks,
Default field that is present when searching Zoho Invoices is not present when pulling an invoice directly using ID
So when I just pull a list of all records, lets say from the past 7 days. It lists the records in a JSON as expected with data for each. One of the fields listed is "transaction_type". This is generally "renewal", "new", etc. The problem is, when I use
Creating Vendor payment with tax deducted
Hello i would like to create a function in zoho deluge to create automtically vendor payment with tax deducted. There is no problem creating a vendor payement without taxes for the bills. I dont see the input of the account of the tax and the amount I
Function #3: Assign a mandatory reporting tag to invoices
At Zoho Books, we receive numerous inquiries about the option to mark reporting tags as mandatory in transactions. We do acknowledge the usefulness of this functionality and we plan to include it as a default option in the future. In the meantime, we
How to get the billing address for a Zoho Books contact using Deluge
I'm trying to get the ATTENTION value from billing address for a contact using Deluge. When I use the below code I don't get any address related information. Is that because the contact comes from Zoho CRM? zoho.books.getRecords("Contacts",organizationId,customerSearchParam)
Change Custom Status Using Custom function
@Pheranda Nongpiur @Christopher @Shyam Sundar S Can you help with codes to change the custom status for sales oder in Zoho books ?
Next Page