Skip to Content
This question has been flagged
2 Replies
826 Views
Avatar
Jayan

Hello Odoo Community,

We are using Odoo 18 Online and need to set up automatic serial number sequencing while generating serial numbers through Manufacturing Orders.

Current System Behavior :

  • Serial numbers are generated per product, restarting the sequence for each product.

Example:

  • MO0001 - Product A (10 units) → Serial Numbers: SN001 - SN010
  • MO0001 - Product A (10 units) → Serial Numbers: SN011 - SN019
  • MO0002 - Product B (5 units) → Serial Numbers: SN001 - SN005 (Restarting from SN001)

Expected requirement : 

  • Serial numbers should be generated continuously across all products without restarting.

Example:

  • MO0001 - Product A (10 units) → Serial Numbers: SN001 - SN010
  • MO0002 - Product A (10 units) → Serial Numbers: SN011 - SN020
  • MO0003 - Product B (5 units) → Serial Numbers: SN021 - SN025

We are looking for solutions to implement this continuous sequencing across all products. Any insights or recommendations would be greatly appreciated!

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Odoo 18.0 standard includes a "Serial Numbers" sequence.

Verify you have it by activating Developer Mode and visiting Settings --> Technical --> Sequences & Identifiers ->  Sequences.

If present, Odoo uses this each time it is asked to generate a Serial Number, irrespetive of the Product (via the Manufacturing Order or via the Shop Floor App).

If you delete/archive this sequence, you are required to define the first Serial Number (or sequence) for each Product and then Odoo will suggest the next number in the sequence

You will see the error "Please set the first Serial Number or a default sequence" if you try to ask Odoo to generate a Serial Number and the Serial Numbers sequence is missing.

Your "Expected requirement" are met out of the box, unless you have customized Odoo or are manually defining or importing Serial Numbers.

Avatar
Discard
Avatar
Ritik (Wan Buffer Services)
Best Answer

​Implementing a continuous, global serial number sequence across all products in Odoo 18 Online enhances traceability and consistency in inventory management. Here's how to achieve this:​

1. Understanding Odoo's Default Behavior:

By default, Odoo generates serial numbers individually for each product, causing sequences to restart for different products. For example, Product A might have serial numbers SN001 to SN010, while Product B also starts from SN001. This product-specific sequencing can lead to confusion when a unified serial numbering system is desired.​

2. Configuring a Global Serial Number Sequence:

To establish a continuous serial number sequence applicable to all products:

  • Access Sequence Settings:
    • Navigate to Settings → Technical → Sequences & Identifiers → Sequences.​
  • Create a New Sequence:
    • Click on Create to define a new sequence.​
    • Assign a descriptive Name (e.g., "Global Serial Numbers").​
    • Set a unique Code (e.g., "global.serial").​
    • Define a Prefix if desired (e.g., "SN").​
    • Specify the Padding to determine the number length (e.g., 5 for SN00001).​
    • Set Number Increment to 1 to ensure sequential numbering.​
  • Modify Product Serial Numbering:
    • Navigate to Inventory → Configuration → Settings.​
    • In the Traceability section, ensure Lots & Serial Numbers is enabled.​
    • Set the Lot/Serial Number Generation method to Global to apply the newly created sequence across all products.​

3. Utilizing Third-Party Modules for Enhanced Functionality:

For more advanced control over serial number sequencing, consider integrating third-party modules:​

  • Product Lot Sequence Module:
    • This module allows defining lot sequences directly from the product, offering flexibility in sequence management. 
  • All In One Auto Generate Lot/Serial Number Module:
    • Facilitates automatic generation of lot/serial numbers for various operations, including manufacturing and inventory adjustments. 

4. Recommendations for Automation and Best Practices:

  • Consistent Configuration:
    • Ensure that all products are configured to use the global serial number sequence to maintain uniformity.​
  • Regular Monitoring:
    • Periodically review the sequence settings and serial number assignments to detect and correct any discrepancies.​

At Wan Buffer Services, we specialize in customizing Odoo to meet specific business requirements, including implementing global serial number sequencing.

Avatar
Discard