Question: Stock count problems

Stock count problems

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,

FR

Felipe Ramos

Asked

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!

  • FR

    Felipe Ramos

    Answered

    Hello! Is there anything about this? Looking forward to your comments thank you!

  • MS

    Mian Saleem

    Answered

    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

  • FR

    Felipe Ramos

    Answered

    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!

  • MS

    Mian Saleem

    Answered

    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

  • FR

    Felipe Ramos

    Answered

    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!

  • MS

    Mian Saleem

    Answered

    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

  • FR

    Felipe Ramos

    Answered

    Thanks! we could try that, please send the information on how to accomplish that? and to completelly get rid of that warehouse, regards!

  • MS

    Mian Saleem

    Answered

    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 warehouses

    DELETE 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

  • FR

    Felipe Ramos

    Answered

    Hello! are there any news on this issue? still havng the stock count problem, looking forward to your comments regards!

  • FR

    Felipe Ramos

    Answered

    Hello! Was any solution find to this issue? on how to display correctly the stock count? regards!

  • Login to Reply