Skip to Content
  2. Mailing Lists
  3. Contributors
  4. stock.picking very slow and some are not validating

Archives

Contributors

Proposing "Kitti U." as PSC for Accounting

"Project Use Case" or "Customer References"

stock.picking very slow and some are not validating

Hello Contributors,

We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

The instance is running on AWS with RDS. RDS configuration:
PostgreSQL - 10.10
4 vcpu x 16 GB RAM
100 GB SSD
IOPS: 100 * 3 = 300

How can we validate the stock.pickings? Any idea or thoughts appreciated.

Best Regards,
MD. Tanzilul Hasan Khan
by ponkhi403 - 08:00 - 3 Feb 2020

Follow-Ups

  • RE: stock.picking very slow and some are not validating

    MD

     

    My apologies I spoke too soon. Just had a look at what we do and all we do is

    • On button submit, instead of processing on the users screen we submit a background task that runs every minute and then effectively runs the submit logic

    • We split out invoice create ( we have a module which creates the draft supplier invoice) as a separate task.

     

     

    We have found that when you add lots or serial numbers (which means stock.move.line records) things slow down considerably.

     

    It would be possible to extend our module to handle each stock move line as a separate commit – looking at our largest customer the longest background task has taken 5 minutes

     

    Regards Kevin

     

    From: MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    Sent: Thursday, 13 February 2020 5:48 PM
    To: Contributors <contributors@odoo-community.org>
    Subject: Re: stock.picking very slow and some are not validating

     

    Did you create automated action for move lines?

     

    As we are using track by lots (can be unique or use existing), how are you managing the lot creation or update? Won’t it create 400 backorders if you are validating one by one ?

     

    Thanks




    On Feb 13, 2020 at 1:51 AM, <Kevin McMenamin> wrote:

    We have had similar – we have a client receiving ~400 lines on a PO. There are issues around average cost calculation. Our solution was to make the receipting a background process and receipt line by line – that way if anything happens to a product during the receipt cycle you don’t get a full roll back.

     

    Contact me below if you would like to discuss further.

     

     

    Regards

     

     

    Kevin McMenamin

    ERP Capability Manager, Solnet

     +64 22 651 3753 | +64 9 977 5805 | Visit our blog | Connect on LinkedIn

     

     

     

     

     

     

    From: MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    Sent: Monday, 3 February 2020 8:02 PM
    To: Contributors <contributors@odoo-community.org>
    Subject: stock.picking very slow and some are not validating

     

    Hello Contributors,

     

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

     

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

     

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

     

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

     

    Best Regards,

    MD. Tanzilul Hasan Khan

    Attention: This email may contain information intended for the sole use of the original recipient. Please respect this when sharing or disclosing this email's contents with any third party. If you believe you have received this email in error, please delete it and notify the sender or postmaster@solnetsolutions.co.nz as soon as possible. The content of this email does not necessarily reflect the views of Solnet Solutions Ltd.

    Attention: This email may contain information intended for the sole use of the original recipient. Please respect this when sharing or disclosing this email's contents with any third party. If you believe you have received this email in error, please delete it and notify the sender or postmaster@solnetsolutions.co.nz as soon as possible. The content of this email does not necessarily reflect the views of Solnet Solutions Ltd.
    by Kevin McMenamin - 11:21 - 13 Feb 2020
  • Re: stock.picking very slow and some are not validating
    Did you create automated action for move lines?

    As we are using track by lots (can be unique or use existing), how are you managing the lot creation or update? Won’t it create 400 backorders if you are validating one by one ?

    Thanks


    On Feb 13, 2020 at 1:51 AM, <Kevin McMenamin> wrote:

    We have had similar – we have a client receiving ~400 lines on a PO. There are issues around average cost calculation. Our solution was to make the receipting a background process and receipt line by line – that way if anything happens to a product during the receipt cycle you don’t get a full roll back.

     

    Contact me below if you would like to discuss further.

     

     

    Regards

     

     

    Kevin McMenamin

    ERP Capability Manager, Solnet

     +64 22 651 3753 | +64 9 977 5805 | Visit our blog | Connect on LinkedIn

     

     

     

     

     

     

    From: MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    Sent: Monday, 3 February 2020 8:02 PM
    To: Contributors <contributors@odoo-community.org>
    Subject: stock.picking very slow and some are not validating

     

    Hello Contributors,

     

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

     

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

     

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

     

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

     

    Best Regards,

    MD. Tanzilul Hasan Khan

    Attention: This email may contain information intended for the sole use of the original recipient. Please respect this when sharing or disclosing this email's contents with any third party. If you believe you have received this email in error, please delete it and notify the sender or postmaster@solnetsolutions.co.nz as soon as possible. The content of this email does not necessarily reflect the views of Solnet Solutions Ltd.

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by ponkhi403 - 05:46 - 13 Feb 2020
  • RE: stock.picking very slow and some are not validating

    We have had similar – we have a client receiving ~400 lines on a PO. There are issues around average cost calculation. Our solution was to make the receipting a background process and receipt line by line – that way if anything happens to a product during the receipt cycle you don’t get a full roll back.

     

    Contact me below if you would like to discuss further.

     

     

    Regards

     

     

    Kevin McMenamin

    ERP Capability Manager, Solnet

     +64 22 651 3753 | +64 9 977 5805 | Visit our blog | Connect on LinkedIn

     

     

     

     

     

     

    From: MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    Sent: Monday, 3 February 2020 8:02 PM
    To: Contributors <contributors@odoo-community.org>
    Subject: stock.picking very slow and some are not validating

     

    Hello Contributors,

     

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

     

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

     

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

     

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

     

    Best Regards,

    MD. Tanzilul Hasan Khan

    Attention: This email may contain information intended for the sole use of the original recipient. Please respect this when sharing or disclosing this email's contents with any third party. If you believe you have received this email in error, please delete it and notify the sender or postmaster@solnetsolutions.co.nz as soon as possible. The content of this email does not necessarily reflect the views of Solnet Solutions Ltd.
    by Kevin McMenamin - 08:51 - 12 Feb 2020
  • 回复：回复：stock.picking very slow and some are not validating
    The error didn't appear in single warehouse system as our observation. 



    -------- 原始邮件 --------
    发件人： MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    日期： 2020年2月3日周一 晚上7:12
    收件人： Contributors <contributors@odoo-community.org>
    主 题： Re: 回复：stock.picking very slow and some are not validating
    Yes, we are using multi warehouse and multi location options.  

    Thanks


    On Feb 3, 2020 at 1:32 PM, <‪‪DIT International‬‬> wrote:

    Is multi-warehouse your customer using?
    DC 
    Regards



    -------- 原始邮件 --------
    发件人： MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    日期： 2020年2月3日周一 傍晚6:01
    收件人： Contributors <contributors@odoo-community.org>
    主 题： stock.picking very slow and some are not validating
    Hello Contributors,

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

    Best Regards,
    MD. Tanzilul Hasan Khan

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by DIT INTL - 11:50 - 3 Feb 2020
  • 回复：回复：stock.picking very slow and some are not validating
    We got one similar case before. and we upgraded the Inventory module to fix it. 


    -------- 原始邮件 --------
    发件人： MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    日期： 2020年2月3日周一 晚上7:12
    收件人： Contributors <contributors@odoo-community.org>
    主 题： Re: 回复：stock.picking very slow and some are not validating
    Yes, we are using multi warehouse and multi location options.  

    Thanks


    On Feb 3, 2020 at 1:32 PM, <‪‪DIT International‬‬> wrote:

    Is multi-warehouse your customer using?
    DC 
    Regards



    -------- 原始邮件 --------
    发件人： MD Tanzilul Hasan Khan <ponkhi403@gmail.com>
    日期： 2020年2月3日周一 傍晚6:01
    收件人： Contributors <contributors@odoo-community.org>
    主 题： stock.picking very slow and some are not validating
    Hello Contributors,

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

    Best Regards,
    MD. Tanzilul Hasan Khan

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by DIT INTL - 11:50 - 3 Feb 2020