Hello,

Please always post detailed question.

If you want to sell out of stock item, you can enable overselling in system settings.

If you are saying that product has quantity but you can’t sell then please check the list products page and select the warehouse to see the quantity in the warehouse.

Thank you

Mian Saleem Greeting support,

today I experience similar problem. I have purchased items. and check in stock it has quantities I need but I cannot sale. please see my attached screenshot.

thank you

Prom Vongchann Hello,

There might be disturbancies for real and sybolic quantity. Can you please select the file on list products page and then try to sync quantity. Let me know the result.

Thank you

Mian Saleem I have sync many times, I also tried sync individual products and also sync all products selected but still same

Mian Saleem I sync but still cannot sale

Prom Vongchann It will be very diffucult to find the cause then as there are not trails or movement track for the items. This item is planed to re-write. I am working on Simple POS update then will work on this item. This item grown quite a lot and issue like this still don’t have proper tracking. I will keep this in about these issue while working on v4.

This query check the quantity for the product. Can you run it and check the results

SELECT `id`, `purchase_id`, `transfer_id`, `quantity`, `quantity_balance`
FROM `sma_purchase_items`
WHERE
	`product_id` = '1'
	AND `warehouse_id` = '1'
	AND `quantity_balance` != 0
	AND (`option_id` IS NULL OR `option_id` = 0)
	AND (`status` = 'received' OR `status` = 'partial')
ORDER BY `date` ASC, `purchase_id` ASC;

Thank you

Mian Saleem this is what i got from query after run your sql

Hello,

That query won’t change anything but will get the rows for the item with quantity balance. I shared it so you can test and know how the system gets the quantity balance for the product.

Thank you

Mian Saleem so it means there is no items with error on quantity balance ? but why we cannot sale the stock quantiy? I am strange now

Hello,

I can’t see the result of the query. You just share the screenshot of status. In the query, I have the product with id 1 and warehouse with id 1. You can change these to your product’s and warehouse’s id and run the query to check the quantity balance.

Thank you