Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

Contributors

  • Consuming stock internally while using the its costs in project 
    Hello,

I am dealing with a customer who provides catering services. The price is 
dependent only on how many portions they serve regardless of the costs of 
labour and/or ingredients used.

I am planning to use projects (analytic accounts) to keep track of 
profitability related to Sale Orders that will be invoiced based od delivered 
quantities (of portions). Now I am scratching my head as on how to consume 
storable stock (ingredients) in a way that its value would be added as a cost 
to the project. Internal transfers? Purchase Order within the organization?

The cost of staff should be possible to be dealt with with timesheets. Is that 
so?

Any advice is highly welcome. Thank you

Best regards

	Radovan Skolnik
    by Radovan Skolnik - 08:40 - 7 Feb 2024

    3 replies 3 replies

    • Re: Consuming stock internally while using the its costs in project 
      Graeme & others,

thank you for your input. I went for option 2. and it seems to be working. I have wanted to keep this tied to the project as other inputs affect profitability (timesheets for example) and it is created from sale order. The general scenario is:

1. I use OCA stock_analytic and stock_picking_analytic modules to get analytic distribution into stock.picking and stock.move and stock.move.line
2. I have created a scrap location representing the kitchen where I consume/expense/scrap the ingredients
3. I have an automatic inventory valuation setup (AVCO but I guess would work with any other)
4. I have created a module that includes valuation records for scrap operations into project profitability.

So when I want to expens the ingredients I create an stock picking to the scrap (kitchen) location using the project's analytical tag. The ingredients will get scrapped creating a negative valuation record with analytic distribution from the stock picking. The project module adds account.analytic.lines (the valuation) records with (quite naive but works) domain like this into profitability calculation: 

            ("account_id", "=", self.analytic_account_id.id),
            (
                "move_line_id.move_id.stock_move_id.location_dest_id.usage",
                "=",
                "inventory",
            ),
            ("category", "!=", "manufacturing_order"),

Any comments on this are welcome. I have migrated stock_analytic and stock_picking_analytic to 17.0 and will open PRs soon. If there was an interest into my module I will gladly donate to OCA.

Best regards

	Radovan Skolnik

On streda 7. februára 2024 21:12:41 CET Graeme Gellatly wrote:

> There are a couple of things I can think of.

> 1. Manufacturing Orders - ingredients as raw materials, portions as outputs,

> workorders as labour. Delivery Order for what is delivered, Analytic

> Accounts on sale. Can be done with/without projects. Will add up all your

> costs. 2. Stock locations - this is not quite the same fit, but many times

> I have faced scenarios where stocked goods are required for internal

> projects and the easiest way has been a stock transfer to a location with a

> different account set. Analytics could be added to both manufacturing and

> stock easily enough and I believe OCA has modules to do so. Also for

> linking MO's to projects. If you had a separate product / customer and used

> anglosaxon you would end up with effectively actual cost, unfortunately

> actual cost is an Odoo Enterprise only direct from Odoo feature at the

> moment, but for something this basic it could be done quite simply.

> Otherwise you could use average cost and rely on analytics/other reporting

> for actuals. On Thu, Feb 8, 2024 at 8:41 AM Radovan Skolnik <

> notifications@odoo-community.org [1] > wrote: Hello,

> I am dealing with a customer who provides catering services. The price is

> dependent only on how many portions they serve regardless of the costs of

> labour and/or ingredients used.

> I am planning to use projects (analytic accounts) to keep track of

> profitability related to Sale Orders that will be invoiced based od

> delivered quantities (of portions). Now I am scratching my head as on how

> to consume storable stock (ingredients) in a way that its value would be

> added as a cost to the project. Internal transfers? Purchase Order within

> the organization? The cost of staff should be possible to be dealt with

> with timesheets. Is that so?

> Any advice is highly welcome. Thank you

> Best regards

> Radovan Skolnik

> 

> 

> _______________________________________________

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

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

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

> 

> 

> _______________________________________________

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

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

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

> 

> 

> 

> [1] mailto:notifications@odoo-community.org

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

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

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

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

> [6] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 10:31 - 12 Feb 2024
    • Re: Consuming stock internally while using the its costs in project
      I've done something quite similar, and the report part on project overview was quite a headache!

      In my use cases I Haven't use stock at all, only consumable product that user are able to report from task or in a new list view likes timesheets.

      The branch (for Odoo 14.0) was stalled but this is still in production and working pretty well https://github.com/OCA/project/pull/814

      So based on this work, setting your stockable product as  `project_ok` and generating analytic lines somehow while consuming the product seems a good solution to mee.

      Hope this can help !



      Le mer. 7 févr. 2024 à 21:12, Graeme Gellatly <notifications@odoo-community.org> a écrit :
      There are a couple of things I can think of.

      1. Manufacturing Orders - ingredients as raw materials, portions as outputs, workorders as labour. Delivery Order for what is delivered, Analytic Accounts on sale. Can be done with/without projects. Will add up all your costs.
      2. Stock locations - this is not quite the same fit, but many times I have faced scenarios where stocked goods are required for internal projects and the easiest way has been a stock transfer to a location with a different account set. 

      Analytics could be added to both manufacturing and stock easily enough and I believe OCA has modules to do so. Also for linking MO's to projects. If you had a separate product / customer and used anglosaxon you would end up with effectively actual cost, unfortunately actual cost is an Odoo Enterprise only direct from Odoo feature at the moment, but for something this basic it could be done quite simply. Otherwise you could use average cost and rely on analytics/other reporting for actuals.

      On Thu, Feb 8, 2024 at 8:41 AM Radovan Skolnik <notifications@odoo-community.org> wrote:
      Hello,

I am dealing with a customer who provides catering services. The price is 
dependent only on how many portions they serve regardless of the costs of 
labour and/or ingredients used.

I am planning to use projects (analytic accounts) to keep track of 
profitability related to Sale Orders that will be invoiced based od delivered 
quantities (of portions). Now I am scratching my head as on how to consume 
storable stock (ingredients) in a way that its value would be added as a cost 
to the project. Internal transfers? Purchase Order within the organization?

The cost of staff should be possible to be dealt with with timesheets. Is that 
so?

Any advice is highly welcome. Thank you

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

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



      --
      Pierre
      by Pierre Verkest - 01:31 - 8 Feb 2024
    • Re: Consuming stock internally while using the its costs in project
      There are a couple of things I can think of.

      1. Manufacturing Orders - ingredients as raw materials, portions as outputs, workorders as labour. Delivery Order for what is delivered, Analytic Accounts on sale. Can be done with/without projects. Will add up all your costs.
      2. Stock locations - this is not quite the same fit, but many times I have faced scenarios where stocked goods are required for internal projects and the easiest way has been a stock transfer to a location with a different account set. 

      Analytics could be added to both manufacturing and stock easily enough and I believe OCA has modules to do so. Also for linking MO's to projects. If you had a separate product / customer and used anglosaxon you would end up with effectively actual cost, unfortunately actual cost is an Odoo Enterprise only direct from Odoo feature at the moment, but for something this basic it could be done quite simply. Otherwise you could use average cost and rely on analytics/other reporting for actuals.

      On Thu, Feb 8, 2024 at 8:41 AM Radovan Skolnik <notifications@odoo-community.org> wrote:
      Hello,

I am dealing with a customer who provides catering services. The price is 
dependent only on how many portions they serve regardless of the costs of 
labour and/or ingredients used.

I am planning to use projects (analytic accounts) to keep track of 
profitability related to Sale Orders that will be invoiced based od delivered 
quantities (of portions). Now I am scratching my head as on how to consume 
storable stock (ingredients) in a way that its value would be added as a cost 
to the project. Internal transfers? Purchase Order within the organization?

The cost of staff should be possible to be dealt with with timesheets. Is that 
so?

