Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
Contributors
-
Javascript Debug
Hello you,
when debuggin js with chrome in v16 and v15 the js/css is located in a non named subfolder.
In v14, it is not the case. There it looks more right. (See attached images.)
I could believe, thats why I can not debug inside Intellij, because the path mapping does not work correctly.
Has anyone here an idea ?
Thank you all.
has got anyone an idea why the javascript/scss/... sources are not located under the running domain
Vielen Dank und viele Grüße
Stefan Wild
Geschäftsführersewisoft GmbH
Örtleinsweg 39
96148 Baunach
info@sewisoft.de
Tel. +49 (0) 160 / 99 11 25 69
www.sewisoft.deSitz der Gesellschaft: Baunach
Registergericht: Amtsgericht Bamberg, HRB 8508
Geschäftsführer: Günter Selbert, Stefan Wild
by Stefan Wild - 02:26 - 17 Dec 2022-
Re: Javascript Debug
> when debuggin js with chrome in v16 and v15 the js/css is located in a non > named subfolder. In v14, it is not the case. There it looks more right. > (See attached images.) I could believe, thats why I can not debug inside > Intellij, because the path mapping does not work correctly. > > Has anyone here an idea ? the files in the source map those versions generate have leading slashes. Given this is a non-standard by google, I'd figure whatever chrome does is correct and the fact that firefox handles this more gracefully is a fluke. You might try to remove leading slashes in https://github.com/odoo/odoo/blob/16.0/odoo/tools/sourcemap_generator.py#L95 and see if this fixes your problem. -- Your partner for the hard Odoo problems https://hunki-enterprises.com
by Holger Brunn - 09:16 - 18 Dec 2022 -
Re: Javascript Debug
> when debuggin js with chrome in v16 and v15 the js/css is located in a non > named subfolder. In v14, it is not the case. There it looks more right. > (See attached images.) I could believe, thats why I can not debug inside > Intellij, because the path mapping does not work correctly. > > Has anyone here an idea ? the files in the source map those versions generate have leading slashes. Given this is a non-standard by google, I'd figure whatever chrome does is correct and the fact that firefox handles this more gracefully is a fluke. You might try to remove leading slashes in https://github.com/odoo/odoo/blob/16.0/odoo/tools/sourcemap_generator.py#L95 and see if this fixes your problem. -- Your partner for the hard Odoo problems https://hunki-enterprises.com
by "Holger Brunn" <mail@hunki-enterprises.nl> - 09:16 - 18 Dec 2022
-
-
Weblate project is locked
Hi,This project https://translation.odoo-community.org/projects/commission-15-0/commission-15-0-account_commission/ seems to have been locked since the module https://github.com/OCA/commission/tree/15.0/account_commission was added on 5 December, and we have not been able to work on the translation on it.The lock seems to have been done due to the following alert:> No file mask matches.
> This component set up is incomplete, as it lacks any translations.
> * Starting new translations directly in Weblate is possible, and creates files based on the file mask.
> * Check whether the file mask account_commission/i18n/*.po matches files in your version control system repository.This is a brand new module, and therefore there is no *.po file yet.Questions:1. Is this (i.e. the project gets locked for new modules with no translation) how Weblate projects are supposed to behave?2. How can we unlock such projects?Thank you.--Yoshi Tashiro
by Yoshi Tashiro. - 03:01 - 16 Dec 2022-
Re: Weblate project is locked
> I guess there is no concrete plans on this at this point.Indeed :)Please send the reports to transbot@odoo-community.org. I monitor that one and will handle the requests.If there are enough of them I guess that will motivate me to dig deeper :)-sbiOn Mon, Dec 19, 2022 at 2:52 PM Yoshi Tashiro <notifications@odoo-community.org> wrote:Thank you very much, Stephane.> We could broaden repository maintenance access but probably not to all translators.I guess there is no concrete plans on this at this point. I may bring up this topic when the problem starts bugging me, but until then please allow us to report individual issues here if this is the proper channel.Thanks again.--Yoshi TashiroOn Mon, Dec 19, 2022 at 8:22 PM Stéphane Bidoul <notifications@odoo-community.org> wrote:Hi Yoshi,On Fri, Dec 16, 2022 at 3:02 PM Yoshi Tashiro <notifications@odoo-community.org> wrote:1. Is this (i.e. the project gets locked for new modules with no translation) how Weblate projects are supposed to behave?No. Unfortunately I don't know exactly why it happens yet.It sometimes happen when there are git sync issues but it was not the case here.2. How can we unlock such projects?I unlocked it just now.We could broaden repository maintenance access but probably not to all translators.Best regards,-sbi_______________________________________________
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 - 03:41 - 19 Dec 2022 -
Re: Weblate project is locked
Thank you very much, Stephane.> We could broaden repository maintenance access but probably not to all translators.I guess there is no concrete plans on this at this point. I may bring up this topic when the problem starts bugging me, but until then please allow us to report individual issues here if this is the proper channel.Thanks again.--Yoshi TashiroOn Mon, Dec 19, 2022 at 8:22 PM Stéphane Bidoul <notifications@odoo-community.org> wrote:Hi Yoshi,On Fri, Dec 16, 2022 at 3:02 PM Yoshi Tashiro <notifications@odoo-community.org> wrote:1. Is this (i.e. the project gets locked for new modules with no translation) how Weblate projects are supposed to behave?No. Unfortunately I don't know exactly why it happens yet.It sometimes happen when there are git sync issues but it was not the case here.2. How can we unlock such projects?I unlocked it just now.We could broaden repository maintenance access but probably not to all translators.Best regards,-sbi_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Yoshi Tashiro. - 02:51 - 19 Dec 2022 -
Re: Weblate project is locked
Hi Yoshi,On Fri, Dec 16, 2022 at 3:02 PM Yoshi Tashiro <notifications@odoo-community.org> wrote:1. Is this (i.e. the project gets locked for new modules with no translation) how Weblate projects are supposed to behave?No. Unfortunately I don't know exactly why it happens yet.It sometimes happen when there are git sync issues but it was not the case here.2. How can we unlock such projects?I unlocked it just now.We could broaden repository maintenance access but probably not to all translators.Best regards,-sbi
by Stéphane Bidoul - 12:21 - 19 Dec 2022
-
-
M14 Accounting for French 'Collectivités locales'
Dear french OCA contributors,I am actually working on a RFQ for accounting software of a French Polynesia City Hall. It works the same as in France due to the regulations.We need M14 implementation (Budgets and Accounting) and PES (Protocole d'échanges standards)RFQ deadline is before january 4th 2023Launching production is planned april 2023If someone interested in answering with us for RFQ and developing modules, please contact meBest regards
by Cyril VINH-TUNG - 07:01 - 15 Dec 2022 -
OCA - Github - Switch brach by default
Hello!
I would like to know as PSC if I can change the default branch of a repository and how 😊
For example, by default account-financial-reporting is v13, It should be v15. Isn’t it?
https://github.com/OCA/account-financial-reporting
More branches by default are v14, etc.
Thanks
Regards
Rafael
by "Rafael Blasco" <rblasco@rbnpro.com> - 03:26 - 14 Dec 2022-
RE: OCA - Github - Switch brach by default
I’m PSC but I don’t see “Settings” tab.
De: Stéphane Bidoul <notifications@odoo-community.org>
Enviado el: miércoles, 14 de diciembre de 2022 16:28
Para: Contributors <contributors@odoo-community.org>
Asunto: Re: OCA - Github - Switch brach by defaultPSC *representatives* have admin rights to change default branches.
-sbi
On Wed, Dec 14, 2022 at 3:27 PM Rafael Blasco <notifications@odoo-community.org> wrote:
Hello!
I would like to know as PSC if I can change the default branch of a repository and how 😊
For example, by default account-financial-reporting is v13, It should be v15. Isn’t it?
https://github.com/OCA/account-financial-reporting
More branches by default are v14, etc.
Thanks
Regards
Rafael
_______________________________________________
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 "Rafael Blasco" <rblasco@rbnpro.com> - 11:31 - 19 Dec 2022 -
RE: OCA - Github - Switch brach by default
Thank you! 😊
De: Stéphane Bidoul <notifications@odoo-community.org>
Enviado el: miércoles, 14 de diciembre de 2022 16:28
Para: Contributors <contributors@odoo-community.org>
Asunto: Re: OCA - Github - Switch brach by defaultPSC *representatives* have admin rights to change default branches.
-sbi
On Wed, Dec 14, 2022 at 3:27 PM Rafael Blasco <notifications@odoo-community.org> wrote:
Hello!
I would like to know as PSC if I can change the default branch of a repository and how 😊
For example, by default account-financial-reporting is v13, It should be v15. Isn’t it?
https://github.com/OCA/account-financial-reporting
More branches by default are v14, etc.
Thanks
Regards
Rafael
_______________________________________________
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 "Rafael Blasco" <rblasco@rbnpro.com> - 09:41 - 19 Dec 2022 -
Re: OCA - Github - Switch brach by default
PSC *representatives* have admin rights to change default branches.-sbiOn Wed, Dec 14, 2022 at 3:27 PM Rafael Blasco <notifications@odoo-community.org> wrote:Hello!
I would like to know as PSC if I can change the default branch of a repository and how 😊
For example, by default account-financial-reporting is v13, It should be v15. Isn’t it?
https://github.com/OCA/account-financial-reporting
More branches by default are v14, etc.
Thanks
Regards
Rafael
_______________________________________________
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:26 - 14 Dec 2022
-
-
Translation for Odoo core<=12.0
Hi all,as Odoo deletes translation ability for versions not supported, is it possible to create a project in weblate for these versions?As an alternative, I'll do PRs for every term to translate, perhaps not the better way (an user without git knowledge will find it hard to do).Thanks,Sergio Corato
by Sergio Corato - 12:05 - 14 Dec 2022-
Re: Translation for Odoo core<=12.0
Hi Martin,so I'll go with direct PR on OCB wheen needed.Thanks allSergio CoratoIl giorno mer 14 dic 2022 alle ore 16:17 Martin Trigaux (mat) <notifications@odoo-community.org> ha scritto:Hi there,
Martin, managing the Transifex project at Odoo S.A. here.
Just to add that the 13.0 Transifex project is going away very soon too (probably end of year), it's no longer supported since the release of 16.0. We have a limited number of terms in our Transifex plan so we can't keep forever for all versions unfortunately.
As said Moises, we will not accept PR on deprecated branches (we can accept translation PR on a supported version if it's in a language/module that are not on Transifex). So OCA/OCB is your best bet but adding past projects on Weblate is not negligible in term of size.
To give you a rough idea to those managing the OCA Weblate project if you consider it : Odoo 13.0 is 236k source words and it's increasing of ~30k at each release.
Best,
Martin
On 14/12/2022 12:06, Sergio Corato wrote:
Hi all,
as Odoo deletes translation ability for versions not supported, is it possible to create a project in weblate for these versions?
As an alternative, I'll do PRs for every term to translate, perhaps not the better way (an user without git knowledge will find it hard to do).
Thanks,Sergio Corato
_______________________________________________
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 Sergio Corato - 05:35 - 14 Dec 2022 -
Re: Translation for Odoo core<=12.0
Hi there,
Martin, managing the Transifex project at Odoo S.A. here.
Just to add that the 13.0 Transifex project is going away very soon too (probably end of year), it's no longer supported since the release of 16.0. We have a limited number of terms in our Transifex plan so we can't keep forever for all versions unfortunately.
As said Moises, we will not accept PR on deprecated branches (we can accept translation PR on a supported version if it's in a language/module that are not on Transifex). So OCA/OCB is your best bet but adding past projects on Weblate is not negligible in term of size.
To give you a rough idea to those managing the OCA Weblate project if you consider it : Odoo 13.0 is 236k source words and it's increasing of ~30k at each release.
Best,
Martin
On 14/12/2022 12:06, Sergio Corato wrote:
Hi all,
as Odoo deletes translation ability for versions not supported, is it possible to create a project in weblate for these versions?
As an alternative, I'll do PRs for every term to translate, perhaps not the better way (an user without git knowledge will find it hard to do).
Thanks,Sergio Corato
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Martin Trigaux - 04:16 - 14 Dec 2022 -
Re: Translation for Odoo core<=12.0
Il giorno mer 14 dic 2022 alle ore 15:27 Moises Lopez <notifications@odoo-community.org> ha scritto:--Hi SergioDid you mean, create a new PR toIf yes, It could breaks Odoo SA contributing guidelines1) Odoo doesn't accept PR related to translations:2) Odoo doesn't accept PR for deprecated branches/versions:A workaround, create in your custom module a translation file:- "your_module/i18n_extra/{LANG}.po"with the terms that you need to change for all installed modules and improve the translation from transifex for stable onesOn Wed 14 Dec 2022 at 5:06 a.m. Sergio Corato <notifications@odoo-community.org> wrote:Hi all,as Odoo deletes translation ability for versions not supported, is it possible to create a project in weblate for these versions?As an alternative, I'll do PRs for every term to translate, perhaps not the better way (an user without git knowledge will find it hard to do).Thanks,Sergio Corato_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Sergio Corato - 03:36 - 14 Dec 2022 -
Re: Translation for Odoo core<=12.0
--Hi SergioDid you mean, create a new PR toIf yes, It could breaks Odoo SA contributing guidelines1) Odoo doesn't accept PR related to translations:2) Odoo doesn't accept PR for deprecated branches/versions:A workaround, create in your custom module a translation file:- "your_module/i18n_extra/{LANG}.po"with the terms that you need to change for all installed modules and improve the translation from transifex for stable onesOn Wed 14 Dec 2022 at 5:06 a.m. Sergio Corato <notifications@odoo-community.org> wrote:Hi all,as Odoo deletes translation ability for versions not supported, is it possible to create a project in weblate for these versions?As an alternative, I'll do PRs for every term to translate, perhaps not the better way (an user without git knowledge will find it hard to do).Thanks,Sergio Corato_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo
by Moisés López Calderón - 03:26 - 14 Dec 2022
-
-
Re: pre-commit changes
> The idea of the first pre-commit set is to store the automatic changesWell, I was coming from a place where I'd separate aesthetic changes (automatic or not) vs. functional changes, but thanks for clarifing that.
I'll squash my intermediate commit into the Migration one.Have a nice day.
by Marco Colombo - 02:10 - 6 Dec 2022-
Re: pre-commit changes
Daniel, the question is not related to the pre-commit config, but the changes that pre-commit does on your code.Regards.
by Pedro M. Baeza - 04:25 - 9 Dec 2022 -
Re: pre-commit changes
Actually, pre-commit config updates should be on their own commit, so that they don't contaminate the module history.
You may want to also create a separate PR cherry-picking that particular commit, that can be fat tracked by maintainers.
That will avoid the risk of someone else proposing a different commit to update pre-commit config, that will cause you merge conflicts.
Thanks
Daniel
On 06/12/22 13:11, Marco Colombo wrote:
> The idea of the first pre-commit set is to store the automatic changes
Well, I was coming from a place where I'd separate aesthetic changes (automatic or not) vs. functional changes, but thanks for clarifing that.
I'll squash my intermediate commit into the Migration one.
Have a nice day._______________________________________________
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 DIRECTORM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, #34
by Daniel Reis - 10:35 - 9 Dec 2022
-
-
Migration 12.0 -> 13.0 and field collision
Hi,I'm starting a migration process for a copy of our production database and it fails on the following error (detailed log attached):ERROR mig_9008 odoo.sql_db: bad query:
UPDATE ir_model_fields
SET name = 'notified_partner_ids'
WHERE name = 'needaction_partner_ids'
AND model = 'mail.message'ERROR: duplicate key value violates unique constraint "ir_model_fields_name_unique"
DETAIL: Key (model, name)=(mail.message, notified_partner_ids) already exists.
ERROR mig_9008 OpenUpgrade: mail: error in migration script mail/migrations/13.0.1.0/pre-migration.py: duplicate key value violates unique constraint "ir_model_fields_name_unique"I tracked down the issue and I found out that the `notified_partner_ids` field was an existing field added in 7.0 but deleted in 9.0.Maybe this field should have been dropped or renamed to `openupgrade_legacy_xxx`, I don't know if it should be the case or if I made a mistake in my original upgrade path, but this field still exists in our database even if not referenced in any files.Whatever, if you are in my case, I made a PR to identify and remove orphaned fields (for the database_cleanup module):For the record, we have more than 1000 orphaned fields (list attached) in our production database (updated from 6.1 -> 7.0 -> 8.0 -> 9.0 -> 10.0 -> 11.0 in october 2020)
--
Yann PAPOUIN
Ingénieur R&D





WWW.DECGROUPE.COM
02 43 21 65 50 poste 51
02 43 39 30 78 
ypa@decgroupe.com
3 r Champ du Verger
72700 ALLONNES
by Yann Papouin - 11:46 - 6 Dec 2022 -
Re: Candidature pour un poste en Alternance – Bachelor Concepteur développeurd’applications
Bonjour,l'OCA est une communauté de développeurs, analystes, gestionnaires de projets autour du logiciel Odoo.Ce n'est pas une entreprise qui offre du service à des clients directs.Je vous conseille de vous renseigner avant d'envoyer ce genre de mail à une mailing liste comptant des centaines de personnes, ce qui s'apparente à du spam.De plus, la langue de communication n'est pas le français mais l'anglais.Bonne continuation dans votre recherche.Virginie Dewulf, membre du board de l'OCA.-----Original Message-----From: adnaneazzouz <notifications@odoo-community.org>Reply-To: Odoo Community Association (OCA) Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: Candidature pour un poste en Alternance – Bachelor Concepteur développeurd’applicationsDate: Sun, 04 Dec 2022 14:02:29 -0000Bonjour,
Afin de réaliser mon Bachelor Concepteur développeur d’applications en alternance, je vous adresse ma candidature pour un poste au sein de votre entreprise.
La formation que je m'apprête à suivre me permettra d'acquérir de nouvelles compétences opérationnelles, afin de mener à bien les missions que vous voudrez bien me confier.
Cette formation en alternance se déroule en ligne selon les modalités suivantes :
- Des rentrées toute l'année (pas de date fixe de rentrée)
- Un rythme d'alternance optimisé : 4 jours en entreprise / 1 jour en formation, adapté aux temps forts d'activité de votre entreprise
- Un programme de formation à la carte : vous déterminez l'ordre des modules à suivre en fonction des missions que vous serez amené à me confier.
De plus, pour toute embauche en alternance vous bénéficiez d’une prime de 8000€ grâce au plan "1 jeune, 1 solution", ce qui diminue considérablement le coût lié à mon embauche.
Vous trouverez ci-joint mon CV ainsi que la brochure de présentation de l'ISCOD.
Dans l'attente d'un entretien, je vous prie d'agréer, Madame, Monsieur, l'expression de mes salutations distinguées.Adnane Azzouz
+33769283265_______________________________________________
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. - 10:31 - 5 Dec 2022 -
Candidature pour un poste en Alternance – Bachelor Concepteur développeur d’applications
Bonjour,
Afin de réaliser mon Bachelor Concepteur développeur d’applications en alternance, je vous adresse ma candidature pour un poste au sein de votre entreprise.
La formation que je m'apprête à suivre me permettra d'acquérir de nouvelles compétences opérationnelles, afin de mener à bien les missions que vous voudrez bien me confier.
Cette formation en alternance se déroule en ligne selon les modalités suivantes :
- Des rentrées toute l'année (pas de date fixe de rentrée)
- Un rythme d'alternance optimisé : 4 jours en entreprise / 1 jour en formation, adapté aux temps forts d'activité de votre entreprise
- Un programme de formation à la carte : vous déterminez l'ordre des modules à suivre en fonction des missions que vous serez amené à me confier.
De plus, pour toute embauche en alternance vous bénéficiez d’une prime de 8000€ grâce au plan "1 jeune, 1 solution", ce qui diminue considérablement le coût lié à mon embauche.
Vous trouverez ci-joint mon CV ainsi que la brochure de présentation de l'ISCOD.
Dans l'attente d'un entretien, je vous prie d'agréer, Madame, Monsieur, l'expression de mes salutations distinguées.Adnane Azzouz
+33769283265
by adnaneazzouz@outlook.fr - 03:01 - 4 Dec 2022 -
Q: How to Configure GS1 barcodes on Odoo 14 community version
Greetings All,
I'm facing an issue with reading gs1 datamatrix codes, I have installed all related gs1 barcodes modules but the system is still not able to read the barcodes. I have tried to configure it but there was no success.
Also, after updating "Stock Barcodes" to the latest version, I could not figure out how to configure the barcode option settings.
It would be really appreciated if you guide me through the process on how to configure the gs1 as well as the new barcode option configurations for the latest version of "Stock Barcodes"
Below you'll find all the module that were installed Odoo 14 community version :
Stock Barcodes
Stock Barcodes GS1
Stock Barcodes GS1 Expiry
GS1 Barcode API
Product GS1 Barcode
by Hazem - 07:05 - 4 Dec 2022 -
pre-commit changes
Hi,quick question about pre-commit changes during migration.I'm migrating a module from 14.0 to 16.0. I've noticed that the first pre-commit related commit ("[IMP]: pre-commit stuff") takes care only of part of the changes needed to make pre-commit happy (it is possible due to the --no-verify). The missing part can be significant.
The following commit ("[MIG]: $MODULE: Migration to 16.0") must include those changes too, plus anything migration related.
So I was wondering if that defeats the purpose of having pre-commit changes separated in their own commit. Right now, my approach is to create a second commit, named "[IMP]: more pre-commit stuff", just to make pre-commit happy, and then add another commit with the migration stuff.
Alternatives I've considered: ignoring the issue and include both migration and the rest of pre-commit changes in one commit ("[MIG]: $MODULE: Migration to 16.0"), or do as I do now but squash the two pre-commit related commits before merge (or equivalently, get rid of the --no-verify in the first place, and manually add all changes to the first commit).
Thoughts / suggestions?
by Marco Colombo - 01:46 - 2 Dec 2022-
Re: pre-commit changes
The idea of the first pre-commit set is to store the automatic changes, so you don't have to review them extensively. The rest of the manual changes to make the linter happy must be on the migration commit, as a third extra commit doesn't make too much sense. You have to review these manual changes, and they can be even provoked by the new code you are introducing for the migration, so better to have all of them in the same migration commit.Regards.
by Pedro M. Baeza - 08:31 - 5 Dec 2022
-
-
XML errors when upgrading modules, because of fields in unrelated modules
Hello,
I've been finding this weird issue for a while, but decided to take some tome to write about it.
I've seen frequently the case where:
1. A custom module adds a field to a model and view. For example. to res.company.
2. Later, another (unrelated) custom module also adds a new field to that same model (model and view).
When installing or upgrading that second module, I see errors loading the XML with the form view.
The error says that the field added by module 1 is missing in the view.
But a) module 1 is installed an the field exists and b) the XML for the view in module 2 doesn't have any reference to that "missing" field!
I found this frequently in Odoo 14.
Honestly I'm not sure if it if also happens in other versions.
Has anyone else experienced this?
Thank you
--
DANIEL REIS
MANAGING DIRECTORM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, #34
by Daniel Reis - 02:30 - 25 Nov 2022-
Re: XML errors when upgrading modules, because of fields in unrelated modules
Hi Daniel,
I encountered a similar issue lately when developing a module in OCA/sale-workflow, everything was working fine locally, but the XML error you described was raised on the CI:
- my module was adding a field in the embedded tree view of sale order line in the SO form, which by default is in editable mode (no form)
- another module from OCA/sale-workflow disabled this editable mode so the form view of the SO line was open, on which my field wasn't added, so during tests when opening the form, the "field not found" error was triggered. Adding the field also on the embedded SO line form view fixed the issue.
Could it be the same kind of issue you are facing?
Regards,
Le 25/11/2022 à 14:31, Daniel Reis a écrit :
Hello,
I've been finding this weird issue for a while, but decided to take some tome to write about it.
I've seen frequently the case where:
1. A custom module adds a field to a model and view. For example. to res.company.
2. Later, another (unrelated) custom module also adds a new field to that same model (model and view).
When installing or upgrading that second module, I see errors loading the XML with the form view.
The error says that the field added by module 1 is missing in the view.
But a) module 1 is installed an the field exists and b) the XML for the view in module 2 doesn't have any reference to that "missing" field!
I found this frequently in Odoo 14.
Honestly I'm not sure if it if also happens in other versions.
Has anyone else experienced this?
Thank you
--
DANIEL REIS
MANAGING DIRECTORM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, #34
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Sébastien Alix Business Solutions Odoo Developer Camptocamp France SA https://www.camptocamp.com/
by Sébastien Alix - 09:46 - 28 Nov 2022 -
Re: XML errors when upgrading modules, because of fields in unrelated modules
Hi Danielthe error you describe usually comes when you remove a field from a model and view.If you now update both modules at the same time, it depends on how your Postgres server returns the modules.Because no explicit ordering is specified when loading the module.If the module is updated first that the field is not removed, an error occurs because the other view is still in the database and not updated.in this context, however, other errors can also occur.such as. when loading data via XML.I hope this helps.RegardsMichaelAm 25.11.2022 15:42 schrieb Daniel Reis <notifications@odoo-community.org>:Hi Moises,
I haven't found this to be easy reproductible.
The particular case I encountered today went away after I ran a "-u base" (that I really din't like to do).
On your questions:
1) Yes, In this case both inherited from "base.view_company_form".
2) No (see 1)
3) No groups set on model on view
4) Yes. View on Module 1 does not have a default priority (16 was assigned) and View in Module 2 has priority=100. This looked good to me.
5) Yes, tons of them, between core addons and other OCA modules :-)
I can give it a try at stripping the modules down and reproducing.
Thanks Moises
/Daniel
On 25/11/22 14:22, Moises Lopez wrote:
Hi Daniel
I have a few question related to reproduce the case
1) Do The third view is inherited from original one?
1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=original
--2) Do The third view is inherited from 2nd one?
1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=inh_a
3) Do the original field has "groups"?
4) Do the inherited views has "priority"?
5) Are there other views inheriting the same view?
Could you share the both modules with minimal code and the odoo-bin command to reproduce it, please?
Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo_______________________________________________
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 DIRECTORM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, #34
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Michael Tietz - 07:20 - 25 Nov 2022 -
Re: XML errors when upgrading modules, because of fields in unrelated modules
Hi Moises,
I haven't found this to be easy reproductible.
The particular case I encountered today went away after I ran a "-u base" (that I really din't like to do).
On your questions:
1) Yes, In this case both inherited from "base.view_company_form".
2) No (see 1)
3) No groups set on model on view
4) Yes. View on Module 1 does not have a default priority (16 was assigned) and View in Module 2 has priority=100. This looked good to me.
5) Yes, tons of them, between core addons and other OCA modules :-)
I can give it a try at stripping the modules down and reproducing.
Thanks Moises
/Daniel
On 25/11/22 14:22, Moises Lopez wrote:
Hi Daniel
I have a few question related to reproduce the case
1) Do The third view is inherited from original one?
1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=original
--2) Do The third view is inherited from 2nd one?
1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=inh_a
3) Do the original field has "groups"?
4) Do the inherited views has "priority"?
5) Are there other views inheriting the same view?
Could you share the both modules with minimal code and the odoo-bin command to reproduce it, please?
Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo_______________________________________________
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 DIRECTORM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, #34
by Daniel Reis - 03:41 - 25 Nov 2022 -
Re: XML errors when upgrading modules, because of fields in unrelated modules
Hi DanielI have a few question related to reproduce the case1) Do The third view is inherited from original one?1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=original--2) Do The third view is inherited from 2nd one?1. id=original2. id=inh_a inherit=original3. id=inh_b inherit=inh_a3) Do the original field has "groups"?4) Do the inherited views has "priority"?5) Are there other views inheriting the same view?Could you share the both modules with minimal code and the odoo-bin command to reproduce it, please?Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo
by Moisés López Calderón - 03:20 - 25 Nov 2022
-
-
OCA Financial Auditors Campaign Closes Today - 25th November
Hello OCA Contributors,Just a reminder our Financial Auditors Campaign closes today. So far we have only had 1 applicant. Preferably we would like to be able to vote for 3.
To apply as a candidate you do not need to be a delegate or member. Perhaps someone on your team has the skills to help the OCA with the annual audit?It isn't a huge task thankfully but does obviously require a certain skill set.Please fill in the survey below or share the link with colleagues who might be interested:Warmest regards,
Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 10:30 - 25 Nov 2022 -
Financial Auditor Campaign closes November 25th
Hello OCA Contributors,
I hope the week is going well for you!I just wanted to remind you our financial auditors campaign closes this coming Friday 25th of November.
To apply as a candidate you do not need to be a delegate or member. Perhaps someone on your team has the skills to help the OCA with the annual audit?Please fill in the survey below or share the link with colleagues who might be interested:--Warmest regards,
RebeccaRebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 04:51 - 23 Nov 2022 -
Module name, name collision
Hi all,It seems there are miscellaneous practices to deal with name collision in OCA, mainly regarding Odoo SA module nameshere mgmt is usedhere and in some other repos oca is usedIs there any other practice ?Should we converge on the same standard ? with a rename in future version with apriori openupgrade file ?Personally I prefer oca, but it probably needs to be voted !?What do you think?RegardsThanks
by David BEAL - 04:16 - 22 Nov 2022-
Re: Module name, name collision
This friends have it for free, it should be nice if OCA contacts them and let them serve something (may be paid).Regards.El mar, 22 nov 2022 a la(s) 09:17, David Beal (notifications@odoo-community.org) escribió:Hi all,It seems there are miscellaneous practices to deal with name collision in OCA, mainly regarding Odoo SA module nameshere mgmt is usedhere and in some other repos oca is usedIs there any other practice ?Should we converge on the same standard ? with a rename in future version with apriori openupgrade file ?Personally I prefer oca, but it probably needs to be voted !?What do you think?RegardsThanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Nhomar G Hernández
Vauxoo | CEO
¡Construyamos algo genial!
Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomarMéxico · Venezuela · Costa Rica · Perú
by Nhomar Hernández - 10:51 - 15 Dec 2022 -
Re: Module name, name collision
IMHO.Avoid prefixes or suffixes.an script in the ci with a centralize DB with module names would be the practical solution.1. A quick service with elastic.2. An script that makes a push to such index.3. Serve a quick rest search.4. An script for the CI that makes:curl url/search/modules_here -r
read_response.json -> found5. Red if exists (with proper output).Why not the prefix/suffix.1. Nothing will avoid with such technique the duplication of functions and modules.2. In dev time the developer will know where the problem is (now I do simply a search in google, but as I said it can be automated).Regards.El mar, 22 nov 2022 a la(s) 09:17, David Beal (notifications@odoo-community.org) escribió:Hi all,It seems there are miscellaneous practices to deal with name collision in OCA, mainly regarding Odoo SA module nameshere mgmt is usedhere and in some other repos oca is usedIs there any other practice ?Should we converge on the same standard ? with a rename in future version with apriori openupgrade file ?Personally I prefer oca, but it probably needs to be voted !?What do you think?RegardsThanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Nhomar G Hernández
Vauxoo | CEO
¡Construyamos algo genial!
Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomarMéxico · Venezuela · Costa Rica · Perú
by Nhomar Hernández - 10:46 - 15 Dec 2022 -
Re: Module name, name collision
Hello,It could be contextual, if we find that a better name would reflect what the module does.However, I would go with an `_oca` suffix by default to avoid the name collision.Cheers,YannickOn Tue, 22 Nov 2022 at 16:17, David Beal <notifications@odoo-community.org> wrote:Hi all,It seems there are miscellaneous practices to deal with name collision in OCA, mainly regarding Odoo SA module nameshere mgmt is usedhere and in some other repos oca is usedIs there any other practice ?Should we converge on the same standard ? with a rename in future version with apriori openupgrade file ?Personally I prefer oca, but it probably needs to be voted !?What do you think?RegardsThanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Yannick Payot - 05:26 - 15 Dec 2022
-
-
OCA - RFQ - Improving the Documentation of Open Upgrade
Hello OCA Contributors.Have you seen our latest RFQ for improving the Open Upgrade Documentation?
Please have a look here if you are interested in responding:Send your proposals in by December 4th. We look forward to hearing from you.Warmest regards,
Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 12:01 - 22 Nov 2022 -
Question about migration of account.tax and related entity (in my case on l10n_be)
Dear community, I'm currently migrating a database from version 9.0 to version 14.0. My problem is between 12.0 and 13.0 where accounting element has changed. The database is using Mis Builder to generate accounting reports. These reports are based on account.account.tag that are linked to account.tax (and also account.move.line in 13.0). As I have seen, in 9.0 (and until 12.0), account.account.tag are linked to an account.tax via a simple field tag_ids : https://github.com/OCA/OCB/blob/12.0/addons/account/models/account.py#L937 Starting from 13.0, tags are no more linked to account.tax directly. They are linked to an account.tax.repartition.line which is linked to an account.account.tax. https://github.com/OCA/OCB/blob/13.0/addons/account/models/account.py#L1340-L1341 In 13.0, the account.chart.template has been updated accordingly. As is, the migration did not succeed. At some point, odoo try to remove the old account.tag. But that's not possible because these tags are linked to existing account.move.line. https://github.com/OCA/OCB/blob/13.0/addons/account/models/account_move.py#L2792-L2796 To avoid such deletetion, I flagged existing account.account.tag as noupdate=True. When migrating the database the existing all account.account.tag linked to the account.tax are moved to all the account.tax.repartition.line of the account.tax. Meaning that if there is account.account.tag named "03", "49", "54" that are all linked to an account.tax. After migration each line of account.tax.repartition.line will have "03", "49" and "54" as tags. This does not reflect the new account.chart.template for belgium. So my first intention was to update the account.tax, particulary their account.tax.repartition.line to replace the old account.account.tag by the new one created during the migration. Using the new account.chart.template as an example. But that does not works, because existing account.move.line always points to the old account.account.tag. I have no idea how to update the tags on the account.move.line to reflects the new account.chart.template and the new tags. I tried to find the logic that computes tags on an account.move.line. But it's really obscure for me. And simply applying the following recompute method does not works (it causses issue about non balanced account element): https://github.com/OCA/OCB/blob/13.0/addons/account/models/account_move.py#L990-L1049 Anther option is to map the old tags to the new one. But here comes the problem that there is more new tags than old ones. So that I'm not sure how to perform the mapping. For example the following records: https://github.com/OCA/OCB/blob/12.0/addons/l10n_be/data/account_tax_template_data.xml#L16-L19 https://github.com/OCA/OCB/blob/13.0/addons/l10n_be/data/account_tax_report_data.xml#L45-L52 In 13.0 the account.account.tag created have sign. There exist two version for the tag 03: SELECT name, applicability, tax_negate FROM account_account_tag WHERE name ILIKE '%03'; name | applicability | tax_negate ---------------------------+---------------+------------ Belgium VAT Form: grid 03 | taxes | <- the old one -03 | taxes | t <-| +03 | taxes | f <-L the two new ones (3 rows) Should I replace the old "03" tag by the "+03" one, or should I sometimes replace it by the "-03" and when ? When this will be solved, I will still be wondering if such a line is ok ? SELECT account_move_line_id, name FROM account_account_tag_account_move_line_rel AS aatamlr JOIN account_account_tag AS aat ON aatamlr.account_account_tag_id = aat.id WHERE account_move_line_id = 9166; account_move_line_id | name ----------------------+--------------------------- 9166 | Belgium VAT Form: grid 03 9166 | Belgium VAT Form: grid 54 9166 | Belgium VAT Form: grid 49 9166 | Belgium VAT Form: grid 64 Where we see that an account.move.line is linked to 4 differents account.account.tag. I also take a look at this: - https://github.com/OCA/OCB/blob/12.0/addons/account/models/chart_template.py#L14-L52 - https://github.com/OCA/OCB/blob/13.0/addons/account/models/chart_template.py#L14-L31 But it does not seams to solve the previous issue. And finaly I looked at account_chart_update module, but it did not seams to solve the previous issues niether. https://github.com/OCA/account-financial-tools/tree/14.0/account_chart_update If you have any clue, it will be very helpfull. :) Regards, -- Rémy Taymans @ Coop IT Easy +32 493 02 69 85 - <https://github.com/remytms> <https://coopiteasy.be>
by Rémy Taymans - 04:06 - 21 Nov 2022-
Re: Question about migration of account.tax and related entity (in my case on l10n_be)
Dear Tom, Dear Danny, Thank you very much for your help. I will look at the resources you mentioned. :) Best regards, -- Rémy Taymans @ Coop IT Easy +32 493 02 69 85 - <https://github.com/remytms> <https://coopiteasy.be> Quoting Tom Blauwendraat (2022-11-22 15:46:48) > Hi Remy, > > We had the same problem in the migration of a few of our Dutch customers. My colleague Danny who is not on this list (yet, but he will sign up) worked on that and says the following: > > ----------------------------------------- > > Dear Remy, > > We have had a very similar thing happen in our migration from 10 to 14, between 12 and 13 yes. Although some of the things you mentioned we did not encounter, I had no problem with account.account.tag's being deleted for example. > > Part of the problem with the tags is this, in 13.0 a new model, called account.tax.report.line has been introduced. Now in 13, some tags are defined in xml files as account.tax.report.line instead of account.account.tag (as they were before). The report line model is responsible for creating new account.account.tag records in python, prefixed with a minus and plus sign. > > So you are dealing with new account.account.tag records, while all your account move lines and other stuff is still linked to the old account.account.tag records. There is no direct link to old and new tag records, so you kind of have to 'know' which old account.account.tag records are replaced with which new account.tax.report.line records, and then you could map them. > I took the route of remapping the old tags to the new tags, and that work can be viewed here: https://github.com/OCA/OpenUpgrade/blob/13.0/addons/l10n_nl/migrations/13.0.3.0/post-migration.py > I've moved some of the code into helper functions: https://github.com/OCA/openupgradelib/blob/master/openupgradelib/openupgrade_130.py > So I hope it will be easy enough to use those helper functions in your own script. Or maybe the convert_old_tax_tags_into_new_report_line_tags function of l10n_nl could even be completely reused? This is the function that does the mapping. > > Best regards, > Danny de Jong > > ------------------ > > With the following PS: ---> I noticed that the "l10n_be" migration scripts are missing from OpenUpgrade so that was the same as we encountered for l10n_nl
by Rémy Taymans - 05:35 - 22 Nov 2022 -
Re: Question about migration of account.tax and related entity (in my case on l10n_be)
Hi Remy,
We had the same problem in the migration of a few of our Dutch customers. My colleague Danny who is not on this list (yet, but he will sign up) worked on that and says the following:
-----------------------------------------
Dear Remy,
We have had a very similar thing happen in our migration from 10 to 14, between 12 and 13 yes. Although some of the things you mentioned we did not encounter, I had no problem with account.account.tag's being deleted for example.
Part of the problem with the tags is this, in 13.0 a new model, called account.tax.report.line has been introduced. Now in 13, some tags are defined in xml files as account.tax.report.line instead of account.account.tag (as they were before). The report line model is responsible for creating new account.account.tag records in python, prefixed with a minus and plus sign.
So you are dealing with new account.account.tag records, while all your account move lines and other stuff is still linked to the old account.account.tag records. There is no direct link to old and new tag records, so you kind of have to 'know' which old account.account.tag records are replaced with which new account.tax.report.line records, and then you could map them.
I took the route of remapping the old tags to the new tags, and that work can be viewed here: https://github.com/OCA/OpenUpgrade/blob/13.0/addons/l10n_nl/migrations/13.0.3.0/post-migration.py
Best regards,
I've moved some of the code into helper functions: https://github.com/OCA/openupgradelib/blob/master/openupgradelib/openupgrade_130.py
So I hope it will be easy enough to use those helper functions in your own script. Or maybe the convert_old_tax_tags_into_new_report_line_tags function of l10n_nl could even be completely reused? This is the function that does the mapping.
Danny de Jong
------------------
With the following PS: ---> I noticed that the "l10n_be" migration scripts are missing from OpenUpgrade so that was the same as we encountered for l10n_nl
------------------------------------------
On 11/21/22 16:07, Rémy Taymans wrote:
Dear community, I'm currently migrating a database from version 9.0 to version 14.0. My problem is between 12.0 and 13.0 where accounting element has changed. The database is using Mis Builder to generate accounting reports. These reports are based on account.account.tag that are linked to account.tax (and also account.move.line in 13.0). As I have seen, in 9.0 (and until 12.0), account.account.tag are linked to an account.tax via a simple field tag_ids : https://github.com/OCA/OCB/blob/12.0/addons/account/models/account.py#L937 Starting from 13.0, tags are no more linked to account.tax directly. They are linked to an account.tax.repartition.line which is linked to an account.account.tax. https://github.com/OCA/OCB/blob/13.0/addons/account/models/account.py#L1340-L1341 In 13.0, the account.chart.template has been updated accordingly. As is, the migration did not succeed. At some point, odoo try to remove the old account.tag. But that's not possible because these tags are linked to existing account.move.line. https://github.com/OCA/OCB/blob/13.0/addons/account/models/account_move.py#L2792-L2796 To avoid such deletetion, I flagged existing account.account.tag as noupdate=True. When migrating the database the existing all account.account.tag linked to the account.tax are moved to all the account.tax.repartition.line of the account.tax. Meaning that if there is account.account.tag named "03", "49", "54" that are all linked to an account.tax. After migration each line of account.tax.repartition.line will have "03", "49" and "54" as tags. This does not reflect the new account.chart.template for belgium. So my first intention was to update the account.tax, particulary their account.tax.repartition.line to replace the old account.account.tag by the new one created during the migration. Using the new account.chart.template as an example. But that does not works, because existing account.move.line always points to the old account.account.tag. I have no idea how to update the tags on the account.move.line to reflects the new account.chart.template and the new tags. I tried to find the logic that computes tags on an account.move.line. But it's really obscure for me. And simply applying the following recompute method does not works (it causses issue about non balanced account element): https://github.com/OCA/OCB/blob/13.0/addons/account/models/account_move.py#L990-L1049 Anther option is to map the old tags to the new one. But here comes the problem that there is more new tags than old ones. So that I'm not sure how to perform the mapping. For example the following records: https://github.com/OCA/OCB/blob/12.0/addons/l10n_be/data/account_tax_template_data.xml#L16-L19 https://github.com/OCA/OCB/blob/13.0/addons/l10n_be/data/account_tax_report_data.xml#L45-L52 In 13.0 the account.account.tag created have sign. There exist two version for the tag 03: SELECT name, applicability, tax_negate FROM account_account_tag WHERE name ILIKE '%03'; name | applicability | tax_negate ---------------------------+---------------+------------ Belgium VAT Form: grid 03 | taxes | <- the old one -03 | taxes | t <-| +03 | taxes | f <-L the two new ones (3 rows) Should I replace the old "03" tag by the "+03" one, or should I sometimes replace it by the "-03" and when ? When this will be solved, I will still be wondering if such a line is ok ? SELECT account_move_line_id, name FROM account_account_tag_account_move_line_rel AS aatamlr JOIN account_account_tag AS aat ON aatamlr.account_account_tag_id = aat.id WHERE account_move_line_id = 9166; account_move_line_id | name ----------------------+--------------------------- 9166 | Belgium VAT Form: grid 03 9166 | Belgium VAT Form: grid 54 9166 | Belgium VAT Form: grid 49 9166 | Belgium VAT Form: grid 64 Where we see that an account.move.line is linked to 4 differents account.account.tag. I also take a look at this: - https://github.com/OCA/OCB/blob/12.0/addons/account/models/chart_template.py#L14-L52 - https://github.com/OCA/OCB/blob/13.0/addons/account/models/chart_template.py#L14-L31 But it does not seams to solve the previous issue. And finaly I looked at account_chart_update module, but it did not seams to solve the previous issues niether. https://github.com/OCA/account-financial-tools/tree/14.0/account_chart_update If you have any clue, it will be very helpfull. :) Regards, -- Rémy Taymans @ Coop IT Easy +32 493 02 69 85 - <https://github.com/remytms> <https://coopiteasy.be>
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Tom Blauwendraat - 03:46 - 22 Nov 2022
-
-
New OCA Delegates and Financial Auditors Campaign Open
Hello OCA Contributors,
I hope this finds you all well.
We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.Dora Jurcevic
Pierre Verkest
Jacques-Etienne Baudoux
Gijs-Jan Otten
Héctor Villarreal Ortega
Emeric Panisset
Quentin Dupont
Jean-Charles Drubay
Danny Adair
Nikolina Todorova
We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.
The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.
The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.
We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.Have a great week,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 05:11 - 14 Nov 2022-
Re: New OCA Delegates and Financial Auditors Campaign Open
Congratulations and welcome, and hope to see at least as many applications as this year for 2023!How many Delegates do we have now?--
Virginie0477/64.17.20-----Original Message-----From: Maxime Chambreuil <notifications@odoo-community.org>Reply-To: Odoo Community Association (OCA) Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: Re: New OCA Delegates and Financial Auditors Campaign OpenDate: Mon, 14 Nov 2022 21:56:47 -0000Congratulations to the new elected delegates and welcome to the party!MAXIME CHAMBREUIL
DIRECTOR GENERAL LATAMM: +52 (442) 114-9164 / WhatsApp
E: MChambreuil@OpenSourceIntegrators.comAv. Paseo Tuna 18a, Local 217, Colonia Zibatá
El Marqués, Querétaro, 76269, México
On Mon, Nov 14, 2022 at 3:51 PM Jay Vora <notifications@odoo-community.org> wrote:Congratulations and good luck to Delegates!On Mon, 14 Nov 2022 at 8:17 AM, Rebecca Gellatly <notifications@odoo-community.org> wrote:Hello OCA Contributors,
I hope this finds you all well.
We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.Dora Jurcevic
Pierre Verkest
Jacques-Etienne Baudoux
Gijs-Jan Otten
Héctor Villarreal Ortega
Emeric Panisset
Quentin Dupont
Jean-Charles Drubay
Danny Adair
Nikolina Todorova
We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.
The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.
The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.
We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.Have a great week,Rebecca
by Virginie Dewulf. - 06:30 - 15 Nov 2022 -
Re: New OCA Delegates and Financial Auditors Campaign Open
Congratulations to the new elected delegates and welcome to the party!MAXIME CHAMBREUIL
DIRECTOR GENERAL LATAMM: +52 (442) 114-9164 / WhatsApp
E: MChambreuil@OpenSourceIntegrators.comAv. Paseo Tuna 18a, Local 217, Colonia Zibatá
El Marqués, Querétaro, 76269, México
On Mon, Nov 14, 2022 at 3:51 PM Jay Vora <notifications@odoo-community.org> wrote:Congratulations and good luck to Delegates!--On Mon, 14 Nov 2022 at 8:17 AM, Rebecca Gellatly <notifications@odoo-community.org> wrote:Hello OCA Contributors,
I hope this finds you all well.
We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.Dora Jurcevic
Pierre Verkest
Jacques-Etienne Baudoux
Gijs-Jan Otten
Héctor Villarreal Ortega
Emeric Panisset
Quentin Dupont
Jean-Charles Drubay
Danny Adair
Nikolina Todorova
We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.
The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.
The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.
We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.Have a great week,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Technology Services @ www.serpentcs.comBusiness Solutions @ www.serpentcs.inEnterprise Mobile Apps @ www.odooonline.comQuality Assurance @ www.odooqa.comSAP Hana @ www.prozone-tech.comPortal & DMS @ www.alfray.inRegards,----------------------------------------------------------------------------------------------------------------------------Jay Vora Managing Director 
Direct: +91-9879354457 Office: +91-9033472982 Skype: jaynvora Twitter : jaynvora -------------------------------------------------------------------------------------------------
Visit our website : http://www.serpentcs.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 Maxime Chambreuil - 10:55 - 14 Nov 2022 -
Re: New OCA Delegates and Financial Auditors Campaign Open
Congratulations and good luck to Delegates!--On Mon, 14 Nov 2022 at 8:17 AM, Rebecca Gellatly <notifications@odoo-community.org> wrote:Hello OCA Contributors,
I hope this finds you all well.
We've completed the Delegates campaign and now welcome 10 new Delegates to the OCA.Dora Jurcevic
Pierre Verkest
Jacques-Etienne Baudoux
Gijs-Jan Otten
Héctor Villarreal Ortega
Emeric Panisset
Quentin Dupont
Jean-Charles Drubay
Danny Adair
Nikolina Todorova
We were extremely fortunate this year with 23 members in total applying. Thank you to everyone who participated. It was energising to see so many great names put forward and I am sure for those voting it was difficult to choose just 10.
The process is now for the existing and new Delegates who wish to apply to become Board members, to do so - this stage closes on the 25th of November. The applicant survey has been shared on the Delegates mailing list.
The Financial Auditors campaign is now open too. The applicants for this do not need to be Delegates or Members, if you or someone in your organisation is interested in applying please complete this survey.
We'll keep you posted on the results of the voting in about a month's time when the Annual General Assembly is complete.Have a great week,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Technology Services @ www.serpentcs.comBusiness Solutions @ www.serpentcs.inEnterprise Mobile Apps @ www.odooonline.comQuality Assurance @ www.odooqa.comSAP Hana @ www.prozone-tech.comPortal & DMS @ www.alfray.inRegards,----------------------------------------------------------------------------------------------------------------------------Jay Vora Managing Director 
Direct: +91-9879354457 Office: +91-9033472982 Skype: jaynvora Twitter : jaynvora -------------------------------------------------------------------------------------------------
Visit our website : http://www.serpentcs.com
by Jay Vora - 10:51 - 14 Nov 2022
-
PSC Members and Representatives - please complete activities for 2022 OCA AGA
HI all,
We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.
Please if you haven't had a chance have a look at the working document here and fill in what you have been up to over the year.
I'll close this off next Wednesday the 16th, so you've got a week ;)
It doesn't need to be a long post, just a quick summary of what has been accomplished.
Thank you in advance.
Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 02:26 - 9 Nov 2022-
Re: PSC Members and Representatives - please complete activities for 2022 OCA AGA
Very much appreciated Nicolas! Thank you.On Wed, 9 Nov 2022 at 14:42, Nicolas Rodriguez <notifications@odoo-community.org> wrote:Hello Rebecca, I’m a quite new PSC but I completed the document with information of what I has been doing to payroll modules even before of becoming PSC.
Hope it helps. Regards.El 8 de nov. de 2022 22:26 -0300, Rebecca Gellatly <notifications@odoo-community.org>, escribió:
HI all,
We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.
Please if you haven't had a chance have a look at the working document here and fill in what you have been up to over the year.
I'll close this off next Wednesday the 16th, so you've got a week ;)
It doesn't need to be a long post, just a quick summary of what has been accomplished.
Thank you in advance.
Rebecca--
Rebecca GellatlyGeneral SecretaryOdoo Community Association_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 02:56 - 9 Nov 2022 -
Re: PSC Members and Representatives - please complete activities for 2022 OCA AGA
Hello Rebecca, I’m a quite new PSC but I completed the document with information of what I has been doing to payroll modules even before of becoming PSC.
Hope it helps. Regards.El 8 de nov. de 2022 22:26 -0300, Rebecca Gellatly <notifications@odoo-community.org>, escribió:
HI all,
We've had a bit of response to my previous email as we check-in for the year on how everyone has gotten on.
Please if you haven't had a chance have a look at the working document here and fill in what you have been up to over the year.
I'll close this off next Wednesday the 16th, so you've got a week ;)
It doesn't need to be a long post, just a quick summary of what has been accomplished.
Thank you in advance.
Rebecca--
Rebecca GellatlyGeneral SecretaryOdoo Community Association_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Nicolas Rodriguez Sande - 02:41 - 9 Nov 2022
-
-
Inventory report / valuation loading time
Hi,do you have any solutions/suggestions to speed up inventory reports/valuation loading time?Thanks!--Francesco ForestiSicurpharma Srl
by Francesco Foresti - 12:51 - 7 Nov 2022-
Re: Inventory report / valuation loading time
Hi Francesco,For things like this, I use a SQL query, creating a new model, based on a database view. Here's a query that works for me in v12.Mattwith a as (
select
pp.id as product_id,
pc.id as category_id,
aa.id as account_id
from product_product pp
left join product_template pt on pt.id=pp.product_tmpl_id
left join product_category as pc on pc.id=pt.categ_id
left join ir_property as ip on ip.res_id='product.category,'||pt.categ_id and ip.name='property_stock_valuation_account_id'
left join account_account as aa on 'account.account,'||aa.id=ip.value_reference
where pt.type='product'
--and pt.active=true
)
select
pp.default_code,
pt.name as product_name,
pc.name as cat_name,
pt.type as product_type,
pt.tracking,
pt.active,
pt.deprecated,
uu.name as uom,
round(mv.avail_qty, 0) as stock_qty,
av.acct_value,
round(av.acct_qty, 0),
av.acct_qty - mv.avail_qty as diff
from a
left join (
select
a.product_id,
sum(aml.balance) as acct_value,
sum(aml.quantity) as acct_qty
from a
left join account_move_line as aml on aml.product_id=a.product_id and aml.account_id=a.account_id
left join account_move as am on am.id=aml.move_id
where am.state='posted'
and aml.date<'2022-01-01'
group by a.product_id
) as av on av.product_id=a.product_id
left join (
select
sm.product_id,
sum(
case when (ls.usage<>'internal' and ld.usage='internal') then sm.product_qty
else -sm.product_qty end
) as avail_qty
from stock_move as sm
left join stock_location as ls on ls.id=sm.location_id
left join stock_location as ld on ld.id=sm.location_dest_id
where sm.state='done'
and sm.date<'2022-01-01'
and (
(ls.usage<>'internal' and ld.usage='internal')
or
(ld.usage<>'internal' and ls.usage='internal')
)
group by sm.product_id
) as mv on mv.product_id=av.product_id
left join product_product as pp on pp.id=a.product_id
left join product_template as pt on pt.id=pp.product_tmpl_id
left join product_category as pc on pc.id=a.category_id
left join uom_uom as uu on uu.id=pt.uom_id
where pc.name like 'RM - %'
and av.acct_value<>0
and coalesce(mv.avail_qty, 0.0)<>0.0On Mon, Nov 7, 2022 at 5:12 AM Frederik Kramer <notifications@odoo-community.org> wrote:Hi Francesco,
that is genuinly one to the more ressource hungry processes in Odoo (and of course all ERP systems). It heavily depends on what report you exactly execute, configuration parameters like (use of serial numbers, concrete valuation method, amount of stock locations to consider) and last but certainly not least the overall amount of stock moves in you database (that are a subset of the concrete report under investigation), version of Odoo that you are using and many more.
As far as i know there is no simple method that helps everywhere (as the problem origins can be vast), but i would recommend to analyze / profile first what actually takes so much time while processing the report in the calculation before taking any measure in whatever direction. Depending on the version of Odoo you are using and the landscape you are running there are different tools to profile. If you tell us the version that you are running, the amount of stock movel lines and stock locations we are speaking about an generally a bit more detail about your case i am sure some more technical people among our community can recommend that to exactly analyze first.
Best Frederik
Am 07.11.22 um 12:51 schrieb Francesco Foresti:
Hi,
do you have any solutions/suggestions to speed up inventory reports/valuation loading time?
Thanks!
--
Francesco ForestiSicurpharma Srl_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Phone: +49 4181 13503-12 Fax: +49 4181 13503-10 Mobil: +49 179 3901819 Email: frederik.kramer@initos.com Web: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 Steuer-Nr: 15/200/53247 USt-IdNr.: DE815580155
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Matt - 08:18 - 7 Nov 2022 -
Re: Inventory report / valuation loading time
Hi Francesco,
that is genuinly one to the more ressource hungry processes in Odoo (and of course all ERP systems). It heavily depends on what report you exactly execute, configuration parameters like (use of serial numbers, concrete valuation method, amount of stock locations to consider) and last but certainly not least the overall amount of stock moves in you database (that are a subset of the concrete report under investigation), version of Odoo that you are using and many more.
As far as i know there is no simple method that helps everywhere (as the problem origins can be vast), but i would recommend to analyze / profile first what actually takes so much time while processing the report in the calculation before taking any measure in whatever direction. Depending on the version of Odoo you are using and the landscape you are running there are different tools to profile. If you tell us the version that you are running, the amount of stock movel lines and stock locations we are speaking about an generally a bit more detail about your case i am sure some more technical people among our community can recommend that to exactly analyze first.
Best Frederik
Am 07.11.22 um 12:51 schrieb Francesco Foresti:
Hi,
do you have any solutions/suggestions to speed up inventory reports/valuation loading time?
Thanks!
--
Francesco ForestiSicurpharma Srl_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Phone: +49 4181 13503-12 Fax: +49 4181 13503-10 Mobil: +49 179 3901819 Email: frederik.kramer@initos.com Web: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 Steuer-Nr: 15/200/53247 USt-IdNr.: DE815580155
by Frederik Kramer - 01:10 - 7 Nov 2022
-


