1. Mailing Lists
  2. Contributors
  3. Re: Consuming stock internally while using the its costs in project

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Consuming stock internally while using the its costs in project

Avatar

Re: Consuming stock internally while using the its costs in project

by
Data Dance s.r.o., Radovan Skolnik
- 12/02/2024 10:30:24 
Graeme & others,

thank you for your input. I went for option 2. and it seems to be working. I have wanted to keep this tied to the project as other inputs affect profitability (timesheets for example) and it is created from sale order. The general scenario is:

1. I use OCA stock_analytic and stock_picking_analytic modules to get analytic distribution into stock.picking and stock.move and stock.move.line
2. I have created a scrap location representing the kitchen where I consume/expense/scrap the ingredients
3. I have an automatic inventory valuation setup (AVCO but I guess would work with any other)
4. I have created a module that includes valuation records for scrap operations into project profitability.

So when I want to expens the ingredients I create an stock picking to the scrap (kitchen) location using the project's analytical tag. The ingredients will get scrapped creating a negative valuation record with analytic distribution from the stock picking. The project module adds account.analytic.lines (the valuation) records with (quite naive but works) domain like this into profitability calculation: 

            ("account_id", "=", self.analytic_account_id.id),
            (
                "move_line_id.move_id.stock_move_id.location_dest_id.usage",
                "=",
                "inventory",
            ),
            ("category", "!=", "manufacturing_order"),

Any comments on this are welcome. I have migrated stock_analytic and stock_picking_analytic to 17.0 and will open PRs soon. If there was an interest into my module I will gladly donate to OCA.

Best regards

	Radovan Skolnik

On streda 7. februára 2024 21:12:41 CET Graeme Gellatly wrote:

> There are a couple of things I can think of.

> 1. Manufacturing Orders - ingredients as raw materials, portions as outputs,

> workorders as labour. Delivery Order for what is delivered, Analytic

> Accounts on sale. Can be done with/without projects. Will add up all your

> costs. 2. Stock locations - this is not quite the same fit, but many times

> I have faced scenarios where stocked goods are required for internal

> projects and the easiest way has been a stock transfer to a location with a

> different account set. Analytics could be added to both manufacturing and

> stock easily enough and I believe OCA has modules to do so. Also for

> linking MO's to projects. If you had a separate product / customer and used

> anglosaxon you would end up with effectively actual cost, unfortunately

> actual cost is an Odoo Enterprise only direct from Odoo feature at the

> moment, but for something this basic it could be done quite simply.

> Otherwise you could use average cost and rely on analytics/other reporting

> for actuals. On Thu, Feb 8, 2024 at 8:41 AM Radovan Skolnik <

> notifications@odoo-community.org [1] > wrote: Hello,

> I am dealing with a customer who provides catering services. The price is

> dependent only on how many portions they serve regardless of the costs of

> labour and/or ingredients used.

> I am planning to use projects (analytic accounts) to keep track of

> profitability related to Sale Orders that will be invoiced based od

> delivered quantities (of portions). Now I am scratching my head as on how

> to consume storable stock (ingredients) in a way that its value would be

> added as a cost to the project. Internal transfers? Purchase Order within

> the organization? The cost of staff should be possible to be dealt with

> with timesheets. Is that so?

> Any advice is highly welcome. Thank you

> Best regards

> Radovan Skolnik

> 

> 

> _______________________________________________

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

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

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

> 

> 

> _______________________________________________

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

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

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

> 

> 

> 

> [1] mailto:notifications@odoo-community.org

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

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

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

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

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

Reference