$ 35.99
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Discuss (mail) |
| Lines of code | 216 |
| Technical Name |
bb_partner_sequences |
| License | LGPL-3 |
| Website | https://bbtech.ae |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Discuss (mail) |
| Lines of code | 216 |
| Technical Name |
bb_partner_sequences |
| License | LGPL-3 |
| Website | https://bbtech.ae |
| Versions | 18.0 19.0 |
BB Partner Sequences
Automatically assign unique Customer and Vendor numbers to your Odoo Contacts. Each company gets its own numbering series (e.g. CUST00001, VEND00001). Assignment happens on create and on updateâno buttons, no wizards. Existing customers and vendors are backfilled on install.
Automatic Customer & Vendor Numbering for Odoo Contacts
BB Partner Sequences adds dedicated Customer No. and Vendor No. fields to Contacts (res.partner) and assigns them automatically based on customer_rank and supplier_rank. Each company has its own numbering series; assignment runs on create and write, and a post-init hook backfills existing customers and vendorsâall without any manual action.
A) Dual Sequences (Customer + Vendor)
Two separate numbers for each role:
- Customer No.: Assigned when the partner is a customer (customer_rank > 0)
- Vendor No.: Assigned when the partner is a vendor (supplier_rank > 0)
- Partners who are both customer and vendor receive both numbers (e.g. CUST00005 and VEND00003)
B) Fully Automatic Assignment (No Buttons)
Numbers are assigned without any user action:
- On create: When a new contact is created with customer_rank or supplier_rank set, the corresponding sequence is assigned
- On update: When a contact later becomes a customer or vendor (e.g. ranks or company change), missing numbers are assigned
- Never overwrites: Existing Customer No. or Vendor No. values are left unchanged; only empty fields are filled
C) Backfill Existing Contacts on Install
Existing data is handled automatically:
- A post-init hook runs after module installation and assigns missing Customer No. and Vendor No. to all existing customers and vendors
- Processing is done in batches (e.g. 500 records) for large databases
- Safe and idempotent: only partners with empty sequence fields are updated; re-running does not duplicate or overwrite
D) Multi-Company Numbering
Full multi-company support:
- Per-company series: Each company has its own ir.sequence for Customer and Vendor (e.g. Company A and Company B each have CUST00001, VEND00001)
- Company-aware assignment: Uses company_id from the partner when set; for shared contacts (no company), uses the current user's (active) company context
- No renumbering: Once a number is assigned, it is not changed if the partner's company or the user's company changes later
E) Concurrency-Safe & Unique
Reliable under parallel usage:
- Sequence generation uses ir.sequence next_by_code in the correct company context (with_company)
- Sequences use no_gap implementation to avoid duplicates under concurrent requests
- Unique SQL constraints on Customer No. and Vendor No. ensure no duplicate numbers (empty/NULL is allowed for non-customers/non-vendors)
F) Seamless UI Integration
Minimal, non-intrusive integration:
- Contact form: Customer No. and Vendor No. are shown in the reference area near the top of the form
- Contact list: Both columns are available in the tree view (optional visibility)
- No new menus or workflows; standard Odoo contact usage is unchanged
Frequently Asked Questions
Screenshots
See BB Partner Sequences in your Odoo Contacts:
Contact Form â Customer No. & Vendor No. fields
Customer No. and Vendor No. in the reference area on the contact form
Contacts List â columns visible
Customer No. and Vendor No. columns in the contacts list view
Multi-company behavior
Company A vs Company B numbering â each company has its own series (e.g. CUST00001 in each)
Vendor assignment example
Vendor No. (VEND00001, VEND00002, â¦) assigned when partner is a vendor
Customer assignment example
Customer No. (CUST00001, CUST00002, â¦) assigned when partner is a customer
Sequence configuration (optional)
Per-company ir.sequence records for Customer and Vendor (Technical / Settings)
Professional Support & Services
Binary Bridge Technology Services provides professional support for the BB Partner Sequences module. Our Odoo experts can help with installation, configuration, and customization so that customer and vendor numbering fits your multi-company setup.
Installation & Implementation Support
We help you get the module running quickly:
- Install and configure the module on Odoo 18
- Verify post-init backfill and per-company sequences
- Confirm assignment on create/update and multi-company behavior
Customization Services
Need different formats or behavior? We can customize:
- Custom prefix formats (e.g. CUST-2025-, VEND-COMPANY-A-)
- Company code in prefix or separate numbering rules per company
- Migration from existing partner codes or other numbering systems
- Extra fields or reporting based on Customer No. / Vendor No.
Please log in to comment on this module