Skip to Content
  2. Mailing Lists
  3. Contributors
  4. A better way to implement serial number tracking?

Archives

Contributors

Functional question: ISR based on customer [l10n_ch_payment_slip]

Speed up init of a database

A better way to implement serial number tracking?

Hi folks,

When I was thinking about a solution for  ‘Unsplittable product’, I came to realize that the current implementation for S/N tracking in Odoo is quite limited.

I create an issue here: https://github.com/odoo/odoo/issues/46290 . I’m also making a copy below, please kindly advise if I missed anything. Thank you.

Currently when a product is configured for S/N tracking, Odoo simply ensure the qty in a quant for the given product to be 1, that is almost all the difference from a normal batch lot tracking. This constraint also implies that the UOM for the S/N tracking product need to be piece or unit.

This works for some cases but certainly not all. For example, In jewelry industry, diamond is tracking by S/N, measuring in weight; in metalwork industry, steel roll is tracking by S/N(roll number), measuring in weight or length of the roll; Glass panel is tracking in S/N, measuring in size, etc. etc.

For the above mentioned S/N tracking, the UOM in question is not Piece and the qty in quant is not 1.

When we apply a serial number to a product, we actually suggest that the product is not splittable in transport. The qty in quant is 1 or not shouldn't be a problem.

The necessary constraint for a S/N tracking product should be:

  1. the quant must not be split
  2. the quant has to be reserved in full qty.

by Gu Tony <digisatori@gmail.com> - 09:21 - 26 Feb 2020