Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
6 Răspunsuri
3194 Vizualizări

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?

Imagine profil
Abandonează
Cel mai bun răspuns

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 #

Imagine profil
Abandonează
Cel mai bun răspuns

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

Imagine profil
Abandonează
Cel mai bun răspuns

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


Imagine profil
Abandonează
Autor Cel mai bun răspuns

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

Imagine profil
Abandonează

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.

Cel mai bun răspuns

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


Imagine profil
Abandonează
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.

Cel mai bun răspuns

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.

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
1
apr. 24
2596
1
sept. 24
3535
3
nov. 23
1894
1
sept. 23
3076
2
sept. 23
1834