Any advice is highly welcome. Thank you

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 "Graeme Gellatly" <graeme@moahub.nz> - 09:11 - 7 Feb 2024
  • Updating translations

    Hi,


    Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


    In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


    In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


    Kind regards, Ronald


    by "Ronald Portier" <rportier@therp.nl> - 01:36 - 7 Feb 2024

    5 replies 5 replies

    • Re: Updating translations

      Hi Ronald,

      to complete Stéphane answer, you can have a look at the slides from the presentation I gave on Weblate during last OCA days : https://cloud.le-filament.com/s/4tdqw6xFxZs27BD

      You get the workflow on page 10.


      To sum up, Weblate waits for 2h before sending translations (in order to group as many translations as possible in a single commit). If needed you can force push updates using Web interface.


      With respect to nl_NL we had the same issue with French where we add both fr and fr_FR. fr_FR should not be used anymore and only fr should be used (+ fr_BE or fr_CA or fr_CH for delta translation for these localized versions of French language). As far as I remember I think Alexis produced a script to remove all fr_FR translations from repos a few months back.

      Probably you may want to apply the same (using only nl for Netherlands, discarding nl_NL, and maybe nl_BE only for specific terms used in Belgium) ?

      As Stéphane mentioned, the .po file that ends up in module code is generated by Weblate directly, so you need to be careful when you create a new translation in Weblate to use Dutch and not Dutch (nl_NL).


      Best Regards,

      Rémi


      Le 07/02/2024 à 16:56, Stéphane Bidoul a écrit :
      Hi Ronald,

      > Would still like to know how this works anyway.

      Weblate pushes translations back to GitHub "a few times a day". I don't remember the exact configuration.

      > Another problem is that I do not actually intent to use a language variant (nl_NL, Dutch as in the Netherlands), but just Dutch (nl). I actually have to rename nl_NL.po to nl.po in my instance, otherwise the language will not load at all.
      > Is it in any way possible to configure the settings on the translation server to generate / update the nl.po file instead of nl_NL.po?

      Actually weblate does not generate nl.po nor nl_NL.po. It's the translators who chose which one to create and use.

      Best regards,

      -Stéphane


      On Wed, Feb 7, 2024 at 4:32 PM Ronald Portier <notifications@odoo-community.org> wrote:

      Hi,


      Indeed after a few hours the nl_NL.po file is refreshed. Would still like to know how this works anyway.


      Another problem is that I do not actually intent to use a language variant (nl_NL, Dutch as in the Netherlands), but just Dutch (nl). I actually have to rename nl_NL.po to nl.po in my instance, otherwise the language will not load at all.


      Is it in any way possible to configure the settings on the translation server to generate / update the nl.po file instead of nl_NL.po?


      Kind regards, Ronald


      On 07-02-2024 14:36, Enric Tobella Alomar wrote:
      You should wait some time before it is sent.

      I think it is already there :D

      Kind regards,

      El mié, 7 feb 2024 a las 14:22, Stefano Consolaro (<notifications@odoo-community.org>) escribió:
      Hi Ronald,
      what I know is that it takes some time from the Weblate server to be tranfered on GitHub.
      So wait some hours and then check if the nl_NL.po file is updated.

      Cc
      Data Wed, 07 Feb 2024 12:37:22 -0000
      Oggetto Updating translations

      Hi,


      Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


      In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


      In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


      Kind regards, Ronald


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



      Stefano Consolaro

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



      --
      Enric Tobella Alomar
      CEO & Founder

      _______________________________________________
      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 Rémi Cazenave - 12:11 - 8 Feb 2024
    • Re: Updating translations
      Hi Ronald,

      > Would still like to know how this works anyway.

      Weblate pushes translations back to GitHub "a few times a day". I don't remember the exact configuration.

      > Another problem is that I do not actually intent to use a language variant (nl_NL, Dutch as in the Netherlands), but just Dutch (nl). I actually have to rename nl_NL.po to nl.po in my instance, otherwise the language will not load at all.
      > Is it in any way possible to configure the settings on the translation server to generate / update the nl.po file instead of nl_NL.po?

      Actually weblate does not generate nl.po nor nl_NL.po. It's the translators who chose which one to create and use.

      Best regards,

      -Stéphane


      On Wed, Feb 7, 2024 at 4:32 PM Ronald Portier <notifications@odoo-community.org> wrote:

      Hi,


      Indeed after a few hours the nl_NL.po file is refreshed. Would still like to know how this works anyway.


      Another problem is that I do not actually intent to use a language variant (nl_NL, Dutch as in the Netherlands), but just Dutch (nl). I actually have to rename nl_NL.po to nl.po in my instance, otherwise the language will not load at all.


      Is it in any way possible to configure the settings on the translation server to generate / update the nl.po file instead of nl_NL.po?


      Kind regards, Ronald


      On 07-02-2024 14:36, Enric Tobella Alomar wrote:
      You should wait some time before it is sent.

      I think it is already there :D

      Kind regards,

      El mié, 7 feb 2024 a las 14:22, Stefano Consolaro (<notifications@odoo-community.org>) escribió:
      Hi Ronald,
      what I know is that it takes some time from the Weblate server to be tranfered on GitHub.
      So wait some hours and then check if the nl_NL.po file is updated.

      Cc
      Data Wed, 07 Feb 2024 12:37:22 -0000
      Oggetto Updating translations

      Hi,


      Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


      In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


      In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


      Kind regards, Ronald


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



      Stefano Consolaro

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



      --
      Enric Tobella Alomar
      CEO & Founder

      _______________________________________________
      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 Stéphane Bidoul - 04:51 - 7 Feb 2024
    • Re: Updating translations

      Hi,


      Indeed after a few hours the nl_NL.po file is refreshed. Would still like to know how this works anyway.


      Another problem is that I do not actually intent to use a language variant (nl_NL, Dutch as in the Netherlands), but just Dutch (nl). I actually have to rename nl_NL.po to nl.po in my instance, otherwise the language will not load at all.


      Is it in any way possible to configure the settings on the translation server to generate / update the nl.po file instead of nl_NL.po?


      Kind regards, Ronald


      On 07-02-2024 14:36, Enric Tobella Alomar wrote:
      You should wait some time before it is sent.

      I think it is already there :D

      Kind regards,

      El mié, 7 feb 2024 a las 14:22, Stefano Consolaro (<notifications@odoo-community.org>) escribió:
      Hi Ronald,
      what I know is that it takes some time from the Weblate server to be tranfered on GitHub.
      So wait some hours and then check if the nl_NL.po file is updated.

      Cc
      Data Wed, 07 Feb 2024 12:37:22 -0000
      Oggetto Updating translations

      Hi,


      Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


      In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


      In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


      Kind regards, Ronald


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



      Stefano Consolaro

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



      --
      Enric Tobella Alomar
      CEO & Founder

      _______________________________________________
      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> - 04:31 - 7 Feb 2024
    • Re: Updating translations
      You should wait some time before it is sent.

      I think it is already there :D

      Kind regards,

      El mié, 7 feb 2024 a las 14:22, Stefano Consolaro (<notifications@odoo-community.org>) escribió:
      Hi Ronald,
      what I know is that it takes some time from the Weblate server to be tranfered on GitHub.
      So wait some hours and then check if the nl_NL.po file is updated.

      Cc
      Data Wed, 07 Feb 2024 12:37:22 -0000
      Oggetto Updating translations

      Hi,


      Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


      In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


      In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


      Kind regards, Ronald


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



      Stefano Consolaro

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



      --
      Enric Tobella Alomar
      CEO & Founder

      by Enric Tobella Alomar - 02:35 - 7 Feb 2024
    • Re:Updating translations
      Hi Ronald,
      what I know is that it takes some time from the Weblate server to be tranfered on GitHub.
      So wait some hours and then check if the nl_NL.po file is updated.

      Da "Ronald Portier" notifications@odoo-community.org
      A "Contributors" contributors@odoo-community.org
      Cc
      Data Wed, 07 Feb 2024 12:37:22 -0000
      Oggetto Updating translations

      Hi,


      Can somebody give insight in how translations are moved from https://translation.odoo-community.org to the actual project?


      In my case I translated helpdesk_mgmt to Dutch for 16.0. There is one commit added to helpdesk repo from when I just started the translations (basically just containing the untranslated nl_NL.po file). Translation is complete now, but nothing happens anymore.


      In the past we could just add a po file and put translations in there. I understand this is maybe not so easy for non developers contributing translations, but is this still possible to do as well, or will stuff just be overwritten from the translation website?


      Kind regards, Ronald


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



      Stefano Consolaro
      www.mymage.it
      by Stefano Consolaro - 02:21 - 7 Feb 2024
  • AW: Mounting location of part upon production

    AW: Mounting location of part upon production


    Hey,


    I would give a unique number to every product in stock and put this number in a bar code on the product for witch you need this mounting location.

    Your worker scans the final product ( the chair ) from the work order and he takes the first leg, scans it and put it first position given by the work order. So he can take the legs out the box without any worry and you knows exact with leg is in with position. And it is simple for the worker, taking him little time ( just scan each leg ) and it is not hard to code. Only maybe the work order that have to automaticaly give the positions and write the leg number on the work order ( here I have no experians -) ).


    With kind regards,


    Van Hirtum Johan



    -----Oorspronkelijk bericht-----
    Afzender: Daniel Reis <notifications@odoo-community.org>
    Verstuurd: Maandag 5 Februari 2024 16:02
    Aan: Contributors <contributors@odoo-community.org>
    Onderwerp: Re: Mounting location of part upon production
    Hi Tom,

    Option 2 will be problematic as it introduces artificial restrictions on component usage.
    Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot numbers for this?


    On 05/02/2024 11:57, Tom Blauwendraat wrote:
    Hello,

