Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

  • Volumetric weight for packaging

    Dear contributors,


    do we have a base module (possibly for odoo14) to compute volumetric weight for Delivery Packages ?


    I found this one https://github.com/OCA/product-attribute/tree/13.0/product_dimension_volumetric_weight but it's for product dimension, not for packaging/package dimension.


    All the best

    --

    Francesco Ballerini


    by Francesco Ballerini - 05:40 - 29 Dec 2023
  • MRP: Replenish MO multi-line (stock.move) selection
    Hello OCAers,

    I have a customer who wants to manually select several lines in a manufacturing order (MO) and launch a replenish action on those selected lines.

    Basically he wants to have the same functionality as in the overview but to be able to search filter and select many lines in place of having to click on “replenish” for each line; get the wizard popup to select the location, route and launch the replenshment action

    The default replenishment system in Odoo doesn't allow them to filter the replenishment lines (stock.warehouse.orderpoint)  to only get lines corresponding to that specific MO (unique line per product/location)

    Is there some module in the OCA that can help? Any insight?
    Thank you


     --
    Yves Goldberg
    odoo| Official Partner - OCA delegate
    Open Source ERP, CRM & CMS
    T +972 (3) 720 8818
    M +972 (55) 966 1405
    T +32 (2) 588 2500
    --

    by Yves Goldberg - 01:16 - 29 Dec 2023

    1 attachments 1 attachments

    image.png
  • Module Question Last Updated by Users
    Hi OCA Mailinglist,
     
    this is my first question: Do you know a module where i can search/look the last updates related to a user in all data models ?
     
    Regards,
    Stefan


    Stefan Kranz
    Geschäftsführer
    Kranz GmbH
    Bellevue 1-3
    23968 Gägelow / GERMANY
    Tel: +49 3841 6290-0
    Fax:+49 3841 6290-32
    Diese E-Mail und alle Anhänge enthalten vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail und ihren Inhalt. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
    This e-mail and any attached files may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail by mistake) please notify the sender immediately and delete this e-mail. Any unauthorised duplication, disclosure or distribution of this e-mail and content is strictly forbidden.
    www.med-technik-kranz.de
    HRB Schwerin 1930

    by "Stefan Kranz" <stefank@med-technik-kranz.de> - 08:56 - 29 Dec 2023

    1 replies 1 replies

    • Re: Module Question Last Updated by Users
      It sounds like you're looking for something like https://apps.odoo.com/apps/modules/14.0/auditlog?

      On Fri, Dec 29, 2023 at 2:57 AM Stefan Kranz <notifications@odoo-community.org> wrote:
      Hi OCA Mailinglist,
       
      this is my first question: Do you know a module where i can search/look the last updates related to a user in all data models ?
       
      Regards,
      Stefan


      Stefan Kranz
      Geschäftsführer
      Kranz GmbH
      Bellevue 1-3
      23968 Gägelow / GERMANY
      Tel: +49 3841 6290-0
      Fax:+49 3841 6290-32
      Diese E-Mail und alle Anhänge enthalten vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail und ihren Inhalt. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
      This e-mail and any attached files may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail by mistake) please notify the sender immediately and delete this e-mail. Any unauthorised duplication, disclosure or distribution of this e-mail and content is strictly forbidden.
      www.med-technik-kranz.de
      HRB Schwerin 1930

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

      by "Adam Heinz" <adam.heinz@metricwise.com> - 02:21 - 29 Dec 2023
  • Odoo 12 - Specific report for customer
    Hi all, i'm looking for a way to specify a potential default report template (for Invoice and/or Order) for each of my customer.

    I've got some specific informations to put in the pdf invoice report according to the type of customer. Rather than create a very complex report, i was looking a way to create report to associate to customer. Do you know if is possible to do it? Some OCA module?

    Thanks 

    Happy New Year
    by Cedric DEBARD - 11:30 - 28 Dec 2023

    4 replies 4 replies

  • Test OCA Carriers in sandbox
    Dear contributors,

    I see OCA has implemented several providers in OCA/delivery-carrier/14.0 , is it possible to test some of them in sandbox ?

    Thanks!
    Best regards

    --

    Francesco Ballerini
    by Francesco Ballerini - 04:31 - 22 Dec 2023

    2 replies 2 replies

  • e-CMR Compliance (transport)

    Hello contributors!

     

    For everyone aware about CRM (Convention relative au contrat de transport international de Marchandise par Route)

     

    We plan to develop an OCA set of modules to implement the CMR Convention.

     

    Any one is near of this matter and would like to give an expert opinion?

     

     

    RFC for CMR Management and e-CMR Integration in Odoo ERP (OCA RFC in stock-logistic-transport)

    Introduction

    eCMR, as a digital adaptation of the traditional CMR consignment note, has been legally validated and is an integral part of the international transport of goods. Endorsed by numerous countries and supported by the United Nations, its adoption signifies a pivotal move towards digitalization in the transportation sector. This transition is not only a technological advancement but also aligns with global efforts for sustainable and innovative logistics practices.

    Objective

    Develop and implement a functionality in Odoo ERP to manage transportation processes in compliance with the CMR Convention and to prepare for the mandatory use of e-CMR starting in September 2024.

    General Description

    • Sale as Route: Each sale represents a transport route.
    • Purchases and Carriers: Each purchase linked to a route is a carrier.
    • CMR Management: One CMR document is updated by each carrier.
    • Final Signature and Invoicing: The completed CMR is attached to the invoice for client payment.

    Technical Specifications

    1. Sale Route Module: Links sales to transport routes and purchases.
    2. CMR Management Module: Creates, updates, and tracks the CMR document.
    3. Integration with Purchases: Links purchases to CMR updates.
    4. Completion and Sending of CMR: Finalizes CMR for invoicing.
    5. CMR Claims from Suppliers: Automated CMR request and collection.
    6. Security and Compliance: Ensures legal compliance and data security.
    7. User Interface and Experience: User-friendly design and accessibility.
    8. Reporting and Analysis: Tools for tracking and improving logistics.

    e-CMR Integration

    • Compliance with 2024 Regulation: Adapts to mandatory e-CMR usage.
    • Digital Transformation: Transitions from paper-based to digital CMR.
    • Subsidy Utilization: Leverages financial programs like "Cheque Moderniza".
    • Technical Adaptation: Prepares for technology changes required by e-CMR.
    • Training and Support: Provides training for e-CMR system use.

    Conclusion

    Integrating CMR and e-CMR functionalities in Odoo aligns with regulatory changes and represents a commitment to digital transformation in logistics and transportation management.

     

    Thank you in advance.

     

    Best regards,

     

    Rafael Blasco

    Moduon

     

    by Rafael Blasco (Moduon) - 03:54 - 21 Dec 2023
  • Odoo 12 - DMS Module - Directory

    Hello All


    I've just installed the DMS module on my Odoo12 installation, https://github.com/OCA/dms/tree/12.0,  i can create a stockage but can't create a root directory inside this stockage. 

    ===============================
    The requested operation cannot be completed due to security restrictions. Please contact your system administrator

    (Type de document : Directory, Opération : create) - (Records: [90], User: 2) 
    ===============================

    Any idea

    Thanks
    by Cedric DEBARD - 03:36 - 20 Dec 2023

    2 replies 2 replies

  • "Translating" pictures in website breaks website editor - any workaround? 
    Hello everyone,

