[7.0]l10n_be problem with dutch translation when creating a new database

I want also to mention the -> addons/l10n_multilang module.

Hi,

I wouldn't say this is a bug, but rather a feature of the l10n_be module: the chart of accounts is automatically installed on the main company if that company does not have a chart of accounts yet. This could in fact be done in all l10n modules.

It is only an issue if you rely on the loading of the i18n/*.po files for installing the chart of accounts translations, and you did not say if that's what you're doing. The official l10n_be does not, and adding a dependency on l10n_multilang should probably not change that. The reason is that there are additional problems with using the i18n/*.po files for storing the translations of the chart of accounts.

For more details, please see this work-in-progress merge proposal from Geert Janssens who is working on this very same improvement, and the corresponding reviews:
    https://code.launchpad.net/~openerp-community/openobject-addons/gjanssens_l10n_be_nl/+merge/165071

Thanks!

Olivier,

I don't want to start a discussion if this is a bug or a new feature because this is irrelevant, this is a legal issue and this is covered by maintenance contract or are legal issues not anymore covered ?

Peter

Peter,

The OpenERP Enterprise contract states the following in Exhibit A, Section 6.1. Definition of a bug: "A non
compliance of an existing feature with legal accounting requirements may also be considered as a bug if, and only if, a quality
certified module is existing for this particular module and particular country."

Olivier is therefore correct in making it important to specify whether this is a new feature or a bug of an existing feature because OpenERP Enterprise doesn't cover a legal requirement that was not already implemented (according to a previous legislation) in an existing certified module. Otherwise, anybody could say that the majority of tax filing documents for all kinds of countries and industries are missing and that OpenERP has to create them for $39 (OE for 1 user during 1 month). I let you judge the sustainability of such a situation if it was allowed.

Feel free to contact you account manager for further assistance on our contracts, and thank you for your report.

Hello,

We have merged a fix for this issue in 7.0 with the translation of l10n_be in Flemish.
The two patches are 5049 in server and 9361 in addons.

As we could not change the dependency tree in 7.0 (may break existing databases), the dependency to l10n_multilang was not enabled. It will only be in the next release but you can already benefit from the changes if you install in the following order :

1. Apply the server and addons patch
2. Switch your instance into Flemish
3. Install l10n_multilang, cancel any wizard
4. Install l10n_be and accept the new wizard

Regards

Hi,

what do you mean with "1. Apply the server and addons patch" ? were do I find these two patches (5049 in server and 9361 in addons) ?

I did step 2, 3 and 4 but all the VAT terminology stays in French instead of Flemish/Dutch

what am I doing wrong ? I have OpenERP v7.0.0-0021 and I am running on a synology NAS... (I have some CLI experience and am not afraid to use it)

Help would be much appreciated!

thanks!

Hello Koray,

The two patches can be found on launchpad history (download diff button)
http://bazaar.launchpad.net/~openerp/openobject-server/7.0/revision/5049
http://bazaar.launchpad.net/~openerp/openobject-addons/7.0/revision/9361

If you have the latest code of openerp 7.0, you don't need to apply step 1 (not sure what you mean by v7.0.0-002, it depends the way you have retrieved the code, you can get the latest version here: http://nightly.openerp.com/7.0/nightly/).

Regards

Thanks for the answer!
I retrieved the code through Synology Package manager... and v7.0.0-0021 is the version that is depicted there..
I downloaded the two diffs and will see if that will get me somewhere. I suppose i have to use bzr to merge the diffs in my codebase ?

when I install the patches on a fresh openerp installation, it says

2014-01-31 15:23:22,333 1300 ERROR OPENERP7 openerp: Failed to initialize database `OPENERP7`.
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/site-packages/openerp/cli/server.py", line 98, in preload_registry
    db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
  File "/usr/local/lib/python2.7/site-packages/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/registry.py", line 214, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/loading.py", line 303, in load_modules
    loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/loading.py", line 161, in load_module_graph
    load_openerp_module(package.name)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/module.py", line 405, in load_openerp_module
    __import__('openerp.addons.' + module_name)
  File "/usr/local/lib/python2.7/site-packages/openerp/modules/module.py", line 133, in load_module
    mod = imp.load_module('openerp.addons.' + module_part, f, path, descr)
  File "/var/packages/OpenERP7.x/target/openerp/addons/base/__init__.py", line 22, in <module>
    import ir
  File "/var/packages/OpenERP7.x/target/openerp/addons/base/ir/__init__.py", line 33, in <module>
    import ir_translation
ImportError: No module named ir_translation

I have followed the steps as described in comment 6. Since I am starting from the current nightly I skipped step one, assuming the patches are already in place.

This did get me a chart of accounts in Flemish which is great.

I do encounter an issue though when using the keyboard to select an account in any field that expects an account (like for example when entering bank statement lines, when entering invoice lines,...): the filter works on the French original account name instead of the translation.

Steps to reproduce:
1. follow the steps in comment 6 to get set up a Belgian Chart of accounts in Flemish
2. Once that's done, go to "Boekhouding->Rekeninguittreksels" (which is Flemish for "Accounting->Bank statements")
3. Create a new bank statement
4. On the new bank statement, click on "Item Toevoegen"
5. Put the cursor in the field labeled "Rekening"
6. In this field type "600000" (without the quotes)

=> Observe that the dropdown will list "600000 Aankopen van grondstoffen" as suggested account

7. remove the entered text and this time type "grond"

=> Observe that this time no suggestions are found. Instead you are offered to create an account named "grond"

8. remove the entered text and this time type "matière"

=> Observe that this time the dropdown will again list (among others) "600000 Aankopen van grondstoffen"

This makes the type-filter of very limited use in a Flemish context.

For reference: "Aankopen van grondstoffen" is the Flemish translation of "Achats de matières premières"

In between step 3 and 4 you will likely still have to create some accounting periods using "Boekhouding->Periodes->Boekjaren"

And this same issue also exists in the SAAS version of OpenERP.