I'm dealing with a situation where upon production, the mounting 
location of the parts needs to be registered.

Imagine a chair with 4 identical legs, but it needs to be registered 
which leg is placed where: front right, front left, rear right or rear left.

Is there something for this case in Odoo? What I could come up with is:

- Requiring work orders for "leg mounting", and specifying the mount 
location on the work order

- Having separate products eg "Left rear leg" and producing these from 
"Leg" (seems a bit of a hassle)

- Adding a required field on stock move line in case certain products 
are produced, where the mount location is filled in; also enforce 1.0 as 
a quantity

- ...

-Tom

    _______________________________________________
    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 johan - 12:07 - 6 Feb 2024
  • Have you organised your 2024 OCA membership yet?
    Dear OCA-ers and Odooers,

    Read the latest OCA news item about the 2024 OCA membership and purchase process.

    If you haven’t purchased the 2024 OCA membership yet, help yourself through the website.

    I’m looking forward to seeing more OCA members in the Netherlands folder directory soon.

    Would like to collaborate and increase the Odoo popularity in the Netherlands together with other OCA members in 2024. Please feel free to contact me in the meantime.



    Best regards,


    Michel Stroom

    by Michel Stroom - 09:21 - 5 Feb 2024

    3 replies 3 replies

    • Re: Have you organised your 2024 OCA membership yet?
      Has any thought been given to using GitHub Sponsorships to track membership and collect money?


      On Mon, Feb 5, 2024 at 3:21 PM Michel Stroom <notifications@odoo-community.org> wrote:
      Dear OCA-ers and Odooers,

      Read the latest OCA news item about the 2024 OCA membership and purchase process.

      If you haven’t purchased the 2024 OCA membership yet, help yourself through the website.

      I’m looking forward to seeing more OCA members in the Netherlands folder directory soon.

      Would like to collaborate and increase the Odoo popularity in the Netherlands together with other OCA members in 2024. Please feel free to contact me in the meantime.



      Best regards,


      Michel Stroom

      _______________________________________________
      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> - 07:06 - 9 Feb 2024
    • Re: Have you organised your 2024 OCA membership yet? 
      Thank you, Gijs-Jan, for the coffee invitation, and I will be in contact soon. 
We have almost 500 OCA Members, as Rebecca wrote in the latest OCA news update. 
Let’s try to double this amount to 1000 OCA Members by the end of the year.



> On 5 Feb 2024, at 22:42, Gijs-Jan Otten <notifications@odoo-community.org> wrote:

> 

> Hi Michel,

> 

> I suspect the list will soon be expanded by quite a bit since I can imagine other companies having done the same as we did: process the due invoice on Membership near the end of January via PO, meaning OCA accounting now has to reconcile quite the number of transactions :-)

> 

> In any case, depending on whether or my colleagues and I are all filed away under the same country, we might see an 1100% increase on that NL list!

> 

> If you’re anywhere near Amersfoort we’d be glad to treat you to a coffee.

> 

> Met vriendelijke groet, Sincerely,

> 

> Gijs-Jan Otten

> Therp BV | gjotten@therp.nl | 

> +31 20 309 30 93

> 

>> On 5 Feb 2024, at 21:21, Michel Stroom <notifications@odoo-community.org> wrote:

>> 

>> 

>> Dear OCA-ers and Odooers,

>> 

>> Read the latest OCA news item about the 2024 OCA membership and purchase process.

>> https://odoo-community.org/blog/news-updates-1/oca-membership-2024-153

>> 

>> If you haven’t purchased the 2024 OCA membership yet, help yourself through the website.

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

>> 

>> I’m looking forward to seeing more OCA members in the Netherlands folder directory soon.

>> https://odoo-community.org/members

>> 

>> Would like to collaborate and increase the Odoo popularity in the Netherlands together with other OCA members in 2024. Please feel free to contact me in the meantime.

>> 

>> 

>> 

>> Best regards,

>> 

>> 

>> Michel Stroom

>> 

>> -- 

>> Office Everywhere

>> t: +31 6 53360677

>> e: mstroom@office-everywhere.com

>> w: Office-Everywhere.com

>> 

>> 

>> 

>> _______________________________________________

>> 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 Michel Stroom - 01:31 - 6 Feb 2024
    • Re: Have you organised your 2024 OCA membership yet?
      Hi Michel,

      I suspect the list will soon be expanded by quite a bit since I can imagine other companies having done the same as we did: process the due invoice on Membership near the end of January via PO, meaning OCA accounting now has to reconcile quite the number of transactions :-)

      In any case, depending on whether or my colleagues and I are all filed away under the same country, we might see an 1100% increase on that NL list!

      If you’re anywhere near Amersfoort we’d be glad to treat you to a coffee.

      Met vriendelijke groet, Sincerely,

      Gijs-Jan Otten
      Therp BV | gjotten@therp.nl | 
      +31 20 309 30 93

      On 5 Feb 2024, at 21:21, Michel Stroom <notifications@odoo-community.org> wrote:

      
      Dear OCA-ers and Odooers,

      Read the latest OCA news item about the 2024 OCA membership and purchase process.

      If you haven’t purchased the 2024 OCA membership yet, help yourself through the website.

      I’m looking forward to seeing more OCA members in the Netherlands folder directory soon.

      Would like to collaborate and increase the Odoo popularity in the Netherlands together with other OCA members in 2024. Please feel free to contact me in the meantime.



      Best regards,


      Michel Stroom

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

      by Gijs-Jan Otten - 10:41 - 5 Feb 2024
  • Please approve PR [17.0][MIG] stock_mts_mto_rule: Migration to 17.0

    Hello,

     

    Please approve my Pull Request

    https://github.com/OCA/stock-logistics-warehouse/pull/1932

    It will take you just 2 minutes!

     

    BR,

    Aleksander Milinkevich

     

    by "Aleksander Milinkevich" <aleksander@versada.eu> - 02:06 - 5 Feb 2024

    3 replies 3 replies

  • Mounting location of part upon production 
    Hello,

I'm dealing with a situation where upon production, the mounting 
location of the parts needs to be registered.

Imagine a chair with 4 identical legs, but it needs to be registered 
which leg is placed where: front right, front left, rear right or rear left.

Is there something for this case in Odoo? What I could come up with is:

- Requiring work orders for "leg mounting", and specifying the mount 
location on the work order

- Having separate products eg "Left rear leg" and producing these from 
"Leg" (seems a bit of a hassle)

- Adding a required field on stock move line in case certain products 
are produced, where the mount location is filled in; also enforce 1.0 as 
a quantity

- ...

-Tom
    by Tom Blauwendraat - 12:57 - 5 Feb 2024

    7 replies 7 replies

    • Re: Mounting location of part upon production
      Hi Tom,
      You should be able to have each of the items (specified legs) be on one BOM and when the Manufacturing order is created, you select the serial numbers being used on those individual line items.

      I might need to build up a test case to be able to show you, and I should check to see what modules I have running that are beyond standard to enable that.

      I would be happy to connect directly.  If I build a test case I could likely share a video or some images.
      I should add, perhaps I am wrong,  but this seems pretty doable.  If not doable, it should be.

      Landis

      Landis Arnold
      Nomadic Inc.
      Niwot, CO USA

      larnold@nomadic.net


      From: "Tom Blauwendraat" <notifications@odoo-community.org>
      To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
      Sent: Friday, February 16, 2024 7:31:46 AM
      Subject: Re: Mounting location of part upon production

      On 2/16/24 15:17, Landis Arnold wrote:


>


> One way to accomplish some of this is to simply use "structured 


> serialization".


> If you were to apply  to your Chair use case, you might do the following:


>


> 200 Legs become 200 serialized items.


> In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 


> 3 and 4, Other components


> Focusing on the Leg Positions:  Basically a BOM for each would allow 


> the Serialized Legs to be used for their source.


