Zoho Finance Limitations 2.0 #18: Can't Validate System Date Fields within Books (if empty)

Throughout books there are system date fields on Purchase Orders, Sales Orders, etc...

You can run validation on these BUT ONLY based on the date entered... example: it must be X days after or before Y.

However you can't validate the field is a user leaves it empty and you can't make the fields mandatory either which leaves you in a tight spot!

Possible Workaround

Add yet another custom field and make that field mandatory and run validation on that and then push the data to the system defined field.

========

Perspective: using Zoho finance integration from within Zoho CRM which adds a new module that pulls in Zoho books data. 

Original Zoho Books / CRM limitations post by Gaurav Sethi

https://help.zoho.com/portal/en/community/topic/zoho-books-zoho-crm-integration-full-of-limitations-rendered-useless

• Topic Participants

• Kevin Flynn

  

• Sukumar

  

• Ishwarya SG

  

• Naveen R

  

• Sticky Posts

• Zoho Books will discontinue support for older browser versions soon

  Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100

• [Webinar] Understanding the New Invoice Management Systems

  Join industry expert CA Pritam Mahure as he discusses the importance of the new Invoice Management System (IMS) and its impact on taxpayers. Topics Covered: - Concept of IMS and pre-requisites - Applicability and Restrictions on Invoices/Records for IMS

• Latest Updates of the 53rd GST Council Meeting & Its Business Implications

  Join industry expert CA Venugopal Gella as he discusses the importance of 53rd GST Council Meeting, the latest notifications and changes introduced by the Finance Act 2024. Register Now: https://zoho.to/GST_Webinar

• Best practices for financial year-end closing with Zoho Books | Free Webinar

  Ready to close your year-end finances like a pro? Join our free webinar and learn how Zoho Books helps you maintain clean accounts, carry forward balances, and get geared up for the new financial year. Register now - https://zoho.to/9f1

• Master the art of budgeting with Zoho Books | Free Webinar | 4th & 5th March 2024

  We're thrilled to launch the Zoho Books monthly webinar series! Don't wait to conquer your finances in 2024! Budgeting can be easy with Zoho Books. Join our FREE webinar and learn how to set and track goals, master budgeting, and unlock insights to make

• Recent Topics

• Zoho Forms - Improved Sub-Forms

  Hi Forms team, I'm helping a client move from JotForms to Zoho Forms and I've found another opportunity for improvement. In the below screenshot, JotForm left and Zoho Forms right. The Zoho Forms Sub-Form is quite a poor visually. There is no way to make

• What's New in Zoho Billing | Q3 2025

  Hello everyone, We are excited to share the latest set of updates and enhancements made to Zoho Billing in Q3 2025. From the latest GST updates to multi-level discounting, Zia-powered report summaries, and customizable web forms, these updates are designed

• How to Delete Personal Account Linked with My Mobile Number in past or by someone else

  How to Delete Account Created with My Mobile Number in past or by someone else This is creating issues in making or sync with my credentials mobile and email address..

• WhatsApp Business Calling API

  Dear Zoho SalesIQ Team, I would like to request a feature that allows users to call WhatsApp numbers directly via Zoho SalesIQ. This integration would enable sending and receiving calls to and from WhatsApp numbers over the internet, without the need

• Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

  Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?

• Enhancing Zia's service with better contextual responses and article generation

  Hello everyone, We are enhancing Zia's Generative AI service to make your support experience smarter. Here's how: Increased accuracy with Qwen One of the key challenges in AI is delivering responses that are both contextually accurate and empathetic while

• Marketer's Space - Going beyond basics: Smarter ecommerce marketing with Zoho Campaigns

  Hello Marketers, Welcome back to this week's Marketer's Space. In the last post, we discussed the basics of email marketing and how to get started with email marketing in ecommerce. In this part, we'll dive much deeper into some other advanced features

• Experience effortless record management in CRM For Everyone with the all-new Grid View!

  Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and

• Connecting two modules - phone number

  Hi, I’d like some guidance on setting up an automation in Zoho CRM that links records between the Leads module and a custom module called Customer_Records whenever the phone numbers match. Here’s what I’m trying to achieve: When a new Lead is created

• SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET

  TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO

• I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.

  These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho

• Zoho Marketing Automation 2.0 - Landing Page function not working

  Dear Zoho Team, I am working on implementing Zoho Marketing Automation 2.0, and am now looking into the section "Lead Generation". If I open the "Landing Pages" section, I immediately get an Error code: Error: internal error occurred. Can you help me

• Auto select option in CRM after Zoho Form merge

  Hi, I have a dropdown field in Zoho CRM that is filled with a Zoho Form. The data is filled but not automatically shown. After selecting the right value in the dropdown the information a second field is shown. So the question is; how can I make the dropdown

• Unable to use Sign "You have entereed some invalid characters"

  Unable to use Sign "You have entered some invalid characters" I do not see any invalid characters. The text in "Leave a Note" is plain text which I entered directly into the field. See attached screenshot

• Default Sorting on Related Lists

  Is it possible to set the default sorting options on the related lists. For example on the Contact Details view I have related lists for activities, emails, products cases, notes etc... currently: Activities 'created date' newest first Emails - 'created

