- Mailing Lists
- Contributors
- Re: Address format in SEPA XML files
Archives
- By thread 1472
-
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 57
- December 2025 33
- January 2026 63
- February 2026 48
Contributors
contributors@odoo-community.org
Re: Address format in SEPA XML files
by Tom Blauwendraat - 09:15 - 17 Dec 2025
Reference
-
Address format in SEPA XML files
Hello OCA Contributors,
There is an ongoing change in the european regulation regarding the format of address in Sepa direct debit and Sepa credit transfer XML files. See here for the presentation of the regulation and here for the full spec.Banks in Belgium are already rejecting some XML files generated from the version 12 and 16 of account_banking_sepa_credit_transfer.
There are two possible formats : structured and hybrid. Using the structured format doesn't seem possible because it requires the street name and number to be separated. In Odoo both pieces of information are in the same field. The hybrid format should therefore be used, but from what I see, the XML files already seem to be consistent with this format.
Have you encountered the same problems ? Or do you have more information about this issue ?
Thank you and have a nice day,
-- Victor Champonnois - Coop IT Easy
by Victor Champonnois - 10:26 - 30 Oct 2025-
Re: Address format in SEPA XML files
My understanding was that vanilla odoo can only support the hybrid format, because for the more detailed format you need street and housenumber separated, which you either need to guessculate or you need to use an oca module to have the data differently in your db, which not all customers have. So i think the hybrid format is a better default. But Alexis might have a different view?
by Tom Blauwendraat - 09:15 - 17 Dec 2025 -
Re: Address format in SEPA XML files
Le mar. 16 déc. 2025 à 10:57, Victor Champonnois <notifications@odoo-community.org> a écrit :--We are not ready to deploy your "big" PR in production yet. So we will isolate the part of the code that makes the correction in a separate PR. Is it OK for you if we propose this PR to the OCA ?
Of course ! Feel free to take code from OCA/bank-payment-alternative to improve OCA/bank-payment !BTW, you don't need to ask my permission, the AGPL licence permits you to do that ; you just have to keep the name of the authors of the code.Alexis de Lattre
by Alexis de Lattre - 04:06 - 17 Dec 2025 -
Re: Address format in SEPA XML files
Yes sorry for not responding, we worked from Alexis's PR and made this PR : https://github.com/OCA/bank-payment/pull/1535
This enforces the structured format, not the hybrid format as in your PR. I don't know which is best though.
Victor Champonnois - Coop IT Easy
On 16/12/25 14:03, Tom Blauwendraat wrote:
Victor, it would be nice if you can respond to the comment that I made on there. So that maybe the PR can be simplified
by Victor Champonnois - 04:41 - 16 Dec 2025 -
Re: Address format in SEPA XML files
Yes, it's my colleague's PR, it's the work I mentionned. He was quicker than I planned ^^
Victor Champonnois - Coop IT Easy
On 16/12/25 14:02, Pedro M. Baeza wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Victor Champonnois - 04:41 - 16 Dec 2025 -
Re: Address format in SEPA XML files
We had started on something here:
https://github.com/OCA/bank-payment/pull/1528
Victor, it would be nice if you can respond to the comment that I made on there. So that maybe the PR can be simplified
On 12/16/25 10:57, Victor Champonnois wrote:
Thank you for your reply Alexis.
We are not ready to deploy your "big" PR in production yet. So we will isolate the part of the code that makes the correction in a separate PR. Is it OK for you if we propose this PR to the OCA ?
Have a nice day,
Victor Champonnois - Coop IT Easy
On 30/10/25 11:12, Alexis de Lattre wrote:
Dear Victor,
I was aware of this change from unstructured addresses to structured addresses in SEPA XML files, as described in the EPC specs. To anticipate this change, I worked on it in august 2024, cf this commit on account_banking_pain_base https://github.com/akretion/banking/commit/e0ccf2d734c1aaea5e26f826c030eb57d392b04f
On v16.0, structured addresses in SEPA credit transfer XML files and SEPA direct debit XML files is implemented in my "big" PR here : https://github.com/OCA/bank-payment/pull/1174I am fully aware of the problem with the separation of street name and number. I didn't want account_banking_pain_base to depend on base_address_extended, because it would be a very big impact for a very small need.My implementation strategy was the following :- if base_address_extended is installed, it use the fields added by that module- if base_address_extended is not installed, I separate street number and street name "on the fly" with code. It's not always perfect, it works most of the time and, when it doesn't work, the street number is empty and the street name has the whole street field.Cf the code :you can have a look at the method _improved_street_split() at line 99.
Look at the test suite to see the result with real life content :
In 18.0, it is implemented in OCA/bank-payment-alternative (which was created from my "big" PR on 16.0 #1174) :The only change is that the module account_banking_pain_base has been renamed to account_banking_sepa_base.
Porting this on OCA/bank-payment should be pretty easy.
Alexis
Le jeu. 30 oct. 2025 à 10:27, Victor Champonnois <notifications@odoo-community.org> a écrit :
Hello OCA Contributors,
There is an ongoing change in the european regulation regarding the format of address in Sepa direct debit and Sepa credit transfer XML files. See here for the presentation of the regulation and here for the full spec.Banks in Belgium are already rejecting some XML files generated from the version 12 and 16 of account_banking_sepa_credit_transfer.
There are two possible formats : structured and hybrid. Using the structured format doesn't seem possible because it requires the street name and number to be separated. In Odoo both pieces of information are in the same field. The hybrid format should therefore be used, but from what I see, the XML files already seem to be consistent with this format.
Have you encountered the same problems ? Or do you have more information about this issue ?
Thank you and have a nice day,
-- Victor Champonnois - Coop IT Easy_______________________________________________
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 Tom Blauwendraat - 02:00 - 16 Dec 2025
-