> You would Select a Serial Number for each in the BOM positions for 


> each (leg1, leg2, leg3, leg4)

Hi Landis,

this sounds exactly like what I need, but I'm not sure that I follow - 
if you say you need a "bom for each", then you basically mean defining 
each leg as a separate product, which you include in the main BoM; so 
there's a production step in between where a leg becomes a leg1, and 
then becomes part of the table. Am I right? Or are you talking about 
some other kind of serialization, that I don't yet know about?

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


      by Landis Arnold - 06:51 - 16 Feb 2024
    • Re: Mounting location of part upon production 
      On 2/16/24 15:17, Landis Arnold wrote:

>

> One way to accomplish some of this is to simply use "structured 

> serialization".

> If you were to apply  to your Chair use case, you might do the following:

>

> 200 Legs become 200 serialized items.

> In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 

> 3 and 4, Other components

> Focusing on the Leg Positions:  Basically a BOM for each would allow 

> the Serialized Legs to be used for their source.

> You would Select a Serial Number for each in the BOM positions for 

> each (leg1, leg2, leg3, leg4)

Hi Landis,

this sounds exactly like what I need, but I'm not sure that I follow - 
if you say you need a "bom for each", then you basically mean defining 
each leg as a separate product, which you include in the main BoM; so 
there's a production step in between where a leg becomes a leg1, and 
then becomes part of the table. Am I right? Or are you talking about 
some other kind of serialization, that I don't yet know about?
      by Tom Blauwendraat - 03:30 - 16 Feb 2024
    • Re: Mounting location of part upon production
      Perhaps related to your request Tom,
      I have worked through something "similar" to this recently.  My use case involved "halves" of a paddle tracked by incoming lots,  right and left side, weights and lengths, and quality.
      The objective of the process was to primarily match pairs, such that left and right side would be balanced,  we would know the combined maximum length of the two sides, and we would flush out any blemishes, and in fact also try to pair blemishes.

      I used Serialization of Incoming as well as BOM processes for this.
      In parallel I built a system in Filemaker which would allow quick sorting of weights/lengths etc.  That sorting allowed relatively simple processing of components into pairs.  Then at time of final build the pairs are combined to built paddle in specific length, twists and control hand specifications.
      Back in Odoo, the traceability report shows the full flow of components used in each paddle.  In the Inventory/Warehouse App, if you look at Serial Numbers. then unselect "product" in the filter/search box, you can then see all of the serial numbers and if used, where they have been used.  This would go "up or down" in terms of a flow from initial part, paired part, built part.

      -------

      But about your Chair and Chair Leg approach.

      One way to accomplish some of this is to simply use "structured serialization".  
      If you were to apply  to your Chair use case, you might do the following:

      200 Legs become 200 serialized items.
      In your BOM you would apply a Top Down with Chair, Leg position 1, 2, 3 and 4, Other components
      Focusing on the Leg Positions:  Basically a BOM for each would allow the Serialized Legs to be used for their source.
      You would Select a Serial Number for each in the BOM positions for each (leg1, leg2, leg3, leg4)  

      ----
      I have been doing this with Odoo 14  Community.    There could definitely be different/better reports for some of this, but if you look well enough, and jump to the correct app, most things are findable.

      I hope that some of this above may be helpful.

      Landis Arnold

      Nomadic Inc.
      Niwot, CO USA

      From: "Tom Blauwendraat" <notifications@odoo-community.org>
      To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
      Sent: Tuesday, February 6, 2024 1:17:27 PM
      Subject: Re: Mounting location of part upon production

      That could indeed be a nice idea - based on where the leg is placed at the moment, we modify a field on the serial number indicating the position.
      That said, maybe it could then also be an extra field that we store the information on in stock.move or stock.quant table, to avoid write traffic on the lot table. Let me think about that some more.

      Thanks, Graeme!

      Therp - Open Source ERP solutions built on Odoo

      On 6 Feb 2024, at 12:22, Graeme Gellatly <notifications@odoo-community.org> wrote:

      Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

      On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
      On 2/5/24 16:02, Daniel Reis wrote:



> Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 



> numbers for this?

Good idea in theory, but in my case we're already using serial numbers 
to track the parts

      _______________________________________________
      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 Landis Arnold - 03:16 - 16 Feb 2024
    • Re: Mounting location of part upon production
      That could indeed be a nice idea - based on where the leg is placed at the moment, we modify a field on the serial number indicating the position.

      That said, maybe it could then also be an extra field that we store the information on in stock.move or stock.quant table, to avoid write traffic on the lot table. Let me think about that some more.

      Thanks, Graeme!

      Therp - Open Source ERP solutions built on Odoo

      On 6 Feb 2024, at 12:22, Graeme Gellatly <notifications@odoo-community.org> wrote:

      Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

      On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
      On 2/5/24 16:02, Daniel Reis wrote:


> Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 


> numbers for this?

Good idea in theory, but in my case we're already using serial numbers 
to track the parts

      _______________________________________________
      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 - 09:16 - 6 Feb 2024
    • Re: Mounting location of part upon production
      Yes, but there is a second field on serials, I don't recall its name, but I use it a lot to store information and lot names are surprisingly accessible during manufacturing processes. I wouldn't discount the idea, it is a pretty simple workaround.

      On Tue, Feb 6, 2024 at 5:42 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:
      On 2/5/24 16:02, Daniel Reis wrote:


> Option 3 looks similar to Lot/Serial usage. What if you (ab)used Lot 


> numbers for this?

