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

    • Ability to Reset Visitor Fields During an Active Chat Flow

      Hello Zoho SalesIQ Team, We hope you are doing well. We would like to propose a feature enhancement to Zoho SalesIQ regarding the management of visitor fields within Zobot flows. Use Case: Our bot asks the visitor to provide information about a 3rd person

    • External ID in Zoho CRM

      Hello everyone! We know that Zoho CRM allows you to integrate third-party apps and manipulate data through APIs. While you integrate a third-party application, you may want to store the third-party reference IDs in Zoho CRM's records. To meet this need

    • Some emails are not being delivered

      I have this problem where some of my mail just seems to disappear. When I send it, it appears as sent with no mention of any problem, but my recipient never gets it, not even in the Spam folder. Same for receiving, I have a secondary e-mail address, and

    • New in Zoho Chat : Search for contacts, files, links & conversations with the all new powerful 'Smart Search' bar.

      With the newly revamped 'Smart Search' bar in Zoho Chat, we have made your search for contacts, chats, files and links super quick and easy using Search Quantifiers.   Search for a contact or specific conversations using quantifiers, such as, from: @user_name - to find chats or channel conversations received from a specific user. to: @user_name - to find chats or channel conversations sent to a specific user. in: #channel_name - to find a particular instance in a channel. in: #chat_name - to find

    • Template modifiactions

      Hello, I am struggling with the templates in ZOHO Books. Especially with the placement of some items, like company address, ship to, bill to etc.  For example: One item I like from template X (placement of ship to and bill to next to each other in the

    • Aggregating the First Value in the Group By of a dataset

      Hi I am trying to get the following Aggregate Formula to work in my chart, but cannot seem to get the right format. I have a series of data that I am running an include_groupby and want to SUM only a column in the first row of each group. So for example.

    • Admin Control Over Profile Picture Visibility in Zoho One

      Hello Zoho Team, We hope you are doing well. Currently, as per Zoho’s design, each user can manage the visibility of their profile picture from their own Zoho Accounts page: accounts.zoho.com → Personal Information → Profile Picture → Profile Picture

    • Track Zoho Campaign and Workflow sales impact

      I am attempting to measure the performance of our marketing workflows and campaigns by comparing the date each campaign was sent to a contact with the purchase date of the contact. For example, if Contact A was sent Email A on 9/1 and made a purchase

    • Tables for Europe Datacenter customers?

      It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?

    • What is a line break code for zoho?

      Hi, I am archiving data by adding values from a single line field from one form to a multi-line field in another form. So I need a code/function that starts a new line on that multi-line field so it does not just keep adding it on the same line. Example, doing something like this means that it will be on a same line. archive.field1 = archive.field1 + input.Field1 I need a code so the input.Field1 can just start on the next line. Instead of "value 1, 2,3,4,5" It will be: "1 2 3 4 etc.".  something

    • Automatic Project Owner change

      Is there a way to change Project Owner automatically once a specific Milestone in a project is marked as completed. Different Teams are working on projects in our Org, they have their own Milestones to complete and so we transfer the project from team

    • Button to add product to cart

      Is there a way to have a button on a page, that when clicked, will add Qty 1 of a product to the cart?

    • Problem with Submit Button Design

      I have made a template to apply to my forms and under the button controls, I have it set to "standard" and yet it's still filling the container. This is super frustrating and looks weird. Why do we not have full control over button size? How can I fix

    • Zoho CRM- Authorize your Microsoft Teams account issue

      Hi, I tried to link Zoho CRM with Teams and I got the following message: Clicking "Authorize now" sent me to the following page, Microsoft tried to start a session but, after 3 seconds the page closed and nothing happened. I get the same message each

    • Passing the CRM

      Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine when

    • Is there a way to associate an email in ZOHO Main to a Vendor record in ZOHO CRM

      My situation is as below, I have a vendor in ZOHO CRM lets say "Vend A" and an associated contact, "Cont A" If Cont A sends me an email using the email I've registered in the contact record the standard OOTB email sync will work. But the vendor has some

    • Bank charges are applied. Please select a bank account.

      Hello, I'm trying to add bank charges to a customer payment, but I get the error message "Bank charges are applied. Please select a bank account." I found this old thread, where it says that I need to "select a Bank account for the 'Deposit To' dropdown

    • Kaizen #207 - Answering your Questions | Advanced Queries using COQL API

      Hi everyone, and welcome to another Kaizen week! As part of Kaizen #200 milestone, many of you shared topics you would like us to cover, and we have been addressing them one by one over the past few weeks. Today, we are picking up one of those requests

    • Présentation de SecureForms dans Zoho Vault

      Soyons francs : demander à quelqu’un de transmettre un mot de passe ou des informations sensibles n’est jamais une tâche facile. On attend, on relance, parfois de nombreuses fois. Et quand l’information arrive, elle se retrouve souvent dispersée dans

    • Introducing Connected Records to bring business context to every aspect of your work in Zoho CRM for Everyone

      Hello Everyone, We are excited to unveil phase one of a powerful enhancement to CRM for Everyone - Connected Records, available only in CRM's Nextgen UI. With CRM for Everyone, businesses can onboard all customer-facing teams onto the CRM platform to

    • Granular Email Forwarding Controls in Zoho Mail (Admin Console and Zoho One)

      Hello Zoho Mail Team, How are you? At present, the Zoho Mail Admin Console allows administrators to configure email forwarding for an entire mailbox, forwarding all incoming emails to another address. This is helpful for delegation or backup purposes,

    • Sales order & purchase order item links for item details

      This is fantastic for checking lots of things, I use it a lot. It would be great to see it extended to invoices & bills On another note, may as well throw in my favourite whinge ..... Wish you guys would get the PO receive differences sorted urgently,

    • Custom Fonts in Zoho CRM Template Builder

      Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities if

    • Zoho Workdrive - Communication / Chat Bar

      Hi Team, Please consider adding an option to allow admins to turn on or off the Zoho Communication Bar. Example of what I mean by Communication Bar: It's such a pain sometimes when I'm in WorkDrive and I want to share a link to a file with a colleague

    • Introducing Profile Summary: Faster Candidate Insights with Zia

      We’re excited to launch Profile Summary, a powerful new feature in Zoho Recruit that transforms how you review candidate profiles. What used to take minutes of resume scanning can now be assessed in seconds—thanks to Zia. A Quick Example Say you’re hiring

    • Kaizen #190 - Queries in Custom Related Lists

      Hello everyone! Welcome back to another week of Kaizen! This week, we will discuss yet another interesting enhancement to Queries. As you all know, Queries allow you to dynamically retrieve data from CRM as well as third-party services directly within

    • Need the ability to have read only fields on a form.

      There needs to be functionality in Creator that allows a field on a form to be read only. Most screen building software applications have this capability. I know you can hide certain fields from specific users and that you can also make the whole form read only but that's not the functionality I need. I want to be able to create a form where certain fields are editable and other are for display purposes only (read only). For example if the form was displaying information on an item that the user

    • Reverse payment on accidentally closed invoice.

      An invoice was closed accidentally with the full payment added. However, only partial payment was paid. How can I reopen the invoice and reverse this to update it to show partial payment?

    • New integration: Track booking page appointments in Google Analytics 4

      Hello all, Greetings from the Zoho Bookings team! We’re excited to introduce our new Google Analytics 4 (GA4) integration designed to help you track booking activity, understand customer behavior, and measure marketing performance, all in one place. What

    • How to list emails in a folder, e.g. Inbox, on multiple pages when using Zoho mail webpage?

      Something as shown in the figure. There are totally 50 emails in Sent folder. If "Mail per page" equals 20, then the Sent folder is split into 3 pages. When I wander through Sent folder, I can just select a specific page to jump to. BTW, it seems that

    • How to add image to items list in Invoice or Estimate?

      Hello! I have just started using Zoho Invoice to create estimates and, possibly to switch from our current CRM/ERP Vendor to Zoho. I have a small company that is installing CCTV systems and Alarm systems. My question is, can I add images of my "items" to item list in Zoho Invoice and Estimates and their description? I would like to show my clients the image of items in our estimates so they can decide if they like these items. And I tell you, often they choose more expensive products just because

    • Zoho Calendar soft bounce on @hotmail.com and @yahoo.com email addresses

      Hello, our Zoho calendar recently does not send the calendar invites to emails with hotmail and yahoo domains and comes back with a "soft bounce". other domains like Gmail works fine. Also sending "email" to the same emails to the above domains work well

    • ERROR CODE :512 - 5.4.4 DNS error:NXDOMAIN.

      Suddenly we cant send mail, we are getting this error for all outbound mail to multiple domains.

    • Can Zoho Flows repeat Actions more than once?

      I'm attempting to make an intentional Zoho Flow loop using the below layout. However, when "WithinLimit" condition is met, the program fails to execute the action "Get & Add Request Co..." again. Is this by design? Is Zoho Flows unable to repeat actions

    • Unveiling Cadences: Redefining CRM interactions with automated sequential follow-ups

      Last modified on 01/04/2024: Cadences is now available for all Zoho CRM users in all data centres (DCs). Note that it was previously an early access feature, available only upon request, and was also known as Cadences Studio. As of April 1, 2024, it's

    • customer data security

      We are exploring ways to enhance our within Zoho CRM. Our Goal: We want to fully integrate RingCentral with Zoho CRM to enable click-to-call functionality for our sales team. However, to comply with data privacy regulations and protect customer contact

    • Zoho Cliq not working on airplanes

      Hi, My team and I have been having this constant issue of cliq not working when connected to an airplane's wifi. Is there a reason for this? We have tried on different Airlines and it doesn't work on any of them. We need assistance here since we are constantly

    • Sync CRM inventory data with Zoho Books

      I just switched everything over to ZoHo books, but I am trying to find out why the CRM Estimates, Invoices, and Sales Orders created in ZoHo CRM are not then duplicated in ZoHo Books? I had Quickbooks before, and had to do everything twice, I thought

    • mask Customer phone number and agents cant see customer phone number

      Is there any way we can integrate Zoom Phone with Zoho CRM while ensuring that customer phone numbers remain masked? We need a solution where agents can make outbound calls but cannot see customer phone numbers. Please let us know if there is any solution

    • Email Reminders on Shared Calendars

      How do we turn off the setting that emails reminders to everyone who has accepted or declined a calendar invite? If 8 of us have been invited to the same meeting, we receive 8 notifications for every step of the process, from invitation to decision.

    • Next Page