Odoo Help

3

Stock picking algorithm in OpenERP

By
Javier Fuentes
on 5/14/13, 6:14 AM 2,105 views

Hi,

We are trying to figure out which algorithm is applied by OpenERP to select the products from the inventory when orders are made.

As an example, imagine we have a product stored in two different stock locations:

  • Location #1: 3 units
  • Location #2: 10 units

If an order arrives requesting 11 units of this product, how does the scheduler decide from which location/locations will units be picked?. Some alternatives would be:

  • All units from #1 and 8 from #2
  • All units from #2 and 1 from #1
  • 2 units from #1 and 9 from #2
  • ...
4
Borni DHIFI
On 5/14/13, 6:32 AM

Hi,

OpenERP searches the locations in order of localization then by name if they have the same localization.

You have defined "Location #1" and "Location #2". Every time it finds a product it looks for, it tries to get as much as needed from that location, until the order is fulfilled.

so you get : All units from #1 and 8 from #2.


If you want to have a different logic, you must create a new module.

Thanks for your response!. Just one quick question, by localization you are refering to warehouses?

Javier Fuentes
on 5/14/13, 6:35 AM

Yes .you need to define locations for each warehouse (location output,location stock and sometimes location input).

Borni DHIFI
on 5/14/13, 6:40 AM

Is there also some check within a warehouse on localization? E.g. length of path to root. Or only on name of location. So if I have stock / Z-001 and stock / second floor / A-001 will stock be first taken from Z-001 (shortest route) or A-001 (alphabetical)?

Richard van der Klooster
on 9/28/13, 4:18 PM

Plz post a new question from this subject.

Borni DHIFI
on 9/28/13, 6:03 PM

The products are taken from locations according to the order of the stock.location object. You can define an new order by modifying the _order of this object.

WANTELLET Sylvain
on 11/12/13, 5:07 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 5/14/13, 6:14 AM
Seen: 2105 times
Last updated: 3/16/15, 8:10 AM