Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

So i'm still designing my zoho one crm as i come over from salesforce.

One of the things i'm trying to build is a commission tracking module.  At some point i'll probably hire someone to help with custom code, I'm just proof of concepting it.  I"m not sure if this will even be possible in zoho crm, it was very much  shoehorned into salesforce that we had built for us through a custom module that a 3rd party vendor made that we have severed ties with,  it worked, but was clunky.

Maybe another zoho one app would be better for this, and if it is, i'm open.  Maybe creator?

Commission statements have the following key fields.  Statement date, commission date, contract id, and sales agent.

I have a custom built contract module, however the contract name is a human readable field, and then there's a separate custom contract id field, along with a start date, and stop date.  I really wish I could rename the default required value of contract name to contract id, that would be helpful, but otherwise it's so incredibly counter intuitive to put the ID in the default  "Contract *name*" field.  I suppose I could do that and create "contract *description*" for something that's a human readable description.  For us contract name is auto generated with a function as something along the lines of "customer name - vendor name - product name(s)".   Even if I did that it still leaves us with 1 problem.

That is to make matters even more confusing is this: contract id, while being unique per customer, is not unique per contract.  One of our vendors reuses the same contract id for a customer if we cancel 1 contract and replace it with another.  IE contract 12345 for customer john snow was active for 1/1/2022-04/31/2022, then john snow decides he wants to change products we cancel the contract, and make a new one for 5/1/2022-12/31/2022 but it has the exact same id of 12345; the contract id id is tied to the customer number.  This is not what I would like, but it's what the vendor does and we can not change it.  

As such we also have to track comissions by contract id and comission date, so if the comission date falls in the window of 1/1/22-4/31/22 it gets applied to the first contract, but if it's between 5/1/22-12/31/22 it goes to the second contract.  we usually get paid quarterly commissions, so each contract can have multiple transactions.

What I would like to do is have a commission transaction module, that has an auto generated number as the primary "name", and then a lookup to the contract id and the start start date and stop date of that contract ID.  so we're dealing with 3 fields here to make sure we're assigning the transaction to the correct contract.  Commission Transaction Record X with a comission date of 1/15/22 and Record Y with a transaction date of 4/1/2022 would both need to be assigned to a Contract ID of 12345 with a start date of 1/1/2022 and an end date of 4/31/2022.  But then Comission Z would need to go to contract id 12345 but with a start date of 5/1/22 and end date of 12/31/22.

The goal is to upload a csv and have the commission transactions auto matched to the policy record and sales agent, manually reveiw the matches to make sure they are good, fix any errors.

There are standalone products that do this commission tracking but we would have to export a report from zoho every period, import it to a commission tool., and then manage it separately.

