How create or use sequence

[christopherDallar]

I will explain some tips and step that i found to create a custom sequence and use it

[christopherDallar]

How to create a sequence, assign to a model and show text generated by the sequence in a form view

For this example, I used two models:

• stock.location

"Where i will add a new field to select one sequence from ir.sequence (settings/technical/sequences)"

• stock.picking

"The form view contains a valid button, I will overwrite its action and add more validations, and that will be where I use a method to get the text generated for the sequence object and saved into another field (Char) of stock.picking record."

Note: When the text is generated by a method it increments the count by itself.

Now look at the steps below:

1. Add the sequence fields to stock.picking model and view:

Model

View

Result

2. Add a field that will contain the text generated for the sequence method to stock.location model and view:

Model

View

Result

The field called "Correlativo de ubicación" after the field "Ubicacion de origen"

3. Add the field that contains the object reference of sequence (ir.sequence model) selected into the location_id (Ubicacion de origen) field:

4. Overwrite the action method of the valid button:

What part of the code that really matter is the below:

Explanation:

• The field location_sequence_id contains an object with the method "_next()" that increment the count and then returns the text needed.
• Then i use the method update to change the value of the location_sequence field with the text generated.

Result

The correlative result:

[christopherDallar]

sequence.get_next_char(sequence.number_next_actual) -> For get the next prefix and number without incresease de sequence is like to return a preview of the next char