ERPNext CRM Date Filter

@naminghn

Hi there, I see you're looking to add a "From / To" date filter to the Opportunities search view within ERPNext's CRM module. This enhancement will be instrumental in allowing you to narrow your search results by date range, maintaining the native look-and-feel of ERPNext as you requested. I can modify this specific search view seamlessly, ensuring the filter works in both quick and advanced search modes while respecting user permissions during pagination. I have extensive experience with PHP and ERPNext, making me well-suited for this task. I can deliver this enhancement swiftly, ensuring that it blends perfectly with your existing user interface. If there are any additional details you’d like to discuss about the project, I’m here to help. Regards, Ali

@denisSolution

Hi, I'm Denis, a full-stack developer with experience in ERPNext customizations and CRM systems. I understand you need a straightforward date range filter for Opportunities that integrates cleanly with ERPNext's native interface. The core challenge is adding the From/To date filter without disrupting the existing list view behavior. ERPNext uses a standard filtering architecture that must be followed precisely. The filter should appear alongside native filters, work in both quick and advanced search modes, maintain state across pagination, and respect existing permissions. I've handled similar customizations where adding filters required understanding DocType structure, list view rendering, and filter persistence. The key is keeping it lightweight and consistent with ERPNext's native date filtering. My approach: First, I'll review the current Opportunity list configuration, then add the date filter directly to the DocType's list view settings. This involves modifying metadata so the filter appears natively without custom JavaScript or workarounds. I'll test across different search scenarios to ensure correct behavior with pagination and permissions. One important consideration is performance—I'll verify the database query performs efficiently, especially if you have a large volume of opportunities. I can start immediately. Let's discuss the details. Thanks, Denis.

@arslanshahid386

Hi, I understand you're looking to enhance the CRM module in ERPNext by adding a "From / To" date filter specifically for the Opportunities search view. This will help you narrow down results by date, making it easier to manage your data effectively. The main technical challenge here is integrating a custom date filter into the existing ERPNext framework without disrupting its current functionality or appearance. My approach would involve first assessing the existing search view architecture to ensure seamless integration. Prioritizing stability and maintaining the native look-and-feel of ERPNext is crucial. I have extensive experience in PHP and software architecture, having worked on several ERPNext customizations, including similar filter enhancements. Q1 – Are there any specific date formats you prefer for the filter (e.g., DD/MM/YYYY)? Q2 – Should this filter also apply to any exported data from the Opportunities search view? Q3 – Do you anticipate any future need for additional filters or modifications in other modules? Looking forward to hearing from you.

@Adilali5310

? Allow me to bring the power of automation and integration to your ERPNext CRM by implementing the precise date filter you need. With a specialized skill set in CRM's and 4+ years of experience, I'm adept at tailoring solutions to enhance productivity and streamline operations. ? I've successfully integrated Zoho with various third-party tools such as CRMs, ERPs, and payment gateways, all requiring an in-depth understanding of software architecture. Your request for the 'From / To' filter will be met with my skills in API development, as I can create it directly where specific connectors do not exist. ⏱ Time is valuable, and repetitive tasks can eat into your resources. My extensive understanding of automated workflows fits seamlessly into your requirement. Not only will I ensure that the solution coheres with the native look-and-feel of ERPNext's list view, but it'll work flawlessly in quick search, advanced search panels and respect user permissions even during pagination. Choose me to get a reliable, scalable and efficient solution that saves your time and makes navigation within the Opportunities search view for created Opportunities a swift breeze. Let's make your ERPNext CRM precisely suited for your needs

@billybryan98

Could you clarify if there are any specific user permissions that need to be considered for the date filter functionality? I recommend ensuring that the filter seamlessly integrates with both quick and advanced search panels to enhance user experience. I am confident in my ability to implement the date filter in the CRM module of ERPNext, leveraging my extensive experience in PHP and database management. To achieve this, I will modify the Opportunities search view, ensuring the filter maintains ERPNext’s native look and feel, while also ensuring it persists across pagination and respects user permissions. Please feel free to reach out to me. I look forward to working with you. Best regards, Billy Bryan

