Skip to Content

Contributors

Consignation for shipping material

Dear community,

I'm searching for a solution to handle "consignation" of products ("consigne" in French). There are 2 aspects we want to handle here:

1. Invoicing
2. Stock t the customer (how many boxes left at each customers facility)

The use case is: To deliver the customer we use X shipping boxes like those https://embalogik.com/produit/fruits-legumes-50-x-30-b/. For every customer, we want to keep the count of how many boxes he received and invoice/refund him when I deliver and take them back...
The behavior is similar to the one with consignation on bottles. We discussed it internally at Camptocamp and have 3 ideas:

1. Cheap solution: an integer field on res.partner to contain the quantity -> 100% manual, not very handy
2. delivery_package_fee that we developed and adds a fee on the SO using a service product -> we cover the invoicing, stock and refunds have to be handled manually
3, A new module that would handle, stock, invoicing and refunds -> seems to be really complicated for the benefit

What are your thoughts? Thank you very much!

Didier

--
camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS

Didier Donzé
Chef de projet

+41 21 619 10 10 (central)
+41 21 619 10 45 (direct)

Camptocamp SA
Quartier de l'Innovation EPFL, PSE-A
1015 Lausanne
Suisse


by Didier Donzé - 09:00 - 7 Dec 2021

Follow-Ups

  • Re: Consignation for shipping material

    Dear Didier,

    As far as I understand, keeping the same behavior as delivery_package_fee but allowing to select a storable product instead of service might do the trick no ?

    • Validating your sale order would then generate a delivery order with the shipping box
    • When you get the shipping box back, you could make a return of these products from delivery order and refund the returned quantity

    Best Regards,

    Le Filament
    Rémi CAZENAVE
    ------
    SCOP LE FILAMENT
    06.87.23.26.04
    remi@le-filament.com
    Le 07/12/2021 à 09:02, Didier Donzé a écrit :
    Dear community,

    I'm searching for a solution to handle "consignation" of products ("consigne" in French). There are 2 aspects we want to handle here:

    1. Invoicing
    2. Stock t the customer (how many boxes left at each customers facility)

    The use case is: To deliver the customer we use X shipping boxes like those https://embalogik.com/produit/fruits-legumes-50-x-30-b/. For every customer, we want to keep the count of how many boxes he received and invoice/refund him when I deliver and take them back...
    The behavior is similar to the one with consignation on bottles. We discussed it internally at Camptocamp and have 3 ideas:

    1. Cheap solution: an integer field on res.partner to contain the quantity -> 100% manual, not very handy
    2. delivery_package_fee that we developed and adds a fee on the SO using a service product -> we cover the invoicing, stock and refunds have to be handled manually
    3, A new module that would handle, stock, invoicing and refunds -> seems to be really complicated for the benefit

    What are your thoughts? Thank you very much!

    Didier

    --
    camptocamp
    INNOVATIVE SOLUTIONS
    BY OPEN SOURCE EXPERTS

    Didier Donzé
    Chef de projet

    +41 21 619 10 10 (central)
    +41 21 619 10 45 (direct)

    Camptocamp SA
    Quartier de l'Innovation EPFL, PSE-A
    1015 Lausanne
    Suisse

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


    by Rémi Cazenave - 10:31 - 7 Dec 2021
  • Re: Consignation for shipping material
    A suggestion:
    - We've done for a project a module that allows to create invoice from a delivery order, while maintaining the compatibility with odoo sales-invoices control.

    So:
    I would suggest to do the above + mimicking the sale deposit process:
    - When creating an invoice from delivery order
          - manually add the number of boxes (e.g. with a wizard)
          - add a sale order line for the number of boxes - order qty =0, delivered qty = as in the stock.picking
         - create the sales invoice

    When the boxes are returned:
    - return the boxes from the DO
    - create a new sales invoice, which will automatically create a credit note
         
    Cheers,
    Dominique


    On Tue, 7 Dec 2021 at 16:02, Didier Donzé <didier.donze@camptocamp.com> wrote:
    Dear community,

    I'm searching for a solution to handle "consignation" of products ("consigne" in French). There are 2 aspects we want to handle here:

    1. Invoicing
    2. Stock t the customer (how many boxes left at each customers facility)

    The use case is: To deliver the customer we use X shipping boxes like those https://embalogik.com/produit/fruits-legumes-50-x-30-b/. For every customer, we want to keep the count of how many boxes he received and invoice/refund him when I deliver and take them back...
    The behavior is similar to the one with consignation on bottles. We discussed it internally at Camptocamp and have 3 ideas:

    1. Cheap solution: an integer field on res.partner to contain the quantity -> 100% manual, not very handy
    2. delivery_package_fee that we developed and adds a fee on the SO using a service product -> we cover the invoicing, stock and refunds have to be handled manually
    3, A new module that would handle, stock, invoicing and refunds -> seems to be really complicated for the benefit

    What are your thoughts? Thank you very much!

    Didier

    --
    camptocamp
    INNOVATIVE SOLUTIONS
    BY OPEN SOURCE EXPERTS

    Didier Donzé
    Chef de projet

    +41 21 619 10 10 (central)
    +41 21 619 10 45 (direct)

    Camptocamp SA
    Quartier de l'Innovation EPFL, PSE-A
    1015 Lausanne
    Suisse

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


    by dominique.k - 10:15 - 7 Dec 2021