- Mailing Lists
- Contributors
- Re: Address format in SEPA XML files
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: Address format in SEPA XML files
FWIW manually stripping <PstCd> and <AdrLine> from the XML solved this, probably forcing hybrid mode acceptance from Triodos Bank.
Looking at our own address information versus the specs provided, as being parsed in a v14 XML:
<Nm>Therp BV</Nm> <PstlAdr> <PstCd>3812 NR</PstCd> <TwnNm>Amersfoort</TwnNm> <Ctry>NL</Ctry> <AdrLine>Oude Fabriekstraat 1 2/2.14</AdrLine> </PstlAdr>
3) Under the unstructured address format, PSUs and scheme participants provide the address
of the payer and/or of the payee with a maximum of 2 occurrences of the unstructured
address element “Address Line” <AdrLine>, possibly in combination with the structured
address element “Country” <Ctry>1. [...]
Meaning we were good before...
4) The provision of a structured address about the payer and/or the payee for EPC payments
must comply with following requirements:
• Data element “Address Line” <AdrLine> cannot be used [...]
5) The hybrid address is a mix of structured and unstructured address details. It allows the
combination of structured ISO 20022 address elements and up to two occurrences of 70
characters of unstructured “Address Line” <AdrLine>. [...] The structured
elements “Country” <Ctry> and “Town Name” <TwnNm> are mandatory.
Emphasis mine, and I'd say the bank is out of order for rejecting our address per 5) but I suppose standards could be giving them some leeway.
We have the same issue with bank-payment 14.0 modules generating files that are now not accepted by the Dutch Triodos bank.
On 10/30/25 10:27, Victor Champonnois wrote:
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
by Gijs-Jan Otten - 02:46 - 30 Oct 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 - 10:26 - 30 Oct 2025-
Re: Address format in SEPA XML files
FWIW manually stripping <PstCd> and <AdrLine> from the XML solved this, probably forcing hybrid mode acceptance from Triodos Bank.
Looking at our own address information versus the specs provided, as being parsed in a v14 XML:
<Nm>Therp BV</Nm> <PstlAdr> <PstCd>3812 NR</PstCd> <TwnNm>Amersfoort</TwnNm> <Ctry>NL</Ctry> <AdrLine>Oude Fabriekstraat 1 2/2.14</AdrLine> </PstlAdr>
3) Under the unstructured address format, PSUs and scheme participants provide the address
of the payer and/or of the payee with a maximum of 2 occurrences of the unstructured
address element “Address Line” <AdrLine>, possibly in combination with the structured
address element “Country” <Ctry>1. [...]
Meaning we were good before...
4) The provision of a structured address about the payer and/or the payee for EPC payments
must comply with following requirements:
• Data element “Address Line” <AdrLine> cannot be used [...]
5) The hybrid address is a mix of structured and unstructured address details. It allows the
combination of structured ISO 20022 address elements and up to two occurrences of 70
characters of unstructured “Address Line” <AdrLine>. [...] The structured
elements “Country” <Ctry> and “Town Name” <TwnNm> are mandatory.Emphasis mine, and I'd say the bank is out of order for rejecting our address per 5) but I suppose standards could be giving them some leeway.
On 10/30/25 12:22, Tom Blauwendraat wrote:
We have the same issue with bank-payment 14.0 modules generating files that are now not accepted by the Dutch Triodos bank.
On 10/30/25 10:27, Victor Champonnois wrote:
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
by Gijs-Jan Otten - 02:46 - 30 Oct 2025 -
Re: Address format in SEPA XML files
FWIW manually stripping <PstCd> and <AdrLine> from the XML solved this, probably forcing hybrid mode acceptance from Triodos Bank.
Looking at our own address information versus the specs provided, as being parsed in a v14 XML:
<Nm>Therp BV</Nm> <PstlAdr> <PstCd>3812 NR</PstCd> <TwnNm>Amersfoort</TwnNm> <Ctry>NL</Ctry> <AdrLine>Oude Fabriekstraat 1 2/2.14</AdrLine> </PstlAdr>
3) Under the unstructured address format, PSUs and scheme participants provide the address
of the payer and/or of the payee with a maximum of 2 occurrences of the unstructured
address element “Address Line” <AdrLine>, possibly in combination with the structured
address element “Country” <Ctry>1. [...]
4)The provision of a structured address about the payer and/or the payee for EPC payments
must comply with following requirements:
• Data element “Address Line” <AdrLine> cannot be used [...]
5) The hybrid address is a mix of structured and unstructured address details. It allows the
combination of structured ISO 20022 address elements and up to two occurrences of 70
characters of unstructured “Address Line” <AdrLine>. [...] The structured
elements “Country” <Ctry> and “Town Name” <TwnNm> are mandatory.Emphasis mine.
I'd say the bank is out of order for rejecting our address per 5), but I suppose standards could be giving them some leeway.
Minimum viable solution here seems to be stripping everything but <Ctry> and <TwnNm>.
On 10/30/25 12:22, Tom Blauwendraat wrote:
We have the same issue with bank-payment 14.0 modules generating files that are now not accepted by the Dutch Triodos bank.
On 10/30/25 10:27, Victor Champonnois wrote:
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
by Gijs-Jan Otten - 02:40 - 30 Oct 2025 -
Re: Address format in SEPA XML files
We have the same issue with bank-payment 14.0 modules generating files that are now not accepted by the Dutch Triodos bank.
On 10/30/25 10:27, Victor Champonnois wrote:
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
by Tom Blauwendraat - 12:20 - 30 Oct 2025 -
Re: Address format in SEPA XML files
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/e0ccf2d734c1aaea5e26f826c030eb57d392b04fOn 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.AlexisLe 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
by Alexis de Lattre - 11:10 - 30 Oct 2025 -
Re: Address format in SEPA XML files
Hi,As far as I understand, this concerns the account payment modules of the OCA? For 16 (I haven't checked for 12), as far as I understand, the node TwnNm (City) is missing in the address block, which, according to the aforementioned EPC document, is mandatory in hybrid mode along with Ctry (Country). This means that version 16 still uses the unstructured format.The code i looked at: https://github.com/OCA/bank-payment/blob/37ed97c155bdba85b79b5a8227b76b95c6294cdb/account_banking_pain_base/models/account_payment_order.py#L530Regarding the street, i.e., the separation of name and number: in Odoo Enterprise, both (i.e., partner.street and partner.street2) are handled using AdrLine. The OCA module does this as well (except for street2) and will hopefully be processed in the same way.Best regards,ChristianVon: "Victor Champonnois" <notifications@odoo-community.org>
An: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
Gesendet: Donnerstag, 30. Oktober 2025 10:27:31
Betreff: Address format in SEPA XML filesHello 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
by Christian Zöllner - 11:06 - 30 Oct 2025
-