@lazarr4

Hello, I can add a date range filter to ERPNext’s Opportunities view while preserving its native UI and ensuring it works across all search modes. I modified a similar filter for a client’s custom ERPNext module—it reduced their manual filtering time by 30% while keeping the interface clean. I’d approach this by extending the existing search query builder to include date fields, then styling the filter controls to match ERPNext’s design system. The biggest improvement will come from making the filter persistent across pagination and search modes without breaking permissions. Clean filtering will help your team focus on relevant opportunities faster, reducing time spent sifting through old records. I’ll also document the changes so they’re easy to update in the future. Once the project is done, I’ll walk through the implementation and confirm the filter works as expected in all scenarios. If this approach fits your needs, I’d be happy to discuss the details further. Thanks, Lazar.

@MSaadJaved

Hi, I’ll add a clean From/To date filter to the ERPNext Opportunities search view so you can narrow created records quickly, while keeping the native list UI and limiting the change strictly to CRM Opportunities. The main technical concern is making the filter behave consistently across quick search, advanced search, pagination, and permission-aware queries, so I’ll wire it into the existing list/query flow rather than layering on a custom workaround. I recently worked on a similar ERPNext customization involving list-view filtering and DocType-specific query adjustments. For your project, I’d begin by tracing the Opportunities search handlers, then implement the date filter, verify it persists through paging, and test it against different user roles. Would you like the filter to use the Opportunity creation date specifically, or a custom date field if one exists? Best regards, NexLoom

@huzaifa306

Hi, I have experience with ERPNext customization and can add the From and To date filters to the Opportunities list without affecting the existing CRM features. I will keep the native ERPNext interface, make sure the filters work with pagination and permissions, and test both quick and advanced search. I can start immediately. Best regards, Huzaifa

@ankits0192

Hello, there. Buenas tardes desde Guatemala - espero que tu semana vaya bien. Una consulta: ¿qué versión de ERPNext usas, v14 o v15? ERPNext ya trae filtros de rango de fechas en list views; el punto real es que persistan en paginación y respeten permisos. Ahí es donde suelen fallar los parches rápidos. 30Puedo agregar el filtro Desde/Hasta solo en Opportunities, manteniendo el look nativo, funcionando en búsqueda rápida y avanzada, con persistencia y permisos intactos. Disponible ahora - prueba en staging antes de aplicar. 1. ¿Versión de ERPNext? 2. ¿Acceso a staging? 3. ¿Custom app o edición directa? Hablemos en más detalle ahora. - Ankit

@ayesha86664

Hi there! The main issue is that ERPNext Opportunities cannot currently be narrowed by a created date range, making it harder to find records quickly. The filter also needs to work smoothly without affecting the existing CRM search behavior. I have experience with ERPNext customization, CRM modules, list views, filters, and backend database logic. I can work with the existing ERPNext structure and keep the customization aligned with its native interface and permission system. I’ll add a clean From and To date filter specifically to the Opportunities search view. I’ll make sure it works with both quick and advanced search, remains active while moving through pagination, and respects the logged-in user’s permissions. I’ll also test different date ranges and edge cases before delivery. check our work https://www.freelancer.com/u/ayesha86664 Could you confirm which ERPNext version your current system is running? Let me know if you’re interested & we can discuss it. Best Regards Ayesha

@BlueLi0n

Saw the screenshot - I'd turn that Creation Date box into a date range picker, From and To in one field, set up as a List Client Script on Opportunity Picking a range would set a Between filter on creation, so it also shows up in the filter popover, stays put while you page through, and results still come through Frappe's own permission checks since the query itself isn't customized It'd sit in that bar looking just like the boxes next to it Send me a login with System Manager rights and I'll put it on your site so you can try it right away

@umer419

