OFBiz & SEPA (IBAN)

[Pierre Smits-3]

Hi All,

SEPA (Single European Payments Area) [1] is an payment-integration
initiative of the European Union, that is in play in the 28 member states
of the EU and the 4 member states of the EFTA (as well as Andorra, Monaco
and San Marino). It is intended to simplify bank transfers in Euro, as well
as cross-border transfers in and out of the eurozone countries, and is
standardised by ISO 20022 [2]. SEPA clearance is based on the IBAN
bank-account identification[3] (which has been adopted in over 70 countries
worldwide).

I have started working on a solution, that will (ultimately):

   1. register parties as banks, register bank accounts and associate these
   with banks and other parties (customers, suppliers, employees, etc.);
   2. process bank statements in camt.053.002.01 format, with
      1. processing statement entries as OFBiz financial account
      transactions (entity FinAccountTrans);
      2. processing payments from customer and suppliers as OFBiz payments
      (entity Payment);
      3. processing these payments as OFBiz payment applications against
      invoices (entity PaymentApplication), where possible;
   3.
   4. store the bank statements in the db as xml (optional) and/or as a
   file in CMS (optional);
   5. generate outgoing SEPA Credit Transfer (SCT) and SEPA Instant Credit
   Transfer (SCT inst) messages for invoice payment, and other payments, e.g.
   salaries, etc.)
   6. work with, and generate messages for SEPA Direct Debit (SDD).

Currently I have completed aspect 1, and I am making great strides in
aspect 2.

Is there an interest to have such a solution publicly available as a
pluggable OFBiz component? If so, please let me know (please also let me
know which OFBiz version you have implemented, or which version(s) you - as
an integrator - are developing for).


[1] https://en.wikipedia.org/wiki/Single_Euro_Payments_Area
[2] https://en.wikipedia.org/wiki/ISO_20022
[3] https://en.wikipedia.org/wiki/International_Bank_Account_Number


Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer

[Jacques Le Roux]

Hi Pierre,

Thanks for your work, I'll have a look as soon as I get a chance.

It should not be soon, I'm engaged in other volunteer tasks in OFBiz...

Jacques


Le 26/11/2018 à 10:51, Pierre Smits a écrit :

> Hi All,
>
> SEPA (Single European Payments Area) [1] is an payment-integration
> initiative of the European Union, that is in play in the 28 member states
> of the EU and the 4 member states of the EFTA (as well as Andorra, Monaco
> and San Marino). It is intended to simplify bank transfers in Euro, as well
> as cross-border transfers in and out of the eurozone countries, and is
> standardised by ISO 20022 [2]. SEPA clearance is based on the IBAN
> bank-account identification[3] (which has been adopted in over 70 countries
> worldwide).
>
> I have started working on a solution, that will (ultimately):
>
>     1. register parties as banks, register bank accounts and associate these
>     with banks and other parties (customers, suppliers, employees, etc.);
>     2. process bank statements in camt.053.002.01 format, with
>        1. processing statement entries as OFBiz financial account
>        transactions (entity FinAccountTrans);
>        2. processing payments from customer and suppliers as OFBiz payments
>        (entity Payment);
>        3. processing these payments as OFBiz payment applications against
>        invoices (entity PaymentApplication), where possible;
>     3.
>     4. store the bank statements in the db as xml (optional) and/or as a
>     file in CMS (optional);
>     5. generate outgoing SEPA Credit Transfer (SCT) and SEPA Instant Credit
>     Transfer (SCT inst) messages for invoice payment, and other payments, e.g.
>     salaries, etc.)
>     6. work with, and generate messages for SEPA Direct Debit (SDD).
>
> Currently I have completed aspect 1, and I am making great strides in
> aspect 2.
>
> Is there an interest to have such a solution publicly available as a
> pluggable OFBiz component? If so, please let me know (please also let me
> know which OFBiz version you have implemented, or which version(s) you - as
> an integrator - are developing for).
>
>
> [1] https://en.wikipedia.org/wiki/Single_Euro_Payments_Area
> [2] https://en.wikipedia.org/wiki/ISO_20022
> [3] https://en.wikipedia.org/wiki/International_Bank_Account_Number
>
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>

[Pierre Smits-3]

Hi Jacques,

Thank you for your interest. While work is not completed yet, we can
schedule a demo/walk-through.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Thu, Nov 29, 2018 at 11:04 AM Jacques Le Roux <
[hidden email]> wrote:

> Hi Pierre,
>
> Thanks for your work, I'll have a look as soon as I get a chance.
>
> It should not be soon, I'm engaged in other volunteer tasks in OFBiz...
>
> Jacques
>
>
> Le 26/11/2018 à 10:51, Pierre Smits a écrit :
> > Hi All,
> >
> > SEPA (Single European Payments Area) [1] is an payment-integration
> > initiative of the European Union, that is in play in the 28 member states
> > of the EU and the 4 member states of the EFTA (as well as Andorra, Monaco
> > and San Marino). It is intended to simplify bank transfers in Euro, as
> well
> > as cross-border transfers in and out of the eurozone countries, and is
> > standardised by ISO 20022 [2]. SEPA clearance is based on the IBAN
> > bank-account identification[3] (which has been adopted in over 70
> countries
> > worldwide).
> >
> > I have started working on a solution, that will (ultimately):
> >
> >     1. register parties as banks, register bank accounts and associate
> these
> >     with banks and other parties (customers, suppliers, employees, etc.);
> >     2. process bank statements in camt.053.002.01 format, with
> >        1. processing statement entries as OFBiz financial account
> >        transactions (entity FinAccountTrans);
> >        2. processing payments from customer and suppliers as OFBiz
> payments
> >        (entity Payment);
> >        3. processing these payments as OFBiz payment applications against
> >        invoices (entity PaymentApplication), where possible;
> >     3.
> >     4. store the bank statements in the db as xml (optional) and/or as a
> >     file in CMS (optional);
> >     5. generate outgoing SEPA Credit Transfer (SCT) and SEPA Instant
> Credit
> >     Transfer (SCT inst) messages for invoice payment, and other
> payments, e.g.
> >     salaries, etc.)
> >     6. work with, and generate messages for SEPA Direct Debit (SDD).
> >
> > Currently I have completed aspect 1, and I am making great strides in
> > aspect 2.
> >
> > Is there an interest to have such a solution publicly available as a
> > pluggable OFBiz component? If so, please let me know (please also let me
> > know which OFBiz version you have implemented, or which version(s) you -
> as
> > an integrator - are developing for).
> >
> >
> > [1] https://en.wikipedia.org/wiki/Single_Euro_Payments_Area
> > [2] https://en.wikipedia.org/wiki/ISO_20022
> > [3] https://en.wikipedia.org/wiki/International_Bank_Account_Number
> >
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> privileges)
> > since 2008*
> > Apache Steve <https://steve.apache.org>, committer
> >
>
>