Skip to Content

Contributors

  • Weblate contact
    Hi,
    I tried to contact weblate support in https://translation.odoo-community.org/contact but after I sent the email, it said "Could not send message to administrator.".
    From what I understand of the platform, maybe there is some configuration missing in OCA's weblate installation? Can someone have a look?

    I have looked in https://odoo-community.org/groups but haven't found any mailing list dedicated to platform or translations issues, let me know if I should write somewhere else.


    Thanks,
    Simone Rubino

    by Simone Rubino - 10:36 - 20 Jan 2022
  • Proposing new PSC's
    Dear Odoo Community contributors,

    I would like to propose new PSC members from ForgeFlow and Creu Blanca.

    The names I'm proposing are all very active contributors. You can check their contributions in the table below.

    PSC Team Propose Github handles
    Banking Aaron Henriquez, Enric Tobella, Jordi Ballester aaronhforgeflow, etobella, jordibforgeflow
    HR Alba Riera albariera
    Reporting engine Hector Villarreal, Enric Tobella hviorforgeflow,etobella
    Search Hector Villarreal, Enric Tobella hviorforgeflow,etobella
    Social Enric Tobella etobella
    Web Enric Tobella etobella


    Regards,
    --
    Jordi Ballester Alomar 
    CEO & Founder  
    Spain: (+34) 629 53 07 07 | USA: (+1) 646 980 46 59 | Denmark: (+45) 78 78 21 89


          

    The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.

    by Jordi Ballester Alomar - 10:30 - 20 Jan 2022
  • Vendor Pricelist records for Product Variants - what am I missing?

    Hello,


    as New Year came it fell upon me to update lots of pricelists. As we use Product Variants (product.product) quite a bit I am invalidating (i.e. setting date_end) on existing Supplier Pricelist (product.supplierinfo) records and creating new ones. Using base_import_match to match the correct product variant by internal reference (default_code) and trying to import related product.supplierinfo record. Originally I wanted to create small helper that would invalidate all existing records (no end date, same variant, same template, same supplier, same company) when creating new one. Just to save time updating existing records and creating new ones. However it never works (more on that below).


    Now there are 2 fields defined for product.template and none for product.product that would serve what I am wanting to do. Here's what's defined for product.template (in 13.0, 14.0 and 15.0 as well):

       seller_ids = fields.One2many('product.supplierinfo', 'product_tmpl_id', 'Vendors', depends_context=('company',), help="Define vendor pricelists.")                          
       variant_seller_ids = fields.One2many('product.supplierinfo', 'product_tmpl_id')                                                                                            

    In Purchase there is this for product.template view:

       <field name="seller_ids" context="{'default_product_tmpl_id':context.get('product_tmpl_id',active_id), 'product_template_invisible_variant': True}" nolabel="1" attrs="{'invisible': [('product_variant_count','&gt;',1)]}"/>

       <field name="variant_seller_ids" context="{'default_product_tmpl_id': context.get('product_tmpl_id', active_id)}" nolabel="1" attrs="{'invisible': [('product_variant_count','&lt;=',1)]}"/>


    Just for clarity, here's part from product.supplierinfo:

       product_id = fields.Many2one('product.product', 'Product Variant', check_company=True, help="If not set, the vendor price will apply to all variants of this product.")

       product_tmpl_id = fields.Many2one('product.template', 'Product Template', check_company=True, index=True, ondelete='cascade')


    Am I missing something here or are these the same besides the context and some witchcraft in views? While trying to import the product.product records when creating product.supplierinfo records there's always product_tmpl_id but never product_id. Shouldn't the definition of variant_s be like this and defined in product.product model:

       variant_seller_ids = fields.One2many('product.supplierinfo', 'product_id')                                                                                            

     

    What is the purpose of current design? Would anyone be willing to shed some light here? Hope such post fits in the mailing list.


    Thank you very much.Best regards


        Radovan Skolnik


    by Radovan Skolnik - 08:31 - 20 Jan 2022
  • Cash flow statement report
    Dear Contributors,

    I need to cash flow statement report on CE V.14 like a enterprise version. I try to find on odoo app or oca but still not found. Are there any modules about this ?

    This is report in enterprise version
    Selection_916.png

    Best Regards,
    Tharathip C.

    by tharathipc - 03:51 - 20 Jan 2022
  • New repositories : cooperative and participative supermarket
    Hi all,

    At Coop IT Easy, we’ve been working for 5 years with cooperative and participatory supermarkets (aka Food Coop, ex: BEES coop). We would like to bring most of that code under the OCA umbrella. The code is now divided into two repositories :

    We will need to 
    • remove all references to Obeesdoo and Easy My Coop (debranding) ;
    • split modules by features ; 
    • cover more code with unit tests.
    These solutions have been used in production for several years now and is now used by 11 supermarkets and 25+ cooperatives (plus a few others by other integrators). Everything is in version 12 and we will soon migrate cooperative modules to version 14.

    Based on the OCA repository policy, we would like to propose to create these 3 new repositories :
    1. cooperative with all modules in beta-stage while we debrand them. 
    2. shift-planning (or shift-management ?) with all modules dealing with shifts in beta stage as well.
    3. vertical-cooperative-supermarket as an incubation repository while we move all the features to oca/purchase-workflow, oca/pos, …
    What do you think ? Is there room for these projects at the OCA ?

    You can find more information on these Github Issues RFC Moving Obeesdoo to OCA #247 and RFC Moving Easy My Coop to OCA.

    All inputs welcome,

    Robin Keunen

    Robin Keunen 
    Coop IT Easy 
    robin@coopiteasy.be 
    +32 488 86 57 40

    by Robin Keunen - 11:26 - 14 Jan 2022
  • Happy New Year: 2022 priorities presented!
    Hello Community,

    New year, New board, New Straegy, New Working Groups (we need you!): everything is in this new blog post from the board:

    Don't hesitate to comment on the blog post or by responding to this mailing list if you want to notify all contributors.

    Have a great day and year!
    -- 
    Virginie
    0477/64.17.20

    by Virginie Dewulf. - 09:15 - 13 Jan 2022
  • New repo proposal: repair

    Hi Community,

    The reasons that support this new repo are:

    * Repair module is isolated in Odoo standard. It depends on stock, account, and sale_management. Nothing to do with manufacture nor rma.
    * There are several repair modules in OCA/manufacture and OCA/rma but almost none of them dependens on mrp or rma.
    * The number of modules related to repairs is growing. 4 modules in OCA/manufacture (and 7 new module proposals and more incoming) and 4 new module proposals in the OCA/rma repo

    Now there are no repair modules in 15.0 branches so I think it is a good moment for doing that.

    For the PSC of the repo I guess it makes sense for now if we add the repo under the control of the manufacturing team.

    WDYT?

    Thank you for considering this proposal.

    Have a nice day.

    --
    Aaron Henríquez Quintana
    Technical Consultant
    Twitter: /AaronHForgeFlow  |  Linkedin: /aaron-henriquez-quintana-84299869


          


    by Aarón Henríquez - 02:10 - 12 Jan 2022
  • Sale Workflow v14
    Hi all,

    FYI and thanks to @hailangv, flows have been improved on sale-workflow v14 as now, two modules that were incompatible together are dependent (sale_isolated_quotation depends on sale_quotation_number). Migration scripts have been taken into account and modules updated their major version.

    That will easy future tests flows : 2 travis jobs instead of 6.

    Best wishes for 2022!


    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg

    by Denis Roussel - 03:46 - 10 Jan 2022
  • Odoo v14 - Bank reconciliation flow
    Hello All

    First, we send our best wishes for this new year, with success in your projects.

    We wanted to reach because we are starting to plan migrations to V14. 

    We are not satisfied with the v14 bank reconciliation process, and the systematic use of transit accounts on payments. 

    We started to have an analysis on how we could propose a more direct and simple way of managing payments and bank reconciliation. 

    We wondered if any of you has already started a project of module on which we could contribute, or have any information / feedback to share on this matter. 

    Ideally, we would have an option to offer end users, enabling them to manage payments and bank reconciliation with a transit account, or with a direct flow close to the one of v12, but this is still an analysis in progress. 

    Have a great day. 


    Julien Jézéquel-Bréard - Chargé de projets
    NUMIGI SOLUTIONS INC.


    Longueuil, Québec, Canada

    linkedinyoutubecustom-icontwitter


    by Julien Jézéquel-Bréard - 10:11 - 7 Jan 2022
  • stock: Retroactively removing lots from incompatible products in stock move history
    Hi all,
    
    I'm a little bit new to Odoo, so please bear with me if I don't get
    everything right, but I've been told that I have struck a difficult
    bug.
    
    TL:DR: Having removed the lot_id from certain rows (products that are
    incompatible with that lot) in stock_move_line and stock_quant, how do
    I know I haven't broken something?
    
    
    I have a database that was migrated from Odoo 9 to Odoo 12. Before the
    migration, there was a bug that assigned lots to by-products of a
    dismantling operation (in this case, empty bottles were assigned the
    lots of full bottles of wine).
    
    As a result, during inventory on Odoo 12, the error message from
    StockMoveLine._check_lot_product() shows up, correctly identifying that
    these various lots are incompatible with empty bottles, then aborting
    the validation.
    
    Because these lots were added in error, I want to remove them from all
    past stock moves. This cannot be done through the UI, so I've made
    these SQL statements to get it done:
    
    ```
    update stock_move_line 
    set lot_id = null, lot_name = null
    where product_id in (67, 38, 29) and lot_id is not null;
    
    update stock_quant
    set lot_id = null
    where product_id in (67, 38, 29) and lot_id is not null;
    ```
    
    (the product_ids here are empty bottles)
    
    Having run the above on a test/staging database, I can now do the
    inventory without troubles. I have also verified that the quantities in
    the inventory have correctly added up (the quantities of bottles that
    previously had lots are added to the lot-less bottles). The quantities
    on the `product.product` view have remained the same, which makes sense
    to me. I have also triggered `_compute_quantities()` for
    'product.product', and nothing has changed.
    
    Although everything works and my problems seem to have disappeared, the
    problem is that I do not know whether I have inadvertently corrupted
    the (test!) database. I've been reading the source code of the stock
    module to find interactions with lot_id and lot_name, but I've not
    really found anything troubling.
    
    Does my approach make sense? Is there anything I can do to verify the
    integrity of what I've done?
    
    Many thanks and best regards,
    
    Carmen Bianca Bakker
    Coop IT Easy
    

    by Carmen Bianca Bakker - 10:46 - 7 Jan 2022
  • Odoo Users List

    Hi,

     

    I would like to see if you or your company is interested in acquiring any Odoo Contact List which can help you to grow your business and boost your sales.

     

    We can also help you with Web Design, WordPress, WordPress Development, WordPress Design, Odoo eCommerce, Odoo CRM, and many more.

     

    Let me know your preferred Target Geography____ so that I can get back to you with the counts and pricing.

     

    I look forward to your response!

     

    Regards,

    Caitlyn Drake

    Demand Generation


    by "Caitlyn Drake" <caitlyn.drake@infodatasource.com> - 05:51 - 6 Jan 2022
  • Stock Valuation by LOT
    Dear community,

    Currently, I am looking for perpetual stock valuation with FIFO method, using LOT.

    So far, I found out that, even though we already use LOT on stock move (same product, different price by LOT), Odoo, the stock valuation report do not show by LOT, but new average cost.

    Also, on case Return stock, it also don't use cost by LOT, but the average cost.

    Are there module in OCA helping out?

    Many thanks!

    by Kitti Upariphutthiphong - 11:26 - 30 Dec 2021
  • Apply to community PSC
    Hi all,

    I want to request your approval to be part of the community PSC, which is in charge of OCA infrastructure and stuff like CI, for me and my colleague Joao, as we both intervene in these processes and can contribute with quick reactions over some events like the one happened yesterday.

    Thanks.

    Regards.

    by Pedro M. Baeza - 01:45 - 29 Dec 2021
  • Boolean grouped line label
    Hi there,

    Do you know any module to improve the display of the grouped lines on a boolean field ?

    In the following example I'd like to see "Active: Yes (5)" (or "Active: True (5)" where true can be translated) instead of "true (5)".

    image.png

    If not, I'm thinking of creating a new PR on the web repo which could be named web_boolean_group_label.

    Your comments are appreciated !

    Regards,

    --
    Pierre Verkest
    06 81 12 25 20
    Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest

    by Pierre Verkest - 02:36 - 24 Dec 2021
  • Does OCA's runbot use OCB ?
    Title says all. Can someone answer this question to complete the OCB faq 
    on the wiki ?
    https://github.com/OCA/OCB/wiki/FAQ
    
    
    -- 
    Librement,
    Xavier Brochard (zeroheure) xavier@alternatif.org
    La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre 
    Rosnay)
    

    by xavier - 10:20 - 15 Dec 2021
  • stock_inventory repository
    Hi all,

    As Odoo removed inventory model in v15 and as there are a bunch of modules for inventory in stock-logistics-warehouse repo, I request the creation of stock-inventory repository.


    Thanks

    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg

    by Denis Roussel - 11:11 - 14 Dec 2021
  • Move purchase_request* and purchase_work_acceptance*
    Hi all,

    To reduce purchase-workflow repository size, I would suggest to create two new repositories in order to speed up tests.

    Thanks
    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg

    by Denis Roussel - 09:35 - 14 Dec 2021
  • Decision tree to solve issues

    Hi all,

    I think anyone knows about decision trees, if even as jokes:

    A customer wants something like this, not the visualisation per-se, but to be able to have users click through it whenever they have an issue.

    I can imagine modeling something like this, but doesnt it already exist?

    I guess the Odoo "Survey" modules can do part of it, but i don't know if they support structuring the survey as a tree.

    Any ideas?

    Tom


    by Tom Blauwendraat - 03:16 - 10 Dec 2021
  • How to use oca-ci
    Hi,
    
    
    I just read the README.md of the https://github.com/OCA/oca-ci project,
    
    
    Does anyone have experience using this to develop and test locally?
    
    
    I am probably not that smart, but I miss in the README.md information to
    get started or how tu use this.
    
    
    Kind regards,
    
    
    Ronald
    
    
    

    by Ronald Portier - 08:50 - 9 Dec 2021
  • Tracing and in general how can we execute an handler on every request

    Hello all,

    I have a technical question and I wonder if anyone here already faced this issue.

    I am trying to integrate Odoo into our monitoring stack, with the three pillars of observability metrics/logging/tracing, starting with the tracing. My issue is, it doesn't look like we have an easy way to insert the handler which will start the trace. Also no documentation anywhere about how we can easily integrate tracing into Odoo. This is a v12 version but I believe the issue is still here on more recent versions.

    We are planning to use Azure Monitor, but the issue will be the same with any other tracing platform : I can't figure a way to override a core function to start the trace and insert the python library I need https://docs.microsoft.com/fr-fr/azure/azure-monitor/app/opencensus-python#tracing

    I can of course override some of the most important controllers like https://github.com/odoo/odoo/blob/12.0/addons/web/controllers/main.py#L961:

    -----------

    from odoo.addons.web.controllers.main import DataSet
    class ExtendDataSet(DataSet):
    @route()
    def call_kw(self, model, method, args, kwargs, path=None):
    print("Insert tracer here")
    return super(
    ExtendDataSet, self).call_kw(
    model, method, args, kwargs, path=path)

    -----------

    But this will force me to override all controllers I can find, and some custom controllers will obviously go under the radar.

    I identified some entry point used by all requests like https://github.com/odoo/odoo/blob/12.0/addons/web/controllers/main.py#L961 or https://github.com/odoo/odoo/blob/12.0/odoo/http.py#L316 but I don't think I have a way to override theses functions without having to rely on the terrible idea to patch the core code.

    Anything I missed on how we could execute some code on every request ? On Django you would just use a middleware for such purpose https://docs.djangoproject.com/fr/2.2/topics/http/middleware/ and it does the job perfectly, I feel like this is something which is really missing in Odoo when we have such requirements.

    Thanks,
    Yannick





    by Yannick Buron - 12:20 - 8 Dec 2021