Contributors mailing list archives

contributors@odoo-community.org

Avatar

Re: Is there a way to create account.analytic.line from stock.move?

by
Radovan Skolnik
- 12/10/2020 09:38:26
Great! Thank you very much Dominique.

One more question: as I explained before I want to use this to produce 
account.analytic.line records to get costs and revenues of cases / project. I 
see lots of modules in OCA/account-analytic that allow adding analytic account 
info to various objects. What is the general idea on using this information? 
Is it creation of those account.analytic.line - i.e. Analytic Items? If so, 
how are they generated? Or am I missing something here?

Best regards

	Radovan

On pondelok 12. októbra 2020 11:32:38 CEST Dominique k wrote:

> indeed. We added few lines of code to propagate the analytic account from SO

> to stock move. Not sure why it is not a module in OCA. May be because it is

> very small, and has to rely on a "glue" module ('sale_stock') Anyway, if

> you add this (v13), in your code, it would work. (you also need to add a

> dependency to 'sale_stock' in your manifest class

> SaleOrderLine(models.Model):

> _inherit = 'sale.order.line'

> def _prepare_procurement_values(self, group_id=False):

> res = super(SaleOrderLine,

> self)._prepare_procurement_values(group_id=group_id) analytic_id =

> self.order_id.analytic_account_id

> res['analytic_account_id'] = analytic_id and analytic_id.id [1] or False

> return res

> 

> class StockRule(models.Model):

> _inherit = 'stock.rule'

> def _get_custom_move_fields(self):

> fields = super(StockRule, self)._get_custom_move_fields()

> fields += ['analytic_account_id']

> return fields

> Regards, Dominique

> On Mon, 12 Oct 2020 at 16:57, Radovan Skolnik < radovan@skolnik.info [2] >

> wrote: Aaron,

> I cannot seem to get analytic_account_id propagated from SO to outgoing

> stock moves (also from PO to incoming stock moves). Is that supposed to

> work that way? When PO is created from SO the value is propagated there

> though. Best regards

> Radovan

> 

> On štvrtok 8. októbra 2020 17:52:24 CEST Aarón Henríquez Quintana wrote:

> > Yes, sorry for that. It only creates analytic entries if you use real time

> > inventory valuation. Regards.

> > On Thu, 8 Oct 2020 at 13:52, Radovan Skolnik <  radovan@skolnik.info [3]

> > [1] > wrote: Thanx Aaron for info. But do I understand it correctly that

> > this only propagates analytic account value into different objects but

> > does not create account.analytic.line records? I need to get cost of

> > products into them as negative amounts to be able to calulate

> > profitability of analytic account. Best regards

> > Radovan

> > 

> > On štvrtok 8. októbra 2020 10:42:06 CEST Aarón Henríquez Quintana wrote:

> > > Yes. It is possible. You need a couple of modules:

> > >  https://apps.odoo.com/apps/modules/12.0/stock_analytic/ [4] [2] [1]

> > >  adds the> > 

> > > analytic account to the stock move.

> > > 

> > >  https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_sto

> > >  ck [5]> > 

> > > _a [3]>

> > > nalytic [2] I use this for passing the analytic form the PO lines to the

> > > stock moves. I think there is a similar one in the OCA apps but I don't

> > > remember what it is called.

> > > 

> > >  https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analy

> > >  ti [6]> > 

> > > c [4]>

> > > [3] To pass the analytic information from the SO to the stock moves of

> > > the

> > > delivery. Regards.

> > > On Thu, 8 Oct 2020 at 10:17, Radovan Skolnik <  radovan@skolnik.info [7]

> > > [5] [4] > wrote: Hello,

> > > we would like to use analytic accounts to track profitability of

> > > individual

> > > sales. So I'd setup automatic creation of analytic account on confirmed

> > > sale orders which would be propagated to invoices. This would cover the

> > > credit side. What I am struggling with is the debit side - i.e. costs of

> > > products. One way would be adding analytic account on POs/POLs but that

> > > is not feasible because we can have products in stock from past which we

> > > decide to sell. So my idea is to generate account.analytic.line records

> > > from stock.moves and assign them value according to average value. Are

> > > there any modules that would support this? Or should I choose different

> > > approach? Thank you. Best regards

> > > Radovan Skolnik

> > > 

> > > 

> > > _______________________________________________

> > > Mailing-List:  https://odoo-community.org/groups/contributors-15 [8] [6]

> > > [5] Post to: mailto:  contributors@odoo-community.org [9] [7] [6]

> > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [10] [8] [7]

> > > 

> > > 

> > > _______________________________________________

> > > Mailing-List:  https://odoo-community.org/groups/contributors-15 [11]

> > > [9] [8] Post to: mailto:  contributors@odoo-community.org [12] [10]

> > > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [13] [11]

> > > [9]

> > > 

> > > 

> > > 

> > > [1]  https://apps.odoo.com/apps/modules/12.0/stock_analytic/ [14] [12]

> > > [2]

> > > 

> > >  https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_sto

> > >  ck [15]> > 

> > > _a [13]>

> > > nalytic [3]

> > > 

> > >  https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analy

> > >  ti [16]> > 

> > > c [14]>

> > > [4] mailto:  radovan@skolnik.info [17] [15]

> > > [5]  https://odoo-community.org/groups/contributors-15 [18] [16]

> > > [6] mailto:  contributors@odoo-community.org [19] [17]

> > > [7]  https://odoo-community.org/groups?unsubscribe [20] [18]

> > > [8]  https://odoo-community.org/groups/contributors-15 [21] [19]

> > > [9]  https://odoo-community.org/groups?unsubscribe [22] [20]

> > 

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [23] [21]

> > Post to: mailto:  contributors@odoo-community.org [24] [22]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [25] [23]

> > 

> > 

> > _______________________________________________

> > Mailing-List:  https://odoo-community.org/groups/contributors-15 [26] [24]

> > Post to: mailto: contributors@odoo-community.org [27]

> > Unsubscribe:  https://odoo-community.org/groups?unsubscribe [28] [25]

> > 

> > 

> > 

> > [1] mailto: radovan@skolnik.info [29]

> > [2]  https://apps.odoo.com/apps/modules/12.0/stock_analytic/ [30]

> > [3]

> > 

> >  https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock

> >  _a [31]> 

> > [4]

> > 

> >  https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analyti

> >  c [32]> 

> > [5] mailto: radovan@skolnik.info [33]

> > [6]  https://odoo-community.org/groups/contributors-15 [34]

> > [7] mailto: contributors@odoo-community.org [35]

> > [8]  https://odoo-community.org/groups?unsubscribe [36]

> > [9]  https://odoo-community.org/groups/contributors-15 [37]

> > [10] mailto: contributors@odoo-community.org [38]

> > [11]  https://odoo-community.org/groups?unsubscribe [39]

> > [12]  https://apps.odoo.com/apps/modules/12.0/stock_analytic/ [40]

> > [13]

> > 

> >  https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock

> >  _a [41]> 

> > [14]

> > 

> >  https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analyti

> >  c [42]> 

> > [15] mailto: radovan@skolnik.info [43]

> > [16]  https://odoo-community.org/groups/contributors-15 [44]

> > [17] mailto: contributors@odoo-community.org [45]

> > [18]  https://odoo-community.org/groups?unsubscribe [46]

> > [19]  https://odoo-community.org/groups/contributors-15 [47]

> > [20]  https://odoo-community.org/groups?unsubscribe [48]

> > [21]  https://odoo-community.org/groups/contributors-15 [49]

> > [22] mailto: contributors@odoo-community.org [50]

> > [23]  https://odoo-community.org/groups?unsubscribe [51]

> > [24]  https://odoo-community.org/groups/contributors-15 [52]

> > [25]  https://odoo-community.org/groups?unsubscribe [53]

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [54]

> Post to: mailto: contributors@odoo-community.org [55]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [56]

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [57]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [58]

> 

> 

> 

> [1] http://analytic_id.id

> [2] mailto:radovan@skolnik.info

> [3] mailto:radovan@skolnik.info

> [4] https://apps.odoo.com/apps/modules/12.0/stock_analytic/

> [5]

> https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock

> [6]

> https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analyti

> [7] mailto:radovan@skolnik.info

> [8] https://odoo-community.org/groups/contributors-15

> [9] mailto:contributors@odoo-community.org

> [10] https://odoo-community.org/groups?unsubscribe

> [11] https://odoo-community.org/groups/contributors-15

> [12] mailto:contributors@odoo-community.org

> [13] https://odoo-community.org/groups?unsubscribe

> [14] https://apps.odoo.com/apps/modules/12.0/stock_analytic/

> [15]

> https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock

> [16]

> https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analyti

> [17] mailto:radovan@skolnik.info

> [18] https://odoo-community.org/groups/contributors-15

> [19] mailto:contributors@odoo-community.org

> [20] https://odoo-community.org/groups?unsubscribe

> [21] https://odoo-community.org/groups/contributors-15

> [22] https://odoo-community.org/groups?unsubscribe

> [23] https://odoo-community.org/groups/contributors-15

> [24] mailto:contributors@odoo-community.org

> [25] https://odoo-community.org/groups?unsubscribe

> [26] https://odoo-community.org/groups/contributors-15

> [27] mailto:contributors@odoo-community.org

> [28] https://odoo-community.org/groups?unsubscribe

> [29] mailto:radovan@skolnik.info

> [30] https://apps.odoo.com/apps/modules/12.0/stock_analytic/

> [31]

> https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock_a

> [32]

> https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analytic

> [33] mailto:radovan@skolnik.info

> [34] https://odoo-community.org/groups/contributors-15

> [35] mailto:contributors@odoo-community.org

> [36] https://odoo-community.org/groups?unsubscribe

> [37] https://odoo-community.org/groups/contributors-15

> [38] mailto:contributors@odoo-community.org

> [39] https://odoo-community.org/groups?unsubscribe

> [40] https://apps.odoo.com/apps/modules/12.0/stock_analytic/

> [41]

> https://github.com/ForgeFlow/eficent-odoo-addons/tree/12.0/purchase_stock_a

> [42]

> https://github.com/OCA/account-analytic/tree/12.0/procurement_mto_analytic

> [43] mailto:radovan@skolnik.info

> [44] https://odoo-community.org/groups/contributors-15

> [45] mailto:contributors@odoo-community.org

> [46] https://odoo-community.org/groups?unsubscribe

> [47] https://odoo-community.org/groups/contributors-15

> [48] https://odoo-community.org/groups?unsubscribe

> [49] https://odoo-community.org/groups/contributors-15

> [50] mailto:contributors@odoo-community.org

> [51] https://odoo-community.org/groups?unsubscribe

> [52] https://odoo-community.org/groups/contributors-15

> [53] https://odoo-community.org/groups?unsubscribe

> [54] https://odoo-community.org/groups/contributors-15

> [55] mailto:contributors@odoo-community.org

> [56] https://odoo-community.org/groups?unsubscribe

> [57] https://odoo-community.org/groups/contributors-15

> [58] https://odoo-community.org/groups?unsubscribe




Reference