Community mailing list archives
Re: Multi-Dimention Account Posting in an account_move_line, Possible?by
In our experience, account distribution data entry for transactions (e.g: invoices) is not easy, splitting in N rows if you want split in several dimensions.Much easier approach will be if dimensions are presented to user in columns and rows are used just to allocate amounts until total
El 17/1/2015, a las 16:22, Ana Juaristi <email@example.com> escribió:It's exactly like @Fabien says but...As I said in a previous email... once analytic distribution is installed all analytic account fields will be invisible in any object you will only see analytic distribution field so configuring distribution will be needed even if you only want make 100% cost register agains a single account.This is the only annoying thing I see with that module. Distributing cost functionality works perfectly but... sometimes is easier making "manual" cost registering againsts the N accounts you need, instead using it, just because of that.:)2015-01-17 19:12 GMT+01:00 Fabien Pinckaers <firstname.lastname@example.org>:
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:
Customer X \ Project Y: 100€
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
FabienOn Jan 17, 2015 6:53 PM, "Kitti U." <email@example.com> 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 <firstname.lastname@example.org> 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 <email@example.com> escribió:>> 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> 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." <firstname.lastname@example.org >> <mailto:email@example.com>> Post to: mailto:firstname.lastname@example.org >> <mailto:email@example.com> >> Unsubscribe: https://www.odoo.com/groups?unsubscribe >> >> _______________________________________________ >> Mailing-List: https://www.odoo.com/groups/community-59 >> Post to: mailto:firstname.lastname@example.org >> Unsubscribe: https://www.odoo.com/groups?unsubscribe >> > _______________________________________________ > Mailing-List: https://www.odoo.com/groups/community-59 > Post to: mailto:email@example.com > Unsubscribe: https://www.odoo.com/groups?unsubscribe > -- Fabien Pinckaers Odoo Founder Phone: +184.108.40.206.00 Web: https://www.odoo.com Twitter: @fpodoo Instant Demo: https://odoo.com/start----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
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 - firstname.lastname@example.org
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 - email@example.comThis 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 – firstname.lastname@example.org
Ecosoft Co. LTD, Kitti Upariphutthiphong