Good idea in theory, but in my case we're already using serial numbers 
to track the parts

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

      by "Graeme Gellatly" <graeme@moahub.nz> - 12:20 - 6 Feb 2024

  • Travis sunset
    Hi everyone,

    As previously announced we have cancelled the OCA Travis subscription.

    This means Travis CI tests will stop working in OCA repos mid February.

    Older branches that still use Travis can be converted to GitHub actions by applying the OCA repo template [1]. Odoo >= 11 is supported.

    Best regards,

    -Stéphane
    by Stéphane Bidoul - 11:21 - 3 Feb 2024

    3 replies 3 replies

    • Re: Travis sunset

      Hi,


      With some limitations it is possible to use github actions for older versions. Check the 9.0 branch of the Dutch localization: https://github.com/OCA/l10n-netherlands/tree/9.0. The move from .travis to .github actions is in the last 4 commits.


      Kind regards, Ronald


      On 05-02-2024 15:17, Adam Heinz wrote:
      I cringe a bit at the idea of removing automated testing. Is there some reason that it doesn't make sense to migrate these old versions to runboat or some other build tool? If it is a matter of cost, "GitHub Actions usage is free for standard GitHub-hosted runners in public repositories" [1].


      On Sun, Feb 4, 2024 at 5:59 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:

      Nice progress, Stephane!

      This is a good hook for me to ask a question that I had, based on the previous discussion around stopping support for Python 2 and Odoo <10.0:

      --> How should PSC's deal (from now on) with incoming PR's for Odoo 8.0 and 9.0? (And maybe 10.0 as well)

      Should we:

      A. Refuse/close any incoming PR's, citing unsupported version (Odoo SA method); perhaps even lock branches on repos

      B. Refuse complex PR's; manually merge in smaller or bugfix PR's

      C. Treat PR's like any PR, just without CI, so we merge manually when there are enough approving reviews

      D. Any of the above, as agreed as a policy between the PSC's of the particular repo

      I guess opinions might differ on this, perhaps if people want to chip in with their particular preference and vote?

      -Tom

      On 2/3/24 11:22, Stéphane Bidoul wrote:
      Hi everyone,

      As previously announced we have cancelled the OCA Travis subscription.

      This means Travis CI tests will stop working in OCA repos mid February.

      Older branches that still use Travis can be converted to GitHub actions by applying the OCA repo template [1]. Odoo >= 11 is supported.

      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

      _______________________________________________
      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:41 - 5 Feb 2024
    • Re: Travis sunset
      I cringe a bit at the idea of removing automated testing. Is there some reason that it doesn't make sense to migrate these old versions to runboat or some other build tool? If it is a matter of cost, "GitHub Actions usage is free for standard GitHub-hosted runners in public repositories" [1].


      On Sun, Feb 4, 2024 at 5:59 AM Tom Blauwendraat <notifications@odoo-community.org> wrote:

      Nice progress, Stephane!

      This is a good hook for me to ask a question that I had, based on the previous discussion around stopping support for Python 2 and Odoo <10.0:

      --> How should PSC's deal (from now on) with incoming PR's for Odoo 8.0 and 9.0? (And maybe 10.0 as well)

      Should we:

      A. Refuse/close any incoming PR's, citing unsupported version (Odoo SA method); perhaps even lock branches on repos

      B. Refuse complex PR's; manually merge in smaller or bugfix PR's

      C. Treat PR's like any PR, just without CI, so we merge manually when there are enough approving reviews

      D. Any of the above, as agreed as a policy between the PSC's of the particular repo

      I guess opinions might differ on this, perhaps if people want to chip in with their particular preference and vote?

      -Tom

      On 2/3/24 11:22, Stéphane Bidoul wrote:
      Hi everyone,

      As previously announced we have cancelled the OCA Travis subscription.

      This means Travis CI tests will stop working in OCA repos mid February.

      Older branches that still use Travis can be converted to GitHub actions by applying the OCA repo template [1]. Odoo >= 11 is supported.

      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 "Adam Heinz" <adam.heinz@metricwise.com> - 03:16 - 5 Feb 2024
    • Re: Travis sunset

      Nice progress, Stephane!

      This is a good hook for me to ask a question that I had, based on the previous discussion around stopping support for Python 2 and Odoo <10.0:

      --> How should PSC's deal (from now on) with incoming PR's for Odoo 8.0 and 9.0? (And maybe 10.0 as well)

      Should we:

      A. Refuse/close any incoming PR's, citing unsupported version (Odoo SA method); perhaps even lock branches on repos

      B. Refuse complex PR's; manually merge in smaller or bugfix PR's

      C. Treat PR's like any PR, just without CI, so we merge manually when there are enough approving reviews

      D. Any of the above, as agreed as a policy between the PSC's of the particular repo

      I guess opinions might differ on this, perhaps if people want to chip in with their particular preference and vote?

      -Tom

      On 2/3/24 11:22, Stéphane Bidoul wrote:
      Hi everyone,

      As previously announced we have cancelled the OCA Travis subscription.

      This means Travis CI tests will stop working in OCA repos mid February.

      Older branches that still use Travis can be converted to GitHub actions by applying the OCA repo template [1]. Odoo >= 11 is supported.

      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 Tom Blauwendraat - 11:59 - 4 Feb 2024
  • 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

    5 replies 5 replies

    • Re: Prepaid Services & Timesheets

      Hi Daniel,

      i am not sure at the moment if this can be adressed like exected.

      At this point, for me it looks like the best apporach is to solve this by creating appropriate timesheet entries (positive and negative).

      I will attack this issue more in detail end of next week and hope to get a more precise idea of what will come up to do this.

       

      All the best

      Nils

       

      Von: Daniel Reis <notifications@odoo-community.org>
      Antworten an: OCA Contributors <contributors@odoo-community.org>
      Datum: Donnerstag, 1. Februar 2024 um 19:13
      An: OCA Contributors <contributors@odoo-community.org>
      Betreff: Re: Prepaid Services & Timesheets

       

      ACHTUNG! Diese E-Mail stammt von außerhalb der Organisation. Klicken Sie nicht auf Links und öffnen Sie keine Anhänge, es sei denn, Sie kennen den Absender und wissen, dass der Inhalt sicher ist.

      Can an upfront Advance Payment address this?

      On 01/02/2024 14:31, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT wrote:

      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

       

      Das Bild wurde vom Absender entfernt. 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.

       

      --

      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

      Das Bild wurde vom Absender entfernt.

      _______________________________________________
      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 - 12:02 - 4 Feb 2024
    • Re: Prepaid Services & Timesheets
      Can an upfront Advance Payment address this?

      On 01/02/2024 14:31, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT wrote:

      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.

      _______________________________________________
      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 - 07:13 - 1 Feb 2024
    • Re: Prepaid Services & Timesheets

      Hi Nils,

      probably not, no. If your customer starts out with Enterprise Subscription than you might be tied into changing this. But this part underwent substantial changes in Enterprise throughout previous versions.

      Best Frederik

      Am 01.02.24 um 15:56 schrieb Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT:

      Hi Frederik,

      thanks for your prompt reply…

      It is quite clear to me, that this is nothing for „hey, lets dattack this right now and it will work tomorrow“.

      I do have an idea of the complexity. But as time is a rare good at the moment… (due to another project ;P) I decided to ask you before approaching anything.

       

      So if this a common need for many users… a proper project seem to make sense…

      As the customer wants to use the enterprise subscription app…. I dont know if contract is the right place to start…

       

      But i´ll start diving into it.

       

      Schöne Grüße aus dem Norden ;P

       

      All the best

      Nils

       

      Von: Graeme Gellatly <notifications@odoo-community.org>
      Antworten an: OCA Contributors <contributors@odoo-community.org>
      Datum: Donnerstag, 1. Februar 2024 um 15:47
      An: OCA Contributors <contributors@odoo-community.org>
      Betreff: Re: Prepaid Services & Timesheets

       

      ACHTUNG! Diese E-Mail stammt von außerhalb der Organisation. Klicken Sie nicht auf Links und öffnen Sie keine Anhänge, es sei denn, Sie kennen den Absender und wissen, dass der Inhalt sicher ist.

      Hi Nils,

      afaik exactly such a function doesn't exist so far. I would be interested in something similar though as well / or lets say in expierence how to set that up with a minimal set of additional modules. 

      I think that is also a quite common requirement, though differs in detail from service company to service company. 

      Furthermore you need to consider what type of module to reflect the "recurrency" and the downstream invoice generation (in detail your requirement is more complex than you might think). 

      Ususally you proably would start out with something from https://github.com/OCA/contract to build this process. 

      Best Frederik

      Am 01.02.24 um 15:31 schrieb Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT:

      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

       

      Das Bild wurde vom Absender entfernt. 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. 

      -- 
      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

      -- 
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 - 04:13 - 1 Feb 2024
    • Re: Prepaid Services & Timesheets

      Hi Frederik,

      thanks for your prompt reply…

      It is quite clear to me, that this is nothing for „hey, lets dattack this right now and it will work tomorrow“.

      I do have an idea of the complexity. But as time is a rare good at the moment… (due to another project ;P) I decided to ask you before approaching anything.

       

      So if this a common need for many users… a proper project seem to make sense…

      As the customer wants to use the enterprise subscription app…. I dont know if contract is the right place to start…

       

      But i´ll start diving into it.

       

      Schöne Grüße aus dem Norden ;P

       

      All the best

      Nils

       

      Von: Graeme Gellatly <notifications@odoo-community.org>
      Antworten an: OCA Contributors <contributors@odoo-community.org>
      Datum: Donnerstag, 1. Februar 2024 um 15:47
      An: OCA Contributors <contributors@odoo-community.org>
      Betreff: Re: Prepaid Services & Timesheets

       

      ACHTUNG! Diese E-Mail stammt von außerhalb der Organisation. Klicken Sie nicht auf Links und öffnen Sie keine Anhänge, es sei denn, Sie kennen den Absender und wissen, dass der Inhalt sicher ist.

      Hi Nils,

      afaik exactly such a function doesn't exist so far. I would be interested in something similar though as well / or lets say in expierence how to set that up with a minimal set of additional modules. 

      I think that is also a quite common requirement, though differs in detail from service company to service company. 

      Furthermore you need to consider what type of module to reflect the "recurrency" and the downstream invoice generation (in detail your requirement is more complex than you might think). 

      Ususally you proably would start out with something from https://github.com/OCA/contract to build this process. 

      Best Frederik

      Am 01.02.24 um 15:31 schrieb Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT:

      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

       

      Das Bild wurde vom Absender entfernt. 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. 

      -- 
      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 Nils Coenen - 03:56 - 1 Feb 2024
    • Re: Prepaid Services & Timesheets

      Hi Nils,

      afaik exactly such a function doesn't exist so far. I would be interested in something similar though as well / or lets say in expierence how to set that up with a minimal set of additional modules. 

      I think that is also a quite common requirement, though differs in detail from service company to service company. 

      Furthermore you need to consider what type of module to reflect the "recurrency" and the downstream invoice generation (in detail your requirement is more complex than you might think). 

      Ususally you proably would start out with something from https://github.com/OCA/contract to build this process. 

      Best Frederik

      Am 01.02.24 um 15:31 schrieb Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT:

      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.

      _______________________________________________
      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:46 - 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

    10 replies 10 replies

  • 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 - 03:21 - 23 Jan 2024

    5 replies 5 replies

    • Re: Reducing the size of a database
      Mail message table is typically 50 per cent of database or more. Frankly 6 years is not a lot. In my country fiscal authorities require 7 years, some other legal requirements need 50 years.

      On Wed, 24 Jan 2024, 5:36 am Holger Brunn, <notifications@odoo-community.org> wrote:
      > In my experience a


