Community mailing list archives

Re[2]: Chart of accounts

- 12/22/2014 08:43:45
Hi John Pia Jr,
Important for using dimensions they must be mandatory by posting into the G/L accounts. (and sub-ledgers)
Only then dimensions is a powerful tool.
Johan Bosma
Senior Consultant

<IMG src="cid:em739b25ed-11c5-4b5b-abba-b86b7c96fdbf@johan-hp" width=16 height=12> +31 88 627 0427
<IMG src="cid:em812207fa-5dce-4ce7-8192-fdf845f0dfa0@johan-hp" width=16 height=12> +31 6 2450 7851
<IMG src="cid:emc57e8787-e8fa-4b29-83a7-8cc07291c2f5@johan-hp" width=16 height=12> hi_johan
<IMG src="cid:em48e6b0ee-e48b-4b26-b0ac-bcd2de624587@johan-hp" width=16 height=12>

Onestein B.V.
<IMG src="cid:em35880f31-1dcb-40f1-a91f-55ba0903613c@johan-hp" width=16 height=12> +31 88 627 0400
<IMG src="cid:em2c497d38-13b6-48dc-94b7-c6e4f68ab091@johan-hp" width=16 height=12>
<IMG src="cid:emb6154fc8-cafe-4854-a59c-1b92cc141260@johan-hp" width=16 height=12> onestein_erp
<IMG src="cid:emc0d4adcb-4bd7-4dd0-b155-91bdbc264164@johan-hp" width=16 height=12> onestein

<IMG src="cid:em0f04c745-d4a0-49a9-aca1-108e5ddc4ca0@johan-hp" width=16 height=12> Amsterdam - Keizersgracht 62-64
<IMG src="cid:em0324fd35-ed03-45a6-b5da-e43ba43e1eaf@johan-hp" width=16 height=12> Oosterhout - Beneluxweg 37
<IMG src="cid:em4d6df1ed-f45a-4f29-84d9-71ad8665a765@johan-hp" width=16 height=12> Antwerpen - Brusselsestraat 51

<IMG src="cid:emb4fb03a4-9a94-42d6-b5e9-76e6d10f9fb6@johan-hp" width=183 height=60>
------ Origineel bericht ------
Van: "John Pia Jr" <>
Aan: "Community" <>
Verzonden: 22-12-2014 14:23:32
Onderwerp: Re: Chart of accounts
<BLOCKQUOTE class=cite2 type="cite">


Thank you for that information.

On Dec 22, 2014 4:27 AM, "Arnis Putniņš" <> wrote:
Hello John,

Large companies using so called "Multidimensional accounting" where cost center as well as other analytical information such as project, contract, product line is stored in journals (booking entries) as separate fields instead of sub-account.

This allows to make multi-axis analysis for accounting.

As I know Odoo allows to use just two dimensions for analytics.

Best regards,
Arnis Putnins

On Fri, Dec 12, 2014 at 1:38 PM, John Pia Jr <> wrote:


I am seeking some feed back as to how other businesses go about managing a very large chart of accounts.

Let me first explain what we have been doing for years (I Dont necessarily think that this method is still the best choice being as we are operating on a very outdated set of software platforms)

Basically we have a list of a couple hundred different types of GL codes. Each of those GL codes must be related to a cost center(locations). Currently we create 1 gl code location. For example let's take the GL code for repair and maintenance, within that code there are 5 sub codes, each one of those 5 sub codes need to be related to a location.


GL = x
Sub gl = Y
Sub gl 2 = z

Location 1=L1
Location 2 = L2
Locations 3 = L3

Here are a list of gl codes that are created as a result from the above.


The entire purpose of creating a separate GL code for each location is only for reporting purposes. My accounting department likes to be able to see on a trial balance report all of me codes broken down by location. To me this is a very old way of doing things

What I would like to do is I would like to be able to give my accountant that same break down of transactional information based on location, but rather than use the GL code to represent the location I want to know if it is possible to use the location being the source or destination location within any transaction to create that relationship between GL code and location. By doing this it will allow me to expedient really decrease the amount of GL codes we currently have.

Finally I would like to ask the community if anybody would be willing to share with me some of the basic accounting reports offered by odoo that are of much larger companies. For example we are a 200 million dollar organization with 8 locations and 3800 GL codes. I would  like to have a better understanding as to how others among our size handle the above question.

What I'm looking to do is get rid of the need to have to identify a location within a GL code.

If I have not been clear please let me know, and thank you in advance for any help

Post to:

Post to:

Post to: