Community mailing list archives

community@mail.odoo.com

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

by
Narayana Moturi
- 01/17/2015 23:41:51
Also, we experienced  most of the community modules related analytical will start to fail, when analytical distribution is used, since all the enhancements are related to Analytical account and doesn’t check if the analytical distribution configuration is enabled.

Cheers,

Description: RU3IX Pty Ltd

Narayana 

nmoturi@ru3ix.com.au

RU3IX Pty Ltd 
http://www.ru3ix.com.au

This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. RU3IX Pty Ltd is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company.

On 18 Jan 2015, at 2:37 pm, 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