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 ?
Zoho Books API pull data into Excel
I looked at the Zoho Books API and I see that I can get it to return invoice details based on the invoice ID: https://books.zoho.com/api/v3/invoices/ [invoice id here] ?authtoken=[authorization token here]&organization_id=[organization id here] When I
Accounting challenge with Invoice and payments happening outside Zoho Books
We use Zoho Books for accounting. Our challenge is that while Zoho is used for accounting, we use Djubo an online hotel reservations app for integrating bookings from various online platforms like Airbnb, booking.com and our own booking engine. The reservations
Accounting challenge with invoice and payments happening outside Zoho Books
I run a small homestay. We use Zoho Books for accounting. Our challenge is that while Zoho is used for accounting, we use Djubo an online hotel reservations app for integrating bookings from various online platforms like Airbnb, booking.com and our own
Getting error in Zoho Books Workflow Rule: Error due to - 'UnAuthenticated Connection: zohobookstocreator'
Hi, I have written a custom function to insert records from Zoho Books Invoice to Zoho Creator whenever an invoice is created. The custom function is working fine when I try to execute manually. I could see the record created in Zoho Creator as well without
Create a specific field with sequential number (+1) - Need help with formula
Hello everyone, I need support please! I would like to create a specific field in Books. This missing field should consist of the following parameters: 1. symtax: "PR-" 2. customer number (cf_kdnr) 3. consecutive 3-digit number I would like to achieve
Webhook Stock Changes
Hi! I created a webhook for item updates. Therefor, I created a Webhook under Automation > Workflow Actions for the Item-Module and a Workflow-Rule under Automation > Workflow Rules for the Item-Module. Everything is working so far except the Stock. Is
Can I specify which fields I want in a response?
When I get a list of customers with https://books.zoho.com/api/v3/contacts?organization_id=org_id, is there a way to specify which fields I want in the response? I don't need to receive every field. I know it's just a matter of only reading the fields
Default value of custom field not showing
I have made a custom field "PO number" under Sales Order. I have made the same custom field under Invoices and set the default value to ${salesorder.cf_po} so that when I make an invoice the PO number from the sales order is automatically filled in. This
Automation - Auto Apply Invoice Template
Hi, I'm looking for help on a way to automatically apply a specific template based on the currency set for the customer. As an example, if I create a brand new invoice and select a customer with their currency set to CAD I want it to automatically change
Custom function that Gives total sales of an item in the last 30 days
Hi, I would like to have a custom field that is updated by a custom function. The field "widget 1 sales" - total sales (Paid amount) of "widget 1" in the last 30 days. The function - everytime "widget 1" has been paid on an invoice update "widget 1 sales"
ChartOfAccounts endpoint does not return description when showbalance filter is used
I'm trying to request the ChartOfAccounts endpoint using the filter showbalance=true but whenever I try this, the description field comes as an empty string for all records in the response. This produces a correct result with description populated but
Updated Python Samples/SDK for books? Edited to include my own repo
There seems to be some wrappers out there but they are outdated and many years old and it looks abandoned and not updated to the latest API. Can anyone share a working python project that handles the token refresh stuff and has some sample endpoint calls?
How to set Automation for expired Estimate Reminder
Hi I see we can set automatic invoice overdue reminders but i am trying to set an automation to send an email reminder when a client has either not seen or not approved an Etimate.so far I have this but have no idea if it would work ? Any help would be
Trying to create a paid invoice
Hi all, I'm trying to use Zapier to connect Woocommerce to Books to create a paid invoice. I can get a draft invoice created, but am stuck trying to update the draft invoice. I've tried a number of custom functions from other threads but can't seem to
Is it possible Multiple Instances in Zoho books?
Is it possible Multiple Instances in Zoho books??? For eg. i have enter a debit note or invoice in 1 company and then 2nd company will update automatically sync the same and get updated.
Multiple Instances in Zoho books
Is it possible Multiple Instances in Zoho books??? For eg. i have enter a debit note or invoice in 1 company and then 2nd company will update automatically sync the same and get updated.
Next Page