Question: Calculation Problem Purchase-Sale Not Correct

Calculation Problem Purchase-Sale Not Correct

Hello support, I notice that in my system has error. my items was purchased 22pcs and 8pcs sold, but remaining in the system is 15pcs which is not correct, it should be 14pcs. please

PV

Prom Vongchann

Asked

Hello support,

I notice that in my system has error. my items was purchased 22pcs and 8pcs sold, but remaining in the system is 15pcs which is not correct, it should be 14pcs.

please see my attached screenshot.

thanks

  • PV

    Prom Vongchann

    Answered

    in my case I have already updated to version 3.5.0

  • MS

    Mian Saleem

    Answered

    Hello,

    Please view the details of the product from the list products page. Is it showing the same number?

    Thank you

  • PV

    Prom Vongchann

    Answered

    Mian Saleem I have attached the databased file with We transfer for you already.

  • MS

    Mian Saleem

    Answered

    Hello,

    Yes, I will check tomorrow and update you.

    Thank you

  • PV

    Prom Vongchann

    Answered

    Mian Saleem oh Okay.

    I will also have to observe other items too. have you got any suggestion or database SQL command I can run to check if any items miss-calculate like this case? so I can observe easily.

    Thank you

  • MS

    Mian Saleem

    Answered

    Hello,

    I am sorry! I don’t have a query.

    I found that while I was checking the product.

    Thank you

  • PV

    Prom Vongchann

    Answered

    Mian Saleem Oh so i have to check manually one by one and observe. but if you check the product how can you know that the product was not substract from stock during November? why not the recent sale?

  • MS

    Mian Saleem

    Answered

    Hello,

    You can observe using products report as shared image in question.

    I have no idea why the item was not deducted at the time and after that it was deducted.

    Thank you

    Thank you

  • PV

    Prom Vongchann

    Answered

    Mian Saleem oh I see. I am so worry that.

    if that is the way, then I am not sure how many other products have caused the same problem. normally I have cron job to run every beginning of the month so it should have not effected.

    it gives me worry a lot.

  • MS

    Mian Saleem

    Answered

    Hello,

    Stock count should be perform perodically to check to match the physical stock with system stock. You will know the product having different stock with stock count.

    I will try to add the product trail in future version.

    Thank you

  • Login to Reply