Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

7

How do I set-up my chart of accounts in OpenERP?

By
Nicoleta Tristan (ngh)
on 2/5/13, 5:31 AM 23,445 views

I am having problems finding documentation about Accounting in OpenERP.

In general, before anything else try typing "l10n_", followed by your country code, into the search box of this page: http://v6apps.openerp.com/ l10n is an abbreviation of "localization" (10 letters between the l and the n) Example: "l10n _ es" lists all localization modules for Spain.

Martin
on 2/8/13, 6:05 PM

Hello. This is an answer for v6 not v7

Mark Lewis
on 2/26/13, 11:55 AM
5
Abner Galeno Jr.
On 2/8/13, 1:15 PM

First and foremost, to enable import/export in OpenERP, you must check the option

[✓] Allow users to import data from csv files

Under

Settings->configuration->general settings

You can do it in a lot of ways.

(1) You can export a sample chart of accounts list from OpenERP, edit them in a spreadsheet and finally Import back your completed Chart of Accounts.

To do this, go to:

Accounting Module -> Configuration -> Accounts

Check/tick a few accounts click [More] button and click Export.

(2) You can also start fresh by deleting all the accounts under

Accounting Module -> Configuration -> Accounts

and creating your the accounts one by one.

(3) I think, the most ideal way would be to create a template at

Accounting Module -> Configuration -> Templates -> Chart of Accounts Templates

You can also import and export the templates later on.


Hello. As commented below I'm looking for the method to create a COA from an installed COA template

Mark Lewis
on 2/27/13, 5:24 AM

@Abner Galeno it would be nicer to use back quotes "`" in stead of code block

Code block

[✓] Allow users to import data from csv files

Back quote

[✓] Allow users to import data from csv files

Camptocamp SA
on 2/28/13, 3:54 PM

Thanks for the tip :)

Abner Galeno Jr.
on 3/2/13, 10:37 AM

Well I have a different problem though. Is it possible to export a configured chart of account from one data base to another in openerp v7.0?

Henry Padi Nyaunu
on 4/22/13, 7:26 PM

Hello, I am trying to create a new chart of accounts + chart of taxes by following the instructions.

Radi's choice Ltd., Radina Kraeva
on 2/9/14, 3:49 PM
2
Fred Blauer
On 2/6/13, 11:30 AM

Under accounting, configuration, accounts, account - here you can add, modify, delete accounts

1

Pierre Soum

--Pierre Soum--
1414
| 5 5 8
Aucamville, France
--Pierre Soum--
Pierre Soum
On 4/25/13, 2:04 PM

Hi, If you already have the template, all you have left s to activate it. Go to Settings / Accounting and select you account template.

do we need to do this?? is their any other way that if we choose the customize chart of account when installing it will automically puts the customize accounting templates??

Lady Sharmane Udtuhan
on 10/29/13, 6:17 AM
1
Alan Bell
On 2/5/13, 7:36 AM

There are a number of default charts of account available for different countries, these will install templates in Accounting/configuration/accounts/templates and when you set up your company you can inherit your chart of accounts from one of these. For the tax reports it is essential that every line of every invoice is coded up to something, if it is not tax relevant then you must code it as zero rated or exempt as appropriate, otherwise the tax reports won't pick up the total sales and purchases correctly.

Hello I looked in Accounting/configuration/accounts/templates and I don't have any templates relating to the French COA that I wish to install. I have things like Configurable Account Chart. Where could I find this template? Thanks

Mark Lewis
on 2/26/13, 11:47 AM
1

Martin

--Martin--
1978
| 5 6 8
Cornwall, Canada
--Martin--

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

Martin
On 2/8/13, 10:01 AM

This blog may get you started.

http://openerp24hrs.blogspot.com/2011/11/introduction.html

Unfortunately, it hasn't been completed yet,

I appreciate every little bit of information that you provide on your blog. I also think it is cool that you write your thought-process, as well :)

Abner Galeno Jr.
on 2/8/13, 1:22 PM

Thanks for the vote of confidence! It distresses me that that is now obsolete. I did the automation scripts for 6.0 and then discovered they're useless for 6.1, let alone 7.0. It now needs a complete re-write :-(

Martin
on 2/8/13, 5:23 PM
0
Peter Kosmalla
On 7/24/13, 5:32 PM

We have the german accounting templates installed but it is only one time possible to install it. If you do not do it or are not using a very tricky module installation and configuration order then you will never again be able to do it. It seems to me that this could be a bug in OpenERP 7.

Peter

0
Samuel Tadesse
On 9/26/13, 4:43 AM

i have tried to import chart of account in v7. but i couldn't match the 'Balance' field. it says "no match found" when i try to search . any help would be appreciated

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

5 follower(s)

Stats

Asked: 2/5/13, 5:31 AM
Seen: 23445 times
Last updated: 5/20/16, 2:50 AM