Kaizen #206 - Answering your Questions | Displaying Related Purchase Orders from Zoho Books in CRM Deals using Queries

Hello everyone!

We're back with another post in the Kaizen series.

We're grateful for the feedback we received from all of you!

One of the questions we received was "I would like to see the list of Purchase Orders in Zoho Books for a Deal in CRM."

We will discuss how to achieve this using the Queries feature in Zoho CRM.

Scenario

In many organizations, a single Deal in Zoho CRM may correspond to one or more Purchase Orders(POs) in Zoho Books. To get a real-time view of all POs associated with a Deal in CRM, we can leverage the Queries feature under Setup > Developer Hub > Queries, and custom related lists.

1. CRM and Zoho Books Integration

Zoho CRM and Books integration allows you to

• View POs, invoices, and payments for deals directly in CRM
  
• Synchronize financial data between CRM deals and Books POs
  
• Automate the mapping of deals to POs via custom fields
  

To create this connection,

1. Go to Setup > Developer Hub > Connections
   
2. Create a connection to Books(OAuth) with the scopes ZohoBooks.contacts.All and ZohoBooks.purchaseorders.All.
   
   

2. Prerequisites

Before creating the query and automation, you must have the following ready:

1. Zoho Books organization ID – needed for REST API calls.
   
2. Custom field in Books PO module:
   Field Name: CRM Deal ID
   Type: Single-line
   Purpose: Store the CRM deal ID that each PO relates to.
   Why do we need this custom field?
   By default, Books POs are not directly linked to CRM Deals. To bridge this gap, we create a custom single-line field(CRM Deal ID) in Books POs to store the CRM Deal’s record ID. This makes it possible to filter POs in queries(cf_crm_deal_id == {{deal_ID}}) and reliably display only the related POs in CRM.
   
   You can store the record ID of the deal in CRM in this field either manually or via a custom function. When you use a custom function, use the Update a Purchase Order API to update the CRM Deal ID field in Books with the record ID of the deal in CRM. You can then associate this function to a button or automation to constantly update the PO in Books every time a deal in CRM is created or updated in CRM. You can also use Zoho Flow to achieve this instead of a function.
3. Trusted domain and source:
   
1. Ensure you have added Books API domain to trusted domain for API calls.
   
   
2. Add Zoho Books as the source of the query to get the PO details from Books. You can add the Books' organization ID as a parameter either here or while creating the query.
   
   

3. Single Deal, Multiple POs

Scenario

• A CRM deal requires multiple POs from different vendors.
  
• Each PO in Books stores the same Deal ID in the CRM Deal ID field.
  
• This allows a related list in CRM to show all POs associated with the deal.
  

Why a Single-line Field Works?

• Each PO references one deal.
  
• Queries in CRM can filter using cf_crm_deal_id == {{deal_ID}}. cf_crm_deal_id is the API name of the custom field in PO of Books. You can find it under Setup > Purchases > Purchase Orders > {the custom field} > Edit.
  
• Works reliably for related list display.
  

4. Creating a REST API Query in CRM

Since we will use Books API to get the list of POs, we will create a REST API type query.

1. Go to Setup > Developer Hub > Queries > Create Query.
   
2. Enter the details as shown in the following image:
   
   
3. Choose the Books source that you added recently.
   
4. Give a name for the query.
   
5. The API name will be auto-populated, and the URL will be populated from the source.
   
6. Enter the endpoint to access the resource from Books. In our case, purchaseorders.
   
7. To filter based on the value in the CRM Deal ID field in Books, enter the parameter as cf_crm_deal_id and its value as a variable. This variable takes the Deal's record ID as the value during run time. This ensures that the query takes the deal residing in the CRM Deal ID(which is also the record ID of the deal in CRM) field in Books and filters only those POs related to this Deal.
   
8. If you have not given org_id as a parameter while creating the source, include it here.
   
9. Click Next. You will get a pop-up asking for the value to the variable cf_crm_deal_id. Give a value to see the query in action.
   
10. The query returns the list of POs from Books that are related to this particular deal in CRM.
    
11. Save the query.
    

5. Serializing(to return a table for the related list)

Serializer allows you to manipulate the response of the query using Javascript.

In our example, the raw response of the query will contain the POs from Books for a deal in CRM as an array with many fields.

