There is really a big issue with this system regarding the stock quantity. Even Synchronizing does not solve the issue. I already have mentioned this issue before, but there is still no fix till now!!! Look I have purchased 53 pieces, and sold 49. I have also made transfers (2 in and 2 out, so it can be considered as 0) The balance should be 4, but it is showing 1.
Please fix this issue, normally it occurs when a transfer is created. What I have figured till now that the quantity_balance in the purchase_items table is the main source of this issue. What is the need of this column, I don’t understand. You can calculate the balance on the go by just this formula (purchases + transfers in) - (sales + transfers out). I suggest to please show available quantity using this formula, else it is creating a number of issues.
I am attaching the screenshots if you like to debug, but I know there will be no fix from your side.
- MSAnswered
Hello,
There is no test suit, we check manually for each reported issue. I have tested as you mentioned.
- Added test products
- Added purchase of 53
- Added sale for 49
- Transfer product quantity 2 to other warehouse and then transfer back
- The quantity is 4
The issue that is reported with steps to reproduce will be fixed much faster then the issue which can’t be replicated.
I have seen your screenshot but the results are different. I might tested it wrong, in that case please let me know how to reproduce the issue.
Thank you
- MAAnswered
We are unable to figure out what exactly is triggering the issue. Can you please give us a query which we can run in phpmyadmin, and it adjusts the stock quantity? Because there are many products with the wrong available quantity… Or if you can add something in the sync to adjust the quantity…
- MAAnswered
Hi. Please kindly check this issue on priority. Thanks
- MSAnswered
Hello,
Yes, we are checking. Didn’t find the cause but will continue on Tuesday. Meanwhile if you find anything helpful, please share with us.
Thank you
- MAAnswered
Sure, will do
- Login to Reply