> huge amount of records can be deleted by deleting old chatter


> records.

similar experience here, and for that we have
https://github.com/OCA/server-tools/tree/14.0/autovacuum_message_attachment
and its migrations to higher versions in the PRs.

You should run the third query from
https://wiki.postgresql.org/wiki/Disk_Usage
anyways to first get an impression where the space goes.



-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

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

      by "Graeme Gellatly" <graeme@moahub.nz> - 09:25 - 23 Jan 2024
    • Re: Reducing the size of a database 
      > In my experience a

> huge amount of records can be deleted by deleting old chatter

> records.

similar experience here, and for that we have
https://github.com/OCA/server-tools/tree/14.0/autovacuum_message_attachment
and its migrations to higher versions in the PRs.

You should run the third query from
https://wiki.postgresql.org/wiki/Disk_Usage
anyways to first get an impression where the space goes.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
      by Holger Brunn - 05:35 - 23 Jan 2024

      1 attachments 1 attachments

      signature.asc
    • Re: Reducing the size of a database

      Hi,


      In my experience a huge amount of records can be deleted by deleting old chatter records.


      Kind regards, Ronald


      On 23-01-2024 15:57, Florian Laporte wrote:

      Dear Victor,

      How large are these databases? Database size usually does not become problematic as a result of too many sale orders or stock movements. You would need an insane amount.
      If this is the case, and you’ve verified that the size is not caused by large blobs/filestore, the only thing you can do is mass-delete records based on some arbitrary parameter like their create_date or write_date. There are many records Odoo won’t let you delete, though. It will ask you to archive them instead, because they are still referenced elsewhere. Archiving will obviously do nothing for database size.

      Sincerely,

      Florian L


      On Tue, 23 Jan 2024 at 15:22, Victor Champonnois <notifications@odoo-community.org> wrote:

      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

      _______________________________________________
      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> - 04:21 - 23 Jan 2024
    • Re: Reducing the size of a database 
      I've seen this module:

https://apps.odoo.com/apps/modules/13.0/muk_autovacuum/

Obviously this can't be used on just any models, but for some models I 
guess such an approach can work.

Another idea I've proposed to a customer once, was to have a moment at 
end of year where you create an "archive copy instance" for that year, 
where people can login but not change anything. The code at that point 
is also frozen and copied with. It's a dirty approach, as you'll after N 
years be sitting with N archive instances, but there's a chance that at 
some point they'll start agreeing to delete the oldest instance (as at 
least here in NL, there's a year limit to which you are obliged to keep 
financial history). The upside to this approach is that you can 
aggressively start deleting records from live.

-Tom
      by Tom Blauwendraat - 04:20 - 23 Jan 2024
    • Re: Reducing the size of a database

      Dear Victor,

      How large are these databases? Database size usually does not become problematic as a result of too many sale orders or stock movements. You would need an insane amount.
      If this is the case, and you’ve verified that the size is not caused by large blobs/filestore, the only thing you can do is mass-delete records based on some arbitrary parameter like their create_date or write_date. There are many records Odoo won’t let you delete, though. It will ask you to archive them instead, because they are still referenced elsewhere. Archiving will obviously do nothing for database size.

      Sincerely,

      Florian L


      On Tue, 23 Jan 2024 at 15:22, Victor Champonnois <notifications@odoo-community.org> wrote:

      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

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

      by florian.laporte - 03:56 - 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

    1 attachments 1 attachments

    OCA Membership Directory 2024-01-21.png

    1 replies 1 replies

    • Re: Can we improve our 2024 OCA Membership numbers in the next few days and set a new record?
      I love your enthusiasm Michael.

      Most of the final renewal invoices have gone out today. 
      I'm still waiting on a few of the companies who like a corporate invoice to come back to me with their list of members for the year to invoice.

      In regards to the members list showing - this is refreshed as invoices are reconciled.
      I've requested the latest bank statements, so anyone who has paid by bank transfer in the last couple of weeks won't be showing yet, but should tomorrow once I have been able to reconcile them.

      The paypal payments will reconcile directly and often the Stripe ones but I notice a couple from last week haven't - I have to wait till the end of each month to do the manual Stripe reconciliation.

      If anyone thinks they should have received an invoice and haven't yet please get in touch with me at membership@odoo-community.org and I can look into it or as Michael says, go ahead and buy online!

      To be shown on the member's list you need to have completed this survey: https://odoo-community.org/survey/start/ec93270c-f080-4ef0-821d-f5ec4531f371
      Some people also don't want to be shown on the list and opt out.

      I hope this helps everyone and also that Michael's enthusiasm is contagious amongst our contributors!

      Have a great week everyone.
      Rebecca



      On Mon, 22 Jan 2024 at 02:37, Michel Stroom <notifications@odoo-community.org> wrote:
      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





      _______________________________________________
      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 - 07:11 - 22 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

    1 attachments 1 attachments

    logo_processcontrol_color_180_3c00a3dc-2edd-43c5-ab8d-6a57b3c7caad.jpg

    3 replies 3 replies

    • Re: Procedure for migration of OCA modules
      Hi,

      The Odoo and OpenUpgrade processes are technically very similar, except Openupgrade offers a more complete migration than Enterprise migration. Enterprise has a few more things like reports. Openupgrade allows you to take a lot more control over timing and scope and allows you to retain sovereignty over your own data. 

      If you have ever viewed the Odoo migration logs they migrate 1 version at a time then next (indeed they do this for every single version like SaaS etc), but only for their own code.

      For Openupgrade the process is the same, except 1. You need to have a system to trigger each version migration. The most common system is when it finishes I manually trigger the next migration, and 2. You can migrate any and all code you want along the way but typically it looks like this.

      • For every version migrated install all of the Odoo and OCA modules you are using.
      • For the final version migration, for your own custom code, you write the migration scripts to go from the original version to the target version. This saves the code effort of migrating custom code to work on 3 or 4 different versions of Odoo. 

      With Enterprise you need to write migration scripts for all non Odoo S.A modules from the current version to target version. Usually, if there are a lot of these, and you are using primarily good quality modules such as OCA, that already will have migration scripts, the effort is much less with Openupgrade IMO, and many many Enterprise customers use OpenUpgrade for this reason.

      On Sat, Jan 20, 2024 at 12:39 AM David Ramia <notifications@odoo-community.org> wrote:

      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.

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

      by "Graeme Gellatly" <graeme@moahub.nz> - 07:30 - 19 Jan 2024
    • Re: [SPAM] Re: Procedure for migration of OCA modules
      Hello,

      You might find a lot of useful information in the latest Open Upgrade documentation, that was updated lately by Sylvain Le Gal.

      Happy migration!
      --
      Virginie
      +32 477 64 17 20
      Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy

      -----Original Message-----
      Reply-To: Contributors <contributors@odoo-community.org>
      Subject: [SPAM] Re: Procedure for migration of OCA modules
      Date: Fri, 19 Jan 2024 12:02:44 -0000

      Normally (hopefully) every migrated OCA module contains that version migration scripts. And then with OpenUpgrade they're triggered in order along with the core migration scripts. Even more, when an OCA module is merged into another or renamed, it can be (should be) declared in a dictionary declared in OpenUpgrade (apriori.py) and that perform some automatic migration tasks that ease that kind of situation.

      On the other hand, you should pass your database through each version migration, as otherwise you'd be missing important data transformations and your result would be very likely inconsistent.


      El vie, 19 ene 2024 a las 12:39, David Ramia (<notifications@odoo-community.org>) escribió:

      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.

      _______________________________________________
      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 Virginie Dewulf. - 01:26 - 19 Jan 2024
    • Re: Procedure for migration of OCA modules
      Normally (hopefully) every migrated OCA module contains that version migration scripts. And then with OpenUpgrade they're triggered in order along with the core migration scripts. Even more, when an OCA module is merged into another or renamed, it can be (should be) declared in a dictionary declared in OpenUpgrade (apriori.py) and that perform some automatic migration tasks that ease that kind of situation.

      On the other hand, you should pass your database through each version migration, as otherwise you'd be missing important data transformations and your result would be very likely inconsistent.


      El vie, 19 ene 2024 a las 12:39, David Ramia (<notifications@odoo-community.org>) escribió:

      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.

      _______________________________________________
      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 Vidal - 01:01 - 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

    2 replies 2 replies

    • Re: Filling in product catalogue by vendors (external parties - i.e. portal users) 
      Hello Miroslav,

