Feature #8398
openEnquiry ID Auto-Generation with Monthly Sequence Reset
Start date:
03/25/2026
Due date:
03/25/2026 (14 days late)
% Done:
100%
Estimated time:
2:30 h
Spent time:
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.
Subtasks
Related issues