Set Validation For Quotes On Conversion To Sales Orders

Set Validation For Quotes On Conversion To Sales Orders

I have a bit of a doozy here. We have 2 fields in our Quote module that aren't required for the quote to be saved (and can't be required fields) however they are required fields on the Sales Order once the quote is converted. Our challenge is that once the SO is created, the validation isn't triggered so despite them being required fields the CRM doesn't care and the SO and in the end the invoice can be created with empty required fields. 

I have been over this exhaustively with Zoho and despite their documentation saying that Validation Rules work for Conversions, they have fessed up that they actually don't. 

They are wanting me to set up workarounds with Tags and all sorts of drama that we don't want or need and that won't work so this is a last ditch effort to see if someone has any ideas.

In our Sales Order we need to know the promised ship date that has been negotiated during the quoting process with the client. We don't need that to supply the quote, its only when its been accepted and is converted to a Sales Order that this info is required. There is another field that is also required as a sales order and yes I've made both these fields required fields.

However, when we convert the Quote to a SO, those fields will either be blank (if staff forget to complete them) or possibly have data, but I can't enforce them as required fields on the quote because otherwise we would have to put in a fake promise date to enable the quote to save. That won't work because obviously then that date might be completely wrong and we would rather it have no date than go into our project process with the wrong date. That could be catastrophic for us. We have a function that creates a Zoho Project based on a template choice in the CRM invoice (once it gets to the invoice) but as it is now the required fields in the SO aren't validated on conversion to the invoice. So both the sales order and the invoice can be created without these fields being validated. 

I said its a good one!

We've added notes to our quoting process for our team to follow but regardless, staff don't always get it right so I'm trying to enforce it to avoid any dramas and to ensure that our system is solid.

In Summary:
  1. Quotes has 2 fields that ideally would be completed before conversion to a SO, but I can't enforce them as required fields here because we won't have that info at the early quoting stage.
  2. Sales Order has both these fields as required but on conversion that validation doesn't fire.
  3. Invoices also have both these fields and again, they aren't triggering any validation on conversion from SO to Invoice.

Does anyone have any idea how I might enforce this validation? Like is it possible to make my own Convert button that triggers the required fields be completed and hide the default button? Clutching at straws but I need to get this working so any help would be greatly appreciated. 

    • Recent Topics

    • Use color coding for picklist field values to enhance visual representation

      It's easier and more efficient to manage a large volume of data in a ticket or other custom module records, such as ticket priorities and issue types, when you apply clear visual distinctions through color coding. Color-coded picklist fields allow users

    • Creating a support request / ticket via email to xxx@zohosupport.com

      Is there the ability to create a ticket from an email sent to my support email address (e.g. xxx@zohosupport.com)? For example, I am running a small computer support/service business and I would like to be able to direct potential customers to send an

    • Call transcrition working for ringcentral?

      I don't see anything about what telephony providers can be used. The Zoho support person A said that RingCentral isn't supported. Zoho support person B said that it works, just make sure the call recording link works. Excellent instructions here: Call

    • Setting up CRM for RFP workflow management

      This will be the first time our organization uses an off-the-shelf CRM, transitioning from our homegrown custom solution, and I would appreciate general thoughts on how to get started in general with our workflow using Zoho CRM. The main question: if

    • Introducing Appointment Title Customization

      Hi all, We're delighted to announce an exciting feature, Appointment Title Customization, which you can use to personalize your appointment title according to your business's specific needs and preferences. An appointment title provides a glimpse of the

    • Custom Module

      I've created a custom module in Zoho Recruit for a separate list outside of qualified candidates. On the module, I use First name and Last Name in separate lines. On the top of the module and when I search a person, it only shows the first name at the

    • How to merge duplicate products?

      merge duplicate products

    • Rollup summary for custom module

      Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature

    • Foreign Currency Bank Account

      I have a bank account in USD zero balance but when i run the bank ledger in my company currency in AED it was shown small balance 1.31 AED , how to make it zero also ,Thanks

    • "Trigger flow for each entry" not working

      I've read this article on how to trigger a flow for each entry in my array. https://help.zoho.com/portal/en/kb/flow/user-guide/create-a-flow/articles/webhook-trigger#Trigger_flow_for_each_entry I cannot get the flow to run for each variant in this JSON

    • migrating from Zoho Invoices (CRM) to Zoho Books

      Good day, I was wondering if there was a easy way to migrate all the quotes and invoices from Zoho Invoices CRM to Zoho Books. We plan to move to using Zoho Books in a few weeks and would like to have all the quotes and invoices from the past 3 years

    • Edit specific job page on carreer site

      Hey, I was wondering how I could change the layout of a specific job page? (when you go to the carreer website and then click on a job listed there). When I go to customization I can edit the carreer website but I seem to be only able to edit the first

    • CRM - Clearing a Subform

      I seem incapable of working out subform functions without assistance.  I've searched, but can't seem to find anything that works. I have a subform that gets filled in when a Zoho Sign document is completed but the fields don't match with the original field values held on CRM (I did have it automatically update, but some fields were being filled in with terrible data, so had to put a stop to it).  There are 4 fields on the subform: Field Name Original Value New Value Update Update is automatically

    • Automatically add a retainer to every estimate

      Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,

    • Planning Sales visit to local lead, contacts

      Hello, We have our leads and contacts in CRM. One sale is asking me how he can view all leads and contacts (ideally on a map) in a given area (city or country or "region") so he can plan visiting them. What can be done or need to be developed to have

    • Force Sync Contact/Account from CRM to Books

      Hi all. This might not be a common issue to the large portion of the user base here, but for those who dabble and use CRM and Books integration, they know how painful it is that we have to wait for the 2-hour intervals for the records to sync; especially

    • Workflow for "Expenses" module?

      Hi there, over the last 2 years, Zoho Expense has seen tremendous growth and we are happy with it. But, sometimes it is frustrating to see things are being implemented halfheartedly, or so it seems. For example, There is the possibility to create workflows

    • When is partial reimbursement going to be launched?

      Hi there. I saw somewhere that the partial reimbursement feature is in the work. What is the update and ETA of that? Our clients and prospects have been asking us and we agree that that is an important feature to have.

    • IP Address List > Sigma

      We have developed a ZohoCRM extension that utilizes API calls to our server from Deluge scripts and Widgets. Our API server has IP restrictions in place. To ensure successful communication, we require a list of IP addresses utilized by Zoho's platform

    • Zoho CRM Canvas Copy Original Layout

      Hello all, I want to use Canvas to make small changes to certain views, not to make huge changes. Is it possible to copy the original Zoho layout and set-up and start from there? I checked and all I can find are some templates which are far from the original

    • ZOHO Nightmare

      I am writing as a long-time Zoho user who has faced significant challenges implementing your platform for my business. As a New York-based real estate broker, I have invested over $10,000 and nearly two years trying to integrate Zoho CRM with my WordPress

    • Approval system in Books/expenses

      Hi In Books Is there a way to do the following: 1) Submitter to know the balance in Budget/cashflow before sending the amount for approval? 2) Approver to know the same as 1 above? In Expenses, is the above possible?

    • attaching pdf to a bill using REST api

      I'm trying to attach a pdf to a bill using REST and curl. The problem is the example in that section in the API reference document does not show how to actually submit the file. It only shows the headers used. I've been trying many variations of this

    • How to Open .mbox file in Gmail with Attachments?

      Gmail offer users to backup INBOX folder in .mbox file format via Google Takeout Feature. Howver there is no such option to Restore Gmail MBOX. Thus I would like to suggest you to choose an alternate approach i.e. MBOX to Gmail Wizard. This utility will open .mbox file in Gmail with attachments.  Steps to open MBOX file in Gmail are; Run MBOX to Gmail Wizard Click Add File and add .mbox file. Enter your Gmail login credentials. Click Convert button. Finished! This is how you can open MBOX file in

    • Custom fields for calls and an enhanced call creation form

      Greetings, I hope you're all doing well. We're happy to announce a few recent enhancements we've made to Bigin's Calls module. We'll go over each one in detail. Enhanced call creation form in Bigin What is this enhancement about? This update includes

    • Customize user data collection with User Layouts

      Users denote the people in your organization who work on agile projects using Zoho Sprints. You can add them to your workspace and associate them with required projects. Organizations have distinct requirements in collecting user data. Apart from the

    • Zoho Sites with GoDaddy DNS

      We have a site hosted with www. in front that works perfectly well. The issue is with getting the TLD/naked DNS pointed to the www. while using GoDaddy dns. I have edited the DNS Forwarding entry in the domain so that the root example.com forwards to

    • Possible for "Specify URL Criteria" in URL/Permalink settings to be assigned to a variable?

      I want to embed a Zoho Analytics chart view as a Related List item in the Zoho CRM Accounts module, such that when one is viewing a CRM Accounts module record for an Account, the user will see the chart for that specific company. Is it possible to set

    • How to present an Analytic on a CRM dashboard and filter it on loginuser id

      How to present an Analytic on a CRM dashboard and filter it on loginuser id? I want to display an Analytics pivot table (as a widget) on a CRM dashboard and have the pivot filtered on the loginuser. I want additional user-filters available, such as date,

    • Allow 2 logos for Branding, one for Light Mode and one for Dark Mode?

      Our logo has a lot of black text on it. If we leave the background transparent, per recommendation of Zoho, when a user is viewing a file and turns on dark mode, our logo is not really visible and looks really weird. It would be really great if we could

    • Pre-fill TO and CC fields for Email Templates

      This would be a game changer to be able to set either specific email addresses or merge fields based on deal role titles into email templates. Please pass this along to *hopefully* add to future features of Zoho CRM.

    • Payroll In Canada

      Hi, When can we expect to have payroll in Canada with books 

    • Why can't we associate a contact to mulitple accounts?

      This simple feature has been for 14 years now... it's way past ridiculous. We don't want to add a multiple lookup field, we just want to add a second account to our contact. This way i'll go on Jonh Doe and see in the account field : Company 1 and Company

    • Calendar Bookings in Recruit

      Hi there, We have recently started using Zoho recruit and although it has some great functionality there are a few gaps that are causing real headaches. One of those being how interviews are scheduled. The majority of our hiring managers are field based

    • Multiple Vendor SKUs

      One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for

    • Automatic Department and Employee Sync Between Zoho One and Zoho People

      Dear Zoho Support, I'm writing to propose a valuable feature request that would streamline data management and improve user experience within the Zoho ecosystem: automatic synchronization between departments and employees in Zoho One and Zoho People.

    • Delete Unactive Users form Directory

      Hi, how to delete all unactive users ?

    • Manual Journal entry problem

      Hi, all my manual Journal entries are not reflected in my general ledger. i have check to see if the entry were done correctly and everything is fine. Please help me

    • Changing Related Modules in a Report

      Once a report is created, is it possible to add Related Modules? David Shalev | Chief Revenue Officer | 800 558 9130 davids@splitit.com | www.Splitit.com

    • Is there a way to limit/turn off unlimited Version History?

      We save CAD files in our Zoho WorkDrive and while the files aren't very big themselves, whenever someone hits the save button in the CAD program it uploads another version of the file to the WorkDrive. This means files that are only a few MBs in size can actually be taking up 10s of GB in our WorkDrive if someone is saving frequently. Is there a way to limit the number of versions WorkDrive stores to save WorkDrive space?

    • Next Page