1. Mailing Lists
  2. Switzerland
  3. Re: BVR/ESR for UBS Bank accounts / l10n_ch_payment_slip (Odoo 8)

Switzerland mailing list archives

switzerland@odoo-community.org

Browse archives

Avatar

Re: BVR/ESR for UBS Bank accounts / l10n_ch_payment_slip (Odoo 8)

by
Camptocamp SA, Yannick Payot
- 18/10/2016 11:00:53
Hello Steven,

I assume you use Odoo version 8.0 or version 9.0

BVR/ESR reference is computed this way:

It is the adherent number (X), the invoice number (Y) and the move line id (id of the move line in database) (Z) and a single digit of checksum (C). Plus it is filled with zeros between the adhérent number and the invoice number.

XX XXXXX 00000 00000 00YYY YYYZC

Later invoice number will be shifted on the left to let the space to move line id.

XX XXXXX 00000 0000Y YYYYY ZZZZC

Move line id is needed in such case as multipayment terms as you will need a different reference number for each payment.

If you want an other behavior, you should probably make your own module and change the behaviour of method `compute_ref` in l10n_ch_payment_slip/models/payment_slip.py

About the amount this is in the scan line not in the 27 characters reference.

It is placed in the 0100000160003> part of the scan line. (160.00 CHF in this exemple)

Regards,

Yannick Vaucher
Business Solutions Software Developer

Camptocamp SA
PSE A, CH-1015 Lausanne
Phone: +41 21 619 10 30
Office: +41 21 619 10 10

On 28 September 2016 at 19:53, Steven Uggowitzer <whotopia@gmail.com> wrote:
I have received a number of pre-printed BVR+ forms for my UBS company account.  These have no client nor amount fields (obviously) in the BVR line 042> 
What I am trying to do based on the data from these forms, and UBS guide is to set up BVR invoicing for clients.


UBS Postfinance adherent number is 01-145-6 (which is what I put into the BVR Account/IBAN Number Field). This works fine.

I have received a sequence of reference numbers from the bank something like 61909 00001 -> 61909 00xxx
-- I set up a BVR journal sales account and sequence so that internally to Odoo, I can match this up.

So I'm running into some problems (though I may not fully understand the BVR line specification).

The checksum that Odoo generates for the Referenz-Nr field seems to be 3 digits at the end before the +. But the standard is 1 digit???

So the referenz-Nr, in my case should be:
>30 xxxxx yyyyy zzzz6 19090 0xxxC+

Where xxxxx yyyyy zzzz is a variant on my bank account number

And finally C is a single digit checksum.

But the best I have managed to do in Odoo is get the referenz-Nr:
>30 xxxxx yyyyy zzzz6 19090 0xxxC CC+

So the module outputs 3 checksum digits, which is not correct??? The whole string is now too long.

Also realised that the adherent number is max 11 characters. But ideally I need to fill in the 30 +  xxxxx yyyyy zzzz

Can someone advise??????

Many thanks,
Steven

_______________________________________________
Mailing-List: http://odoo-community.org/groups/switzerland-29
Post to: mailto:switzerland@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference