Community mailing list archives

community@mail.odoo.com

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

by
Eficent Business and IT Consulting Services, S.L.
- 01/19/2015 04:19:00
+1 to Eva's comments.

In my opinion, if you want to properly implement analytic distributions, then you have to use  a double-entry analytic accounting system. Otherwise you can easily end up with inconsistencies.

Ensuring that each analytic dimension is consistent would be really good, because you can then trust in a system that provides you in depth analysis of your organisational structures AND internal processes.

See the following post that I wrote regarding this topic:

Regards,
Jordi.



On Sun, Jan 18, 2015 at 4:37 AM, Eva Pinter <epinter@openit.ch> wrote:

Hello all,


The most important missing feature is the fact that you cannot decide at the end of the period about how you want to spread the costs or the revenues. You have to decide it at the end and the spread is final. This is not what is needed in larger organisations.

Overhead costs accounting
What is needed is to be able to get all the costs for projects or cost centers on the relevant objects and to be able to distribute them to other cost centers. As an example, you want to have all electricity costs and other such costs that you cannot directly assign to a cost center in a kind of pool cost center. At the end of the month, you want to distribute this cost to all other cost centers, representing for instance departments based on a factor defined and possibly changing regularly, like the number of people in the department or the surface used by the department.

Contribution margin
In order to calculate the contribution margin, you need to be able to record each sales using different characteristics, for example, the region of the customer, the product sold, the sales person or any self defined characteristics you want to analyze your data by. Then, you need to be able to assign direct costs along the same characteristics for the first level contribution margin. For further contribution margins, you will want to consider overhead costs that you want to distribute following certain rules.

Product costing
When you try to calculate the product costs using only direct costs, you end up with an incorrect result, as the overhead can be significant and not necessarily directly assigned to the product. An example is the electricity. You may only be able to assign electricity costs, based on the produced quantity. This is known at the end of the period, so you may have a plan value for it, but you should be able to calculate the actual costs based on the real production quantities. This can only be done at the end of the month and therefore the online posting using plans will not work for these cases.

Further, all these calculations should be able to be redone multiple times, in case one of the criteria was wrongly chosen. As this belongs to cost accounting and is not (mostly) legally relevant, there should not be too many restrictions as how the redone can be handled.

For revenue postings and assignment to multiple characteristics via the plan, it is a first step and works sufficiently to cover most needs as you rarely redistribute the revenues at the end of the month.


---
Eva P.

Get free Odoo training in our youtube channel http://www.youtube.com/user/ybofr





On 17 Jan 2015, at 18:12, Fabien Pinckaers <fp@openerp.com> wrote:

You may have missed features of the module. (It's not an easy module as it requires configuration) You have to configure plans structure and link them in the journal, if I remember well.

It allows to split an invoice line of 100€ into:

- Projects:
      Customer X \ Project Y: 100€
- Funding:
      Fund A: 60€
      Fund B: 40€

It all depends on how you configure plans for the related journal. Number of plans are unlimited, as well as hierarchies.

If someone understand how to make it works, it would be great to create a question and answer on: https://www.odoo.com/forum/1

Thanks,

Fabien

On Jan 17, 2015 6:53 PM, "Kitti U." <kittiu@ecosoft.co.th> wrote:
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

_______________________________________________
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




--

Jordi Ballester Alomar


Tel: (+34) 629530707 

E-mail: jordi.ballester@eficent.com  |   Web: http://www.eficent.com

Twitter: @jbeficent_erp                              |   Skype: jordi.ballester



Este email contiene información confidencial. El contenido de la misma se encuentra protegido por Ley. Cualquier persona distinta a su destinatario tiene prohibida su reproducción, uso, divulgación o impresión total o parcial. Si ha recibido este mensaje por error, notifíquelo de inmediato al remitente y borre el mensaje original junto con los ficheros anexos.

This message contains confidential information and it is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute or copy this email. Please notify the sender immediately by email if you have received this email by mistake and delete it from your system. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.