Project

General

Profile

Edit Copy Actions
Copy link

Feature #8398

open

Enquiry ID Auto-Generation with Monthly Sequence Reset

Added by Pavan Kumar Murala 14 days ago. Updated 14 days ago.

Status:
Resolved
Priority:
Normal
Assignee:
Pavan Kumar Murala
Target version:
-
Start date:
03/25/2026
Due date:
03/25/2026 (14 days late)
% Done:

100%

Estimated time:
2:30 h
Spent time:
2:30 h
Quote

Description

Implemented a standardized and automated Enquiry ID generation system across all enquiry sources. The ID format follows <PREFIX><MM><YY>_<SEQUENCE> (e.g., EM0325_001), ensuring consistency and uniqueness.

Key features include:

Defined prefixes for different sources:
EM – Manual Entry
EW – Website
EU – Excel Upload
Developed a shared sequence logic that increments globally across all sources.
Implemented automatic monthly reset of the sequence counter.
Ensured unique ID generation for:
Manual enquiries
Website enquiries
Excel imports
Preserved existing IDs during enquiry updates to maintain data integrity.

Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Pavan Kumar Murala 14 days ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

Updated by Pavan Kumar Murala 14 days ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 100
  • Estimated time set to 2:30 h
Edit Copy Actions
Copy link

Also available in: Atom PDF