Odoo Help

Welcome!

This community 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.

0

[Solved] Knowing the product Stock Location

By
Fernando La Chica Mera
on 10/28/15, 5:39 AM 810 views

Hello,

I'm starting to use the stock module Odoo. I know as stock movements, as enlisted locations and other settings work . But I have a problem:

How I can list the stock of products on location? I found the report of inventory movements but do not know how to know where the product is located .

Thank you

1

Axel Mendoza

--Axel Mendoza--
10238
| 7 7 8
Camaguey, Cuba
--Axel Mendoza--

DevOps - Full stack - Software Architect - Developer - Technology Integrator

I could help you to develop anything and solve complex problems based on technologies, integrations and tricky stuffs mostly in Python with OpenERP/Odoo, Zato, Django and many others frameworks programming languages and technologies.

I offers consulting services to anyone with an unanswered questions or needs for customizations. Think about it, maybe it's better to have an expert to solve your issues and projects than having a full time employee trying to understand what to do an how

Reach me at aekroft@gmail.com

Axel Mendoza
On 10/28/15, 5:55 AM

You could see that info at the menu /Warehouse/Traceability/Quants

From: https://www.odoo.com/es_ES/forum/how-to/warehouse-management-6/whats-the-difference-between-quants-lots-and-products-55243

The Quants table stores the current state of stock (per location). It is updated each time a stock move is set to done and has 3 main impacts:
A quant optimizes the computation (e.g. quantity available), because a quant only contains information about the current stock (not the past or the future). The volume is smaller and doesn’t grow in time;
A quant will be used in FIFO, LIFO and FEFO costing, as we need to match the incoming and outgoing moves for a correct stock valuation;
A quant can also be used for upstream/downstream traceability and lot management; a quant contains the information about lots. Quant history displays a list of stock moves indicating the current stock level.
1
Fernando La Chica Mera
On 10/28/15, 7:06 AM

First acknowledge the extraordinary speed of your answers .

I tell you, based on the list of movements shown in this image (Click it to show more big)

 the two products that I have should be located in "Ubicaciones de empresas/Envios" yet , although stock values ​​look correct, does not tell you in a clear way the product is in that location. In the next picture I show the report that I am to launch Quants. 

When I go to Locations and ask me to list the Stock is in "Ubicaciones de empresas/Envios" I get empty . It seems like I was missing a step, or I have not configured properly and warehouse locations

Clicking on the Quants report to display the list view, you can see how shows me all the locations for which the product has passed What I really need is a report that tells me what the real product is located. With this report, I do not know where the product is


That's because you open the graph view of the Quants menu, you could see it in the list like this:
http://postimg.org/image/drtldqktx/

Axel Mendoza
on 10/28/15, 7:37 AM

Don't forget to vote the answers

Axel Mendoza
on 10/28/15, 7:39 AM

I update de Answer. With this report, I do not know where the product is. Clicking on the Quants report to display the list view, you can see how shows me all the locations for which the product has passed What I really need is a report that tells me what the real product is located. With this report, I do not know where the product is

Fernando La Chica Mera
on 10/28/15, 8:01 AM

That's not what this doc says: https://www.odoo.com/es_ES/forum/how-to/warehouse-management-6/whats-the-difference-between-quants-lots-and-products-55243

The Quants table stores the current state of stock (per location). It is updated each time a stock move is set to done and has 3 main impacts:
A quant optimizes the computation (e.g. quantity available), because a quant only contains information about the current stock (not the past or the future). The volume is smaller and doesn’t grow in time;
A quant will be used in FIFO, LIFO and FEFO costing, as we need to match the incoming and outgoing moves for a correct stock valuation;
A quant can also be used for upstream/downstream traceability and lot management; a quant contains the information about lots. Quant history displays a list of stock moves indicating the current stock level.

Axel Mendoza
on 10/28/15, 8:56 AM

This solve my problem, How I can vote this answer?

Fernando La Chica Mera
on 10/28/15, 9:16 AM

I update my answer with the info that helps you

Axel Mendoza
on 10/28/15, 9:24 AM
0
IT Libertas
On 3/13/16, 5:45 PM

Besides, have a look at this module https://apps.odoo.com/apps/modules/9.0/product_stock_balance/. Perhaps, it may be useful

0
HappyOdoo
On 10/28/15, 5:51 AM

hi,

goto warehouse > configuration > Location 

you show number of location for warehouse. Open any Location and show Right side two button one is current stock and second is product.

you get list after click on that button which product and how much available in current location. 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 10/28/15, 5:39 AM
Seen: 810 times
Last updated: 3/13/16, 5:45 PM