Skip to Content

Contributors

  • Re: New OCA Delegates and Financial Auditors Campaign Open

    Congratulations and good luck to Delegates!
    On Mon, 14 Nov 2022 at 8:17 AM, Rebecca Gellatly <notifications@odoo-community.org> wrote:
    Hello OCA Contributors,

    I hope this finds you all well.

    We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.
    • Dora Jurcevic 

    • Pierre Verkest 

    • Jacques-Etienne Baudoux 

    • Gijs-Jan Otten 

    • Héctor Villarreal Ortega 

    • Emeric Panisset 

    • Quentin Dupont 

    • Jean-Charles Drubay 

    • Danny Adair 

    • Nikolina Todorova 

    We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.

    The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.

    The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.

    We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.

    Have a great week,
    Rebecca

    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

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

    --

    Technology Services @ www.serpentcs.com
    Business Solutions @ www.serpentcs.in
    Enterprise Mobile Apps @ www.odooonline.com 
    Quality Assurance @ www.odooqa.com
    Portal & DMS @ www.alfray.in



    Regards,
    ----------------------------------------------------------------------------------------------------------------------------
    Jay Vora
    Managing Director


     
    Direct: +91-9879354457
    Office: +91-9033472982
    Skype: jaynvora
    Twitter : jaynvora
       
    -------------------------------------------------------------------------------------------------
    Visit our website : http://www.serpentcs.com


    by Jay Vora - 10:51 - 14 Nov 2022
  • New OCA Delegates and Financial Auditors Campaign Open
    Hello OCA Contributors,

    I hope this finds you all well.

    We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.
    • Dora Jurcevic 

    • Pierre Verkest 

    • Jacques-Etienne Baudoux 

    • Gijs-Jan Otten 

    • Héctor Villarreal Ortega 

    • Emeric Panisset 

    • Quentin Dupont 

    • Jean-Charles Drubay 

    • Danny Adair 

    • Nikolina Todorova 

    We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.

    The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.

    The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.

    We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.

    Have a great week,
    Rebecca

    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    by Rebecca Gellatly - 05:11 - 14 Nov 2022
  • Re: PSC Members and Representatives - please complete activities for 2022 OCA AGA
    Very much appreciated Nicolas! Thank you.

    On Wed, 9 Nov 2022 at 14:42, Nicolas Rodriguez <notifications@odoo-community.org> wrote:
    Hello Rebecca, I’m a quite new PSC but I completed the document with information of what I has been doing to payroll modules even before of becoming PSC.

    Hope it helps. Regards. 
    El 8 de nov. de 2022 22:26 -0300, Rebecca Gellatly <notifications@odoo-community.org>, escribió:
    HI all,

    We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.

    Please if you haven't had a chance have a look at the  working document here and fill in what you have been up to over the year.

    I'll close this off next Wednesday the 16th, so you've got a week ;)
    It doesn't need to be a long post, just a quick summary of what has been accomplished.

    Thank you in advance.
    Rebecca

    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    _______________________________________________
    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



    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    by Rebecca Gellatly - 02:56 - 9 Nov 2022
  • Re: PSC Members and Representatives - please complete activities for 2022 OCA AGA
    Hello Rebecca, I’m a quite new PSC but I completed the document with information of what I has been doing to payroll modules even before of becoming PSC.

    Hope it helps. Regards. 
    El 8 de nov. de 2022 22:26 -0300, Rebecca Gellatly <notifications@odoo-community.org>, escribió:
    HI all,

    We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.

    Please if you haven't had a chance have a look at the  working document here and fill in what you have been up to over the year.

    I'll close this off next Wednesday the 16th, so you've got a week ;)
    It doesn't need to be a long post, just a quick summary of what has been accomplished.

    Thank you in advance.
    Rebecca

    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

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


    by Nicolas Rodriguez Sande - 02:41 - 9 Nov 2022
  • PSC Members and Representatives - please complete activities for 2022 OCA AGA
    HI all,

    We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.

    Please if you haven't had a chance have a look at the  working document here and fill in what you have been up to over the year.

    I'll close this off next Wednesday the 16th, so you've got a week ;)
    It doesn't need to be a long post, just a quick summary of what has been accomplished.

    Thank you in advance.
    Rebecca

    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

    by Rebecca Gellatly - 02:26 - 9 Nov 2022
  • Re: Inventory report / valuation loading time
    Hi Francesco,

    For things like this, I use a SQL query, creating a new model, based on a database view.  Here's a query that works for me in v12.

    Matt

    with a as (
        select
            pp.id as product_id,
            pc.id as category_id,
            aa.id as account_id
        from product_product pp
        left join product_template pt on pt.id=pp.product_tmpl_id
        left join product_category as pc on pc.id=pt.categ_id
        left join ir_property as ip on ip.res_id='product.category,'||pt.categ_id and ip.name='property_stock_valuation_account_id'
        left join account_account as aa on 'account.account,'||aa.id=ip.value_reference
        where pt.type='product'
        --and pt.active=true
    )
    select
        pp.default_code,
        pt.name as product_name,
        pc.name as cat_name,
        pt.type as product_type,
        pt.tracking,
        pt.active,
        pt.deprecated,
        uu.name as uom,
        round(mv.avail_qty, 0) as stock_qty,
        av.acct_value,
        round(av.acct_qty, 0),
        av.acct_qty - mv.avail_qty as diff
    from a
    left join (
        select
            a.product_id,
            sum(aml.balance) as acct_value,
            sum(aml.quantity) as acct_qty
        from a
        left join account_move_line as aml on aml.product_id=a.product_id and aml.account_id=a.account_id
        left join account_move as am on am.id=aml.move_id
        where am.state='posted'
        and aml.date<'2022-01-01'
        group by a.product_id
    ) as av on av.product_id=a.product_id
    left join (
        select
            sm.product_id,
            sum(
                case when (ls.usage<>'internal' and ld.usage='internal') then sm.product_qty
                else -sm.product_qty end
            ) as avail_qty
        from stock_move as sm
        left join stock_location as ls on ls.id=sm.location_id
        left join stock_location as ld on ld.id=sm.location_dest_id
        where sm.state='done'
        and sm.date<'2022-01-01'
        and (
            (ls.usage<>'internal' and ld.usage='internal')
            or
            (ld.usage<>'internal' and ls.usage='internal')
        )
        group by sm.product_id
    ) as mv on mv.product_id=av.product_id
    left join product_product as pp on pp.id=a.product_id
    left join product_template as pt on pt.id=pp.product_tmpl_id
    left join product_category as pc on pc.id=a.category_id
    left join uom_uom as uu on uu.id=pt.uom_id
    where pc.name like 'RM - %'
    and av.acct_value<>0
    and coalesce(mv.avail_qty, 0.0)<>0.0



    On Mon, Nov 7, 2022 at 5:12 AM Frederik Kramer <notifications@odoo-community.org> wrote:

    Hi Francesco,

    that is genuinly one to the more ressource hungry processes in Odoo (and of course all ERP systems). It heavily depends on what report you exactly execute, configuration parameters like (use of serial numbers, concrete valuation method, amount of stock locations to consider) and last but certainly not least the overall amount of stock moves in you database (that are a subset of the concrete report under investigation), version of Odoo that you are using and many more.

    As far as i know there is no simple method that helps everywhere (as the problem origins can be vast), but i would recommend to analyze / profile first what actually takes so much time while processing the report in the calculation before taking any measure in whatever direction. Depending on the version of Odoo you are using and the landscape you are running there are different tools to profile. If you tell us the version that you are running, the amount of stock movel lines and stock locations we are speaking about an generally a bit more detail about your case i am sure some more technical people among our community can recommend that to exactly analyze first.

    Best Frederik


    Am 07.11.22 um 12:51 schrieb Francesco Foresti:
    Hi, 

    do you have any solutions/suggestions to speed up inventory reports/valuation loading time?

    Thanks!

    image.png

    --

    Francesco Foresti
    Sicurpharma Srl

    _______________________________________________
    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.
    
    Phone:  +49 4181 13503-12
    Fax:    +49 4181 13503-10
    Mobil:  +49 179 3901819
    
    Email: frederik.kramer@initos.com
    Web:   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
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

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


    by Matt - 08:18 - 7 Nov 2022
  • Re: Inventory report / valuation loading time

    Hi Francesco,

    that is genuinly one to the more ressource hungry processes in Odoo (and of course all ERP systems). It heavily depends on what report you exactly execute, configuration parameters like (use of serial numbers, concrete valuation method, amount of stock locations to consider) and last but certainly not least the overall amount of stock moves in you database (that are a subset of the concrete report under investigation), version of Odoo that you are using and many more.

    As far as i know there is no simple method that helps everywhere (as the problem origins can be vast), but i would recommend to analyze / profile first what actually takes so much time while processing the report in the calculation before taking any measure in whatever direction. Depending on the version of Odoo you are using and the landscape you are running there are different tools to profile. If you tell us the version that you are running, the amount of stock movel lines and stock locations we are speaking about an generally a bit more detail about your case i am sure some more technical people among our community can recommend that to exactly analyze first.

    Best Frederik


    Am 07.11.22 um 12:51 schrieb Francesco Foresti:
    Hi, 

    do you have any solutions/suggestions to speed up inventory reports/valuation loading time?

    Thanks!

    image.png

    --

    Francesco Foresti
    Sicurpharma Srl

    _______________________________________________
    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.
    
    Phone:  +49 4181 13503-12
    Fax:    +49 4181 13503-10
    Mobil:  +49 179 3901819
    
    Email: frederik.kramer@initos.com
    Web:   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
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

    by Frederik Kramer - 01:10 - 7 Nov 2022
  • Inventory report / valuation loading time
    Hi, 

    do you have any solutions/suggestions to speed up inventory reports/valuation loading time?

    Thanks!

    image.png

    --

    Francesco Foresti
    Sicurpharma Srl

    by Francesco Foresti - 12:51 - 7 Nov 2022
  • Re: Reconcile Widget with OWL
    OK, then go ahead with it!

    Regards.

    by Pedro M. Baeza - 12:36 - 6 Nov 2022
  • Re: Reconcile Widget with OWL
    No, reconcile has two parts. One is the reconcile of bank statement lines, that is almost done. The second one is the reconcile of accounts used from invoicing / accounting/actions/reconciliation. I would like to do some big changes of the view, following a similar approach from the bank

    On 6 Nov 2022 09:36, "Pedro M. Baeza" <notifications@odoo-community.org> wrote:
    About reconcile accounts, do you mean to use the suspense account in the journal? If so, I think that should be.

    Regards.

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






    Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
    pueden contener información reservada y/o confidencial, destinada exclusivamente
    para el uso del destinatario o la persona responsable de entregarlo al mismo,
    estando su uso no autorizado prohibido legalmente.
    Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
    salvo ratificación escrita por ambas partes. En caso de su recepción por error,
    rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
    o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
    a su eliminación.

    by Enric Tobella Alomar - 12:15 - 6 Nov 2022
  • Re: Reconcile Widget with OWL
    About reconcile accounts, do you mean to use the suspense account in the journal? If so, I think that should be.

    Regards.

    by Pedro M. Baeza - 09:36 - 6 Nov 2022
  • Re: Reconcile Widget with OWL
    The current behavior allows you to have the same result on your bank and your ERP for the bank account balance. So it is a good idea IMO.
     
    The bank reconcile widget is ready for review. A bug was found regarding the chatter, but I don't know how to fix it in an easy way. 
     
    Next step is the reconcile accounts. I think it would be cleaner to reuse the same functionality (not the old one), as it seems cleaner to me. WDYT?
     
    Enric Tobella Alomar
    Av. J. V. Foix 63
    08034 Barcelona
    Tlf.    932 522 522 (Ext. 9611)
     
     
    From: "Marco Marchiori" <notifications@odoo-community.org>
    To: "Contributors" <contributors@odoo-community.org>
    Date: Thu, 03 Nov 2022 21:36:53 -0000
    Subject: Re: Reconcile Widget with OWL
     
    Maybe an alternative could be to post only the reconciled entries (and not the import or the synchro entries).
    I don't see the point in having temporary posted entries all with the same counterpart.
    Sooner or later I  think odoo will decide to change.
     
    Marco
     
     
     
    Il mer 2 nov 2022, 22:06 Cyril VINH-TUNG <notifications@odoo-community.org> ha scritto:
    Dear all,
     
    Here in PF (country of FR), we disagree with the modification of a posted entry.
     
    We still do like we did in v8.
     
    We had to hack both account_payment and reconciliation_widget in order to :
    - forbid deletion of a validated payment https://github.com/odoo/odoo/pull/96941
    - allow reconciliation of draft entries https://github.com/OCA/account-reconcile/pull/403
     
    We have to force journal setup to disable suspense accounts use. With that setup, the payment entries are validated with an intermediate account. This intermediate account is reconciled with the bank.
     
    As Odoo SA won't change the reconciliation process, I agree with Pedro that the module has to be flexible.
     
    @Alexis De Lattre what do you think ?
     
    Best regards
     
     
     
    Le mer. 2 nov. 2022, 10:27, Pedro M. Baeza <notifications@odoo-community.org> a écrit :
    Although the purist approach would be to generate a new journal entry moving the balance from the suspense account to the definitive account matched on the reconciliation widget, I think we can keep current approach for not generating too much noise, and taking into account that you can't do this in a locked period. Maybe we can introduce a parameter for choosing which one to use...
     
    Regards.
    _______________________________________________
    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




    Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
    pueden contener información reservada y/o confidencial, destinada exclusivamente
    para el uso del destinatario o la persona responsable de entregarlo al mismo,
    estando su uso no autorizado prohibido legalmente.
    Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
    salvo ratificación escrita por ambas partes. En caso de su recepción por error,
    rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
    o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
    a su eliminación.

    by Enric Tobella Alomar - 08:56 - 6 Nov 2022
  • Re: Reconcile Widget with OWL
    Maybe an alternative could be to post only the reconciled entries (and not the import or the synchro entries).
    I don't see the point in having temporary posted entries all with the same counterpart.
    Sooner or later I  think odoo will decide to change.

    Marco



    Il mer 2 nov 2022, 22:06 Cyril VINH-TUNG <notifications@odoo-community.org> ha scritto:
    Dear all,

    Here in PF (country of FR), we disagree with the modification of a posted entry.

    We still do like we did in v8.

    We had to hack both account_payment and reconciliation_widget in order to :
    - forbid deletion of a validated payment https://github.com/odoo/odoo/pull/96941
    - allow reconciliation of draft entries https://github.com/OCA/account-reconcile/pull/403

    We have to force journal setup to disable suspense accounts use. With that setup, the payment entries are validated with an intermediate account. This intermediate account is reconciled with the bank.

    As Odoo SA won't change the reconciliation process, I agree with Pedro that the module has to be flexible.

    @Alexis De Lattre what do you think ?

    Best regards



    Le mer. 2 nov. 2022, 10:27, Pedro M. Baeza <notifications@odoo-community.org> a écrit :
    Although the purist approach would be to generate a new journal entry moving the balance from the suspense account to the definitive account matched on the reconciliation widget, I think we can keep current approach for not generating too much noise, and taking into account that you can't do this in a locked period. Maybe we can introduce a parameter for choosing which one to use...

    Regards.

    _______________________________________________
    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 Marco Marchiori - 10:35 - 3 Nov 2022
  • Re: Reconcile Widget with OWL
    Dear all,

    Here in PF (country of FR), we disagree with the modification of a posted entry.

    We still do like we did in v8.

    We had to hack both account_payment and reconciliation_widget in order to :
    - forbid deletion of a validated payment https://github.com/odoo/odoo/pull/96941
    - allow reconciliation of draft entries https://github.com/OCA/account-reconcile/pull/403

    We have to force journal setup to disable suspense accounts use. With that setup, the payment entries are validated with an intermediate account. This intermediate account is reconciled with the bank.

    As Odoo SA won't change the reconciliation process, I agree with Pedro that the module has to be flexible.

    @Alexis De Lattre what do you think ?

    Best regards



    Le mer. 2 nov. 2022, 10:27, Pedro M. Baeza <notifications@odoo-community.org> a écrit :
    Although the purist approach would be to generate a new journal entry moving the balance from the suspense account to the definitive account matched on the reconciliation widget, I think we can keep current approach for not generating too much noise, and taking into account that you can't do this in a locked period. Maybe we can introduce a parameter for choosing which one to use...

    Regards.

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


    by Cyril VINH-TUNG - 10:05 - 2 Nov 2022
  • Re: Reconcile Widget with OWL
    Although the purist approach would be to generate a new journal entry moving the balance from the suspense account to the definitive account matched on the reconciliation widget, I think we can keep current approach for not generating too much noise, and taking into account that you can't do this in a locked period. Maybe we can introduce a parameter for choosing which one to use...

    Regards.

    by Pedro M. Baeza - 09:25 - 2 Nov 2022
  • Re: Getting in touch
    Hi, Ludovic,

    Please check the website https://odoo-community.org/ and come with any doubt you have after that.

    Regards.

    by Pedro M. Baeza - 01:06 - 2 Nov 2022
  • Getting in touch
    Hi,

    My name is Ludovic Gilardi, I am financial director and I have been using odoo for two years now.

    I discovered your association during the odoo experience 2022.

    Can you give me more information about your association and your activities?

    Best regard.

    Ludovic Gilardi



    by "Chlorobike" <l.gilardi@chlorobike.com> - 11:46 - 2 Nov 2022
  • Re: Help solving a CI issue
    > I need to install the version in this
    
    > repo https://github.com/reingart/pyafipws - branch py3k and also execute
    
    > this commands: 
    
    you can use external_dependencies_override (cf https://pypi.org/project/
    setuptools-odoo/#controlling-setuptools-odoo-behaviour) where you can do 
    something like
    pyafipws@https://github.com/reingart/pyafipws/archive/py3k.zip
    (cf https://pip.pypa.io/en/stable/reference/requirement-specifiers/
    #requirement-specifiers)
    
    
    > Go to installation directory of PyAFIPWS:
    
    > cd /usr/local/lib/python3/dist-packages/pyafipws
    
    > Note: Replace python3 by the python version in the system (like python3.9)
    
    > Create a folder with the name cache:
    
    > sudo mkdir cache
    
    > Change permission of folder:
    
    > sudo chmod -R 777 cache
    
    > * extracted from one of our local wikis
    
    I'd strongly suggest to fix this in the python package itself, this will make 
    stuff better for anyone involved anyways. Having a cache directory there is 
    quite wrong, this should go to /var/cache or ~/.cache (cf https://
    en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard), and you can create this 
    for the global case (local can just create it on first run) during installation 
    by overriding the install command class passing a custom cmdclass (cf https://
    docs.python.org/3/distutils/extending.html#integrating-new-commands) dict.
    
    
    -- 
    Your partner for the hard Odoo problems
    https://hunki-enterprises.com

    by Holger Brunn - 07:30 - 2 Nov 2022
  • Help solving a CI issue
    Hello, I’m the new PSC of l10n-Argentina. We are delayed with uploading the modules to the repository due to a issue that I’m trying to solve.

    If you see this PR (https://github.com/OCA/l10n-argentina/pull/66) you will see that CI is trying to install pyafipws like an external dependency. The problem is that the pipx package is outdated and I need to instal pyafipws from a github repository and follow some specific install guidelines. 

    I need to install the version in this repo https://github.com/reingart/pyafipws - branch py3k and also execute this commands: 

    Go to installation directory of PyAFIPWS:
    cd /usr/local/lib/python3/dist-packages/pyafipws
    Note: Replace python3 by the python version in the system (like python3.9)
    Create a folder with the name cache:
    sudo mkdir cache
    Change permission of folder:
    sudo chmod -R 777 cache
    * extracted from one of our local wikis


    This instructions can be easily followed in a local or production installation but I’m having trouble to replicate this with OCA CI since oca tries to install it with pipx and it will not work because we need an specific version. 

    This library is essential to our Argentinian localization since it’s a wrapper of our country AFIP api, which is widely used across all our localization. So electronic invoice modules can not work without it. 

    So I’m thinking in writing a custom CI workflow with GitHub actions but don’t know if it’s allowed in OCA and also don’t know where to start. 

    I will be dedicating time to this next week so any input or suggestion of how to do that will be great. 
    Any of you had to do something similar in the past? If you can refer me to a repo which also need something similar or point me in the correct direction about this I will be very great 
    full since I want to do it without changing OCA CI configuration too much. 

    Help will be highly appreciated.

    Also, if any of you with repo access can make branch 14.0 the default one in the repository, it will be great, since we are going to start migrating version 14.0 first, adapt the modules and add tests and the migrate to 15 and 16. 

    Sorry for the length of the email. Hope you can provide some input. Thanks and regards. 

    by Nicolas Rodriguez Sande - 01:21 - 2 Nov 2022
  • Re: Call for action - Metrics and KPIs for OCA accounting and finance dashboards
    As mentioned before, different goal will use different indicators.

    For a dashboard analyzing past financial financial performance, a well known set of indicators is the DuPont analysis.
    It is quite interesting because it starts with the ROI or ROE and decomposes it in more focused indicators.

    See: https://en.wikipedia.org/wiki/DuPont_analysis

    --
    DANIEL REIS
    MANAGING DIRECTOR

    M: +351 919 991 307
    E: dreis@OpenSourceIntegrators.com
    A: Avenida da República 3000, Estoril Office B, #34


    by Daniel Reis - 10:00 - 1 Nov 2022