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. 

    • Recent Topics

    • Auto Update Event Field Value on Create/Edit

      Hi there, I know this question has been posted multiple times and I've been trying many of the proposed similar scripts for a while now but nothing seems to work... what might I do wrong? The error I receive is this: Value given for the variable 'meetingId'

    • Pre-orders at Zoho Commerce

      We plan to have regular producs that are avaliable for purchase now and we plan to have products that will be avaliable in 2-4 weeks. How we can take the pre-orders for these products? We need to take the money for the product now, but the delivery will

    • Constant color of a legend value

      It would be nice if we can set a constant color/pattern to a value when creating a chart. We would often use the same value in different graph options and I always have to copy the color that we've set to a certain value from a previous graph to make

    • Zoho Pagesense really this slow??? 5s delay...

      I put the pagesense on my website (hosted by webflow and fast) and it caused a 5s delay to load. do other people face similar delays?

    • Payroll and BAS ( Australian tax report format )

      Hello , I am evaluating Zoho Books and I find the interface very intuitive and straight forward. My company is currently using Quickbooks Premier the Australian version. Before we can consider moving the service we would need to have the following addressed : 1.Payroll 2.BAS ( business activity statement ) for tax purposes 3.Some form of local backup and possible export of data to a widely accepted format. Regards Codrin Mitin

    • Problem with Email an invoice with multiple attachments using API

      I have an invoice with 3 attachments. When I send an email manually using the UI, everything works correctly. I receive an email with three attachments. The problem occurs when I try to initiate sending an email using the API. The email comes with only

    • Page Layouts for Standard Modules like CRM

      For standard modules like quotes, invoices, purchase orders, etc, it would be a great feature to be able to create custom page layouts with custom fields in Zoho Books similar to how you can in Zoho CRM. For example, and my current use case, I have a

    • Non-depreciating fixed asset

      Hi! There are non-depreciable fixed assets (e.g. land). It would be very useful to be able to create a new type of fixed asset (within the fixed assets module) with a ‘No depreciation’ depreciation method. There is always the option of recording land

    • Fixed asset management

      I want to know if there is any individual module for fixed assets management

    • One time sale item in billing automatically detects as service

      if i have some items which i don't want to add in my "item" list because its sold only for one time. but when i type item name in invoice, it (system) automatically takes it as a service and despite of HSN , it shows SAC code to be entered. if its selectable i.e. either item or service , it would be very helpful and a must have feature.

    • Project template after project creation

      How can I apply a project template AFTER the project has been created?

    • convert the project to templet

      i have some deployment ME product for different customer , i need to create a fixed template for use it rather then keeping creating this template every time

    • Is there a notification API when a new note is addeding

      Trying to push to Cliq, or email notification when there's a new note added in module. How to implement this?

    • Seriously - Create multiple contacts for leads, (With Company as lead) Zoho CRM

      In Zoho CRM, considering a comapny as a lead, you need us to allow addition of more than one contact. Currently the Lead Section is missing "Add contact" feature which is available in "Accounts". When you know that a particular lead can have multiple

    • Related Module in Sharing Rules

      Zoho CRM team recently added the feature to filter records by Related Records It will be really beneficial if we can have this feature for Sharing Rules as well

    • Assignment Thresholds Resetting After Lead Conversion

      Hello everyone, We're facing an issue with Zoho CRM's lead assignment thresholds that makes them unsuitable for our workflow. I'm hoping to find a potential workaround or solution from the community. Here’s our current process: A new lead is created automatically

    • Zoho CRM Analytics - Allow To Reorder Dashboards

      I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go

    • Territory view for custom modules?

      I have recently activated territories however I can't seem to find how to use territories for custom modules? These modules have territories:  Contacts /  Accounts / Opportunities These modules don't have territories:   Buildings (custom module) and 

    • Zoho Books - How to Invoke a Custom Function in Schedulers

      We have multiple schedulers that send emails to customers in batches. Currently, we are maintaining the same code across several schedulers. Is it possible to use a custom function inside a scheduler script? If yes, how can we invoke the custom function

    • Approval Process Comments

      Is it possible to view the comments entered during the approval or rejection of a record in the approval process? If not, is there a way to require a field to be completed upon approval or rejection?

    • Login for test case

      Had a few questions regarding authentication test cases and couldn't find an answer in the the docs. 1. If an app like Zoho Creator requires authentication before providing access, do I need to create a login function and add it to each test case? 2.

    • Zoho / Outlook Calendar sync

      The current Marketplace -> Microsoft -> Meetings integration needs 2 changes. 1. The current language for the Two-Way sync option should be changed. It currently states, "Sync both your Zoho CRM Calendar and Office 365 Calendar meetings with each other."

    • Please make it easier to Pause syncing

      right now it takes 3 clicks to get there. sounds silly, but can you make it just 2 clicks to get it done instead? thats how dropbox does it, 2 clicks to pause instead of 3.

    • Customer members area

      Does FSM support a customer members area? If not what do you propose we use if we want the data used in FSM for customers to give them an area / login to see past orders, create new orders and general announcements.

    • Zoho Books-Accounting on the Go Series!

      Dear users, Continuing in the spirit of our 'Function Fridays' series, where we've been sharing custom function scripts to automate your back office operations, we're thrilled to introduce our latest initiative – the 'Zoho Books-Accounting on the Go Series'.

    • Desktop app doesn't support notecards created on Android

      Hi, Does anybody have same problem? Some of last notecards created on Android app (v. 6.6) doesn't show in desktop app (v. 3.5.5). I see these note cards but whith they appear with exclamation mark in yellow triangle (see screenshot) and when I try to

    • Notes created in mobile can no longer be accessed in desktop

      Working with a 2013 Mac running OS 10.14.6; Desktop Notebook version 4.5.3. Using Motorola Moto G Power 5G - 2024; Android app version 6.7 I have been using Notebook for some years. Starting several weeks ago, the notes newly created ion the phone can

    • Function #49: Manage varying installment payments using Zoho Books

      . Hello everyone, and welcome back to our series! Last week, we discussed automating the collection of fixed installment payments in Zoho Books. But what if your payment structure involves charging varying percentages of the invoice total as installments?

    • Open Sans Font in Zoho Books is not Open Sans.

      Font choice in customising PDF Templates is very limited, we cannot upload custom fonts, and to make things worse, the font names are not accurate. I selected Open Sans, and thought the system was bugging, but no, Open Sans is not Open Sans. The real

    • Zoho Writer - Option to Export as .zdoc format

      I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become

    • Is it possible for contacts to "Re-enter" a workflow in Zoho Campaign?

      We are currently working on a way to automatically add users to from one list to other lists based on specific criteria, but can't seem to find a native way of doing this so we are trying to use Workflows to do this. So, for example, if a user's status is set to "Active," then they should be added to the list "Active Users." If the same user's status is then set to "Paused," they should be added to the list "Paused Users" and removed from the list "Active Users." This works fine for the first go

    • Bulk upload images and specifications to products

      Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.

    • Out of Office for Just One of My Alias Email

      Can I set up the Out of Office Reply for Just One of my Alias Email Addresses?

    • Can I map multiple Surveys into the CRM using the same fields?

      Hello, We are a healthcare practice that offers two distinct services (Nutrition and Primary Care). We use Zoho Survey for our lead generation form (Get Started Survey), which allows people to express interest in one of the two services and even allows

    • Dealing with API responses where integers have more than 16 digits

      Hi there How do I deal with an api response contaning an int or float with more than 16 digits (before any decimal places for a float). I constantly receive the response "Unable to cast the 'BigInteger' value into a 'BIGINT' value because the input is

    • To Zoho customers and partners: how do you use Linked Workspaces?

      Hello, I'm exploring how we can set up and use Linked Workspaces and would like to hear from customers and partners about your use cases and experience with them. I have a Zoho ticket open, because my workspace creation fails. In the meantime, how is

    • Can't change form's original name in URL

      Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new

    • Need Inactive accounts to be visible in Reports in Zoho Books

      I N=need Inactive accounts to be visible in Reports in Zoho Books to do recons of the accounts but when i see the same they are not visible in the Accountant - Account Transactions report

    • unblock e-mail

      please unblock my e-mails info@meatnews.gr and myrtokaterini@meatnews.gr

    • Add Zoho Mail for users who do not need Zoho One

      We have licenses for ZOho One for teams that need to use the suite of products that Zoho One offers.  We have 8 more people who only need email access and we would like to add just a Zoho Mail.  They do not need the Zoho One license.  We are currently

    • Next Page