sorry for non-development question but this is really so specific I cannot imagine anyone besides experts here would be able to answer.

A client has a website where on few pages there is a picture that needs to be different for different language version (because it contains embedded text in that language). The way we came out to deal with this is adding something like <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/> before the image itself and then in the image itself something like <img t-att-href="image_url"/>

This way the URL value can be translated to other languages. While it works as planned unfortunately it breaks the website editor - some JS error appears and the component palette won't be loaded :-(

I have a stupid feeling I am missing some other obvious option. Any ideas please?

Best regards

	Radovan Skolnik
    by Radovan Skolnik - 07:15 - 19 Dec 2023

    3 replies 3 replies

    • Re: "Translating" pictures in website breaks website editor - any workaround? 
      > Yes! That's exactly that option that made me feel stupid in the back of my

> head...

> Not optimal in my opinion but better than nothing.

under the hood this sets the html lang attribute [1] of the element, that's 
pretty optimal in the html sense of things in my opinion.

I guess you don't want to have users in the editor have to put in all 
translated img's there? Then I'd suggest to have the users follow a naming 
scheme for those images, if en_US is the base language, it's
/images/en_US/${some_name}.png
and in
https://github.com/OCA/OCB/blob/17.0/odoo/addons/base/models/ir_qweb.py#L562
you check the current language, if it's not en_US you go and search for
//img[starts-with(@src, '/images/en_US/')]
and replace that with
/images/${language}/${some_name}.png

Or do the same thing on the client side with JS.
Or generate CSS replacement rules where you hide the en_US image and put the 
$language image there instead.

I assume you've already considered using one SVG and do the text part there 
where you can also set a lang attribute? Not feasible for a lot of things, but 
if you generate those images automatically anyways, that might be the way.

[1] https://developer.mozilla.org/en-US/docs/Web/HTML/Global_attributes/lang


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
      by Holger Brunn - 04:01 - 20 Dec 2023

      1 attachments 1 attachments

      signature.asc
    • Re: "Translating" pictures in website breaks website editor - any workaround? 
      Yes! That's exactly that option that made me feel stupid in the back of my 
head...

Not optimal in my opinion but better than nothing.

Thank you Julien. Best regards

	Radovan

On utorok 19. decembra 2023 19:37:19 CET Julien Guenat wrote:

> Hello,

> 