I'd like to do something in the zoho world, even if i have to get a little custom development done, that can have some integration and bidirectional data flow back to the CRM that's ultimately our central 'hub'.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

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

                              Zoho CRM コンテンツ










                                ご検討中の方

                                  • Recent Topics

                                  • Removed email address - can't access account

                                    Hi Zoho Support Team, I recently removed my email address from my Zoho Desk account (which is part of our organization's Desk setup) and then signed out. Now, I’m unable to log back in because there is no email address associated with the account, even
                                  • 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
                                  • Custom Serial numbers in Inventory tied to customers

                                    Hello, We have both software and hardware serial numbers that we need to track for active customers in the field. We do not know the serial numbers for the software until the customer buys it as its not a stock item but something we order and deploy for
                                  • How to nurture leads, manage contacts and grow your B2B business with SalesIQ?

                                    Zoho SalesIQ is one of the most powerful support tools in the industry and is preferred by millions of customers. SalesIQ is used to acquire leads across various sectors and automate your workflows. The all-new SalesIQ brings more power to your business
                                  • Contracts Management

                                    Hello, We are implementing Zoho FSM for our field service operations and, one of the features we are lacking is Service Contract Management. I was told that such feature might be in the pipeline but an estimated launch date for this is not available at
                                  • One notebook is on my Android phone app, but not on Web or PC app.

                                    This problem started in stages. At first my phone was occasionally failing to sync. Then I noticed two things added to my Phone App. One was an existing notebook had a new cover, and the other was a new Note Card with an odd text in it. These were only
                                  • New notecards not syncing across devices

                                    Hello. I just noticed this problem happen recently. A new note being created on one device is not appearing on a different device, even though they're supposed to be synced with each other through setting it up on your account. I don't know if there's
                                  • Does Thrive work with Zoho Billing (Subscriptions)?

                                    I would like to use Thrive with Zoho Billing Subscriptions but don't see a way to do so. Can someone point me in the right direction? Thank you
                                  • Is it possible to add HTML or a button on email templates in Zoho Desk?

                                    Hello team, I am working on getting the best use out of Zoho Desk. I have noticed that when you hit 'reply' on a ticket, it comes with a small 'survey' to the recipient saying something like 'how would you rate your experience with us?'... so my question,
                                  • Is it possible to add buttons on email replies to internal team members?

                                    Hello everyone, I am currently trying to set up some workflow rules to trigger when a ticket is created. I have noticed there is a button that can be added to email templates when sending email alerts from workflow rules, for example ${Cases.SUPPORT_PORTAL_BUTTON}.
                                  • What is the use of the stage environment ?

                                    Salut, I am woundering what is the use of the stage environment. Usually, I do all the testing in developpement, and then go straight to production. The only thing I cannot test in developpement, is the result for portal users. Could the stage environment
                                  • Peppol Malaysia API

                                    Hi Zoho Books, my country Malaysia will going to implement "Peppol" (E-Invoicing), starting 1 Jul 2025 for all businesses. The government intends to provide API for accounting app. The workflow involves creating an invoice from accounting app, triggers
                                  • At transaction level Discounts for Zoho books UAE version

                                    Dear Team, Please add transaction level Discounts for Zoho books UAE version. I have been requesting Zoho team past 3 years, Transaction level Discounts is a mandatory option required for our business needs. Zoho books Indian version has the option then
                                  • New in CRM: Dynamic filters for lookup fields

                                    Last modified on Oct 28, 2024: This feature was initially available only through Early Access upon request. It is now available to all users across all data centers, except for the IN DC. Users in the IN DC can temporarily request access using this form
                                  • Sales Order automatic Convert to Invoice using boolean True or false

                                    It is possible to convert the Sales order to an invoice using a boolean field, true or false Example: I create a field in my Sales Order, I name it QBO Invoice, and the field type is Boolean, true or false. Let's say the default is false, so when I change
                                  • Presenting the brand new Zoho Bookings!

                                    Hello everyone, Greetings from Zoho Bookings! We're happy to announce a new version of our product with enhanced features to simplify scheduling, coupled with a sleek interface and improved privacy across teams. Here's what you can expect from the latest
                                  • Feature Request: Ability to copy notecards to Windows desktop

                                    Hello, Please consider adding the ability to copy notecards to Windows desktop. Thanks!
                                  • Script on Page used as dashboard don't work anymore

                                    Salut, I have a page used as dashboard that worked fine, but recently the workflows don't seem to work, I have the icons like on a page for portal user when I try to look at it as admin. See screen shot : Anybody knows what could have happen ? The only
                                  • Invalid URL error when embedded sending url into iframe for my website when using in another region

                                    Hi team, My site is currently working on integrating your signature feature as part of the system functionality, it's working great but recently there's been a problem like this: After successfully creating the document, i will embed a sending url into
                                  • Add Direct Ticket Link to Zoho Help Center Portal in Email Replies

                                    Hi Zoho Support Team, We hope you're doing well. We’d like to request a small but valuable improvement to enhance the usability of the Zoho Help Center portal (https://help.zoho.com/portal/en/myarea). Currently, when someone from Zoho replies to a support
                                  • Zoho Error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details

                                    Hello There, l tried to verify my domain (florindagoreti.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details. Screenshot Given Below -  please check what went wrong. Thanks
                                  • Zoho Flow Needs to Embrace AI Agent Protocols to Stay Competitive

                                    Zoho Flow has long been a reliable platform for automating workflows and integrating various applications. However, in the rapidly evolving landscape of AI-driven automation, it risks falling behind competitors like n8n, which are pioneering advancements
                                  • Error AS101 when adding new email alias

                                    Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                  • How to mass update member status in a CRM Campaign?

                                    Does anybody knows how to mass update member status of the contacts (or leads) associated to a campaign. I can click on a campaign record and go to the Contacts in the Related List fields but then it shows only 10 contacts per page at once. It is hard
                                  • CRM HAS BEEN SOOO SLOW For Days 05/15/25

                                    I have fantastic Wifi speed and have zero issues with other websites, apps, or programs. It takes an excruciatingly amount of time to simply load a record, open an email, compose an email, draft a new template, etc. Am I in a subset/region of subscribers
                                  • First Respons time questions regarding ticket SLA's, Ticket Re-Assignment, and Ticket Closure.

                                    I am chasing down a few outliers on tickets that my team is reporting to me seen in some of our Zoho Analytics Dashboards with regards to Zoho Desk with regards to First Response Time. Our support organization is setup with different SLA's based on three
                                  • View Expenses in Zoho Books Without Approval or Reports in Zoho Expense

                                    Hello, I’m using both Zoho Books and Zoho Expense (on the free plan for both). I would like to view the expenses recorded in Zoho Expense within Zoho Books, but I read that they need to be approved first. Since I manage a small freelance business, I don’t
                                  • Idea: Workflow Rule Trigger Only When Subform Row Is Updated (Thanks to New Inline Row Feature)

                                    Hi Zoho team and community, With the recent update to Zoho CRM, we can now add or delete rows inside subforms without entering edit mode, using the inline Add row button. This is a fantastic improvement for user experience — seamless, fast, and efficient.
                                  • Blocking / black listing customers

                                    Hi, We have a situation, we observed that certain customers are blocking multiple appointments with our advsiors but not showing up. Some of these are repeat offenders. This leads to those service hours getting blocked and not available for genuine customers.
                                  • Turning off the new UI

                                    Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?
                                  • 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 contacts, why was this feature not included. Now we have to miss out other contacts or enter them somewhere in the description.!!! this is bad.
                                  • Global Sets for Multi-Select pick lists

                                    When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.
                                  • Change default "Sort by"

                                    Is there a way to change the default "sort by" when searching across modules?" in Zoho CRM? Currently the default sort method is "Modified time" but i would like to utilize the second option of "relevance" as the sort by default and not have to change
                                  • Create project (flow) and assign to person without account (company)

                                    Hi Zoho Support & Community, I'm trying to automate a process using Zoho Flow to create a Zoho Project and link it directly to a Zoho CRM Contact. This reflects our B2C workflow where we primarily deal with individual Contacts, not Companies/Accounts.
                                  • Forte's Extra Costs

                                    Hello everyone in the Zoho community, I wanted to share some information about Forte in case anyone wanted to look into them as a processor.  I currently use Stripe, but wanted to use Forte's ACH to pay vendors and take ACH payments for our products.  This is one of the only ACH processors that Zoho accepts. They state their cost is $25/month plus their transaction fees for ACH.  However, after signing up and going through their approval process, I found this out they work with a PCI compliance service
                                  • Can Zoho CRM JS SDK Send Notifications, Create Tasks & Calendar Events?

                                    Hello everyone! I’m just starting to explore this topic, so please excuse my beginner-level questions! Is it possible to use the JS SDK (https://help.zwidgets.com/help/latest/index.html) to: Send messages (signals, notifications) to specific employees,
                                  • Restricting Printing

                                    Hi Is it possible to stop users printing documents?
                                  • Backup and Restore of Projects

                                    Hi Guys, my boss asked me "do we store regulary offline Backups of Zoho Projects" and i could only answer "no way". Is there really no way to backup and restore a project manualy? As Projects is the main Product we decided to use Zoho it could be that
                                  • Enable Zia Bot for Intelligent Conversations in Zoho Cliq

                                    Hi Zoho Cliq Team, We would like to request a new feature: the ability to interact with Zia via a dedicated bot in Zoho Cliq, in a way similar to how users interact with GPT-based assistants. Use Case: We're looking for functionality beyond the existing
                                  • Zoho RPA is now available in your Zoho One bundle!

                                    Hello All! Of late, it's been quite a stint of new app integrations in Zoho One. This announcement pertains to the addition of another Zoho application, the most sought-after Zoho RPA - Robotic Process Automation, to the bundle. What is Zoho RPA? Zoho
                                  • Next Page