c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <700928@xxxxxxxxxxxxxxxxxx>]

On 29/03/11 20:38, Steffi Frank (Bremskerl, DE) wrote:
> Olivier,
> for my understanding: could please describe your conception of 'lot'?

I meant 'lot' as 'production lot', i.e. product serial numbers.

By default OpenERP can be made to force tracking these production lots
numbers for 3 kinds of operations:
- when receiving products from suppliers
- when sending products to customers
- when transforming products via manufacturing operations

These are the real meanings of the 3 check-boxes on the product form.

The third one "Track Manufacturing Lots" is probably a bit confusing,
but it is really explained in the tooltip: forces you to specify a
production lot for each move generated by a Manufacturing Order. This is
what will link production lots of different products together, i.e.
"Wood Piece #323" > has been used to build > "Table #124".

This check box does *not* mean that production lots are required for all
moves!

The reason for this is that OpenERP does not currently track production
lots for internal moves. You are free to specify them manually if you
want on internal moves, but they are not mandatory, and the system does
not verify them.

Most companies have sufficient tracking with these 3 operations:
reception, delivery, and transformation via manufacturing.

If you need to also track all internal moves, it may be necessary to
write a small module to implement this according to your needs.


> how you will ensure traceability (on level production lot) if you
> don't ensure that your FIRST stock level (starting with new software
> normally starts with an inventory of your existing stock) gets set up
> with correct production lots?

Of course it makes sense to indicate production lot numbers for starting
inventories, i.e. when adding products to your stock, as if they had
just entered your warehouse from the outside.

But it is not mandatory to do it on all physical inventories, and should
probably not be, because it does not work the same for corrective/yearly
inventories.

The reason for this is that if you say you have only product X with
production lot #111 in Stock, OpenERP will not detect that it means
product X with prod lot #112 is now missing.
Why? Same as above: OpenERP does not currently track or verify
production lots on internal moves. So there is no guarantee that we know
the correct production lot for each product that is in each location.
Therefore no computation can be safely based on that, at the moment.


> "...a physical inventory has nothing to do with a manufacturing
> order"
> 
> It has! all raw material you'll consume in a MO gets inverted before 
> 'going live'

I don't understand what you mean. In any case, see above about the
"Track Manufacturing Lots" option: it is really meant for Manufacturing
Orders, nothing else, and nothing to do with Physical Inventories.


> I agree: the term 'production lot' is unclear.... 
> https://bugs.launchpad.net/openobject-addons/+bug/730094

Production Lot = Serial Number = Batch Number
Also, having a Production Lot does not mean you produced the goods yourself.


> without any comment: openerp book V6, page 282, chapter 20.9.3 
> Traceability:
> 
> "If you key in the lot numbers for stock moves as described above you
> can investigate the traceability of any given lot number."

Here again, Lot number = Production Lot Number = Serial Number = Batch
number. Yes, you can investigate the traceability of any such number.
But like everything else in the system, this is only meant to show you 3
kinds of moves by default: incoming/outgoing/manufacturing.

If you have manually added production lot numbers on each internal move,
you should see them too, of course.


I understand that this may very important for your business cases, so
let me start an internal review of this bug as well as this related one
[1] and then we'll give you feedback on whether they are valid (and if
they are, what else needs to be changed to keep the system consistent).

I hope my explanations were clear... this is not an easy topic


[1] https://bugs.launchpad.net/openobject-addons/+bug/700963

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/700928

Title:
  Validation production lot in inventory

Status in OpenERP Modules (addons):
  In Progress

Bug description:
  In V6 you are now allowed to enter production lots, but the system
  does not validate the entry. Would be nice if a validation would come
  up by leaving the new line. At latest when an inventory is getting
  confirmed.