Hello, I checked your project "ERPNext CRM Date Filter" and already have a clear understanding of your requirements and how to deliver them efficiently. I have solid experience in PHP, API Development, and I've successfully completed similar projects by delivering high-quality, scalable, and reliable solutions. Why choose me? * Strong expertise in PHP, API Development * Clean, optimized, and scalable implementation * Fast communication and regular progress updates * Focused on delivering results, not just completing the task I'm ready to start immediately and would be happy to discuss the details. Best regards, Umer

@PINESCRIPTERR

Hi, I can add the date-range filtering specifically to the ERPNext Opportunities list while keeping the native ERPNext UI and existing permission behavior intact. I’ll implement the From/To date filters so they work with both the quick search and advanced filter interfaces, preserve the selected values across pagination and refreshes, and ensure the query continues to respect the current user’s permissions without affecting other CRM list views. Question 1: Which ERPNext/Frappe version are you currently running, and should the date range filter use the Opportunity creation date or another existing Opportunity date field? Question 2: Do you want both From and To dates to be optional independently, so users can search from a date onward or up to a specific date as well as between two dates? Regards, Houssame.

@iymkaa

Hi, I'd put a From / To pair right in the Opportunity filter bar where Creation Date sits now, same grey boxes as the rest of the filter bar Under the hood it would be a normal Between filter on the creation date, so ERPNext's own list query does the filtering, nothing custom on the server side. I'd test it logged in as a limited sales user too, not only as admin I'd keep it in a small custom app instead of core files, nothing else in CRM changes Which ERPNext version are you on, v15? So I build and test on the same one

@codeandcommand

Opportunity date filters in ERPNext CRM usually break because the field uses a datetime picker instead of a plain date range, or the report view filter isn't hooked to the right doctype field. I can patch the filter logic directly in the CRM module and have it searching correctly within a day. Available now, can start today. Budget and timeline here are a starting point based on the post. Once I see your actual instance, I will confirm exact scope. Want me to take a quick look at your setup first?

@sara0346

Hello, I reviewed your project about adding a precise date range filter to ERPNext Opportunities. I will extend the existing list-view filtering with native From and To date fields, keeping ERPNext’s standard UI and permission behavior intact. The filter will work with quick and advanced search, remain active during pagination, and be tested against different date ranges and user permissions. Which ERPNext version is currently running? Best Regards, Sara

@nakabirik

Hi, Muheebwa here. I understand you need a precise tweak in ERPNext's CRM module: a "From / To" date filter on the Opportunities search view only, so you can narrow created Opportunities by date range—keeping the native list view look, working in both quick and advanced search, persisting through pagination, and respecting user permissions. The real focus here is a clean, native-feeling addition rather than a custom workaround. My approach would be to add the date-range filter to the Opportunities list view using ERPNext's standard filter framework (customising the doctype's list view JS/filters rather than core files, so upgrades stay safe). I'd ensure it appears in both quick and advanced search, persists during pagination, and honours the user's permissions. Then test against real Opportunity records. To get started: could you share your ERPNext version and confirm whether I can work on a staging instance first? Looking forward to hearing from you.

@copulas

Hello, I'm based in Japan, blending strong technical skills with Japanese discipline, punctuality, and attention to detail. I'll work efficiently to complete your project perfectly, and as quickly as possible. Expect clear communication, reliable delivery, and a deep commitment to quality. Let’s make it happen. Warmly Regards.

@tinyo3

Hi. ERPNext Opportunities filter — you need a focused From/To date range filter added without disturbing the native CRM list behavior. I’d first trace how the Opportunities list currently builds quick and advanced filters, then add the date constraint through ERPNext/Frappe’s existing filter mechanisms rather than modifying the broader CRM search framework. The important edge cases are inclusive date boundaries, filter state surviving pagination, and ensuring the query still passes through the existing permission checks. I’d keep the UI consistent with the standard ERPNext list view and limit the change strictly to Opportunities, followed by regression testing of existing search/filter behavior. Which ERPNext version are you currently running? That will determine the cleanest supported implementation point. Best. Kara.