For example, the deal with CRM record ID 3652397000017912047 has two POs in Books viz, PO-00001 and PO-00003. The raw response before serialization is as follows.

But, to associate this response with a related list, we don't need all the fields. We can use the serializer to modify this response and use only the required fields.

The following image shows the serialized response.

Click Save and configure the Schema.

Click Save to save the query.

6. Adding the Query to a Related List

Now that we have the query ready, let's associate this with a related list in the Deals module in CRM to contextually view the POs of the Deal in Books.

1. Navigate to the Deals module in CRM.
   
2. Click the three-dot icon on the right corner of the record, and click Add Related List. Alternatively, you can also click the Add Related List option on the left in the Related List pane.
   
   
3. From the pop-up, select Queries.
   
   
4. From the list of available queries, select the Get Purchase Orders query you created and click Associate.
   
   
5. Give a name for the related list.
   
6. Under Variable Mapping, type #(to view merge fields) to get the list of modules available. Choose Deals and the Deal Id field. This means that the record ID of the deal will be passed as the value of the cf_crm_deal_id variable at runtime. The query will then fetch the list of POs for this Deal ID from Books, and display it in this related list.
   
   
7. Click Save and you will see the related list under the Related Lists section of the record.
   
   
8. Reload the page to see the query in action.
   
   

Automation Options

You can automatically update the CRM Deal ID in Books POs when a deal is created or a PO is raised.

1. Using Function

• Function triggers on deal creation or a button click in CRM.
  
• Fetches the PO in Books and updates the CRM Deal ID field using the Books connection.
  

2. Using Zoho Flow

• Event: Deal created or updated in CRM.
  
• Action: Update the corresponding PO(s) in Books.
  
• Works without writing Deluge code.
  

Both methods require the Books connection and organization ID.

Summary/Best Practices

• Single Deal, Multiple POs: Use single-line CRM Deal ID field in Books.
  
• Queries and serializer: Filter POs based on cf_crm_deal_id == {{deal_ID}}.
  
• Automation: Use functions or Zoho Flow for real-time updates.
  
• Multi-Deal, Single PO: Not supported for related lists; use custom reporting instead.
  

This setup ensures that sales and finance teams can see all POs for a deal directly in CRM without manual reconciliation.

We hope this post answered your question and you found this useful.

Let us know what you think in the comments or write to us at support@zohocrm.com.

Cheers!

--------------------------------------------------------------------------------------------------------------------------

See Also

• Queries in Zoho CRM
  
• Previous Kaizen - 205 - Managing Picklists and Enabling History Tracking via Zoho CRM APIs
  
• Kaizen Directory
  

• Topic Participants

• Shylaja S

  

• Sticky Posts

• Kaizen #217 - Actions APIs : Tasks

  Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.

• Kaizen #216 - Actions APIs : Email Notifications

  Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

• Kaizen #152 - Client Script Support for the new Canvas Record Forms

  Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved

• Kaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script

  Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.

• Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI

  Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over the

• Recent Topics

• How can I prevent the Zoho Vault extension from automatically logging me out?

  Hi, I want the Zoho Vault Chrome extension to never log out. How can I do this? It only allows me to log out for 1 week, and the same applies to the Android app.

• Zoho CRM App - Links

  Hi  Is there are plan for making Custom Links available in the Zoho CRM Android App? I can't see them being added? Thanks Gene

• Templates

  Trying to sort out / get rid of unwanted invoice templates, the error msgs are not at all helpful. Surely it's easy to amend the error msg by including a list of the names of the customers / vendors that use it, denying deletion or making it inactive

• Contacts limit in basic vs standard - what counts? Are customers contacts?

  I’ve been using books for a number years for my small business. I only ever work with 20 clients at any given time. I do purchase services from a number of vendors to run my business, so there are some comtacts there too. I used to use the basic package,

• Finding missing records

  I have a challenge and I am not really sure where to start with it. I can't find any similar threads on here, can anyone help: I have two forms, FormA and FormB. Both forms have records that contain a field called Job_Number. What I am trying to achieve

• Prevent Unapproved Quotes from Exporting to Zoho CRM Finance Module

  Is it possible to prevent unapproved quotes in Zoho Books from being exported from Zoho Finance module inside Zoho CRM?

