Skip to Content
  • Prepaid Services & Timesheets

    Hi OCA Contributors,

    i was asked, if it is possible to manage prepaid service hours in the following way..

     

    Prepaid service is sold on a montly basis. If the sold or more hours are used, then of course it is quite clear and simple.

    If there are non-used hours, they should be transferred to a customer „hours“-account to reflect the non -used hours. As mentioned… After a period of 6 month, the non-used hours should be dropped from the „hours“-account.

     

    Does somebody tackled this kind of issue already? I would start digging now. If someone was facing a similar issue, it would be great to push me into the right direction…

     

    All the best

    Nils


    Mit freundlichen Grüßen

    Nils Coenen
    --------

    Nils Coenen
    Inhaber
    NICO SOLUTIONS - ENGINEERING & IT
    NICO SOLUTIONS - ENGINEERING & IT
    Dr.-Ruckert-Str. 1G | DE 28865 Lilienthal
    Tel. +49 (0)4298-4667492
    Website | Map | Email
    Confidentiality Note: This email may contain confidential and/or private information. If you received this email in error please delete and notify sender.

    by Nils Coenen - 03:31 - 1 Feb 2024
  • OCA/connector-telephony Mantainers/PSC
    Hello, is there an active maintainer of the OCA/connector-telephony repo? I saw that there are some people trying to migrate modules but no one is active to review/merge them. 

    If there is no active PSC i volunteer as PSC of the repository, since i use these modules in v14.0 and now i need them in v16.0. So I volunteer to be the PSC and bring the repository back to life since it appears to be abandoned.  

    I'm currently PSC of OCA/payroll and the other HR repositories, you can see some of my work there. 

    Hope this week finds you well. 
    Kind regards. 

    by Nicolas Rodriguez Sande - 01:10 - 30 Jan 2024
  • Reducing the size of a database

    Dear contributors,

    Some of our customers have been using their database for more than 6 years. They want to reduce the size of the database, by archiving/aggregating old data (accounting entries, sales lines, stock movements, etc.). It would also be easier to do exports, pivot tables and so on.

    I see different solutions :

    1. Manually aggregate old data, with a specific method  by type of tables (account move lines, stock picking, sale order lines). For instance, aggregate old accounting entries with annual miscellaneous operations. Of course, we should keep a backup of the old data somewhere.

    2. Mass delete all the old and unused records, such as canceled POs, articles created by mistake. I don't see a way to do this quickly.

    Maybe an alternative solution would be a module that sets a "limit date" that acts as an automatic filter when doing exports, pivots, etc.

    Do you know any tool or procedure that would help with this ?

    Best regards,
    -- 
    Victor Champonnois - Coop IT Easy
    Tel : +32 475 81 01 12

    by Victor Champonnois - 03:21 - 23 Jan 2024
  • Workers on odoo.sh

    Hi community,

    I have something that's puzzling me.

    We migrated an Odoo instance from odoo.sh to our server, in multiprocessing mode with workers=8. A thing with multiprocessing mode is that each of these 8 workers has their own cache, so that whenever Odoo is restarted or cache gets otherwise cleared, it takes 8 HTTP calls for all caches to be filled again, so only from the 9th call things can start getting faster. I've always thought that this is a necessary evil in Odoo. Fabien seems to have done some tests with shared cache, but AFAIK these are just tests.

    Now I've checked their previous odoo.sh instance which is configured with 5 workers. Long ago I read "somewhere" (can't find it anymore) that SH workers are not really workers, which intrigued me; at that time I thought they must be threads, or (gunicorn?) WSGI threads, but I didn't pay any more attention to it. But my tests reveal that on their instance, any second RPC call is already quicker, and on shell, I see Odoo is started with workers=0, so in multithreaded mode. I see no sign of gunicorn anywhere.

    In Odoo's documentation however, they explicitly warn against workers=0 because of the GIL:

    https://www.odoo.com/documentation/17.0/administration/install/deploy.html

    What am I looking at here? Did odoo.sh find a magic cure for the GIL, or are they just not following their own advice and preferring the memory frugality and cachiness of workers=0 above possible GIL-induced performance hits ?

    -Tom


    by Tom Blauwendraat - 11:21 - 21 Jan 2024
  • Can we improve our 2024 OCA Membership numbers in the next few days and set a new record?
    Dear OCA Community,

    I apologize for being direct, but I believe we can increase the total number of OCA members in 2024 significantly.

    As of today, only 47 OCA members are listed in the 2024 directory.
    It seems that many 2023 OCA members prefer being served rather than taking the initiative to purchase their memberships online (see my previous email encouraging online membership purchases).

    AND,

    • You don’t need to buy the OCA 2024 membership to ask questions this year.
    • Nor do you need an OCA membership to receive answers from our wonderful community regarding Odoo and the OCA apps.

    BUT,

    If you asked a question in 2023 and received valuable assistance from our community that benefited:

    • your business,
    • the company you work for,
    • or helped your customer,

    Isn’t that reason enough to buy the 2024 OCA Membership?

    Let’s significantly 
    increase our total membership in the next few days and set a new record in total OCA members.


    Have a great day, and don’t forget to purchase the 2024 OCA Membership TODAY – it’s only 50 Euros.

    OCA Membership 2024: https://odoo-community.org/shop/24-msm-2024-oca-member-503809#attr=




    Best regards,

    Michel Stroom

    OCA member 2023 and 2024
    Using Odoo since version 8


    -- 
    Office Everywhere
    e: mstroom@office-everywhere.com






    by Michel Stroom - 02:35 - 21 Jan 2024
  • Procedure for migration of OCA modules

    Hello, I have a question about migrating a database when we want to jump several versions, for example from v14 to v16.

    Odoo allows you to migrate your modules without problem between several versions, but what would be the correct procedure for OCA modules since if I go from v14 to v16 all the v15 migration scripts are not executed. I know that OpenUpgrade exists, but I see that it is to migrate Odoo modules, I don't see anything with OCA modules.

    Is there any procedure for this?

    Thanks


    David Ramia
    Consultor Programador

    david.ramia@processcontrol.es
    93 229 68 10

    www.processcontrol
    .es

    Este mensaje va dirigido exclusivamente a su destinatario, pudiendo contener información confidencial sometida a secreto profesional. No está permitida su comunicación, reproducción o distribución sin la autorización expresa de PROCESS CONTROL S.C.C.L. De conformidad con lo dispuesto en el GDPR, y la LOPDGDD, sus datos personales y el email del interesado, se tratarán bajo la responsabilidad de PROCESS CONTROL S.C.C.L. por un interés legítimo y para el envío de comunicaciones sobre nuestros productos y servicios, y se conservarán mientras ninguna de las partes se oponga a ello. Los datos podrán comunicarse a las empresas del grupo con el mismo fin antes descrito. Le informamos de que puede ejercer los derechos de acceso, rectificación, portabilidad y supresión de sus datos y los de limitación y oposición a su tratamiento dirigiéndose a rgpd@processcontrol.es. Si considera que el tratamiento no se ajusta a la normativa vigente, podrá presentar una reclamación ante la autoridad de control en www.aepd.es.
    This message are addressed exclusively to the recipient and may contain confidential information subject to professional secrecy. It may not be communicated, reproduced or distributed without the express authorisation of PROCESS CONTROL S.C.C.L.. In accordance with the provisions of GDPR and LOPDGDD, your personal data and email addresses collected under the responsibility of PROCESS CONTROL S.C.C.L. for a legitimate interest and for the purpose of sending communications about our products and services and will be retained for as long as none of the parties object. The data may be communicated to companies in the same group for the same purposes as described above. You can exercise your rights of access, rectification, portability and erasure of your data and those of restriction and objection to their processing by mailing
    rgpd@processcontrol.es. If you consider that the processing does not comply with current legislation, you may file a complaint with the Spanish supervisory authority at www.aepd.es.


    by David Ramia - 12:38 - 19 Jan 2024
  • v.17.0 on Weblate
    Hi all.
    A simple question: why I don't find nothing on OCA-Weblate (https://translation.odoo-community.org/accounts/profile/#notifications) if I look for the 17.0 version but actually there are some modules ported as https://github.com/OCA/pos/tree/17.0 ?
    Thanks


    Stefano Consolaro
    www.mymage.it

    by Stefano Consolaro - 10:05 - 19 Jan 2024
  • Filling in product catalogue by vendors (external parties - i.e. portal users)
    Hello,
    
    I am working with a client that works in food supply industry - i.e. they purchase groceries and other food stuff and prepare food on large scale. An example would be hundreds/thousands portions of bolognese sauce made of beef, tomato sauce, ...
    
    Now the company is just starting their operations and are collecting information about possible suppliers and products available. Their idea is something like sending out Rf? (P as proposal maybe) let's say for that tomato sauce where the vendors would provide information such as: description, origin, packaging, price, ...
    
    My experience strongly suggests not allowing external parties to be allowed to create business records such as products in the system but this is the kind of scenario they describe as the desired outcome. I have used a 3rd party module which extends the RfQ functionality to fill in the prices by suppliers (so effectively changing one attribute in purchase.order.line). But in this case the scenario should lead to creation of new product.[template|product] and also product.supplierinfo by the suppliers.
    
    AFAIK Odoo out-of-the-box does not have anything even close to this. Has anyone faced similar requirement? Any recommendations on how to tackle this one?
    
    Any advice is greatly welcome.
    
    Best regards
    
    	Radovan Skolnik
    
    
    

    by Radovan Skolnik - 11:10 - 18 Jan 2024
  • Elimination of multi-company transactions
    Dear community,

    I have been researching, multi-company in Odoo is not great. For consolidation, it seem possible through some appstore module purchase (not OCA, so I am not very confident)

    Elimination of multi company transactions for consolidation purposes is nowhere we could find.

    Anyone have experiences with this?

    Thanks!

    by Kitti Upariphutthiphong - 07:55 - 17 Jan 2024
  • Odoo 12 / Creating Invoice from Sale Order
    Hello all, happy new year

    I'm working on Odoo12 and i try to understand the process of creation an Invoice from a Sale Order. In some of my Sales Orders, i've got some product line (with quantity and price) and also some sections and notes. When i create the invoice the note lines are not created and the section are created only if there is at least on product line after. Why this restrictions? Is there a possibility to workaround? Any OCA module? For those who work on Odoo 13,14,15,16, is this operating mode persist?

    Thanks

    Cedric  DEBARD

    by Cedric DEBARD - 09:27 - 15 Jan 2024
  • MQTT client for Odoo
    Dears,

    Please can one who already experienced to pub/sub on topics of MQTT broker share the approach or the pieces of use?


    Best regards,
    MiroL


    - iPhone -

    by milori2006 - 08:05 - 13 Jan 2024
  • Module to Create Custom Menu / Link to External Apps
    Hi Community,

    I would like to ask whether there is a module that allows us to create a menu to external apps url. For example, we have a superset installed, and we want user to have a menu to click to this superset url from the odoo main menu it self. That module should allow us to add multiple apps/url and build the menu automatically. Its like an external apps menu in Nextcloud if you all familiar.

    I've searched the apps/web to look whether someone already created that before thinking of creating my self. It should be easy to do, I think.

    Thank you.


    Kind regards, 


    Zainuddin

    by fanzalika - 07:21 - 13 Jan 2024
  • define weight for product template
    Hi!
    Using Odoo 15.0, I can define weight within each product variant but not 
    within a product template. I use the variant creation method 
    "dynamically" and want to define the weight once in the product template 
    which should be applies to all future product variants. Is this possible 
    with existing modules or does it require custom code?
    
    Best regards
    Jan
    

    by Jan Suhr - 10:06 - 12 Jan 2024
  • External access token expiration
    Dear community

    With portal module installed, Odoo can send links to documents by e-mail using an access token so that the recipient doesn't need a portal user to see said documents.

    Access to the document is handled through this controller: https://github.com/odoo/odoo/blob/15.0/addons/portal/controllers/mail.py#L206

    Now, it's been multiple time customer are requiring to expire this token one way or another, because in standard Odoo the document stays accessible forever. The only solutions I could come up with without having to change everything are described below (extracted from personal notes):

    That means, to restrict the validity of the token that was sent in the mail, the token set on the record that is accessed needs to change after a "validity period". The issue with this, is if the link for a same record is sent multiple times during a single "validity period", the availability will not be the same. For example, if we want to define that access tokens are recomputed every 30 days, someone receiving an e-mail 5 days after the token was recomputed would be able to access the document for 25 days, and someone receiving an e-mail 25 days after the token was recomputed would be able to access it only for 5 days.

    A slightly better solution without changing everything but probably more tricky to implement properly, would be to add a new Datetime field next_access_token_refresh on portal.mixin (or another mixin to be inherited on selected models in order to control the application by model) and set it XXX days in the future (according to a server parameter) each time we need to set the access token in an email. If we define the availability to 30 days, that means if a mail is sent to access the same document to a first external user today and to a second external user in 15 days, the first external user would be able to access it during a period of 45 days.

    Did anyone here face a similar requirement? How did you handle it?

    Ideally, we would need a single token to be generated per e-mail being sent so that we can define the expiration of said token, but it seems like there's no other solution than to overwrite and redefine everything, what I would prefer to avoid to ease maintenance of such a module.

    Thanks for sharing your insights.

    camptocamp
    INNOVATIVE SOLUTIONS
    BY OPEN SOURCE EXPERTS

    Akim Juillerat
    Business solutions
    Software architect
    +41 62 544 03 78

    Camptocamp SA
    Leberngasse 21
    4600 Olten
    Switzerland
    +41 21 619 10 10

    by Akim Juillerat - 07:46 - 11 Jan 2024
  • tested website_odoo_debranding: Migration to 17.0
    Hi Odoers,

    Tested the latest changes made by Niels, website_odoo_debranding, and it works, see the link below.


    Can anybody move this version to the GitHub OCA - version 17?


    I have no clue what the policy is and who is allowed to create/move this to version 17.



    Best regards,

    Michel


    by Michel Stroom - 07:11 - 11 Jan 2024
  • OCA 2024 Membership
    Hello OCA Contributors,

    Welcome to 2024!

    I am in the process of sorting out memberships for 2024. Check out our new logo badges!
    If you would like, you can purchase your membership yourself on the website: 
    If you would like a corporate membership with all your company's members on the one invoice please get in touch with me at membership@odoo-community.org and I will sort this out for you.

    We have changed the process up a bit and hope that the new corporate invoicing will be much smoother going forward. 

    I am super excited to share that the membership directory has been fixed as well - once your invoice has been reconciled you should now show on the directory. Big thanks to Benoît Guillot and Graeme Gellatly for all the work on getting this sorted.

    Please be a little patient with reconciliation on the direct bank payments - this takes a little longer for the info to get through than Paypal and Stripe.

    Wishing you all a wonderful start to the year.
    Any questions please just get in touch.
    Rebecca


    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    by Rebecca Gellatly - 03:05 - 11 Jan 2024
  • Document Management System
    Hi

    The Documents app from Odoo seems great in presentations, but I think there is something I am missing...

    Our customer wants to have one workspace for everything related to a customer project, from the time it is created as a lead to the paid invoice, including sales ordes, delivery orders, drawings/other documentation. As you can see some of this is generated outside of Odoo, that must be handled manually, but how can I configure Odoo to create a workspace when a lead is created for example? Seems invoices are supported somehow, but can't find much information on how to use this app.


    Torvald Baade Bringsvor
    Bringsvor Consulting AS - Developer, consultant, allrounder

    Tel (+47) 4548 2848

    by Torvald Bringsvor - 09:55 - 10 Jan 2024
  • EDI Platform
    Hi,

    We are a meat processing industry and we want to implement Odoo 16 Community. 

    We have to meet a need very important for us: EDI. Our actual ERP (A3ERP) has a connection directly to our partner "Seres" that send invoices and receiver orders to our customers. The systems sends and receive this messages via FTP.

    Could anyone help us with this project?

    Thank you very much.

    Saludos,

     
    Nota Legal: Este mensaje y sus anexos se dirigen exclusivamente a su destinatario y pueden contener información privada y confidencial para uso exclusivo de su destinatario. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción, informándole que cualquier divulgación, copia, distribución o uso de los mismos está prohibida en virtud de la legislación vigente.

     Legal Notice: This message and its attachments are exclusively directed to the addressee and may contain private and confidential information for the use of the addressee. If you have received this message by mistake we request that you immediately inform us and delete it. If you are not the intended recipient you are being notified that the coping, disclosing, distribution or use of this information is forbidden by law


    by Sergio Borja - 02:39 - 10 Jan 2024
  • purchase information gone in 15.0?
    Hi!
    In 14.0 and older I could define purchase information for each product 
    and supplier. (Product -> Purchase -> supplier's line entry) In 15.0 
    this screen and information seems to be gone. At least it's not where it 
    used to be. Has this been moved to elsewhere? If its removed from base, 
    is there any module which reintroduces this information?
    
    Best regards
    Jan

    by Jan Suhr - 06:16 - 9 Jan 2024
  • Inquiry on Preferred BI Tools and Connection Methods for Odoo

    Dear OCA Contributors,

    I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.

    As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:

    1. Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any particular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
    2. Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
    3. Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.

    Your feedback and insights will not only assist me in making informed decisions for my current projects but will also benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.

    Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.

    Best regards,

    Rafael Blasco

    Moduon


    by "Rafael Blasco" <rblasco@rbnpro.com> - 04:43 - 9 Jan 2024