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
-
RE: Module that encrypt printed PDF, which require password to open.
When signing the file, you are not encrypting it, you are avoiding modification of the file.Enric Tobella Alomaretobella@creublanca.esCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Rafael Blasco <rblasco@rbnpro.com>
To: "Contributors" <contributors@odoo-community.org>
Date: Tue, 22 Dec 2020 23:22:25 -0000
Subject: RE: Module that encrypt printed PDF, which require password to open.
Hello,We have been using from Odoo v8 this one: https://github.com/OCA/reporting-engine/tree/12.0/report_qweb_signer“sign PDFs using a PKCS#12 certificate” = EncryptRegards,RafaelDe: Enric Tobella [mailto:etobella@creublanca.es]
Enviado el: jueves, 17 de diciembre de 2020 15:17
Para: Contributors <contributors@odoo-community.org>
Asunto: Re: Module that encrypt printed PDF, which require password to open.Sure, all yours ;) Keep the commit history and start improving :)Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: "Kitti Upariphutthiphong" <kittiu@ecosoft.co.th>
To: "Contributors" <contributors@odoo-community.org>
Date: Thu, 17 Dec 2020 12:32:12 -0000
Subject: Re: Module that encrypt printed PDF, which require password to open.
Eric,Thanks so much. Can I take it to OCA v14? Will be discussing with you along the way. :)On Thu, 17 Dec 2020, 16:52 Enric Tobella, <etobella@creublanca.es> wrote:I found the module I did that allows to set the password when generating the file.Enric Tobella AlomarCentros Médicos Creu BlancaTel: 902 202 230Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Jordi Ballester Alomar <jordi.ballester@forgeflow.com>
To: "Odoo Community Association (OCA) Contributors" <contributors@odoo-community.org>, Enric Tobella <etobella@creublanca.es>
Date: Thu, 17 Dec 2020 10:42:52 +0100
Subject: Re: Module that encrypt printed PDF, which require password to open.
@Enric Tobella you did sonething, did you?El jue., 17 dic. 2020 10:22, Kitti Upariphutthiphong <kittiu@ecosoft.co.th> escribió:Dear community,May I check if anyone had done something already about encrypt printed PDF, which require password to open the file.Thank you,Kitti U._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.
by Enric Tobella Alomar - 10:26 - 23 Dec 2020 -
Re: E-commerce mass reconcile
+1
You actually need 2 bank accounts, 1 for your payment acquirer and one for the bank. From the accounting point of view (in France at least), you cannot record the 100€ paiements on your bank account since they are paid on another account.
Rgds
Le 22/12/2020 à 19:37, Houssine BAKKALI a écrit :
you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).
Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.
On 22/12/2020 10:32, Harald Panten Lopez wrote:
Hi Community,
I have a use case that I can't properly solve. Let's see if you have had this use case.
1- I have an e-commerce where I sell my products.
2- I have my payment methods properly set.
3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).
4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.
5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.
How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?
I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.
Thank you for your ideas!--
Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona
_______________________________________________
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 v.regouby - 10:11 - 23 Dec 2020 -
Re: Help on account_multicurrency_revaluation
And the issue has been reported, and even easily reproducible and explainableOn 22 Dec 2020, at 14:26, Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Hi Graeme,Yep, that makes sense. I’d support claim that Odoo has a major bug somewhere, at least when you do “Validate” on USD bank account (when you have EUR as main currency) and then reconcile that outstanding payment to a USD bill - no FX entries seem to be generatedI’ll try to debug this specific module since from code what I see it should’ve worked even with bank accounts properly, so it must be something with my dataKind regards,AlexeyOn 22 Dec 2020, at 11:22, Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Alexey,As I say I don't really know the module. You are talking half an hour of easy work once a quarter at most so never really saw the need for it. However do not be convinced it is the module causing the problem. I have seen these strange revaluations with nothing but vanilla Odoo. In fact I am almost certain that Odoo has a major bug here as it relates to FX valuations as I've seen very similar transactions in companies with vanilla Odoo and only one enabled currency.On Tue, Dec 22, 2020 at 11:02 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Hi Graeme,Indeed, both unpaid invoices and bills are making unrealized amount that needs to be revaluated, and foreign currencies are pretty much the same - “unrealized” amount from operating currency point of view. The the thing about that module that is completely unclear to me is this picture:What exactly did it do? It took following exchange rates22 Jun 2016 1 EUR to AUD = 1.50658130 Sep 2016 1 EUR to AUD = 1.467449Took one (why that one?) transaction:100 / 1.506581 = 66.37100 / 1.467449 = 68.14and wrote that difference to the to the bank account, making 0.0 AUD and 1.78 EUR as resulting balance. What makes no sense, at least to me.That logic would be perfectly valid for AR and AP, I guess, but for liquidity it probably should’ve been:1. Take ending balance in liquidity currency (0.0 AUD)2. Convert it to operating currency: 0.0 AUD / 1.506581 = 0.0 EUR3. Write difference between current balance of liquidity in EUR and actual value to balance it outWhat am I missing?On 22 Dec 2020, at 09:47, Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Alexey,Been a while since I had to go through foreign currency in detail. I don't really know the module but I did a lot with Odoo and mis_builder in this space.Now from your email it appears you are converting an account currency to a functional currency for reporting purposes. We must value that fairly as we must do for any liquidity accounts. If you think about it, a liquidity account is nothing more than a debtor when in debit, and a creditor when in credit (from your perspective). Ultimately someone owes someone else money. IAS 21 covers most of what you ask. para 16, 17, 23(a) 28 and 29.Therefore the contra will end up on the P&L because realized or unrealized it is a true and fair view of those accounts at balance date. This is the easy side of balance date type valuation issues. Ordinarily I'd just reverse them out on the first day of new year, and then when the actual transactions flowed through everything squares up.On Tue, Dec 22, 2020 at 8:36 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Dear contributors,I’m in dire need of help regarding account_multicurrency_revaluation and what it actually supposed to do.I’ve experimented with it a bit and it seems (at least to my current understanding) that it does following:On AR & AP accounts it revaluates unpaid amounts of foreign currency, effectively making entries about “Unrealized currency gains/losses”But also by default it affects Liquidity accounts (bank accounts), making entries that seem to duplicate ones that Odoo makes when a multi-currency transaction is reconciled, effectively making some sort of “Realized currency gain/loss revaluations”. This completely falls beyond my understanding what it supposed to do, and why.Also, I’m looking for a module that would do “bank balance revaluation”, account_multicurrency_revaluation is clearly not about that.Any help would be greatly appreciatedKind regards,Alexey_______________________________________________
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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Alexey Pelykh - 05:30 - 23 Dec 2020 -
RE: Module that encrypt printed PDF, which require password to open.
Hello,
We have been using from Odoo v8 this one: https://github.com/OCA/reporting-engine/tree/12.0/report_qweb_signer
“sign PDFs using a PKCS#12 certificate” = Encrypt
Regards,
Rafael
De: Enric Tobella [mailto:etobella@creublanca.es]
Enviado el: jueves, 17 de diciembre de 2020 15:17
Para: Contributors <contributors@odoo-community.org>
Asunto: Re: Module that encrypt printed PDF, which require password to open.Sure, all yours ;) Keep the commit history and start improving :)
Enric Tobella Alomar
Centros Médicos Creu Blanca
Tel: 902 202 230
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: "Kitti Upariphutthiphong" <kittiu@ecosoft.co.th>
To: "Contributors" <contributors@odoo-community.org>
Date: Thu, 17 Dec 2020 12:32:12 -0000
Subject: Re: Module that encrypt printed PDF, which require password to open.
Eric,
Thanks so much. Can I take it to OCA v14? Will be discussing with you along the way. :)
On Thu, 17 Dec 2020, 16:52 Enric Tobella, <etobella@creublanca.es> wrote:
I found the module I did that allows to set the password when generating the file.
Enric Tobella Alomar
Centros Médicos Creu Blanca
Tel: 902 202 230
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación.From: Jordi Ballester Alomar <jordi.ballester@forgeflow.com>
To: "Odoo Community Association (OCA) Contributors" <contributors@odoo-community.org>, Enric Tobella <etobella@creublanca.es>
Date: Thu, 17 Dec 2020 10:42:52 +0100
Subject: Re: Module that encrypt printed PDF, which require password to open.
@Enric Tobella you did sonething, did you?
El jue., 17 dic. 2020 10:22, Kitti Upariphutthiphong <kittiu@ecosoft.co.th> escribió:
Dear community,
May I check if anyone had done something already about encrypt printed PDF, which require password to open the file.
Thank you,
Kitti U.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Tanto este mensaje como los documentos que, en su caso, lleve como anexos,
pueden contener información reservada y/o confidencial, destinada exclusivamente
para el uso del destinatario o la persona responsable de entregarlo al mismo,
estando su uso no autorizado prohibido legalmente.
Su contenido no constituye un compromiso para Creu Blanca (la empresa remitente)
salvo ratificación escrita por ambas partes. En caso de su recepción por error,
rogamos nos lo comunique por igual vía, se abstenga de realizar copias del mensaje
o documentos adjuntos, remitirlo o facilitarlo a un tercero, y proceda en su defecto,
a su eliminación._______________________________________________
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 (Moduon) - 12:21 - 23 Dec 2020 -
Re: E-commerce mass reconcile
That's exactly what we do at Commown, using a module very similar to Sebastien's stripe move import module but for slimpay.
Work's pretty well !Le 22 décembre 2020 19:37:31 GMT+01:00, Houssine BAKKALI <houssine@coopiteasy.be> a écrit :
-- Envoyé de /e/ Mail.v>you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).
Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.
On 22/12/2020 10:32, Harald Panten Lopez wrote:
Hi Community,
I have a use case that I can't properly solve. Let's see if you have had this use case.
1- I have an e-commerce where I sell my products.
2- I have my payment methods properly set.
3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).
4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.
5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.
How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?
I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.
Thank you for your ideas!--
Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona
_______________________________________________
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 Florent Cayré - 10:40 - 22 Dec 2020 -
Re: E-commerce mass reconcile
Thanks for your suggestions 👍I'll try!El mar, 22 dic 2020 a las 19:37, Houssine BAKKALI (<houssine@coopiteasy.be>) escribió:you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).
Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.
On 22/12/2020 10:32, Harald Panten Lopez wrote:
Hi Community,
I have a use case that I can't properly solve. Let's see if you have had this use case.
1- I have an e-commerce where I sell my products.
2- I have my payment methods properly set.
3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).
4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.
5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.
How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?
I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.
Thank you for your ideas!--
Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona
_______________________________________________
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
--Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona
by Harald Panten Lopez - 08:16 - 22 Dec 2020 -
Re: E-commerce mass reconcile
you could manage your payment acquirer like a bank account so you have to import all the payment transaction from you payment acquirer (10 transaction of 100€).
Then you manage the 1000€ transfer from the acquire to you bank account like an usual bank transfer between to of your bank account.
On 22/12/2020 10:32, Harald Panten Lopez wrote:
Hi Community,
I have a use case that I can't properly solve. Let's see if you have had this use case.
1- I have an e-commerce where I sell my products.
2- I have my payment methods properly set.
3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).
4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.
5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.
How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?
I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.
Thank you for your ideas!--
Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Houssine BAKKALI - 07:36 - 22 Dec 2020 -
-
Re: Downtime of the OCA services today
Error on the OCA site regarding the recaptcha:
Op 12/18/20 om 9:06 PM schreef Simone Orsi:
All seems good! Thank you Alex and migration team! :)
On Fri, Dec 18, 2020 at 5:41 PM Jairo Llopis <jairo.llopis@tecnativa.com> wrote:
Did you manage to do the discord-matrix bridging?
I'll have a look :)
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Simone Orsi
Full stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
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 - 05:41 - 22 Dec 2020 -
Re: Downtime of the OCA services today
Oh ok, I miss it. Thank you Yoshi.On Tue, 22 Dec 2020, 10:17 Yoshi Tashiro, <tashiro@quartile.co> wrote:Hi Kitti, clear the browser cache as Pedro suggested?--Yoshi TashiroOn Tue, Dec 22, 2020 at 11:42 AM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Thank you very much Alex.FYI,- Goto https://odoo-community.org/shop/
- Click on any module there is error message when the page is loaded.
Traceback: Error: QWeb2: Template 'portal.Chatter' not found at Object.exception (https://odoo-community.org/web/content/932138-cfdf3c5/1/web.assets_common_lazy.js:3593:7) at Engine._render (https://odoo-community.org/web/content/932138-cfdf3c5/1/web.assets_common_lazy.js:3638:103) at Engine.render (https://odoo-community.org/web/content/932138-cfdf3c5/1/web.assets_common_lazy.js:3634:151) at Class.renderElement (https://odoo-community.org/web/content/932138-cfdf3c5/1/web.assets_common_lazy.js:3995:1137) at https://odoo-community.org/web/content/932138-cfdf3c5/1/web.assets_common_lazy.js:4005:6 at async Promise.all (index 1) at async Promise.all (index 0) at async Promise.all (index 63) at async Promise.all (index 1)On Sat, Dec 19, 2020 at 11:42 AM Jay Vora <vora.jay@serpentcs.com> wrote:Thank you Rockstars, publish a documentary of the steps, might be a good idea.--On Sat, 19 Dec 2020 at 1:36 AM, Simone Orsi <simahawk@gmail.com> wrote:All seems good! Thank you Alex and migration team! :)On Fri, Dec 18, 2020 at 5:41 PM Jairo Llopis <jairo.llopis@tecnativa.com> wrote:Did you manage to do the discord-matrix bridging?I'll have a look :)_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Simone OrsiFull stack Python web developer, Odoo specialist, Odoo Community Board Member, Freelance in love with open source._______________________________________________
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
_______________________________________________
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:20 - 22 Dec 2020 -
Re: Pywebdriver in the OCA
+1 I briefly discussed that with fkantelberg of our team and for now its seem arguments are for instance - no need for local postgres installation - windows support - flask usage - extensible architecture - .... But there is probaly much more. Best Frederik Am Dienstag, den 22.12.2020, 14:52 +0000 schrieb Pedro M. Baeza (Tecnativa): > Yeah, it could be interesting. I think the minimum for having it in > OCA is: > > - Having a decent CI for not lowering contribution quality. > - Extended README, explaining the reasoning for having it and > advantages over existing IoTBox. > > Regards. > _______________________________________________ > 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 An der Eisenbahn 1 21224 Rosengarten Phone: +49 4105 56156-12 Fax: +49 4105 56156-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: Rosengarten – Klecken Amtsgericht Tostedt, HRB 205226 Steuer-Nr: 15/200/53247 USt-IdNr.: DE815580155
by Frederik Kramer - 03:56 - 22 Dec 2020 -
Re: Pywebdriver in the OCA
Yeah, it could be interesting. I think the minimum for having it in OCA is:- Having a decent CI for not lowering contribution quality.- Extended README, explaining the reasoning for having it and advantages over existing IoTBox.Regards.
by Pedro M. Baeza - 03:50 - 22 Dec 2020 -
Re: Pywebdriver in the OCA
Great, thanks Pierrick!--
Virginie0477/64.17.20--Si vous avez un contrat de support, posez-nous vos question à l'adresse "support@coopiteasy.be"--Lors de l'envoi d'un mail, renseignez le nom de la structure pour laquelle vous travaillez. Merci.-------- Message initial --------De: "Roussel, Denis" <denis.roussel@acsone.eu>Répondre à: Odoo Community Association (OCA) Contributors <contributors@odoo-community.org>À: Contributors <contributors@odoo-community.org>Objet: Re: Pywebdriver in the OCADate: Tue, 22 Dec 2020 14:32:01 -0000Great!Thanks for digging up that subject.IMHO, this could be an interesting value added for OCA.On Tue, Dec 22, 2020 at 3:16 PM Pierrick Brun <pierrick.brun@akretion.com> wrote:Hello everyone,
As some of you might know, at Akretion we use a replacement tool for
the IoT box, which is called Pywebdriver.
We are currently maintaining it with other OCA members like Acsone or
GRAP.
We thought this could be a good idea to have this tool under the OCA
umbrella to ease the workflows around it.
Since this differs from the usual repositories the OCA manages, I
created an issue to discuss around this possible inclusion:
https://github.com/akretion/pywebdriver/issues/57
Looking forward to read from you about this !
--
Pierrick Brun
Akretion
_______________________________________________
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. - 03:36 - 22 Dec 2020 -
Re: Pywebdriver in the OCA
Great!Thanks for digging up that subject.IMHO, this could be an interesting value added for OCA.On Tue, Dec 22, 2020 at 3:16 PM Pierrick Brun <pierrick.brun@akretion.com> wrote:Hello everyone, As some of you might know, at Akretion we use a replacement tool for the IoT box, which is called Pywebdriver. We are currently maintaining it with other OCA members like Acsone or GRAP. We thought this could be a good idea to have this tool under the OCA umbrella to ease the workflows around it. Since this differs from the usual repositories the OCA manages, I created an issue to discuss around this possible inclusion: https://github.com/akretion/pywebdriver/issues/57 Looking forward to read from you about this ! -- Pierrick Brun Akretion
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--__________________________________________
Denis Roussel
Software Engineer
Acsone SA, Succursale de Liège (Val Benoît)
Tel : +32 2 888 31 49
Fax : +32 2 888 31 59
Gsm : +32 472 22 00 57Acsone sa/nv
Boulevard de la Woluwe 56 Woluwedal | B-1200 Brussels | BelgiumQuai Banning, 6 (Val Benoît) | B-4000 Liège | Belgium
Zone Industrielle 22 | L-8287 Kehlen | Luxembourg
by Denis Roussel - 03:30 - 22 Dec 2020 -
Pywebdriver in the OCA
Hello everyone, As some of you might know, at Akretion we use a replacement tool for the IoT box, which is called Pywebdriver. We are currently maintaining it with other OCA members like Acsone or GRAP. We thought this could be a good idea to have this tool under the OCA umbrella to ease the workflows around it. Since this differs from the usual repositories the OCA manages, I created an issue to discuss around this possible inclusion: https://github.com/akretion/pywebdriver/issues/57 Looking forward to read from you about this ! -- Pierrick Brun Akretion
by Pierrick Brun - 03:15 - 22 Dec 2020 -
Re: Help on account_multicurrency_revaluation
Hi Graeme,Yep, that makes sense. I’d support claim that Odoo has a major bug somewhere, at least when you do “Validate” on USD bank account (when you have EUR as main currency) and then reconcile that outstanding payment to a USD bill - no FX entries seem to be generatedI’ll try to debug this specific module since from code what I see it should’ve worked even with bank accounts properly, so it must be something with my dataKind regards,AlexeyOn 22 Dec 2020, at 11:22, Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Alexey,As I say I don't really know the module. You are talking half an hour of easy work once a quarter at most so never really saw the need for it. However do not be convinced it is the module causing the problem. I have seen these strange revaluations with nothing but vanilla Odoo. In fact I am almost certain that Odoo has a major bug here as it relates to FX valuations as I've seen very similar transactions in companies with vanilla Odoo and only one enabled currency.On Tue, Dec 22, 2020 at 11:02 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Hi Graeme,Indeed, both unpaid invoices and bills are making unrealized amount that needs to be revaluated, and foreign currencies are pretty much the same - “unrealized” amount from operating currency point of view. The the thing about that module that is completely unclear to me is this picture:What exactly did it do? It took following exchange rates22 Jun 2016 1 EUR to AUD = 1.50658130 Sep 2016 1 EUR to AUD = 1.467449Took one (why that one?) transaction:100 / 1.506581 = 66.37100 / 1.467449 = 68.14and wrote that difference to the to the bank account, making 0.0 AUD and 1.78 EUR as resulting balance. What makes no sense, at least to me.That logic would be perfectly valid for AR and AP, I guess, but for liquidity it probably should’ve been:1. Take ending balance in liquidity currency (0.0 AUD)2. Convert it to operating currency: 0.0 AUD / 1.506581 = 0.0 EUR3. Write difference between current balance of liquidity in EUR and actual value to balance it outWhat am I missing?On 22 Dec 2020, at 09:47, Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Alexey,Been a while since I had to go through foreign currency in detail. I don't really know the module but I did a lot with Odoo and mis_builder in this space.Now from your email it appears you are converting an account currency to a functional currency for reporting purposes. We must value that fairly as we must do for any liquidity accounts. If you think about it, a liquidity account is nothing more than a debtor when in debit, and a creditor when in credit (from your perspective). Ultimately someone owes someone else money. IAS 21 covers most of what you ask. para 16, 17, 23(a) 28 and 29.Therefore the contra will end up on the P&L because realized or unrealized it is a true and fair view of those accounts at balance date. This is the easy side of balance date type valuation issues. Ordinarily I'd just reverse them out on the first day of new year, and then when the actual transactions flowed through everything squares up.On Tue, Dec 22, 2020 at 8:36 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Dear contributors,I’m in dire need of help regarding account_multicurrency_revaluation and what it actually supposed to do.I’ve experimented with it a bit and it seems (at least to my current understanding) that it does following:On AR & AP accounts it revaluates unpaid amounts of foreign currency, effectively making entries about “Unrealized currency gains/losses”But also by default it affects Liquidity accounts (bank accounts), making entries that seem to duplicate ones that Odoo makes when a multi-currency transaction is reconciled, effectively making some sort of “Realized currency gain/loss revaluations”. This completely falls beyond my understanding what it supposed to do, and why.Also, I’m looking for a module that would do “bank balance revaluation”, account_multicurrency_revaluation is clearly not about that.Any help would be greatly appreciatedKind regards,Alexey_______________________________________________
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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Alexey Pelykh - 02:30 - 22 Dec 2020 -
Re: E-commerce mass reconcile
HiOn our side we use the following modules from account-reconcile (V12) not yet migrated in V14This modules for importing a move based on the payment info given by the bank (10*100€ payment + one transfert of 1000€)Note here you have an example with stripe https://github.com/OCA/account-reconcile/pull/315Then with account_mass_reconcile we automatically reconcile the invoice with the paymentWe used this process since openerp 6.1 (module had different name before)Le mar. 22 déc. 2020 à 10:32, Harald Panten Lopez <harald.panten@sygel.es> a écrit :Hi Community,I have a use case that I can't properly solve. Let's see if you have had this use case.1- I have an e-commerce where I sell my products.2- I have my payment methods properly set.3- Imagine that I sell 10 products today, to 10 different customers. Each product costs 100€, so... I sold 1.000€ (in total).4- I'll Have 10 different invoices, for 10 different customers. Each invoice for an amount of 100€.5- Tomorrow, my payment acquirer will transfer 1.000€ to my bank account, but he'll not specify any customer. These 1.000€ would be transferred in the same statement line.How can I easily reconcile these 1.000€ with my 10 different invoices avoiding the manual reconciliation? How do you manage these situation?I've been checking the account-reconcile repository but I wasn't able to find any appropriate solution.Thank you for your ideas!--Harald Panten López
CEO
Sygel Technology S.L

+34 637 88 42 41 
harald.panten@sygel.es 
https://www.sygel.es 
C/ Àlaba 61, 5ª planta, 08005, Barcelona _______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Sébastien Beau - 02:20 - 22 Dec 2020 -
Re: Help on account_multicurrency_revaluation
Hi Alexey,As I say I don't really know the module. You are talking half an hour of easy work once a quarter at most so never really saw the need for it. However do not be convinced it is the module causing the problem. I have seen these strange revaluations with nothing but vanilla Odoo. In fact I am almost certain that Odoo has a major bug here as it relates to FX valuations as I've seen very similar transactions in companies with vanilla Odoo and only one enabled currency.On Tue, Dec 22, 2020 at 11:02 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Hi Graeme,Indeed, both unpaid invoices and bills are making unrealized amount that needs to be revaluated, and foreign currencies are pretty much the same - “unrealized” amount from operating currency point of view. The the thing about that module that is completely unclear to me is this picture:What exactly did it do? It took following exchange rates22 Jun 2016 1 EUR to AUD = 1.50658130 Sep 2016 1 EUR to AUD = 1.467449Took one (why that one?) transaction:100 / 1.506581 = 66.37100 / 1.467449 = 68.14and wrote that difference to the to the bank account, making 0.0 AUD and 1.78 EUR as resulting balance. What makes no sense, at least to me.That logic would be perfectly valid for AR and AP, I guess, but for liquidity it probably should’ve been:1. Take ending balance in liquidity currency (0.0 AUD)2. Convert it to operating currency: 0.0 AUD / 1.506581 = 0.0 EUR3. Write difference between current balance of liquidity in EUR and actual value to balance it outWhat am I missing?On 22 Dec 2020, at 09:47, Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Alexey,Been a while since I had to go through foreign currency in detail. I don't really know the module but I did a lot with Odoo and mis_builder in this space.Now from your email it appears you are converting an account currency to a functional currency for reporting purposes. We must value that fairly as we must do for any liquidity accounts. If you think about it, a liquidity account is nothing more than a debtor when in debit, and a creditor when in credit (from your perspective). Ultimately someone owes someone else money. IAS 21 covers most of what you ask. para 16, 17, 23(a) 28 and 29.Therefore the contra will end up on the P&L because realized or unrealized it is a true and fair view of those accounts at balance date. This is the easy side of balance date type valuation issues. Ordinarily I'd just reverse them out on the first day of new year, and then when the actual transactions flowed through everything squares up.On Tue, Dec 22, 2020 at 8:36 PM Alexey Pelykh <alexey.pelykh@gmail.com> wrote:Dear contributors,I’m in dire need of help regarding account_multicurrency_revaluation and what it actually supposed to do.I’ve experimented with it a bit and it seems (at least to my current understanding) that it does following:On AR & AP accounts it revaluates unpaid amounts of foreign currency, effectively making entries about “Unrealized currency gains/losses”But also by default it affects Liquidity accounts (bank accounts), making entries that seem to duplicate ones that Odoo makes when a multi-currency transaction is reconciled, effectively making some sort of “Realized currency gain/loss revaluations”. This completely falls beyond my understanding what it supposed to do, and why.Also, I’m looking for a module that would do “bank balance revaluation”, account_multicurrency_revaluation is clearly not about that.Any help would be greatly appreciatedKind regards,Alexey_______________________________________________
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 Graeme Gellatly - 11:21 - 22 Dec 2020 -
Re: Discord rooms bridged over to Matrix
Oh BTW. We didn't bridge the #track-1-trainings, #track-2-trainings and #support rooms from the OCA Days because those should be probably archived already. We can set up those bridges later if needed for the next event.
by Jairo Llopis - 11:16 - 22 Dec 2020 -
Discord rooms bridged over to Matrix
Hi contributors.For those of you who use Matrix to communicate, good news! João Marques and me, from Tecnativa, have worked on setting up the bridge with Discord.We have set up the +oca:matrix.org community. You can join it freely. From there, you can see all the public rooms, which are bridged over to OCA's Discord server. We took the chance to also include in the list the bridged rooms for #oca and #openobject IRC channels in freenode.net, although I guess these days less and less people attend those.Before you ask:- You don't need to have a discord account to talk to discord people from matrix.
- You don't need to have a matrix account to talk to matrix people from discord.
Just use the chat system you prefer, and the bridge will handle the rest.Someone with permissions, please add instructions to https://odoo-community.org/page/talk (both for discord and matrix, and maybe even IRC).This was the tl;dr. More details below:- We created all rooms on the public matrix.org homeserver. Yes, it would have been nicer to host a OCA homeserver, but we felt like this was the easiest way to get up and running without impacting in OCA's maintenance.
- We used https://t2bot.io/discord/ appservice bridge to bridge the discord community. Again, we could have self-hosted the bridge, but same reasons apply.
- As such, if you want to support those helpful tools, you can donate to Matrix (details on matrix.org website) and/or to t2bot. Maybe OCA board itself can consider that, given these are open source SaaS services that are saving infrastructure costs.
- Private Discord rooms are not bridged because the appservice bot has no access to them. I consider this is better because it allows board members to focus on a single permissions system. However that can be also bridged if needed (by adding permissions to the matrix-appservice-discord-t2bot role in the discord server). I should lose my permissions soon, so I leave that comment here for oca board members.
- I'll stick around in all matrix rooms for a while, just to be sure it all works fine. But I'll leave rooms that are not interesting to me later.
- We tried to bridge Discord's #general channel to Freenode's #oca channel, but that would mean self-hosting the IRC bridge. I don't think it's worth it, so we just added the IRC autobridged rooms to the community, in case somebody still wants to track them from Matrix.
- You can join from Matrix to specific rooms without necessarily being part of the community.
- Communities is an area that is getting a big refactor lately in the Matrix world. We expect some changes regarding this, and will possibly convert it into a Communities V2 or Matrix Space once that's settled. For now, we have this.
by Jairo Llopis - 11:11 - 22 Dec 2020