• Updates for Zoho Campaigns: Merge tag, footer, and autoresponder migration

  Hello everyone, We'd like to inform you of some upcoming changes with regard to Zoho Campaigns. We understand that change can be difficult, but we're dedicated to ensuring a smooth transition while keeping you all informed and engaged throughout the process.

• Process between CRM and Campaigns to ensure double opt-in contacts?

  I would like to ask for a few clarifications to ensure we fully comply with best practices and legal requirements: According to the documentation (Zoho Campaigns CRM sync – Default option), the best and recommended way to sync contacts is by using the

• What's New in Zoho Inventory | August – October 2025

  Hello customers, The last quarter has been incredibly productive! We've released a powerful slate of new features and enhancements in Zoho Inventory designed to give you better control, greater efficiency, and expanded functionality across your inventory

• Let's Talk Recruit: Meet Zia, your all-in-one AI assistant (Part-2)

  Welcome back to Let’s Talk Recruit series. In Part 1, we introduced Zia and how AI is reshaping the way recruiters work. This time, we’re taking a closer look at how far Zia has come and how each update continues to simplify your everyday tasks. When

• Zoho Developer - Feature Request Platform

  Zoho Developer is one of the most underatted platform in zoho ecosystem, however, it may just be what zoho needs to welcome more people to use Zoho Services. The more developers you have creating zoho creator applications and zoho extensions the more

• Last/Previous month in relative date filter

  In the relative date filter, what is the difference between "Last 2 months" and "Previous 2 months"? So, if we are on 25-July, then is my understanding correct of the following: Last 2 months :=:      25-May~24 July Previous 2 months :=:     01-May~30-June Thanks.

• Tags get removed from notes on mobile

  I don't know why this keeps happening even after all these app updates but if you log out and log back into the app or you reinstall it, all the tags you assigned to your notes get taken off, but if you go on the desktop version the tags are still there.

• Show Zoom Link in Recipient's Calendar

  We set up meetings within a record, selecting the "Make this an online meeting".  We use Zoom. Most of the recipients go to their calendar (usually Gmail or Outlook, corporate) to join the Zoom meeting, but there is no Zoom link in the calendar. Can this

• How to fetch custom fields for time entries in Zoho Project API v3

  In the previous Zoho Projects REST API, we were able to retrieve custom field details for time entries, including picklist options, using the endpoint: GET /restapi/portal/[PORTAL_ID]/timesheetcustomfields In the new Zoho Projects API v3, we tried using

• VAT rates - exempt and out of scope

  Good Evening, UK based company here. I am a bit confused in respect of setting up VAT rates for exempt goods and services; at present I am simply leaving the VAT rate blank in the transactions in order to prevent any VAT appearing in the VAT return. When

• Introducing Lead Capture: Empower exhibitors to capture leads effortlessly

  Events provide a great opportunity for exhibitors to generate awareness and engage with potential customers. Efficiently distributing attendee information to exhibitors through a seamless and secure way is of paramount importance. Introducing Lead Capture

• Work Order Creation Issue

  Dear Team, I would like to inquire about the daily limit for Work Order creation in Zoho FSM. Yesterday (02/05/2025) at around 6:30 PM GST, I attempted to create a Work Order, but I have been unable to do so since then. Please find the attached image

• Accessing shared mailboxes through Trident (Windows)

  Hi, I have a created a couple of shared mailboxes. The mailboxes are showing up on the browser based Zoho workplace, but I cannot seem to figure out how to access my shared inboxes through Trident (Windows). Am I missing something or is this feature not

• URGENT: ChatGPT Extension Failing With “gpt-3 Access Error” (Priority Support)

  Appreciate support reviewing this urgently. I am a Priority Support member and need immediate clarification on a recurring issue involving the ChatGPT extensions inside Zoho Desk. Both extensions — including the version created and published by Zoho —

• Zoho Desk iOS update: Custom buttons, follow/ unfollow option on tickets

  Hello everyone! In the most recent Zoho Desk iOS app update, we have brought in support to access the custom buttons configured on web app(desk.zoho.com). Using custom buttons you can seamlessly execute predefined actions directly from their mobile devices,

• Zoho pdf suit

  Pl. design products with following feature: 1. Please add all features given in Ilovepdf website to work on pdf files. It is mandatory to use pdf in court work. 2. Courts have prescribed New Times Roman, pl. add this font as well 3. Indexing, signature