> In Odoo 16 (and maybe before, didn't test) you have a "Visibility"

> option on website building blocks (image, image-text ...) where you

> can choose to make the block visible only for specific languages.

> 

> If not available in your Odoo version I guess you could use some

> t-if.

> 

> Best regards,

> 

> Julien

> 

> Le 19.12.23 à 19:17, Radovan Skolnik a

> écrit :

> 

> 

> Hello everyone,

> sorry for non-development question but this is really so specific I cannot

> imagine anyone besides experts here would be able to answer. A client has a

> website where on few pages there is a picture that needs to be different

> for different language version (because it contains embedded text in that

> language). The way we came out to deal with this is adding something like

> <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/>

> before the image itself and then in the image itself something like <img

> t-att-href="image_url"/> This way the URL value can be translated to other

> languages. While it works as planned unfortunately it breaks the website

> editor - some JS error appears and the component palette won't be loaded

> :-( I have a stupid feeling I am missing some other obvious option. Any

> ideas please? Best regards

> Radovan Skolnik

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [1]

> Post to: mailto:contributors@odoo-community.org [2]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [3]

> 

> 

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [4]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [5]

> 

> 

> 

> [1] https://odoo-community.org/groups/contributors-15

> [2] mailto:contributors@odoo-community.org

> [3] https://odoo-community.org/groups?unsubscribe

> [4] https://odoo-community.org/groups/contributors-15

> [5] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 07:46 - 19 Dec 2023
    • Re: "Translating" pictures in website breaks website editor - any workaround?
      Hello,

      In Odoo 16 (and maybe before, didn't test) you have a "Visibility" option on website building blocks (image, image-text ...) where you can choose to make the block visible only for specific languages.

      If not available in your Odoo version I guess you could use some t-if.

      Best regards,

      Julien

      Le 19.12.23 à 19:17, Radovan Skolnik a écrit :
      Hello everyone,

sorry for non-development question but this is really so specific I cannot imagine anyone besides experts here would be able to answer.

A client has a website where on few pages there is a picture that needs to be different for different language version (because it contains embedded text in that language). The way we came out to deal with this is adding something like <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/> before the image itself and then in the image itself something like <img t-att-href="image_url"/>

This way the URL value can be translated to other languages. While it works as planned unfortunately it breaks the website editor - some JS error appears and the component palette won't be loaded :-(

I have a stupid feeling I am missing some other obvious option. Any ideas please?

Best regards

	Radovan Skolnik

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


      by julien - 07:36 - 19 Dec 2023
  • Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
    Dear OCA Team,

    We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

    Your assistance in this matter is highly valuable. Thank you in advance for your support.

    Thanks and Regards,
    LogoLogo
    Mitesh Jayswal
    Team Lead - Open Source (Odoo Certified)
    M: +91-7016346545
    P: +91-8140810579 / EXTN: 1001
    E: mitesh.jayswal@brainvire.com
    W: www.brainvire.com
    Facebook icon LinkedIn icon Twitter icon Blog
    Inc MagazineDeloitteSilicon Valley's Fastest Growing CompanyReviewed on clutchGreat Place to Work

    Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.


    by mitesh.jayswal - 02:01 - 18 Dec 2023

    8 replies 8 replies

    • Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
      Hi,

      we are using the ssh tunnel into odoo.sh to download and restore the latest backup located at /backup.daily/*_daily.sql.gz into another Azure Postgres database once a day.
      The restore script also creates a readonly user on the odoo database so PowerBI can connect to this Azure Postgres database.

      Of course the data is always from yesterday, and when you run the database restore from your odoo.sh instance, it should not take longer than 15 minutes because the ssh connection is terminated after a while.
      You also need to ensure that all connections are closed on your target database when restoring the backup.

      Best regards,
      Christopher

      Am Mo., 18. Dez. 2023 um 15:23 Uhr schrieb Frederik Kramer <notifications@odoo-community.org>:

      Mehhh, Paul you are right. I missed the Odoo.SH part in my proposal. Again another good reason not to go for Odoo.SH in the first place

      Best Frederik

      Am 18.12.23 um 15:16 schrieb Paul Catinean:
      Hi Mitesh,

      I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

      1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
      2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
      3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

      These are the only approaches I know of. Would be excited to learn of others if there are any.

      Best,
      Paul

      On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
      Dear OCA Team,

      We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

      Your assistance in this matter is highly valuable. Thank you in advance for your support.
      Thanks and Regards,
      Logo Logo
      Mitesh Jayswal
      Team Lead - Open Source (Odoo Certified)
      M: +91-7016346545
      P: +91-8140810579 / EXTN: 1001
      E: mitesh.jayswal@brainvire.com
      W: www.brainvire.com
      Facebook icon LinkedIn icon Twitter icon Blog
      Inc Magazine Deloitte Silicon Valley's Fastest Growing Company Reviewed on clutch Great Place to Work

      Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

      _______________________________________________
      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

      -- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Tel:   +49 (0) 4181 13503 12
Fax:   +49 (0) 4181 13503 10
Mobil: +49 (0) 179 3901819

Email: frederik.kramer@initos.com
Internet: www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
USt-IdNr.: DE815580155
Steuer-Nr: 15/200/53247

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

      by Christopher Rogos - 03:46 - 18 Dec 2023
    • Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

      Hi Everyone,


      Anyhow the postgresql database is not supposed to be directly used, because it will ignore all information and structure provided by the ORM. So xml-rpc or json-rpc would be the interface to use for connecting to Odoo data. This is also fully supported by odoo.sh/


      Kind regards, Ronald


      On 18-12-2023 15:27, Tom Blauwendraat wrote:

      Hi everyone,

      there's a commercial module from Techneith that can do this also without the SQL connection.

      I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.

      -Tom

      On 12/18/23 15:16, Paul Catinean wrote:
      Hi Mitesh,

      I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

      1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
      2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
      3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

      These are the only approaches I know of. Would be excited to learn of others if there are any.

      Best,
      Paul

      On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
      Dear OCA Team,

      We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

      Your assistance in this matter is highly valuable. Thank you in advance for your support.
      Thanks and Regards,
      Logo Logo
      Mitesh Jayswal
      Team Lead - Open Source (Odoo Certified)
      M: +91-7016346545
      P: +91-8140810579 / EXTN: 1001
      E: mitesh.jayswal@brainvire.com
      W: www.brainvire.com
      Facebook icon LinkedIn icon Twitter icon Blog
      Inc Magazine Deloitte Silicon Valley's Fastest Growing Company Reviewed on clutch Great Place to Work

      Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

      _______________________________________________
      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 "Ronald Portier" <rportier@therp.nl> - 03:46 - 18 Dec 2023
    • Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

      Hi Tom

      That being said "the code ist obfuscated" is already enough not to feed such a modul with credentials to the database. I wouldn't need an argument other than this to avoid using it ;-)

      Best Frederik

      Am 18.12.23 um 15:27 schrieb Tom Blauwendraat:

      Hi everyone,

      there's a commercial module from Techneith that can do this also without the SQL connection.

      I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.

      -Tom

      On 12/18/23 15:16, Paul Catinean wrote:
      Hi Mitesh,

      I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

      1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
      2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
      3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

      These are the only approaches I know of. Would be excited to learn of others if there are any.

      Best,
      Paul

      On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
      Dear OCA Team,

      We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

      Your assistance in this matter is highly valuable. Thank you in advance for your support.
      Thanks and Regards,
      Logo Logo
      Mitesh Jayswal
      Team Lead - Open Source (Odoo Certified)
      M: +91-7016346545
      P: +91-8140810579 / EXTN: 1001
      E: mitesh.jayswal@brainvire.com
      W: www.brainvire.com
      Facebook icon LinkedIn icon Twitter icon Blog
      Inc Magazine Deloitte Silicon Valley's Fastest Growing Company Reviewed on clutch Great Place to Work

      Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

      _______________________________________________
      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

      -- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Tel:   +49 (0) 4181 13503 12
Fax:   +49 (0) 4181 13503 10
Mobil: +49 (0) 179 3901819

Email: frederik.kramer@initos.com
Internet: www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
USt-IdNr.: DE815580155
Steuer-Nr: 15/200/53247
      by Frederik Kramer. - 03:41 - 18 Dec 2023
    • Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

      Hi everyone,

      there's a commercial module from Techneith that can do this also without the SQL connection.

      I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.

      -Tom

      On 12/18/23 15:16, Paul Catinean wrote:
      Hi Mitesh,

      I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

      1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
      2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
      3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

      These are the only approaches I know of. Would be excited to learn of others if there are any.

      Best,
      Paul

      On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
      Dear OCA Team,

      We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

      Your assistance in this matter is highly valuable. Thank you in advance for your support.
      Thanks and Regards,
      Logo Logo
      Mitesh Jayswal
      Team Lead - Open Source (Odoo Certified)
      M: +91-7016346545
      P: +91-8140810579 / EXTN: 1001
      E: mitesh.jayswal@brainvire.com
      W: www.brainvire.com
      Facebook icon LinkedIn icon Twitter icon Blog
      Inc Magazine Deloitte Silicon Valley's Fastest Growing Company Reviewed on clutch Great Place to Work

      Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

      _______________________________________________
      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 Tom Blauwendraat - 03:26 - 18 Dec 2023
    • Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

      Mehhh, Paul you are right. I missed the Odoo.SH part in my proposal. Again another good reason not to go for Odoo.SH in the first place

      Best Frederik

      Am 18.12.23 um 15:16 schrieb Paul Catinean:
      Hi Mitesh,

      I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

      1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
      2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
      3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

      These are the only approaches I know of. Would be excited to learn of others if there are any.

      Best,
      Paul

      On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
      Dear OCA Team,

      We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

      Your assistance in this matter is highly valuable. Thank you in advance for your support.
      Thanks and Regards,
      Logo Logo
      Mitesh Jayswal
      Team Lead - Open Source (Odoo Certified)
      M: +91-7016346545
      P: +91-8140810579 / EXTN: 1001
      E: mitesh.jayswal@brainvire.com
      W: www.brainvire.com
      Facebook icon LinkedIn icon Twitter icon Blog
      Inc Magazine Deloitte Silicon Valley's Fastest Growing Company Reviewed on clutch Great Place to Work

      Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

      _______________________________________________
      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

      -- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Tel:   +49 (0) 4181 13503 12
Fax:   +49 (0) 4181 13503 10
Mobil: +49 (0) 179 3901819

Email: frederik.kramer@initos.com
Internet: www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
USt-IdNr.: DE815580155
Steuer-Nr: 15/200/53247
      by Frederik Kramer. - 03:21 - 18 Dec 2023

  • Receive and deliver in Packages
    Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:

    I receive from my supplier boxes with Parts A, B and C.
    They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
    This works out of the box, with some UX sugarcoat that may become an OCA module.

    Then I want to deliver that box to a customer.
    I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
    I can't get this working, even enabling the "Move packages" option in the Operation Type.

    So my guess is that I'll need a feature to pick a box in a DO.
    But maybe someone knows better.

    Thanks for the feedback.


    --
    DANIEL REIS
    MANAGING PARTNER

    M: +351 919 991 307
    E: dreis@OpenSourceIntegrators.com
    A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

    by Daniel Reis - 02:39 - 15 Dec 2023

    2 replies 2 replies

    • Re: Receive and deliver in Packages
      Thank you Vincent.

      Unfortunately that won't match the needed reception workflow, that is more specific:
      You scan the Kit SKU, the we know explodes into parts, and we then only scan the part SNs without the need to scan their Product barcodes.

      And the warehouse is too simple to use the shopfloor app.
      I'm looking at a Delivery Order form feature.

      I guess I'll have to create something new for this.

      Thanks
      Daniel

      On 15/12/2023 15:33, Vincent Regouby wrote:

      Hello Daniel,

      Did you try https://github.com/OCA/wms/tree/14.0/stock_reception_screen ?

      From the module, you validate the reception, lot number, packaging and put everything in a box with a SSID.

      Then you just scan the SSID to pick the box.

      You can then use shopfloor to manage the box with SSID.

      Regards

      Vincent Regouby
Port Cities
06 49 67 47 16
      Le 15/12/2023 à 14:39, Daniel Reis a écrit :
      Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:

      I receive from my supplier boxes with Parts A, B and C.
      They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
      This works out of the box, with some UX sugarcoat that may become an OCA module.

      Then I want to deliver that box to a customer.
      I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
      I can't get this working, even enabling the "Move packages" option in the Operation Type.

      So my guess is that I'll need a feature to pick a box in a DO.
      But maybe someone knows better.

      Thanks for the feedback.


      --
      DANIEL REIS
      MANAGING PARTNER

      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

      _______________________________________________
      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


      --
      DANIEL REIS
      MANAGING PARTNER

      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

      by Daniel Reis - 09:26 - 15 Dec 2023
    • Re: Receive and deliver in Packages

      Hello Daniel,

      Did you try https://github.com/OCA/wms/tree/14.0/stock_reception_screen ?

      From the module, you validate the reception, lot number, packaging and put everything in a box with a SSID.

      Then you just scan the SSID to pick the box.

      You can then use shopfloor to manage the box with SSID.

      Regards

      Vincent Regouby
Port Cities
06 49 67 47 16
      Le 15/12/2023 à 14:39, Daniel Reis a écrit :
      Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:

      I receive from my supplier boxes with Parts A, B and C.
      They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
      This works out of the box, with some UX sugarcoat that may become an OCA module.

      Then I want to deliver that box to a customer.
      I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
      I can't get this working, even enabling the "Move packages" option in the Operation Type.

      So my guess is that I'll need a feature to pick a box in a DO.
      But maybe someone knows better.

      Thanks for the feedback.


      --
      DANIEL REIS
      MANAGING PARTNER

      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

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

      by v.regouby - 04:31 - 15 Dec 2023
  • AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUE
    Bonjour à tous je viens vers vous solliciter votre aide, aufaite je suis sur odoo online version 16, puis que j'ai pas d'accès au code source j'aimerais automatisé le seuil minimale atteint par un mail envoyé au responsable de stock si c'était possible avec les actions automatisés svp aider moi

    --

    SY Hawa Diallo - (IngéniEure SI)

    InfOrmation SystEms EnginEer


    by hawa1 - 02:01 - 13 Dec 2023

    2 replies 2 replies

  • Sale Order packaging without specify products
    Hello, 

    TLTR 

    I am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.

    More details

    Long time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier. 

    We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order. 
    Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.

    I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.

    But I did not find anything covering this, possibly did I miss it?

    Thanks

    Francesco Ballerini

    Privo di virus.www.avast.com
    by Francesco Ballerini - 12:24 - 11 Dec 2023

    5 replies 5 replies

    • Re: Sale Order packaging without specify products

      Thanks for reporting Daniel, it's always good to know!


      --

      Francesco


      Privo di virus.www.avast.com

      Il giorno ven 22 dic 2023 alle ore 17:02 Daniel Reis <notifications@odoo-community.org> ha scritto:
      Probably they don't address your particular use case, but for information there are a few PRs now trying to solve problems around moving Packages:

      - https://github.com/OCA/stock-logistics-workflow/pull/1422
      - https://github.com/OCA/stock-logistics-workflow/pull/1463

      Thanks
      Daniel

      On 22/12/2023 15:17, Francesco Ballerini wrote:

      I think I found a good solution for this.


      In very short worlds: 


      • Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).


      • When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package


      • extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location


      This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.

      I might be able to propose this as an OCA module in the future, in case someone has similar interests.

      Best regards

      Francesco Ballerini

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


      --
      DANIEL REIS
      MANAGING PARTNER

      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

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

      by Francesco Ballerini - 02:22 - 23 Dec 2023
    • Re: Sale Order packaging without specify products
      Probably they don't address your particular use case, but for information there are a few PRs now trying to solve problems around moving Packages:

      - https://github.com/OCA/stock-logistics-workflow/pull/1422
      - https://github.com/OCA/stock-logistics-workflow/pull/1463

      Thanks
      Daniel

      On 22/12/2023 15:17, Francesco Ballerini wrote:

      I think I found a good solution for this.


      In very short worlds: 


      • Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).


      • When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package


      • extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location


      This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.

      I might be able to propose this as an OCA module in the future, in case someone has similar interests.

      Best regards

      Francesco Ballerini

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


      --
      DANIEL REIS
      MANAGING PARTNER

      M: +351 919 991 307
      E: dreis@OpenSourceIntegrators.com
      A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais

      by Daniel Reis - 05:00 - 22 Dec 2023
    • Re: Sale Order packaging without specify products

      I think I found a good solution for this.


      In very short worlds: 


      • Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).


      • When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package


      • extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location


      This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.


      I might be able to propose this as an OCA module in the future, in case someone has similar interests.


      Best regards


      Francesco Ballerini

      by Francesco Ballerini - 04:16 - 22 Dec 2023
    • Re: Sale Order packaging without specify products
      Update 2

      From what I can understand the management of carrier deliveries with packages is super complex either from a functional and developing point of view as the delivery package definition is a bit clunky by itself.

      I finally understood that you still need to you need to define a "delivery package" associated with carrier, because dimension and weight data cannot be not taken from package directly. They are taken instead from each "delivery package" linked with a picking "package".. but you still have to define both package and delivery package to access packaging data because picking structure will be like 

      picking > multiple packages (stock.quant.packages) > every package has packaging_id (product.packaging) (which is designed to be product specific unless you define it as a "delivery packages", aka a "product.packaging" object without product id 😵‍💫 )

      If this is correct and someone has taken the trouble to read until this point, maybe you could also confirm that it is possible to speed up (a lot) the whole process by generating multiple "packaging" objects from a sale order and automatically recreate the structure

      > picking > packages > delivery packages 

      by automatically generating 

      - 1 package containing all products and 
      - n° fake packages (containing no products, or a dummy product..) 
      -  link every package to one of previously defined delivery packages (this workflow can be activated, for example, by clicking put in pack if a custom option is selected on picking.. to avoid conflicts with normal workflows)

      Of course this is possible only if you manage the whole delivery in a single picking, like we do.
      Seems like it's going to be more challenging than I thought but it seems like it can be done, unfortunately I don't think that we already have designed a workflow for this situation.

      Francesco Ballerini

      Il giorno mar 12 dic 2023 alle ore 20:29 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:
      Update: 

      Forgive me I have mistaken "packaging" and "package" business logic.

      I think that if I want to provide this feature and keep a decent level of scalability/extensibility I need to:

      1 - make possible for backend user to generate n° stock.quant.package objects from a sale order (simply adding a one2many relation with stock.quant.package, in Sale Order)

      2 - use stock_quant_package_dimension to allow setting dimensions and automatic volume calculation from the Sale Order as well

      3 - when the outgoing picking is generated by confirming order (as I previously said we have a really simplified picking process but this part will still probably be a bit tricky in case of picking and/or order cancel)
         3a) all sale order packages will be automatically attached to the outgoing picking by setting them on "picking.package_ids"
         3b) all the products will automatically be put in a single pack, the other packs will be "fake packs" in the sense that they will not store any products but still has dimensions

      This will not provide huge advantages by itself, but definitely better than having separate model to manage "shipping packs" delivery rate and tracking. Tracking will not be really accurate as it doesn't target products, but the rate we need to get is always based on taxable weight, so it should be a decent solution. I'm still not sure if it's worth to manage "package_id" on stock.quant.package, if I am not wrong that's needed in order to print shipping label.

      If you have any kind of suggestions that comes from experience in developing similar workflows (TLDR generating packages from sale order without having to specify the pack content) it will be helpful for sure.

      Thanks,

      Francesco Ballerini


      Privo di virus.www.avast.com

      Il giorno dom 10 dic 2023 alle ore 23:27 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:
      Hello, 

      TLTR 

      I am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.

      More details

      Long time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier. 

      We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order. 
      Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.

      I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.

      But I did not find anything covering this, possibly did I miss it?

      Thanks

      Francesco Ballerini

      Privo di virus.www.avast.com
      by Francesco Ballerini - 12:28 - 13 Dec 2023
    • Re: Sale Order packaging without specify products
      Update: 

      Forgive me I have mistaken "packaging" and "package" business logic.

      I think that if I want to provide this feature and keep a decent level of scalability/extensibility I need to:

      1 - make possible for backend user to generate n° stock.quant.package objects from a sale order (simply adding a one2many relation with stock.quant.package, in Sale Order)

      2 - use stock_quant_package_dimension to allow setting dimensions and automatic volume calculation from the Sale Order as well

      3 - when the outgoing picking is generated by confirming order (as I previously said we have a really simplified picking process but this part will still probably be a bit tricky in case of picking and/or order cancel)
         3a) all sale order packages will be automatically attached to the outgoing picking by setting them on "picking.package_ids"
         3b) all the products will automatically be put in a single pack, the other packs will be "fake packs" in the sense that they will not store any products but still has dimensions

      This will not provide huge advantages by itself, but definitely better than having separate model to manage "shipping packs" delivery rate and tracking. Tracking will not be really accurate as it doesn't target products, but the rate we need to get is always based on taxable weight, so it should be a decent solution. I'm still not sure if it's worth to manage "package_id" on stock.quant.package, if I am not wrong that's needed in order to print shipping label.

      If you have any kind of suggestions that comes from experience in developing similar workflows (TLDR generating packages from sale order without having to specify the pack content) it will be helpful for sure.

      Thanks,

      Francesco Ballerini


      Privo di virus.www.avast.com

      Il giorno dom 10 dic 2023 alle ore 23:27 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:
      Hello, 

      TLTR 

      I am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.

      More details

      Long time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier. 

      We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order. 
      Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.

      I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.

      But I did not find anything covering this, possibly did I miss it?

      Thanks

      Francesco Ballerini

      Privo di virus.www.avast.com
      by Francesco Ballerini - 09:04 - 12 Dec 2023
  • Packaging

    Dear OCA’ers,

    i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.

    I already checked the sale_attach_product of the sales_workflow repo, but this doesnt seem to cover the needs in this case. It adds the same quantity of the parent product.

     

    I also checked the product-pack repo. But the flow seems to be the opposite way. You can select a pack in the sales order, which adds the pack components to the SO.

     

    What i want to achieve… Add a product „Product 1“ to sales order (e.g. quantity of 20).

    Automatic addition of the packaging product „Packaging Product“ to the sales order (quantity = quantity of Product 1 / variable then round up, so in this case e.g. 20/6=3,33 -> 4).

    Ideally this is related only to selected delivery methods or route. So for example: When the delivery is done by the company itself, the packaging product should be apllied to the sales order. If the delivery is performed by a shipping provider, the mechanism should not apply.

     

    I will go ahead checking the stock-logistics-warehouse repo. But if there is something helpful crossing your minds, feel free to share these thoughts…

     

    Cheerio

    Nils

     

    -- 

    NICO SOLUTIONS - ENGINEERING & IT 
    Dr.-Ruckert-Str.     1G 
    28865 Lilienthal 
    Deutschland (Germany) 
    Ust.-Idnr. (VAT-ID): DE341437044 

     

    by Nils Coenen - 06:31 - 8 Dec 2023

    2 replies 2 replies

    • Re: Packaging

      HI Jairo,

      thanks for your reply.

      Unfortunatly this does not cover the needs. When you enter a product to the sales order it only adds the packaging if the quantity of the product divided by the number of products inlcuded is an integer value. For example… a package with 6 is defined.

      In SO if you add 6 or 12 or 18 it adds the packaging. If you add 8 it will not add any packaging. And i want to have the package reusable.

       

      I will do some further testing. But anyway. Thanks for the input!

       

      All the best

      Nils

       

      -- 

      NICO SOLUTIONS - ENGINEERING & IT 
      Inhaber (Owner): Nils Coenen 
      Dr.-Ruckert-Str.       1G 
      28865 Lilienthal 
      Deutschland (Germany) 
      Ust.-Idnr. (VAT-ID): DE341437044 

       

       

      Von: jairo <notifications@odoo-community.org>
      Antworten an: Contributors <contributors@odoo-community.org>
      Datum: Montag, 11. Dezember 2023 um 13:32
      An: Contributors <contributors@odoo-community.org>
      Betreff: Re: Packaging

       

      El vie, 08-12-2023 a las 17:32 +0000, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT escribió:

      i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.

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

      by Nils Coenen - 10:26 - 12 Dec 2023
    • Re: Packaging
      El vie, 08-12-2023 a las 17:32 +0000, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT escribió:

      i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.

      by Jairo Llopis - 01:30 - 11 Dec 2023
  • Suggesting Samuel Macias to various PSC
    Hello OCA Contributors,

    I would like to recommend my colleague Samuel Macias to the following PSC:
    Thank you!

    MAXIME CHAMBREUIL
    DIRECTOR GENERAL LATAM
    Calendario
    T:     +52 (800) 953-2012 #5200
    M: +52 (442) 114-9164 | WhatsApp
    C: MChambreuil@OpenSourceIntegrators.com
    Av. Antea 1032, Piso 4 Local 8, Colonia Jurica
    Santiago de Querétaro, Querétaro, 76100, México

    Analizar. Optimizar. Automatizar. Transicionar.

    by Maxime Chambreuil - 07:51 - 29 Nov 2023

    3 replies 3 replies

  • Porting a module from the OCA whose feature is now in Odoo CE
    Hi community,

    The functionality of module stock_picking_responsible in v12 is now part of Odoo CE in v16 but it still needs a migration script* : what should I do in this case ?

    My intuition is to port stock_picking_responsible to v16 and only leave the migration script in the module. I'm afraid this would clutter the oca repository with empty repositories.

    What do you people think ?

    All the best,

    * more detail :
    responsible_id is a many2one to a res.partner in stock_picking_responsible
    responsible_id is a many2one to a res.users in stock

    Robin Keunen 
    Coop IT Easy 
    robin@coopiteasy.be 
    +32 488 86 57 40
    by Robin Keunen - 07:01 - 21 Nov 2023

    5 replies 5 replies

  • Purchase / Procurement Teams? 
    Hello,

for a future project I am looking for something like Sales Teams (or procurist 
specialization) but for Purchase. The split between teams/people should be 
based on category of the products being purchased. For example in a 
construction company someone purchases base materials, someone else 
insulation, ... Couldn't find anything even remotely similar.

Any help / pointers are welcome.

Best regards,

        Radovan Skolnik
    by Radovan Skolnik - 06:21 - 20 Nov 2023

    3 replies 3 replies

    • Re: Purchase / Procurement Teams?
      The module procurement_purchase_no_grouping has also split by category, so almost there!

      Regards.
      by Pedro M. Baeza - 07:46 - 20 Nov 2023
    • Re: Purchase / Procurement Teams? 
      You/OCA is unbelievable! I wouldn't have been looking under this name but here it is. Does not cover all I need but still a huge step forward.

The missing pieces would be:
*) splitting incoming RfQ into segments (something along the lines of procurement_purchase_no_grouping)
*) assigning these partial RfQs to appropriate Representatives (any idea of something similar?)

But as always: OCA is great source of great modules. I'm proud to be part of it. Thanks Pedro.

Best regards,

	Radovan

On pondelok 20. novembra 2023 18:27:23 CET Pedro M. Baeza wrote:

> We have your back covered ;)

> https://github.com/OCA/purchase-workflow/pull/1921 [1]

> Regards.

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [2]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [3]

> 

> 

> 

> [1] https://github.com/OCA/purchase-workflow/pull/1921

> [2] https://odoo-community.org/groups/contributors-15

> [3] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 07:35 - 20 Nov 2023
    • Re: Purchase / Procurement Teams?
      We have your back covered ;)


      Regards.
      by Pedro M. Baeza - 06:26 - 20 Nov 2023
  • Porting sale_order_type to 17 
    Hi guys
i'm trying to port sale_order_type module to Odoo 17
(i'm not a python developer)

I've done almost everything and now the module install properly (and
seems to work properly too)
But there are two things i don't know how to solve:

1. group_display_incoterm was removed from sale_stock and thus the
actually views used by sale_order_type doens't install properly. I've
removed the reference to ' groups="sale_stock.group_display_incoterm"
' but I don't know if this is correct or has to be replaced with
something else

2. `states` are deprecated in 17. How can I replace these ?
https://github.com/OCA/sale-workflow/blob/16.0/sale_order_type/models/sale.py#L20-L23

Tnx
    by gandalf.corvotempesta - 06:57 - 19 Nov 2023

    2 replies 2 replies

    • Re: Porting sale_order_type to 17 
      Il giorno dom 19 nov 2023 alle ore 23:16 Francesco Ballerini
<notifications@odoo-community.org> ha scritto:

> although in Odoo17 I think this expression has to be changed into something like

>

> <field

>     name="type_id"

>     readonly="state not in ['sale', 'done', 'cancel']"

> />

>

> as a consequence of this commit.

Great idea, thank you
      by gandalf.corvotempesta - 09:06 - 20 Nov 2023
    • Re: Porting sale_order_type to 17
      Hi Gandalf Corvotempesta I appreciate your name : )

      1 - In the context of a porting I think it's correct to simply remove "groups" attribute from fields in order to resolve the missing xml_id, as the group has been completely removed from the source code
      2 - about this case I'm not sure because I don't know if it's possible in odoo17, to avoid the usage of deprecated python argument "states" while keeping the "readonly" condition in python. If you don't find a way to keep this in python, I think there is no problem on defining the "readonly" conditions on XML. Until odoo16 you could have parsed type_id readonly states into XML by adding "attrs" attribute on field like the following code

      <field
          name="type_id"
          attrs="{'readonly': [('state', 'in', ['sale', 'done', 'cancel'])]}"
      />
      although in Odoo17 I think this expression has to be changed into something like
      <field
          name="type_id"
          readonly="state not in ['sale', 'done', 'cancel']"
      />
      as a consequence of this commit.

      Best regards
      --
      Francesco Ballerini

      Il giorno dom 19 nov 2023 alle ore 18:57 Gandalf Corvotempesta <notifications@odoo-community.org> ha scritto:
      Hi guys
i'm trying to port sale_order_type module to Odoo 17
(i'm not a python developer)

I've done almost everything and now the module install properly (and
seems to work properly too)
But there are two things i don't know how to solve:

1. group_display_incoterm was removed from sale_stock and thus the
actually views used by sale_order_type doens't install properly. I've
removed the reference to ' groups="sale_stock.group_display_incoterm"
' but I don't know if this is correct or has to be replaced with
something else

2. `states` are deprecated in 17. How can I replace these ?
https://github.com/OCA/sale-workflow/blob/16.0/sale_order_type/models/sale.py#L20-L23

Tnx

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

      by Francesco Ballerini - 11:16 - 19 Nov 2023
  • runboat update
    Hi everyone,

    I just deployed a runboat update to address the issue of modules that conflict at installation in the same repo.

    When installation fails for any reason, runboat now initializes a database with the base module only. This way, users can select which addons to install.

    This is only an imperfect workaround, though, and in general we should continue to refrain from having modules that conflict at install time in the same repository.

    Best regards,

    -Stéphane

    by Stéphane Bidoul - 05:16 - 19 Nov 2023

    4 replies 4 replies

    • Re: runboat update
      Thank you very much Stéphane!


      El lun., 20 nov. 2023 22:47, Stéphane Bidoul <notifications@odoo-community.org> escribió:
      Hello again,

      By popular demand [1], I tweaked it so each runboat build now has two databases: one with all modules of the repo installed (if that succeeded), and one with only base installed (which should always succeed).

      Enjoy,

      -sbi


      On Sun, Nov 19, 2023 at 4:35 PM Stéphane Bidoul <stephane.bidoul@acsone.eu> wrote:
      Hi everyone,

      I just deployed a runboat update to address the issue of modules that conflict at installation in the same repo.

      When installation fails for any reason, runboat now initializes a database with the base module only. This way, users can select which addons to install.

      This is only an imperfect workaround, though, and in general we should continue to refrain from having modules that conflict at install time in the same repository.

      Best regards,

      -Stéphane

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

      by Rafael Blasco (Moduon) - 10:56 - 20 Nov 2023
    • Re: runboat update
      Hello again,

      By popular demand [1], I tweaked it so each runboat build now has two databases: one with all modules of the repo installed (if that succeeded), and one with only base installed (which should always succeed).

      Enjoy,

      -sbi


      On Sun, Nov 19, 2023 at 4:35 PM Stéphane Bidoul <stephane.bidoul@acsone.eu> wrote:
      Hi everyone,

      I just deployed a runboat update to address the issue of modules that conflict at installation in the same repo.

      When installation fails for any reason, runboat now initializes a database with the base module only. This way, users can select which addons to install.

      This is only an imperfect workaround, though, and in general we should continue to refrain from having modules that conflict at install time in the same repository.

      Best regards,

      -Stéphane

      by Stéphane Bidoul - 10:46 - 20 Nov 2023
    • Re: runboat update
      Really thanks Stephane,

      Bonne journée

      David BEAL
      Consultant ERP Odoo


      Le dim. 19 nov. 2023 à 18:40, Pedro M. Baeza <notifications@odoo-community.org> a écrit :
      Welcome addition, thanks!

      El dom., 19 nov. 2023 17:16, Stéphane Bidoul <notifications@odoo-community.org> escribió:
      Hi everyone,

      I just deployed a runboat update to address the issue of modules that conflict at installation in the same repo.

      When installation fails for any reason, runboat now initializes a database with the base module only. This way, users can select which addons to install.

      This is only an imperfect workaround, though, and in general we should continue to refrain from having modules that conflict at install time in the same repository.

      Best regards,

      -Stéphane

      _______________________________________________
      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 David BEAL - 09:50 - 20 Nov 2023
    • Re: runboat update
      Welcome addition, thanks!

      El dom., 19 nov. 2023 17:16, Stéphane Bidoul <notifications@odoo-community.org> escribió:
      Hi everyone,

      I just deployed a runboat update to address the issue of modules that conflict at installation in the same repo.

      When installation fails for any reason, runboat now initializes a database with the base module only. This way, users can select which addons to install.

      This is only an imperfect workaround, though, and in general we should continue to refrain from having modules that conflict at install time in the same repository.

      Best regards,

      -Stéphane

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

      by Pedro M. Baeza - 06:18 - 19 Nov 2023
  • Operating unit
    Hi 
    I have installed 

    account_operating_unit , operating_unit and product_operating_unit
    The description of the modules says "Product and customer independence of OU." 
    Yes
    I can see the independence of the products: if an OU1 user created a product, an OU2 user will not see it.

    But the same is not happening with the Customers, it seems customers are global over OUs. If an OU1 user created a customer, an OU2 user can see it.
    How to achieve the independence of customers?

    Regards

    by Ahmed - 11:52 - 16 Nov 2023

    1 replies 1 replies

  • New way to create repositories and add maintainers
    Hello Community,

    On the last weeks, Simone and myself have been working on a new tool that can be used to create repositoires and add maintainers. Right now, everything will be managed inside Github: https://github.com/OCA/repo-maintainer-conf/

    So, if you want to add yourself as a PSC, you just need to find the PSC team on https://github.com/OCA/repo-maintainer-conf/tree/master/conf/psc and add your github token with a Pull Request. Once it is merged, you will be added as PSC.

    Also, you can ask for the creation of a new repo and even change the default branch of the repo there. For example: https://github.com/OCA/repo-maintainer-conf/blob/master/conf/repo/account.yml#L1-L18

    This will improve the transparency and clean-up the management of it.

    I hope you all enjoy the changes.

    Kind regards,

    --
    Enric Tobella Alomar
    CEO & Founder

    by Enric Tobella Alomar - 10:57 - 16 Nov 2023

    7 replies 7 replies