I tried to turncate sma_wharehouses_product table and see if it fix. Because i tried to purchase the beng beng product and the avg_cost still stay at 5250 instead of 1350

Please try to test with new product. Add purchases with different cost and see the avg cost. I have no idea how your product avg went up. If you find the cause or step to replicate that would be very helpful to find the cause and fix. Thank you

I tried with new product its working, the avg cost and cost is same.

What happend to me was, my local computer was broke and i cant access to the computer anymore then i tried to install the SMA to a cloud server. After the installation i import the product using csv and enable the over selling, then making 2 cashiers account with permission only "POS", "SALE". After that i tried selling with my admin account and its working normally till my 2 cashiers start selling and thats where the product cost is messed up.

It was fixed yesterday, what i did was give "PRODUCT COST" permission to the cashier and reset the sma_wharehous_product table.

So you are saying the issue only if the user don't have product cost permission. I will check.

I am glad you have figured a work round.

Yeah, atleast thats what happend to me.

I will check in next update. Thank you