thank you for the input. This is OCA's mailing list and as such focuses on free OCA's modules or modules by OCA contributors not yet in OCA's repositories. The modules you have mentioned generally (judging by their description) provide a way to setup new supplier records by themselves and then some communication around pricelists/products.

However these have limitations that I am trying to overcome here:
1) I am stringly against possibility of creating a new contact in the system by just filling in the publicly available form on the website as the Website Vendor Form Registration module does. This poses numerous risks: flooding the system with nonsense, innocent and not so innocent duplication of entries, etc... My solution here is a survey with a module that allows to create a res.partner record from the information collected (by dynamically mapping fields from survey to target model). When the module is matured enough I'll create a PR in OCA repo.

2) The other modules work with already existing products and pricelists. My original question was aimed more towards how to help creating these in a safe way (the same risks as above) and move part of the work to suppliers themselves.


But thank you for trying to help here.

Best regards

	Radovan Skolnik


On sobota 20. januára 2024 11:21:58 CET Apm Consultancy wrote:

> Hi,

> My 5c suggestion is, before going farer and further here, to look at the

> following existing functionalities, I must admit not exhausted list: - 

> Supplier Relationship Management Bundle Apps [1]  -  Purchase Order Showing

> Vendor PriceList [2]  - Website Vendor Registration Form in Odoo [3]  -

> Vendor Portal for Product PriceLists [4] I hope (believe) that you can

> figure out your first-step working scenario which will satisfy your desire

> not to rely on "external hands" data management. However, because your

> initial more important business requirement looks like to be minimising or

> eliminating the internal workload of the procurement team , still a process

> that is implementing a "horizontal integration" across vendors must be

> architected (designed), which is also possible, but probably not with the

> existing (like above) functionalities. Eventually, that might be the

> second-step scenario which will meet your business functional requirements

> to decrease the internal workload of the procuring people. Another

> e-catalog-based approach is also feasible but that would require adapting

> the purchasing strategy and operations of the company' sourcing process.

> 

> 

> 

> 

> Best regards,

> Miroslav Lorinkov

> (  apmcservice@gmail.com [5]  )

> 

> On Fri, Jan 19, 2024 at 5:12 AM Radovan Skolnik <

> notifications@odoo-community.org [6] > wrote: 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

> 

> 

> _______________________________________________

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

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

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

> 

> 

> _______________________________________________

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

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

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

> 

> 

> 

> [1]

> https://apps.odoo.com/apps/modules/16.0/supplier_relationship_manage_bundle

> / [2]

> https://apps.odoo.com/apps/modules/16.0/vendor_pricelist_purchase_order/

> [3] https://apps.odoo.com/apps/modules/16.0/vendor_registration_form/ [4]

> https://apps.odoo.com/apps/modules/16.0/vendor_pricelist_portal/ [5]

> mailto:apmcservice@gmail.com

> [6] mailto:notifications@odoo-community.org

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

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

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

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

