Ir al contenido
Menú
Se marcó esta pregunta
6 Respuestas
2439 Vistas

Odoo 16 Enterprise on odoo.sh

Some products show On Hand and Forecasted quantities of 352, but no quantity Free To Use. This product's initial inventory was imported in Inventory Adjustments and there have been no POs or deliveries for it. What could cause this?

Avatar
Descartar
Mejor respuesta

This was most likely from the import. You may want to check the reserved_qty in stock_quant table. I've noticed that if I have a product already reserved and then do a manual on hand qty adjustment the free to use qty is always off until those reserved stock pickings get closed and the reserve_qty in stock_quant gets reset to 0.  I found the only way to fix it in this situation is to unreserve  all the reserved qty for that product using the forecasted repot and then I do a SQL query in pgAdmin to fix the real reserved qty 0. 

SELECT id, product_id, quantity, reserved_quantity

FROM public.stock_quant

Where product_id = 421582;


Replace 421582 with your product id #

Avatar
Descartar
Mejor respuesta

Were you able to solve this problem. If so, please share the solution. 

Avatar
Descartar
Mejor respuesta

Make sure to review the forecast report's data as they may offer some insight into which operation is potentially holding the quantity.


Avatar
Descartar
Autor Mejor respuesta

No multi-company, stock for this item was only entered once (initial inventory) in one location, no stock is reserved.

Avatar
Descartar

Hi Bruce,

How did you sell if you have no deliveries for the product? I can see on one of your screenshots, that you have sold 50 Each. Additionally I can see that there are 17 outgoing stock pickings for the product as well.

Thanks.

Mejor respuesta

Do check the details on the forecast report, this could provide some insights on which operation might be reserving the qty.


Avatar
Descartar
Autor

See these screenshots for one of many products having this problem.

https://tinyurl.com/ysgwvvsr
https://tinyurl.com/ylou7geh
https://tinyurl.com/yvonmkoh

Issue does seem to be from the initial import of inventory. To validate I would test by taking 1 product and then manually update the qty in inventory adjust and then try to create a SO for that product.

If the manual adjust fixes the issue, then I would try to use the inventory Adjust to select all products and then action > set to quantity on hand and then 'Apply All'

Though this does not identify the cause of the issue, hopefully it would help resolve it.

Mejor respuesta

There could be several reasons for not seeing a product available for sale in Odoo:


Multi-Company: If your organization has multiple business entities (companies) set up in Odoo, you might have stock in one company, but you're trying to place an order in another. Make sure you're selecting the right company when creating your sales order.


Multi-Warehouse/Locations: In a single business entity, you might have stock in different warehouse locations. Ensure that you've selected the correct warehouse when creating your sales order.


Reserved Stock: Check the forecast view of the product to see if any stock is reserved for sales or manufacturing orders. This can affect the availability of the product for new orders.

Thanks.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
abr 24
1792
1
sept 24
2770
3
nov 23
1315
1
sept 23
2317
2
sept 23
1316