تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
6 الردود
2175 أدوات العرض

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?

الصورة الرمزية
إهمال
أفضل إجابة

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 #

الصورة الرمزية
إهمال
أفضل إجابة

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

الصورة الرمزية
إهمال
أفضل إجابة

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


الصورة الرمزية
إهمال
الكاتب أفضل إجابة

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

الصورة الرمزية
إهمال

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.

أفضل إجابة

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


الصورة الرمزية
إهمال
الكاتب

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.

أفضل إجابة

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.

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
1
أبريل 24
1589
1
سبتمبر 24
2609
3
نوفمبر 23
1008
1
سبتمبر 23
2106
2
سبتمبر 23
1188