Zoho Books - Zoho CRM INTEGRATION. FULL OF LIMITATIONS = RENDERED USELESS.

Zoho Books - Zoho CRM INTEGRATION. FULL OF LIMITATIONS = RENDERED USELESS.

A word of caution for anyone thinking of trying the integration. This might save you loads of time. 

SHAME this  isn't clarified in the guidance notes. 

THE MAIN PROBLEM AREAS THAT RENDER THE ZOHO BOOKS - ZOHO CRM INTEGRATION LARGELY USELESS:

1. The GUI of Inventory Modules (from ZohoBooks) are significantly archaic in comparison to the ones in the CRM + with lots of limitations. Limited fields and field types.

2. Record View Page: NO record details view. Once you create an estimate (for example) then you can only view it as a template. What about other fields you may want to exclude from template?? The only way to see it is to edit the record. Ditto in SO's or Invoices. 

3. Emails: If you create a template and send an email using the button in Zoho Books (Save & Send Email), these emails DO NOT show up in a list view, as they would if you sent from a record in the CRM. Resulting in loss of time because you need to look in different places to figure if an Estimate was actually sent. No IMAP integration of emails like in CRM. 

4. ZERO sales enablement: Before you create an invoice, you need to Quote. And the Estimate module in Books being limited in functionality (no tasks, no reminders etc) is a deal breaker in the first place. 

5. NO custom Lookup fields in ZohoBooks: Before you create a quote, a potential is created (to reflect in your sales pipeline) and then comes the quote. There is no way to associate an Estimate in ZohoBooks to a Potential in Zoho CRM. They are all associated with the Contacts - so what if you've multiple potentials for a contact?? Several clicks and navigation through multiple records to get to the potential for which you're quoting. 
PS: In creator you can add ZCRM lookup fields very easily, not sure why that can't be done in Books. 

6. Convoluted nomenclature:
Contacts in CRM is a Contact Person AND in Books it can either be Contact, Account or Vendor. 
Accounts in CRM is a Company AND in Books it is called a Contact.
Vendors in CRM is filed under Contacts in Books in a list view. 

7. Each Customer Account is "tied" to a currency. Meaning, you cannot transact with the customer in different currency other than what is set when the Customer Account record was created. So if a Customer Account record was created with USD then if you want to quote them in GBP - you need to create a duplicate Contact/Customer Account with GBP as currency. This is dumb! Because it renders the "Statement of account" feature useless. 

8. NO WAY to have Parent Account associated with Accounts to circumvent the issue in point 7 OR just in case you're dealing with different branch offices of a Customer and also a head office / parent company. Forget about a SOA for a customer's group of companies. 

9. Delivery Note and Packing slip are just printed using the Invoice record details. So an invoice needs to be created before you can create a Delivery Note or Packing Slip. 
WHATIF your customers are on credit terms of say "Invoice on Delivery" and "Due 30 days from invoice" 
IT messes up the Invoice Date and Due date in your accounts. 
 
10. No option to track status of a Delivery Note / Packing List individually because they're just templates printed using Invoice. 

11. Commercial Invoice: An important one for customs which declares value of the goods being shipped. This is MISSING altogether. Ofcourse you can create a module in creator to do this but when you have 10's of line items its inefficient at best to type it all up because DELUGE doesn't copy subform table in between records.
i.e. If you convert a Sales Order to Invoice - your line items are copied. However if you have a custom module Inventory in creator you cannot link it to ZohoCRM record (say a Quote) and then fetch all the line items into creator module record. As a result - the only option is to do the donkey work and type it all again. 

12. NO Multiple Organisation Setup: XERO has it. SAGE has this. QUICKBOOKS has this. If you're an enterprise, you likely have multiple companies/legal entities in different geo regions. Eg: Zoho USA, ZOHO India or Zoho China etc. 
And it is not essential you keep your billing or accountancy centralised for various reasons such as tax, regulatory or forex rates implication. I don't think the Book product team is even aware of these crucial imperatives that justify the need for Multiple Org Setup when it comes to accounting for Enterprises or even a SME with multiple branch offices. 

13. There is NO way to calculate and add markup at the quote stage for example when creating an Estimate in ZohoBooks. 

14. NO Approval process like in the CRM.

All these points are just from scratching the surface. There are more points but I had enough for now.

MY VERDICT - Unless you're a one man band, nut-bolt seller this integration is highly useless. NOT FOR ENTERPRISE. Better to stick to CRM Inventory modules.

Advice for Zoho Books - CRM Integration Developers.

Here's how you can start fixing some of these and what would make the integration useful. Some are simple fixes:

1. Since a Quote (Estimate) and Sales Orders are more SALES related. Let them be in the CRM. (Atleast until you match the Inventory Modules in Books to be highly customisable like in the CRM) 
2. Allow the ability to convert from Quote or Sales Order in the CRM to an Invoice in Zoho Books. 
3. All Inventory Modules are related to a Potential. So give a look up field in Books to relate records to Potentials. 
4. Remove the limitation of Account "tied" to a currency. This has to be flexible. Let people choose who they want to bill in what currency. 
5. Rename stuff.. to simplify things. 
6. Add Parent Account feature. 
Plus other points as above. 

    Access your files securely from anywhere








                    Zoho Campaigns Resources


                          Zoho Developer Community



                              Bootcamp
                              Community
                              Pricing
                              Webinars
                              What's New
                              Integrations
                              Contact Support
                              Contact Sales

                                Zoho Survey Resources
                                  Features
                                  Survey Templates
                                  Integrations
                                  Community
                                  iOS Mobile Surveys
                                  Pricing
                                  Android Mobile Surveys
                                  Insurvey Blogs
                                  Insight Blogs
                                  Tips & Tricks






                                              Latest Feature Updates

                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts




                                                    Zoho SalesIQ Resources


                                                          Manage your brands on social media
                                                          Access Zoho Social

                                                            Zoho Pagesense Resources


                                                                Zoho TeamInbox Resources

                                                                  Zoho DataPrep Resources


                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources


                                                                                            Zoho Writer Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ





                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Need Easy Way to Update Item Prices in Bulk

                                                                                                            Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

                                                                                                          • Please Make Zoho CRM Cadences Flexible: Allow Inserting and Reordering Follow-Up Steps

                                                                                                            Sales processes are not static. We test, learn, and adapt as customers respond differently than expected. Right now, Zoho Cadences do not support inserting a new step between existing follow-ups or changing the type of an existing primary step. If I realize

                                                                                                          • Vendor Signatures Needed for Purchase Orders

                                                                                                            Hello everyone, We have a unique requirement that necessitates that Vendors & Suppliers formally acknowledge our Purchase Orders upon receipt. I was hoping that there would be an option to do so in Zoho Books, but that does not appear to be the case.

                                                                                                          • Is there an API to "File a Ticket" in Desk

                                                                                                            Hi, Is there an API to "File a Ticket" in Desk to zoho projects?

                                                                                                          • Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed

                                                                                                            Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted

                                                                                                          • Unarchive tickets

                                                                                                            How can I manually unarchive tickets?

                                                                                                          • Optimize your Knowledge Base for enhanced accessibility by adding alt tags for images

                                                                                                            Let's learn why alt tags are crucial for your articles. You can add alternative tags (alt tags) and alternative text (alt text) to the images you share on your community forums or when embedding them in articles. Alt tags refer to the HTML attribute,

                                                                                                          • report showing assignment type

                                                                                                            Hi, We've created a number of workflows to allow us to auto assign tickets to agents based on keywords and other criteria. I'm struggling to create a report that would show me what is the percentage of tickets that are assigned automatically via workflows

                                                                                                          • Time Entry Notifications

                                                                                                            Hi All - I have support staff who place notes of their work in the time entry section of Zoho Desk. Is there a specific workflow or setting I need to enable to have the ticket holder updated via email when an entry is saved?

                                                                                                          • How to report 'Response violation' OR 'Resolution violation'

                                                                                                            Hi, I want to report on SLA Violation Type. I grouped my tickets on this column. It seems I only get 'Response and Resolution Violation' or 'Not Violated'. The former seems to be given to a ticket if only the Response Time was violated. I would expect

                                                                                                          • Edit Permission during and after approval?

                                                                                                            When a record is sent for approval Can a user request for edit permission from the approver? We don't want to give edit permissions for all the records under approval Only on a case-by-case basis How can we achieve this?

                                                                                                          • Messages not displayed from personal LinkedIn profile

                                                                                                            Hello. I connected both our company profile and my personal profile to Zoho social. I do see all messages from our company page but none from my private page. not even the profile is being added on top to to switch between company or private profile,

                                                                                                          • Should I Use DMARC?

                                                                                                            When I configure Zoho Mail's DMARC settings, it's mandatory to fill in the RUA and RUF (Aggregate notification email address*, Forensic notification email address*) addresses. When we enter an email address in these fields, we receive reports from the

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

                                                                                                          • Power of Automation :: Quick way to associate your Projects with Zoho CRM

                                                                                                            A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate complex tasks and

                                                                                                          • Date triggering Workflow rule

                                                                                                            I have a function triggered by a workflow rule. The function takes a date and creates a task for that date and fills in a field with the name of the day for that date. It also updates the status field of the record. The workflow rule is set to run whenever

                                                                                                          • Unable to retrieve Contact_Name field contents using Web API in javascript function

                                                                                                            Hello, I've added a field in the Purchase Order form to select and associate a Sales Order (Orden_de_venta, lookup field). I've also created a client script to complete some fields from the Sales Order (and the Quote), when the user specifies the related

                                                                                                          • Restricting contact creation

                                                                                                            Hi all! I am looking to use Zoho Desk in a part of the business that takes end user enquiries. These are generally single interactions, and not linked to an account name. As Desk is Account centric, has anyone designed a way to manage these incoming emails

                                                                                                          • Import Holiday Calendars

                                                                                                            HI Zoho Is there anyway of importing an online calendar like https://www.calendarlabs.com into the business hours calendars, to speed up setup of holiday calendars. Also could we also request a feature where you can specify a Holiday as hours, i.e it could be that the company is on a 1/2 day due to a holiday or when it is Eid in the UAE and they are only allowed to work restricted hours so we need the calendar to be flexible to allow for this. Regards Jamie

                                                                                                          • Filtering Tickets based on Email headers

                                                                                                            We're starting to get a lot more junk coming into our Zoho Desk, which is then triggering unnecessary email alerts to agents. Once thing we could do to cut this junk in half, is to filter tickets based on email headers. Any email containing the `List-Unsubscribe`

                                                                                                          • Zoho Books - France

                                                                                                            L’équipe de Zoho France reçoit régulièrement des questions sur la conformité de ses applications de finances (Zoho Books/ Zoho Invoice) pour le marché français. Voici quelques points pour clarifier la question : Zoho Books est un logiciel de comptabilité

                                                                                                          • Feature Request: Conditional Field Mandatoriness Based on Display Status

                                                                                                            Hello Zoho Creator Team, I would like to suggest an enhancement to improve the flexibility of form validations. Currently, when we need a field to be mandatory only if it's displayed on the form, the only option is to: Set the field as not mandatory in

                                                                                                          • Im Stuck in an EDIT ONLY WITH WIZARD issue

                                                                                                            So I found Wizards to be a really helpful tool in minimizing the exposure of redundant, superfluous fields to staff that would never otherwise have to edit those fields. My issue is, that when the record (in this case a lead) is created with a wizard,

                                                                                                          • Data Migration Strategies for Moving to a Cloud Solution

                                                                                                            Hi everyone, I’ve been working on moving some of our critical systems, including CRM and project data, to a Zoho cloud solution, and one of the biggest challenges I’ve encountered is data migration. Transferring large volumes of data while keeping it

                                                                                                          • Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function

                                                                                                            Hello there, I am working on a formula field based on a 3-item picklist field (i.e. *empty value*, 'Progress payment', 'Letter of credit'). Depending on the picked item, the formula field shall give a specific multi-line string (say 'XXX' in case of 'Progress

                                                                                                          • Bulk Moving Images into Folders in the Library

                                                                                                            I can't seem to select multiple images to move into a folder in order to clean up my image library and organize it. Instead, I have to move each individual image into the folder and sometimes it takes MULTIPLE tries to get it to go in there. Am I missing

                                                                                                          • Error 550 5.4.1

                                                                                                            I’ve tried sending an email to someone but keep receiving this back. Any help would be greatly appreciated 

                                                                                                          • Billing Management: #2 Fair way of Billing- Prorated Billing

                                                                                                            Hello, From speaking about the traditional ways of billing in the previous post, we are moving into the deep sea of billing. We are now in a zone to break out the most complex yet, I would call it the fairest way of billing, the Prorated Billing. Prorated

                                                                                                          • Automatic Matching from Bank Statements / Feeds

                                                                                                            Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these

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

                                                                                                          • Store "Sign in with Google/Microsoft/GitHub etc." details

                                                                                                            Quite often now, users are using a sign-in provider like Google or Microsoft to sign into various apps and services. It would be great if Vault could remember which providers you use for each website and sign you in with that provider instead of a username

                                                                                                          • Placing a condition before converting the LEAD

                                                                                                            Hi,  I need some assistance with Lead conversion. I need to place certain conditions before allowing the user to convert the lead.  For example: up until the certain status's doesn't equal "green" don't allow to convert lead.  I tried creating this using

                                                                                                          • Subform edits don't appear in parent record timeline?

                                                                                                            Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user

                                                                                                          • How can I filter a field integration?

                                                                                                            Hi,  I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.

                                                                                                          • Adding image in HTML report page

                                                                                                            Hi, I want to know two things: 1. Can anyone advise how to add an image in HTML report. The tagged used is <img> but what path do I mention for the image to be added in the HTML report. 2. Also, I want to know if I am creating an application for the market

                                                                                                          • How to change view of HTML report based on device but always print in A4

                                                                                                            Hello everyone, I am aware that HTML report view can be configured to adjust according to the screen size like Laptop, Tablet and mobile using media queries. But my concern is no matter on which device the reports is opened when printed should always

                                                                                                          • Age Calculation

                                                                                                            I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.

                                                                                                          • Search on Custom Field

                                                                                                            We're working on an integration with the Zoho FSM API and are trying to retrieve companies based on a custom field we added to the Companies module. However, we can't find a way to filter or query records using custom fields through the API. We have a

                                                                                                          • in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Q

                                                                                                            in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Quantity Returned\ pls check the recording fetch_salesorder

                                                                                                          • Sendmail function / custom action?

                                                                                                            I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been entered

                                                                                                          • Next Page