Community mailing list archives

community@mail.odoo.com

Re: Multi-Dimention Account Posting in an account_move_line, Possible?

by
AVANZOSC, S.L., Ana Juaristi Olalde
- 01/17/2015 13:11:53
Hi... 
As said by Fabien, a single cost can be distributed in N dimensions.

System is linked by default with analytics not only for invoices but also for projects and human resources. You can compute HR or project costs against a single analytic account = cost center or an analytic distribution includin N analytic accounts, specifying a % of the cost that must be spplited into each one. 

If you simply want to split 100% for each account, you can also do that, so you are registering full cost to each analytic account into the distribution. You can also split N% if you need spliting in several accounts inside same cost tree. 

Said that... Anaytic distribution in Odoo is powerfull and I think it can cover almost all cases that are needed but... IMHO its configuration is so complicated / not user friendly that very few people is using it properly. 
I think it could be improved easily just allowing to use single accounts or analytic distributions when needed. It would be perfect like that.

Examples:
1. You buy a computer 1000€ for project1 --> You create project1 account and it's done. No analytic distribution is needed
2. You buy a computer 1000€ but cost should be splited in 2 dimensions, being 50% project1, 50% project2, 100%ingeneering department --> you create analytic distribution with 3 lines so you need installing module.

Now... after installing analytic distribution you buy another computer 1000€ for project1 --> You need creating another analytic distribution with a single line 100% project1 that would not needed at all, just because project1 account would be enough like in case1.

That is... there could be situations where single analytic account would be enough, but installing analytic distribution you need always configuring the percentages and that's annoying thing. 

I think if this could be solved/automated somehow module would fit anyone needs. That's all.

Thank you:

Ana



2015-01-17 18:53 GMT+01:00 Kitti U. <kittiu@ecosoft.co.th>:
Hello Fabian,

I have look into account_analytic_plans thoroughly. Although I admit that it is a smart and very generic way to distribute a move line with multiple Analytic Accounts, and will work for many cases. Yet, I also agree with others. 

What most of us want is something different. In the PO / INV Lines itself, we need to select another dimension directly in the line which might be another kind of master data, much like partner or products. For example, Sales Region, Campaign.

In other SAP(or even Compiere/Adempiere), for example, they might prepare up to 6 dimension, and allow us to tie it to our master data of choice, like, Sales Region, Business Area, Campaign, Project, etc. These dimension will account into Accounting Combination when posting. (i.e., HQ-12110-_-_-_-_).

In account_analytic_plans, I try to think of using it also, but really can't imaging how user can use it easily. Also not to mentioned that we will have to make every dimension we want as analytic account.

Kind Regards,
Kitti U.

Additional Notice: Odoo is a great product, and we love it in many many ways. But when come to accounting, somehow we always have trouble. Although we already try to adjust our thinking to the modern way of Odoo. But some aspect of accounting engine just not solid enough comparing to other ERP (for accounting aspect). Example like, deleting all journal entries when cancelling invoice, just not bearable for auditing standpoint of large companies, etc...

On Sun, Jan 18, 2015 at 12:35 AM, Daniel Stolovich <daniel.stolovich@quanam.com> wrote:
Hi Fabien,

First thing we did was analyze that module you recommend, but the way it works, requires to enter several rows and you can't mix easily several dimensions, for instance: assign an amount for a specific cost center AND a project at the same time...

We think  the approach should be in columns not rows, do you that will be addressed in v9?



El 17/1/2015, a las 14:27, Fabien Pinckaers <fp@odoo.com> escribió:

> I understand that the requirement refers to combine several dimensions
> in the same line, in my experience with Oracle and SAP ERPs, is very
> useful for a lot of companies, in certain cases valid combinations among
> dimensions can be defined to validate input.
> 
> We are having same limitations and thinking in create a specific module
> to support that. Impact is large, affects transaction input, posting
> process, report filters and info.

As explained just before, please don't develop a module. It already
exists in standard: account_analytic_plans. It allows to define multiple
dimensions, models of how to spread entries, constraints per journal.



