Add payment reference number and types

[sonikf]

Feature Request

Payment reference number mainly helps companies identify payments.

Use case

Using payment reference number in invoices and PDF(invoice, proposal, order) makes it easy for debtor to quickly pay and for creditor upon receipt of the payment, to link the payment to their sales invoice.

Types

International

Customer code, contract ref, invoice ref or a combination can be used as a unique payment id.

Europe

Through Single Euro Payments Area (SEPA) banks already implement various methods.

1. Belgium is using the so called Structured communication based on ISO 20022 standard.
   https://support.nickel.eu/en-be/how-do-i-create-structured-communication-when-making-transfer

2. Finland is using its own implementation of Structured Creditor Reference(RF), based on
   ISO 11649 with a string of 4-20 characters based on the invoice number.

3. Germany, Greece, Switzerland and possibly other countries are using Structured Creditor Reference(RF), an international business standard based also on ISO 11649 implementation with an alphanumeric string, up to 25 characters long which adds more flexibility as it can also be used per third party.

relevant link
https://www.dolibarr.org/forum/t/how-are-you-using-dolibarr-without-being-able-to-issue-payment-reference-numbers/24929/22
https://pbs.twimg.com/media/ECkcCF-U4AAoJ0c.jpg:large

Suggested implementation

• Add field payment_reference in llx_facture table
• Add field tp_payment_reference in llx_societe table

• Add method to create user configurable payment_reference using Customer code, contract ref, invoice ref or a combination.
• Commit NEW Invoice - Generate payment information - Structured communication #31376 for Belgian type
• Add QR code for Finnish RF
• Add Finnish legacy payment reference
• Add Finnish legacy payment barcode (PDF) / virtual barcode (email)
• Add methods for "European" RF generation and QR code support
• Structured communication in sepa xml NEW Prelevement - Use structured payment data for Belgium #31383
• Add RF in sepa xml
• Add FI/RF in sepa xml
• Add payment_reference in EPC QR code and Swiss QR-Bill

• Add option for user to select payment reference type
• Add per third party RF generation options like customer/vendor code in societe/card.php
• Show selected type generated field in validated invoice, proposal, sales cards
• Add payment_reference in relevant PDF templates

Suggested steps

No response

[sonikf]

@aspangaro
Thank you!
I started working on international RF.
As from 18 November 2024, it will be no longer necessary to use a Finnish creditor reference as the basis for generating an RF Creditor Reference, so changes must be made there too.
Maybe @mikko80 can help.
Can you or @eldy create an empty repo to collaborate on this as it has many moving parts and planning and discussion required!

[mikko80]

Also need to add Finnish legacy payment reference and Finnish legacy payment barcode (PDF) / virtual barcode (email).
Does we have any place to collaborate?

[sonikf]

Anyone willing to collaborate on this please state your intention here so you can be added as a team member in https://github.com/DoliGreece/payment-reference

[eldy]

@aspangaro Thank you! I started working on international RF. As from 18 November 2024, it will be no longer necessary to use a Finnish creditor reference as the basis for generating an RF Creditor Reference, so changes must be made there too. Maybe @mikko80 can help. Can you or @eldy create an empty repo to collaborate on this as it has many moving parts and planning and discussion required!

May be you can use you own repo so you can manage everything yourself...

[sonikf]

Thanks @eldy
I already did, she my previous comment