Archives
Contributors
Re: Consuming stock internally while using the its costs in project
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
by Radovan Skolnik - 10:31 - 12 Feb 2024
Reference
-
Consuming stock internally while using the its costs in project
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
by Radovan Skolnik - 08:40 - 7 Feb 2024