• Elevate your CX delivery using CommandCenter 2.0: Simplified builder; seamless orchestration

  Most businesses want to create memorable customer experiences—but they often find it hard to keep them smooth, especially as they grow. To achieve a state of flow across their processes, teams often stitch together a series of automations using Workflow

• Messages not displayed from personal LinkedIn profile

  Hello. I connected both our company profile and my personal profile to Zoho social. I do see all messages from our company page but none from my private page. not even the profile is being added on top to to switch between company or private profile,

• "Performed changes in the query is not allowed due to following reason" when adding columns or reordering data

  I'm trying to make changes to a query but every time i try to save it i get this error message. I'm not touching the data it's flagging. All I've tried to do is reorder a couple of fields and add a new one. Why won't it let me do this? It's a core query

• Onboard new users easily with native screen recording in Zoho Projects Plus

  Communication involving both visual and audio elements tends to capture more interest among the audience. Whenever we onboard new employees to the organization, the task of engaging them in the induction sessions, and keeping the spark going in their

• Request to Add Support for PDF Templates and More Flexibility in Email Editor

  Hi Zoho Campaigns Team, I hope you're doing well. I wanted to share some feedback and request a few improvements in the Email Template feature of Zoho Campaigns. Right now, we can create email templates using the HTML editor, which is helpful. But we’re

• Can you stop Custom View Cadences from un-enrolling leads?

  I'm testing Cadences for lead nurture. I have set un-enroll properties to trigger on email bounce/unsubscribe, and do NOT have a view criteria un-enroll trigger. However, help documents say that emails are automatically un-enrolled from a Cadence when

• Meet Canvas' Grid component: Your easiest way to build responsive record templates

  Visual design can be exciting—until you're knee-deep in the details. Whether it's aligning text boxes to prevent overlaps, fixing negative space, or simply making sure the right data stands out, just ironing out inconsistencies takes a lot of moving parts.

• Zoho Desk Android and iOS app update: Agent detail overview

  Hello everyone! We’ve introduced agent detail overview on the Zoho Desk Android and iOS app update. With this feature, you can get a complete view of agent’s tickets, response times, logged hours (for both tickets and activities), customer happiness ratings

• Blog Widget: Show recent blog posts on my homepage

  Hey there I am using the Zoho Sites Blog feature. On my homepage, on the bottom I'd like to have a featured content section where I show some of my blog posts (selected, most recent, filtered by category and so on...). It would be nice to have a blog

• YouTube Live #2: Agreement Intelligence with Zoho Sign's eSign AI assistant

  Hi there, We're back again with our YouTube live series and this time, we'll take you through our holistic agreement intelligence powered signature workflows. Struggling to draft an agreement? Need help double-checking clauses and going through complicated

• How to iterate through excel data using zoho rpa

  I wanted to iterate or loop through excel data ( datatable). How can i do that

• Update on the client portal URL for Guest users

  We’re updating the way Guest users access their Connect network. As part of this change, all client organization portals used by Guest users will now be accessible through a dedicated domain specific to each data center. The access URLs mentioned here

• Zoho Commerce

  Hi, I have zoho one and use Zoho Books. I am very interested in Zoho Commerce , especially with how all is integrated but have a question. I do not want my store to show prices for customers that are not log in. Is there a way to hide the prices if not

• Mass (Pull back) (Close WOs) (Close APs)

  Hi develop team. Just idea because Zoho FSM is great but its too manual. we have a lot of task to do every day and the system needs to have more features to automatic our tasks. I need to close several WOs, APs and Pull Back per day. Please we need mass

• Workdrive on Android - Gallery Photo Backups

  Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma

• Customising Zohidesk portal default widgets

  Hello, I'm wondering how could I customise the default widgets such as "popular topics", "popular articles" using CSS or to make the tiles at the bottom match the ones that I made in the picture attached. I have made some custom widgets and edited them

• Microsoft Teams now available as an online meeting provider

  Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings

• Add Custom Reports To Dashboard or Home Tab

  Hi there, I think it would be great to be able to add our custom reports to the Home Tab or Dashboards. Thanks! Chad

• If there’s a batch at the end, the ‘mark as inactive’ function doesn’t work.

  when my batch has a date to batch end and I "mark as inactive" he batch does not obey the status and reactivates the batch.

• Seamless multilingual messaging and tone control in Zia IM Composer

  Hello everyone! Managing customer conversations across multiple languages can be time-consuming. Using Zia in the Instant Messaging (IM) Composer helps you overcome this by providing tools to translate content, adjust your tone, and refine your messages

• Workflow Failure - Notifications

  Good afternoon, I have just experienced an error whereby a Workflow failed, for a reason currently unknown. The problem is that one of my users had to flag this manually (thankfully he's very thorough) and this otherwise would have flown under the radar.

• Advanced Deluge help needed with custom function and COQL limits

  I have a scheduled function that takes a snapshot of specific metrics and saves them to a custom module. However I'm struggling with the limits of COQL. I attach my full code, but an example of the issues I'm having is that it's erroring with a 'Limit

• Tip of the Week - Conditional Formatting Chart

  Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend.  Zoho Analytics allows you to

• Zoho Learn - AI Translate

  Hi Learn team, I had a situation today where I was providing training to a client team and I had written articles into their Zoho Learn to support their learning. I realised that one of the team members was a non-native English speaker and they were struggling

• Payroll In Canada

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

• Next Page