>> Install the official module account_analytic_plans, it allows to
>> define multiple dimensions/plans
>>
>> On Jan 16, 2015 11:58 PM, "Kitti U." <kittiu@ecosoft.co.th
>> <mailto:kittiu@ecosoft.co.th>> wrote:
>>
>>     Dear community,
>>
>>     Normally in Odoo, we can have one additional *Analytic Account
>>     column* for projects or contract, when do the account posting, right?
>>
>>     *QUESTION: *Are there addons or ways to have *Multiple Analytic
>>     Accounts posting* in an account_move_line? 
>>
>>
>>
>>     In other ERP, it is called Accounting Dimensions, where you can
>>     define dimension like, Projects, Departments, Sales Person, etc.
>>     but I couldn't find such concept in Odoo.
>>
>>     I am not talking about Analytic Account Distribution
>>     (account_analytic_plan), which seem to only make sub table to
>>     define the percentage distribution of each project in a plan.
>>
>>     Many thanks,
>>     -- 
>>     Mobile: +66-(0)8-1841-7480
>>     Your ERP Partner => www.ecosoft.co.th 
>>
>>     _______________________________________________
>>     Mailing-List: https://www.odoo.com/groups/community-59
>> Post to: mailto:community@mail.odoo.com >> <mailto:community@mail.odoo.com> >> Unsubscribe: https://www.odoo.com/groups?unsubscribe >> >> _______________________________________________ >> Mailing-List: https://www.odoo.com/groups/community-59 >> Post to: mailto:community@mail.odoo.com >> Unsubscribe: https://www.odoo.com/groups?unsubscribe >> > _______________________________________________ > Mailing-List: https://www.odoo.com/groups/community-59 > Post to: mailto:community@mail.odoo.com > Unsubscribe: https://www.odoo.com/groups?unsubscribe > -- Fabien Pinckaers Odoo Founder Phone: +32.81.81.37.00 Web: https://www.odoo.com Twitter: @fpodoo Instant Demo: https://odoo.com/start

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
CEO Avanzosc, S.L : Office phone / Tfono oficina: (+34) 943 02 69 02
Ana Juaristi Olalde : Personal phone: 677 93 42 59. User/usuario skype: Avanzosc
www.openerpsite.com


El contenido de esta comunicación y de toda su documentación anexa es confidencial y se dirige exclusivamente a su destinatario. El uso no autorizado de esta información está prohibido por la legislación vigente. Si usted no es el destinatario le rogamos nos lo indique, no comunique su contenido a terceros y proceda a su destrucción. Disculpe las molestias que le haya ocasionado la recepción indebida de este e-mail. Sus datos figuran en un fichero cuyo titular es Avanzosc, S.L., a quien usted puede dirigirse para ejercer sus derechos de acceso, rectificación, cancelación y oposición en Julio Urkijo, 32, 20720, Azkoitia (Gipuzkoa), Tef. 943 02 69 02 - administracion@avanzosc.com

Komunikazio honen edukia eta dokumentazio erantsia konfidentziala da eta hartzaileak bakarrik jaso beharko luke. Indarrean dagoen legeriak debekatu egiten du bertan eskainitako informazioa baimenik gabe erabiltzea. Komunikazioa zuri iritsi bazaizu, baina zu ez bazara hartzailea, mesedez, guri jakinarazi, eta jasotako informazioa ez inori jakinarazi eta suntsitu. Barkatu okerreko email hau jasotzeak eragindako eragozpenak. Zure datuak Avanzosc, S.L. enpresaren fitxategietan sartuta daude. Zure datuak atzitzea eska dezakezu, bai eta, datuak zuzentzea, ezereztea eta tratamenduari aurka egitea ere. Horretarako, enpresara jo dezakezu, helbide honetan: Julio Urkijo, 32, 20720, Azkoitia (Gipuzkoa), telefonoa: 943 02 69 02 - administracion@avanzosc.com

This message and all documents attached to it are confidential and intended only for the person or entity to which it is addressed. Any use of this information by unauthorised persons is prohibited under current legislation. If you received this message by error, please advise us, destroy it and refrain from communicating its contents to third parties. We apologise for any inconvenience receiving this email improperly may cause to you. Your personal data are included in a file owned by Avanzosc, S.L. If you want to exercise your rights of access, correction, erasure and objection you can contact the Controller at Julio Urkijo, 32, 20720, Azkoitia (Gipuzkoa), T: 943 02 69 02 – administracion@avanzosc.com