Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
6 ตอบกลับ
2304 มุมมอง

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.

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
1
เม.ย. 24
1694
1
ก.ย. 24
2688
3
พ.ย. 23
1096
1
ก.ย. 23
2220
2
ก.ย. 23
1250