• Zoho Not Working

  Today Zoho not wokring

• Dynamically autofill fields with URL parameters

  I have a zoho form embedded in my organization's WP website. Our users find their account with a search tool, and then can select to open this page with the embedded form. The URL of the page holds the parameter that I need, but I cannot figure out how

• User Automation: User based workflow rules & webhooks

  User management is an undeniable part of project management and requires adequate monitoring. As teams grow and projects multiply, manual coordination for updating users & permissions becomes difficult and can give way to errors. User automation in Zoho

• Integrate Projects for Desk KB article release tasks

  Could you please look into the possibility of integrating project tasks for Zoho Desk article release processes? We are looking for an internal integration between Zoho Projects and Zoho Desk's KB article drafting, reviewing and releasing tasks. We could

• Issue in Annual Leave

  We created a policy to credit 21 days at the Start of the Year An employee has taken 16 days of leaves thought the year, so we expect to see 5 Leaves remaining right? But Zoho People is Showing 12 Days of Leave Balance Available If we check the Leave

• Use the searchBy parameter to find user by email address

  I'm trying to find a user is Zoho Desk via the Api. In the documentation I see that there is the possibility to add a searchBy parameter in the request. But I can't find how the search values should be formatted. I've tried multiple things and get either

• Zoho CRM Community Digest - September 2025 | Part 2

  Hello Everyone! Mid-September vibes: fresh tips, smart hacks, and practical Zoho CRM updates all in one place. Let’s dive in. Product Updates: The All-New Address Field! The new Address field type makes it easier to capture complete addresses in one structured

• Zoho Vault API: Create new Secrets

  Hello, I attempt to Post Secrets to the vault, since the encrypted entries are almost impossible to decrypt, since there is no documentation on how to decrypt them. Like with the lack of documentation on how to descrypt, there are missing information regarding on how to create new secrets/post secrets. Source: https://www.zoho.com/vault/api/#create-a-new-secret When I try to send JSON Informationen as a POST-Request I only receive the error message: {     "operation": {         "result": {             "error_code": "",

• CRM and Finance Tab - Add Invoice "Subject " Column

  When On a contact in CRM, and you click the Zoho Finace tab, how can I put in the invoice subject line? Or even a custom field for this.  We need to see what that invoice is for, without opening it.   If we have tons of invoices we need a way to quick

• Collections Management: #4 Before, During & After Payment Processing

  "Mark, I think the payment link isn't working. Can you send it again?" Staring at a message, Mark got on his phone. This was the third time the same customer had asked him that week. A few minutes later, another message came, "Hey, the invoice total seems

• Account name not populating when importing contacts

  When importing a csv file to add contacts the account name is blank? Every other filed gets mapped and imported correctly, i.e contact name, phone number. However not the account name which I have mapped to "company" field in my csv file

• Suggestion to improve zoho writer

  I am using your product, I believe it is very useful, however, i was writing a note and I needed to draw an arrow in different angles to explain a point and I couldn't. it would be helpful, to add draw functions to the zoho writer. thanks

• webhook basic authentication

  II want to use a webhook to send out a SMS. Unfortunately Twilio does not use an authToken but basic authentication. I created the webhook as POST and get this url: https://{username}:{password}@api.twilio.com/2010-04-01/Accounts/{account}/Messages?body=<BODY>&to=+155555555&from=+1555555555

• Managing functions

  Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created

• Custom function return type

  Hi, How do I create a custom deluge function in Zoho CRM that returns a string? e.g. Setup->Workflow->Custom Functions->Configure->Write own During create or edit of the function I don't see a way to change the default 'void' to anything else. Adding

• Issue with Hour Calculation in Zoho People Attendance Module

  I have noticed an issue in the attendance regularization feature of Zoho People. When trying to regularize past dates, the total working hours are not calculated correctly. For example, if I enter a check-in and check-out time for a previous day, the

• Push Notification for New Bookings in Zoho Bookings App

  when a someone schedules an appointment through the booking page, is there any option to receive a push notification in the mobile app?

• Automation in Zoho Sprints

  Hi. I have a Sprints board with the following statuses: ToDo, InProgress, CodeReview, Testing, Preprod, Live When a ticket is moved from e.g. Testing to Preprod, the following tags should be modified: remove 'tested OK' remove 'ready for Preprod' add

• Next Page