> [11] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 10:56 - 22 Jan 2024
    • Re: Filling in product catalogue by vendors (external parties - i.e. portal users)
      Hi,

      My 5c suggestion is, before going farer and further here, to look at the following existing functionalities, I must admit not exhausted list:


      I hope (believe) that you can figure out your first-step working scenario which will satisfy your desire not to rely on "external hands" data management. 

      However, because your initial more important business requirement looks like to be minimising or eliminating the internal workload of the procurement team, still a process that is implementing a "horizontal integration" across vendors must be architected (designed), which is also possible, but probably not with the existing (like above) functionalities. Eventually, that might be the second-step scenario which will meet your business functional requirements to decrease the internal workload of the procuring people. Another e-catalog-based approach is also feasible but that would require adapting the purchasing strategy and operations of the company' sourcing process.

      Best regards,

      Miroslav Lorinkov

      ( apmcservice@gmail.com )



      On Fri, Jan 19, 2024 at 5:12 AM Radovan Skolnik <notifications@odoo-community.org> wrote:
      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

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

      by milori2006 - 11:21 - 20 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

    4 replies 4 replies

    • Re: Elimination of multi-company transactions
      Thank you everyone for the valuable suggestions.

      This helps us understand the what is available / lacking and know what needs to be developed further if we want to proceed with this requirement.

      On Wed, Jan 17, 2024 at 4:06 PM Oleg Kuryan <notifications@odoo-community.org> wrote:
      Hello,

      About Odoo consolidation/multi-company. This is indeed in standard good only for basic needs. Though OCA did a great job to improve it. But because it is opensource not everything is migrated to latest version:
      1) Like consolidation module that Pedro have sent you might check (but only available for Odoo 14) 
      2) For multi company improvements check this repository https://github.com/OCA/multi-company (from amount of modules you may see how many gaps there are)
      3) I in general encourage you to at least once per quarter check what's new in repositories here https://github.com/oca 
      4) In my company experience we ended up our own consolidation approach that works for our managerial accounting so I can see company financial KPIs across branches/departments/service lines etc. in single currency (and I can say this is quite a struggle as if you work in different currencies (we work with 3 currencies) you will end up with lots of challenges related to exchange rates difference in order to have proper consolidated view for standard reports in single currency.

      About other topics on if Odoo is a ready solution or not. Also I do not want to start a long discussion. But still want to say that Odoo is selected not because it is ready OOTB solution, but because: 
      (1) it can be adapted to your needs easily (because of framework and popular programming language)
      (2) it has great community (BTW, if you see Odoo comparison with other software like with Accounting, CRM and etc - then what you need to understand that if it is no done by Odoo themselves, it is based on feedback by Odoo community - that is very active and vote very active for Odoo - and this is really strong point of Odoo, not features)

      I guess you might be misled by Odoo marketing. I suggest not to pay too much attention to it - this is just marketing (though I agree it is confusing).
      When choosing Odoo you need to understand what it is all about and what you are purchasing. I would say that Odoo is a LEGO constructor (not Business solution, but a business framework). I wrote an article about it some time ago and it is still valid https://www.linkedin.com/pulse/odoo-really-saporacle-killer-oleg-kuryan/

      Once you understand the above, there will be no confusion. To convert Odoo into ERP for your company (if it is not a small company around 1-5 employees) you require quite a bit of investment. This is a photo from the Odoo conference from 2022. To understand pretty much about average costs of the project (not including license cost). Also you can read more about Total Cost of Ownership in this article https://ventor.tech/odoo/the-true-cost-of-odoo-erp-pricing-and-ownership-insights/
      Odoo-experience-2021-2023-09-20T155840.664.jpg



      On Wed, Jan 17, 2024 at 9:27 AM Pedro M. Baeza <notifications@odoo-community.org> wrote:

      _______________________________________________
      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 Kitti Upariphutthiphong - 04:26 - 18 Jan 2024
    • Re: Elimination of multi-company transactions
      Hello,

      About Odoo consolidation/multi-company. This is indeed in standard good only for basic needs. Though OCA did a great job to improve it. But because it is opensource not everything is migrated to latest version:
      1) Like consolidation module that Pedro have sent you might check (but only available for Odoo 14) 
      2) For multi company improvements check this repository https://github.com/OCA/multi-company (from amount of modules you may see how many gaps there are)
      3) I in general encourage you to at least once per quarter check what's new in repositories here https://github.com/oca 
      4) In my company experience we ended up our own consolidation approach that works for our managerial accounting so I can see company financial KPIs across branches/departments/service lines etc. in single currency (and I can say this is quite a struggle as if you work in different currencies (we work with 3 currencies) you will end up with lots of challenges related to exchange rates difference in order to have proper consolidated view for standard reports in single currency.

      About other topics on if Odoo is a ready solution or not. Also I do not want to start a long discussion. But still want to say that Odoo is selected not because it is ready OOTB solution, but because: 
      (1) it can be adapted to your needs easily (because of framework and popular programming language)
      (2) it has great community (BTW, if you see Odoo comparison with other software like with Accounting, CRM and etc - then what you need to understand that if it is no done by Odoo themselves, it is based on feedback by Odoo community - that is very active and vote very active for Odoo - and this is really strong point of Odoo, not features)

      I guess you might be misled by Odoo marketing. I suggest not to pay too much attention to it - this is just marketing (though I agree it is confusing).
      When choosing Odoo you need to understand what it is all about and what you are purchasing. I would say that Odoo is a LEGO constructor (not Business solution, but a business framework). I wrote an article about it some time ago and it is still valid https://www.linkedin.com/pulse/odoo-really-saporacle-killer-oleg-kuryan/

      Once you understand the above, there will be no confusion. To convert Odoo into ERP for your company (if it is not a small company around 1-5 employees) you require quite a bit of investment. This is a photo from the Odoo conference from 2022. To understand pretty much about average costs of the project (not including license cost). Also you can read more about Total Cost of Ownership in this article https://ventor.tech/odoo/the-true-cost-of-odoo-erp-pricing-and-ownership-insights/
      Odoo-experience-2021-2023-09-20T155840.664.jpg



      On Wed, Jan 17, 2024 at 9:27 AM Pedro M. Baeza <notifications@odoo-community.org> wrote:

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

      by Oleg Kuryan - 10:05 - 17 Jan 2024

      1 attachments 1 attachments

      Odoo-experience-2021-2023-09-20T155840.664.jpg
    • Re: Elimination of multi-company transactions
      by Pedro M. Baeza - 09:26 - 17 Jan 2024
    • Re: Elimination of multi-company transactions
       Hi,

      it is  a very good point bcs I am also exploring to which extents (if at all) Odoo is a real-real enterprise ERP : multicompanies, multicountries, multiCA, running in parallel COCA and LOCA (corporate and local country' Chart of Accounts). We call a vehicle and a car and a truck but car is not truck and vs. 

      I don't intentd to step into "run in battle" here (or elsewhere) but I was overimpressed by a recent presentation how Odoo is overcoming another ERP (well known big brand) bcs of this , bcs of that... and am puzzled if one involving them in public presentations are actually well prepeared what the "E" in ERP really stands for.

      Coming back to the consolidation topic - looking forward to learn more about it from the experiences of others.

      Have a nice day!


      On Wed, 17 Jan 2024, 13:57 Kitti Upariphutthiphong, <notifications@odoo-community.org> wrote:
      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!

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

      by milori2006 - 09:16 - 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

    3 replies 3 replies

    • Re: MQTT client for Odoo 
      Hello,

I would also throw my approach in the ring 
https://github.com/fkantelberg/interfaces/tree/15.0/mqtt

There are basically events you can configure which trigger on specific 
things (like create, write, delete of records, there is an extra module 
to trigger on user login) and convert the record/changes to a MQTT 
payload and send it on the bus. The sub side is handled by the 
processors where you can define code which handles incoming payload. It 
also includes a small framework to subscribe model functions directly 
(see readme/USAGE.rst).

The demo basically demonstrates a sync between 2 Odoo systems of some 
fields for res.partner. Should be portable to any newer Odoo versions 
quite well and I can make sure to push it to the OCA. (got distracted 
and forgot about it)

Best regards,

Florian

Am 13.01.24 um 08:06 schrieb Apm Consultancy:

> 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 -

>

> _______________________________________________

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

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

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

>

-- 
Mit freundlichen Grüßen

Florian Kantelberg
Softwareentwickler

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

Tel.: +49 (0) 4181 1350344
Fax: +49 (0) 4181 1350310

Email: florian.kantelberg@initos.com
Internet: https://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: DE 815580155
Steuer-Nr: 15/200/53247
      by Florian Kantelberg - 06:31 - 18 Jan 2024
    • MQTT client for Odoo

      We have create specially for our customers with complex environment (multi-service) this addon https://apps.odoo.com/apps/modules/17.0/rabbitmq_connector/


      It is also compatible with queuejob module from OCA. So makes it even better in terms of scalability and architecture 

      On Saturday, January 13, 2024, Apm Consultancy <notifications@odoo-community.org> wrote:
      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 -

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



      --
      ///

      Best Regards,
      Oleg Kuryan

      CEO & COO, VentorTech OÜ |       Building Personalized Inventory and Product Management Systems

      | ph PL: +48 573 992 456
      | skype: kuryan.oleg

      by "Oleg Kuryan" <oleg@ventor.tech> - 08:51 - 13 Jan 2024
    • Re: MQTT client for Odoo
      There is a module for AMQP. If you use RabbitMQ as your broker, both AMQP and MQTT are compatible


      On Sat, 13 Jan 2024, 08:07 Apm Consultancy, <notifications@odoo-community.org> wrote:
      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 -

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

      by Enric Tobella Alomar - 08:35 - 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

    3 replies 3 replies

    • Re: AW: Module to Create Custom Menu / Link to External Apps
      Hi Dave, 

      Awesome, didn't know it was possible. Thank you.

      Best regards,

      Zainuddin



      On Saturday, 13 January 2024 at 04:32:25 pm MYT, David Brühlmeier <notifications@odoo-community.org> wrote:


      Hi Zainuddin,

       

      no need to create a module, you can do this directly in Odoo.

       

      1. Download the Nextcloud icon you wish to have as a menu item

      2. Activate Developer Mode

      3. Go to “Settings / Technical / User Interface / Menu Items”

      4. New

        1. Menu: Nextcloud

        2. Web Icon Image: Upload your file

        3. Action: Choose “ir.actions.act_url” and in the field right next to it, enter “Nextcloud”

        4. Click on “Create and edit”

                                                                    i.      Action URL: Enter the URL you want the menu to point to

                                                                   ii.      Save and Close

      1. Save

      2. Hit refresh in the browser to see the new menu item

       

      I actually just learned this a few weeks ago, because I also wanted a Nextcloud icon on the home screen. :-)

       

      Cheers, Dave

       

       

       

       

      Von: Zainuddin Zakaria <notifications@odoo-community.org>
      Gesendet: Samstag, 13. Januar 2024 07:22
      An: Contributors <contributors@odoo-community.org>
      Betreff: 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

      _______________________________________________
      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 fanzalika - 01:30 - 13 Jan 2024
    • AW: Module to Create Custom Menu / Link to External Apps

      Hi Zainuddin,

       

      no need to create a module, you can do this directly in Odoo.

       

      1. Download the Nextcloud icon you wish to have as a menu item

      2. Activate Developer Mode

      3. Go to “Settings / Technical / User Interface / Menu Items”

      4. New

        1. Menu: Nextcloud

        2. Web Icon Image: Upload your file

        3. Action: Choose “ir.actions.act_url” and in the field right next to it, enter “Nextcloud”

        4. Click on “Create and edit”

                                                                    i.      Action URL: Enter the URL you want the menu to point to

                                                                   ii.      Save and Close

      1. Save

      2. Hit refresh in the browser to see the new menu item

       

      I actually just learned this a few weeks ago, because I also wanted a Nextcloud icon on the home screen. :-)

       

      Cheers, Dave

       

       

       

       

      Von: Zainuddin Zakaria <notifications@odoo-community.org>
      Gesendet: Samstag, 13. Januar 2024 07:22
      An: Contributors <contributors@odoo-community.org>
      Betreff: 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

      _______________________________________________
      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 Brühlmeier - 09:31 - 13 Jan 2024
    • Re: Module to Create Custom Menu / Link to External Apps
      Hi,

      I saw it other way around- an one embedded the Odoo menu (Sales, Manufacturing, accounting,…) within a simple made e-commerce web page where the flow starts with the customer ordering online a piece… despite all the limitations it looked not bad from UI point of view. I am not clear how that would work from Odoo user’ license point of view …

      Best regards
      MiroL

      - iPhone -


      On Sat, 13 Jan 2024 at 13:22 Zainuddin Zakaria <notifications@odoo-community.org> wrote:
      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

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

      by milori2006 - 08:16 - 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

    1 replies 1 replies

    • Re: define weight for product template
      Hello Jan,
      I have the same need in Odoo 14.  We have also added a "FedEx Shipping Module" from Vraja and it is very complicated to get anything like a proper weight for shipping, and moreover,  as you note,  the effort of applying Product weights and dimensions per variant takes considerable upkeep.

      My "sense" is that if weight and dimensions would have been applied BEFORE variants were created then it might work.
      It is on my "to do list" to see if I can set the data for such directly to the Database.  
      More optimisically, there might be an OCA module to help with these subjects.

      Thanks for noting,

      Landis Arnold
      Nomadic Inc.
      Niwot, CO USA

      From: "Jan Suhr | Nitrokey" <notifications@odoo-community.org>
      To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
      Sent: Friday, January 12, 2024 2:06:48 PM
      Subject: 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

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


      by Landis Arnold - 10:41 - 12 Jan 2024