I don't know if I'm just not getting this, maybe, so bear with me.
Our website is integrated with Odoo we have two option, either to link inventory with On hand or Forecasted stock. The problem is that both options can lead to us selling stock we don't have.
Case scenario 1:
Website is linked to On Hand stock and stock of product A is 5.
Order comes in for 1 unit of Product A, SO and invoice is confirmed and payment is received. The website reduces the stock to 4. However, On hand stock in Odoo is not reduced and still 5. So we already have a mismatch, but at the moment it doesn't matter, because the website stock is correct.
After the order has come in, but not yet shipped, the warehouse receives stock from a supplier (let's say 5 units of product A), counts the stock and validates the received items in Odoo. So now On hand stock is 10 in Odoo. Because we don't update the stock on the website manually as we have +1200 SKUs on 5 different websites, when the stock is set to received in Odoo, stock is automatically updated on the website. So now stock on the website is updated to 10, even though we actually only have 9, as the other one is sold and paid for.
A new order comes in of the 10 remaining units of product A before the first order is shipped, and congrats, you now sold a product you don't have in stock.
Case scenario 2:
Website is linked to Forecasted stock and stock of product A is 5.
Order comes in for 1 unit of Product A, SO and invoice is confirmed and payment is received. The website reduces the stock to 4. Forecasted stock in Odoo is reduced 4. So no mismatch, yayy. The order is shipped and everybody is happy.
Product A is running low, so the warehouse makes a PO of 10 units and gets it confirmed from the supplier. Forecasted stock is now 14, and On hand is 4. Stock isn't updated on the website as it's not received.
Every night we have a cronjob syncing all stock levels to insure there's no mistakes. So now stock on the website is updated to 14, even though we actually only have 4 and won't receive the remaining 10 in three weeks. It won't take long before we are selling stock we don't have..
Is it just me, or isn't Odoo missing "Available stock", which is stock on hand minus sold stock (shipped or not)??
