← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 734791] [NEW] The generated file for csb 19 is not compliant

 

Public bug reported:

Hi,

I'm using v5.0.15 with the spanish localization modules.

I have checked the csb19 file generated by the module l10n_ES_remesas
and it is not correct:

1) In "_individual_obligatorio_19" you generate the "Registro Indivudual
Obligatorio" (using the first procedure) but use the last 48 characters
of the line as the concept. The code has commented this:

"Esto es lo convencional, descripción de 40 caracteres, pero se puede
aprovechar los 8 espacios en blanco finales"

In the csb19 file structure, the last 8 characters of the line are
defined as free, so they should be kept blank, not with text. Maybe it
was added because in some banks they may be showing it but other banks
may reject the file just for not following the file structure.

2) In "_individual_opcional_19" you generate the "Registro Individual - Sexto Opcional" (using the first procedure), In this register you use 115 characters to save the recibo['communication2'] starting at position 29 (first position of the register being position 1). However, this register is NOT used for communication text. The 115 characters that you use for communication is described in the csb19 file description as:
- Nombre del Titular de la Cuenta Domiciliataria (40 characters)
- Domicilio del Titular de la Cuenta (40 characters)
- Plaza del Domicilio del Titular de la Cuenta (35 characters)

This is wrong. There are other register types defined in order to supply
extended description for the payment line to the customer. However,
"Registro Individual - Sexto Opcional" is used to specify information
about the customer (Nombre del Titular de la Cuenta Domiciliataria,
Domicilio del Titular de la Cuenta, Plaza del Domicilio del Titular de
la Cuenta, Codigo Postal). Currently you ignore the first three fields
and supply a description instead, and finally tiy use the postal code
00000 for the last field.

The proper fix to both problems you need to keep in mind that with the
csb19 file specification you can supply to the bank eight lines of 80
characters of description. The fist 40 characters of the first line are
the ones used in "Registro Indivudual Obligatorio". The other optional
registers ("Registro Individual - Primero Opcional", "Registro
Individual - Segundo Opcional", "Registro Individual - Tercero
Opcional", "Registro Individual - Cuarto Opcional","Registro Individual
- Quinto Opcional") except the "Registro Individual - Sexto Opcional"
register, are used to specify the other parts of the description.

Each of those registers holds 120 characters of concept description
(among other things), so for the "Registro Individual - Primero
Opcional" the first 40 characters of concept description correspond to
the last 40 characters of the first line, and the next 80 to the second
line. For the "Registro Individual - Segundo Opcional" the first 80
characters of concept description correspond third line, and the next 40
characters to the first 40 characters of the fourth line and so on...

So IMHO the best would be to calculate how many lines will be used by
recibo['communication'], how many by recibo['communication2'] and send
as many needed registers in order to send that info to the line, keeping
in mind to use a different line for recibo['communication2'] so that
info doesn't get printed in the same line as the ending part of
recibo['communication']

I hope I explained the problematic properly.

** Affects: openerp-spain
     Importance: Undecided
         Status: New


** Tags: 5.0

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/734791

Title:
  The generated file for csb 19 is not compliant

Status in OpenERP Spanish Localization Project:
  New

Bug description:
  Hi,

  I'm using v5.0.15 with the spanish localization modules.

  I have checked the csb19 file generated by the module l10n_ES_remesas
  and it is not correct:

  1) In "_individual_obligatorio_19" you generate the "Registro
  Indivudual Obligatorio" (using the first procedure) but use the last
  48 characters of the line as the concept. The code has commented this:

  "Esto es lo convencional, descripción de 40 caracteres, pero se puede
  aprovechar los 8 espacios en blanco finales"

  In the csb19 file structure, the last 8 characters of the line are
  defined as free, so they should be kept blank, not with text. Maybe it
  was added because in some banks they may be showing it but other banks
  may reject the file just for not following the file structure.

  2) In "_individual_opcional_19" you generate the "Registro Individual - Sexto Opcional" (using the first procedure), In this register you use 115 characters to save the recibo['communication2'] starting at position 29 (first position of the register being position 1). However, this register is NOT used for communication text. The 115 characters that you use for communication is described in the csb19 file description as:
  - Nombre del Titular de la Cuenta Domiciliataria (40 characters)
  - Domicilio del Titular de la Cuenta (40 characters)
  - Plaza del Domicilio del Titular de la Cuenta (35 characters)

  This is wrong. There are other register types defined in order to
  supply extended description for the payment line to the customer.
  However, "Registro Individual - Sexto Opcional" is used to specify
  information about the customer (Nombre del Titular de la Cuenta
  Domiciliataria, Domicilio del Titular de la Cuenta, Plaza del
  Domicilio del Titular de la Cuenta, Codigo Postal). Currently you
  ignore the first three fields and supply a description instead, and
  finally tiy use the postal code 00000 for the last field.

  The proper fix to both problems you need to keep in mind that with the
  csb19 file specification you can supply to the bank eight lines of 80
  characters of description. The fist 40 characters of the first line
  are the ones used in "Registro Indivudual Obligatorio". The other
  optional registers ("Registro Individual - Primero Opcional",
  "Registro Individual - Segundo Opcional", "Registro Individual -
  Tercero Opcional", "Registro Individual - Cuarto Opcional","Registro
  Individual - Quinto Opcional") except the "Registro Individual - Sexto
  Opcional" register, are used to specify the other parts of the
  description.

  Each of those registers holds 120 characters of concept description
  (among other things), so for the "Registro Individual - Primero
  Opcional" the first 40 characters of concept description correspond to
  the last 40 characters of the first line, and the next 80 to the
  second line. For the "Registro Individual - Segundo Opcional" the
  first 80 characters of concept description correspond third line, and
  the next 40 characters to the first 40 characters of the fourth line
  and so on...

  So IMHO the best would be to calculate how many lines will be used by
  recibo['communication'], how many by recibo['communication2'] and send
  as many needed registers in order to send that info to the line,
  keeping in mind to use a different line for recibo['communication2']
  so that info doesn't get printed in the same line as the ending part
  of recibo['communication']

  I hope I explained the problematic properly.



Follow ups

References