Hello!
Im having problems with stock count in SMA for some products if you check purchases and sales, the stock shown does not match what it should, several products have the same problem, in some of them you can see it in real time when a sale is done the stock count doesnt change, im using now the latest version 3.4.37 and still the same issue, i had cleares the quantity adjustments and everything to start from 0 and let only the sales and purchases for the count, still the same issue, it does not match the correct stock, looking forward to your comments regards!
- FRAnswered
Hello! Is there anything about this? Looking forward to your comments thank you!
- MSAnswered
Hello,
I am sorry as I could able to check it again. I tried to check the database base twice but I wasn’t able to find out any cause that might has triggered the wrong quantity. I will try to check it again tomorrow. Did you find any thing or any steps to replicate it?
Thank you
- FRAnswered
Hello! Had found nothing at the moment, just what i told and that the stock qty is not correct, how can i solve this so the correct stock qty is shown? regards!
- MSAnswered
To be honest, I am at dead end 😦 At the moment, you can refer to each warehouse quantity by choosing the warehouse on the list products page. The all warehouse listing page will be updated in future. Thank you
- FRAnswered
Thank you! but to correct the stock for now? how can i correct it for now to reflect the stock as the purchases and sales? maybe delete all warehouses and only maintain one will work too, looking forward to your comments regards!
- MSAnswered
Hello,
We can delete all the entries from the missing warehouse but I am not really sure, if it would cause any other problem (5% changes on for bad effect).
Thank you
- FRAnswered
Thanks! we could try that, please send the information on how to accomplish that? and to completelly get rid of that warehouse, regards!
- MSAnswered
Hello,
I am improving the
Synq Quantity
, you will need to update to latest version (v3.4.41 coming soon) and then delete record no not available warehousesDELETE FROM sma_purchases where warehouse_id = 2; DELETE FROM sma_purchases where warehouse_id = 3; DELETE FROM sma_purchase_items where warehouse_id = 2; DELETE FROM sma_purchase_items where warehouse_id = 3;
Lastly, you need to select the products on list products page and perform
Sync Quantity
.Please do database backup before doing any action as the result of above queries will be permanent.
Thank you
- FRAnswered
Hello! are there any news on this issue? still havng the stock count problem, looking forward to your comments regards!
- FRAnswered
Hello! Was any solution find to this issue? on how to display correctly the stock count? regards!
- Login to Reply