MODULES / CUSTOMER

CRM Lead References

Assign stable, company-scoped yearly references to CRM leads and opportunities.

Overview

Module idask_crm_sequence
Version1.0.0
Who uses itAnyone who uses the screens listed below.
InstalledOn demand, from Settings → Modules. Anything it needs is installed with it.

How it links to other modules

  • Needs: CRM
  • Works better with: no other module in particular
  • Needed by: no other module

A module that is needed cannot be turned off while the module that needs it is on.

Details

CRM Lead References

This optional addon adapts the CRM identity portion of Odoo 18's ask_crm_sequence from D:/Odoo18/asksol/custom_addons. It assigns references such as CRM/2026/00001 to leads and opportunities and shows them in the CRM list and record header while the addon is installed for the company.

References are issued in PostgreSQL in the lead's creating transaction. The counter is company- and year-scoped, tenant-protected by RLS, and concurrent creates serialize on the counter row. A unique index prevents duplicates and the reference cannot be edited after assignment. Existing CRM records receive stable references during migration; companies that have not installed this addon do not receive numbers on new records. Disabling the addon preserves old references and stops assigning new ones until reinstalled.

The Odoo source also contains Project-specific fields and project workflow dependencies. Those are not part of this port because ASKERP has no Project module; only the useful CRM reference behavior is included.

CRM Lead References | ASKERP Docs