Odoo Help

2

8
18 Answers
3
Avatar

Andreas Brueckl Austria

--Andreas Brueckl--

5546
| 8 8 9
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl Austria
3/18/13, 11:41 AM

In menu "Reporting / Warehouse / Inventor Analysis" you see the stock level of all products. Per default you see the stock level of all internal locations.

If you want to have the stock level of a certain location you have to do an Advanced Search with field Location.

If you want to see a product's stock level in all locations, then simply Group By .. product and location.

Of course, as patrick already mentioned you can click More and Stock by Location in the product's form view to see the stock level of a certain product.

8 Comments
Rove.design GmbH, Stefan Reisich Germany
3/18/13, 11:54 AM

ok, but how can i get all stock locations of a product? eg. a product is distributed in various locations. how can i get a list of this locations with quantity?

Remya India
3/18/13, 1:06 PM

I also want to know this!!!

patrick Netherlands
3/18/13, 1:21 PM

If you select a product, you should be able to click on the button More, and select 'Stock by Location'. At the moment you cannot filter on amount > 0 (or other number), so if you have got a lot of locations, you have to go through the whole list.

Rove.design GmbH, Stefan Reisich Germany
3/18/13, 1:53 PM

Group By ...product and location just shows the company not the location(shelf).

Yes we have a lot of locations, going through the whole list is not an option... :-(

Andreas Brueckl Austria
3/18/13, 1:56 PM

You have to remove the "Internal" filter so that you see really all locations were the product is available. you can add another filter for the product if you only want to see certain products

Rove.design GmbH, Stefan Reisich Germany
3/18/13, 2:07 PM

ahh, thank you, i got it.

john
3/25/13, 8:00 AM

My issue is that this gives us 2000 locations and the filter seems broke. You cant click the column header 'real stock' but you can click to sort the headers 'location type' and 'location name'.. also if you use the 'Advanced Search' and select either 'real stock' or 'real stock value' is greater than 0.00 the results dont change. The view still shows all the locations including those with 0.00 stock !

IT Libertas Russian Federation
3/13/16, 5:43 PM

Perhaps, this module https://apps.odoo.com/apps/modules/9.0/product_stock_balance/ would be useful to this purpose

3
Avatar

Serpent Consulting Services Pvt. Ltd. India

--Serpent Consulting Services Pvt. Ltd.--
Serpent Consulting Services Pvt. Ltd.
http://www.serpentcs.com
5103
| 7 6 10
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. is an Official Odoo Partner, working on Odoo ever since 2007, experience of 11+ years and witnessed the growth of Odoo.

We are a team of 80+ experts on various verticals. Our portfolio of products can be seen at http://www.serpentcs.com and http://www.serpentcs.in

Our Expertise and Services:

  • Odoo Support

  • Odoo Development

  • Odoo Training

  • Odoo Migration

  • Odoo Implementation

  • Odoo Consulting

Our 290+ Apps on Appstore : https://apps.odoo.com/apps/modules/browse?author=Serpent Consulting Services Pvt. Ltd.

Thanks.

Serpent Consulting Services Pvt. Ltd. India
3/18/13, 1:38 PM

In OpenERP, location is a generic concept and it is not bound to any product specifically.

If you wanna see locations with quantity, you should print a report available on locations.

If not a report, you have do a little customization.

Thanks.

6 Comments
Rove.design GmbH, Stefan Reisich Germany
3/18/13, 1:56 PM

what kind of customization?

Serpent Consulting Services Pvt. Ltd., Serpent Consulting Services Pvt. Ltd. India
3/18/13, 3:10 PM

Override the search() to show only the nonzero qty holder locations! I 've made it, will attach here.

Serpent Consulting Services Pvt. Ltd., Serpent Consulting Services Pvt. Ltd. India
3/18/13, 3:12 PM

def search(self, cr, uid, args, offset=0, limit=None, order=None, context=None, count=False): if context is None: context = {} res_ids = super(stock_location, self).search(cr, uid, args, offset, limit, order, context=context, count=count) loc_obj = self.browse(cr, uid, res_ids, context=context) res_ids = [x.id for x in loc_obj if x.stock_real>0 return res_ids

patrick Netherlands
3/19/13, 5:52 AM

Missing a closing ] at the end, but thank you. This is useful for us as well.

Serpent Consulting Services Pvt. Ltd., Serpent Consulting Services Pvt. Ltd. India
3/20/13, 7:20 AM

Welcome Patrick! might have missed ] in a hurry! My aim was just to give an idea :)

Rove.design GmbH, Stefan Reisich Germany
3/25/13, 9:37 AM

thank you very much. this will help me a lot...

1
Avatar

IT Libertas Russian Federation

--IT Libertas--
1258
| 4 3 9
Saint Petersburg, Russian Federation
--IT Libertas--

Visit us: https://odootools.com/

IT Libertas is a team of developers and automation experts to help you to unlock Odoo ERP system's potential. We have been communicating with end users to whom the software became a main business tool since 2012. As a result, we are proud of dozens of successful Odoo apps developed.

We are open for new ideas and challenges to create the best Odoo tools for business needs all over the world

IT Libertas Russian Federation
6/7/16, 8:41 AM

Have a look at the app: https://apps.odoo.com/apps/modules/9.0/product_stock_balance/ 

0
Jahnelle Azupardo Philippines
1/23/15, 8:49 AM

Team

I am new to Odoo... so if i may..

Its eay to find stock by loaction...

What I want to know is where in the location is the stock.... so imagine I have a bunch of shelving that has me finished goods.. so my warehouse has say WH/Finished Goods... but logically and physically I divide that shelving into racks and in the Location WH/Finished Goods  I have Rack 1... and on my Product under the Inventory tab I say this product should be in Finished Goods but specifically on Rack 1.... 

So when new product comes in I want to tell my storeman.. you will find "like" producrs in Rack 1 so put this stuff there too...

So when I ask him to "Pick" the product.. not only can i tell him to go to the Finished Goods "zone"..but to make it fatser go to Rack 1...

Back to the original question how can i see what's in rack 1

 

Ask a Question
Writer
Keep Informed
6 follower(s)
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