Bidiman wrote - "Meanwhile i'm evaluating the solution to go for odoo (openerp) it seems a super followed project and all setup for belgium"

Have you taken a look at Tryton - a 2008 fork of OpenERP (I have nothing to do with them BTW)
http://www.tryton.org/

Tryton has a client - server setup, however, the clients are available configured in some Linux distro's e.g. Puppy Linux, Arch Linux, Debian, Fedora and possibly Ubuntu.

Interesting:
http://openerphell.blogspot.co.uk/2010/10/tryton-vs-openerp-which-is-best-better.html

I only mention this as I came across something talking about Tryton being Belgium friendly - I think that one of the main devs is Belgian.

Personally, I favour FrontAccounting, WebERP and PhreeBooks for their relative simplicity.

regards and thank you for your help

https://github.com/apmuthu/frontaccounting/tree/master/extensions/Charts/chart_nl_NL-general
and
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Charts/chart_en_FR-general
and
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Charts/chart_fr_CA-general
and
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Charts/chart_fr_FR-general

are available.

Take the 2nd one and edit the account head names in the sql.

Now upload the sql into the sql folder in the FA installation and choose it in creating a new company and then log onto the new company.

Meanwhile i'm evaluating the solution to go for odoo (openerp) it seems a super followed project and all setup for belgium already exist.

If you have the accounts in a CSV file, I'm sure Joe can generate the required sql. That seems to be how it's usually done.

On a more constructive note, one thing we might consider would be reusing COAs defined by/for other projects. Has anyone looked into this?

ps: I still don't know how can I activate this COA...?? Help will be welcome.

Thank you,

I suggest you install it, and have a look. If it looks (structurally) correct, you could replace the account names in the sql file with their French equivalents. You only need to do this for the accounts you actually use, but if you translate all of them the new file can be included in the repo for the benefit of all Belgians. Or, at least, some of them.

As for the language pack, I suspect the problem is that it expects the fr_FR locale to be installed on the server, and you probably have fr_BE. If you do get it installed, there may be a few tweaks required but they should be minimal. Even if there are no differences, we should still have a language pack for fr_BE.

about the COA I only see a zip file on the sourceforge.
From this link,
https://frontaccounting.com/fawiki/index.php?n=Help.InstallActivateChartOfAccounts

I seem to understand that it's a sql file under the /sql folder from the FA zip. Is it correct?

DO I have to update a sql db file in order to follow the Belgium COA, or there is a belgium COA I did not find?

regards,

you can Try The COA to get your country
accounting code. Try get Belgium COA from the repo.

Having the inferface in english doesn't matter, but my accountant friend noticed that the accouting code aren't the same for belgium than for the basic install

Is it linked with the language file config file?

If it doesn't exist from Belgium I don't mind to create it.

regards,