Skip to Content

Contributors

Bulk return of serials from multiple partner locations to wh/stock

Hi,

I have a situation where a lot of lots/serials go to a lot of customers/partners and I have partial returns and need to create backorders.

As it is, I have to go to the serial and - based on the traceability - see which outgoing shipment put it in that location, start an Incoming shipment by clicking Return, leave only the serial that I care about and create backorders for the rest.

This workflow is overwhelming for the warehouse staff due to the volume of movements and I am looking for an alternative workflow, ideally:

1) New Incoming Transfer
2) Add the serials that need to come in stock added one per line
3) Have Odoo find the outgoing shipments for these shipments, create a return incoming shipment only for the serials selected (and a backorder for the rest)
4) Process the incoming shipment

This is what I am roughly looking for, I see https://github.com/OCA/stock-logistics-workflow/tree/15.0/stock_return_request which somewhat does what I want but not exactly since it requires me to add a From: location, among other things.

Any ideas/directions will be appreciated

Cheers


--
George Daramouskas
Odoo Development, https://bitwise.solutions

by George Daramouskas - 07:30 - 20 Jul 2023

Follow-Ups

  • Re: Bulk return of serials from multiple partner locations to wh/stock
    Hi, George.

    You might want to complement stock_return_request with its sidekicks sale_stock_return_request and purchase_stock_return_request.

    The defaults are quite straight forward: you select the customer, the products that are going to be returned and then you can choose from all the deliveries which serials you'll be receiving. You can add more filters on top of that (operation type, date limit...). The only thing you need to know in advance is the products the customer is returning. When you pick the proper serials, you'll be able to:

    - Make a single return picking from several delivery picking origins.
    - Refund the linked sale orders at once.

    --
    David Vidal
    Tecnativa

    El jue, 20 jul 2023 a las 7:31, George Daramouskas (<notifications@odoo-community.org>) escribió:
    Hi,

    I have a situation where a lot of lots/serials go to a lot of customers/partners and I have partial returns and need to create backorders.

    As it is, I have to go to the serial and - based on the traceability - see which outgoing shipment put it in that location, start an Incoming shipment by clicking Return, leave only the serial that I care about and create backorders for the rest.

    This workflow is overwhelming for the warehouse staff due to the volume of movements and I am looking for an alternative workflow, ideally:

    1) New Incoming Transfer
    2) Add the serials that need to come in stock added one per line
    3) Have Odoo find the outgoing shipments for these shipments, create a return incoming shipment only for the serials selected (and a backorder for the rest)
    4) Process the incoming shipment

    This is what I am roughly looking for, I see https://github.com/OCA/stock-logistics-workflow/tree/15.0/stock_return_request which somewhat does what I want but not exactly since it requires me to add a From: location, among other things.

    Any ideas/directions will be appreciated

    Cheers


    --
    George Daramouskas
    Odoo Development, https://bitwise.solutions

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


    by David Vidal - 08:16 - 28 Jul 2023
  • Re: Bulk return of serials from multiple partner locations to wh/stock
    If it is possible to find the correct outgoing shipment from a serial. It is possible to create a wizard to read barcodes and and create a stock.return.request allowing them to process it fast. stock_return_request didn't affect the original PO and WHIN (on my tests) and i couldn't be sure if it works as intended. needs to be migrated to 16 too. It might be easier to develop it similar to that module with your flow.

    Levent Karakaş
    Eska Business Solutions
    EGS Business Park B2 Blok Ofis No:1 Yeşilköy - İstanbul
    +90 212 663 34 50


    On Thu, Jul 20, 2023 at 8:31 AM George Daramouskas <notifications@odoo-community.org> wrote:
    Hi,

    I have a situation where a lot of lots/serials go to a lot of customers/partners and I have partial returns and need to create backorders.

    As it is, I have to go to the serial and - based on the traceability - see which outgoing shipment put it in that location, start an Incoming shipment by clicking Return, leave only the serial that I care about and create backorders for the rest.

    This workflow is overwhelming for the warehouse staff due to the volume of movements and I am looking for an alternative workflow, ideally:

    1) New Incoming Transfer
    2) Add the serials that need to come in stock added one per line
    3) Have Odoo find the outgoing shipments for these shipments, create a return incoming shipment only for the serials selected (and a backorder for the rest)
    4) Process the incoming shipment

    This is what I am roughly looking for, I see https://github.com/OCA/stock-logistics-workflow/tree/15.0/stock_return_request which somewhat does what I want but not exactly since it requires me to add a From: location, among other things.

    Any ideas/directions will be appreciated

    Cheers


    --
    George Daramouskas
    Odoo Development, https://bitwise.solutions

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


    by "Levent Karakas" <leventk@eska.biz> - 09:39 - 20 Jul 2023