This question has been flagged
2 Replies
3810 Views

I would expect the costs of sold products to be tracked in the analytic account linked with the sales order but Odoo seems not to do this.

Why is that and is there a module available which provides this feature?

Our goal is to have one place for reviewing the rentability of sales orders. Analytic accounts seem to provide most of this functionality (they keep track timesheet costs and invoices). Or should we look in another direction?

Avatar
Discard
Best Answer

Odoo is tracking only cost from purchase and revenues from sales on its analytic feature.  The lacking in the analytics is the tracking cost of internal overhead.  Such as for equipment owned by a company that is used for certain hours for a project, man-power cost doing the task on the project, need to create journal entry if it is needed in PnL, while not make a double entry of the cost  (so need to credit the depreciation expenses account or salary expenses account as the contra on journal item entry for such cost on a project).

Avatar
Discard
Best Answer

Analytic accounts only track revenues from Sales Orders.

Expenses are tracked on Purchase Orders.

If you purchase a product for a Customer then the cost of that product would be recorded when the Vendor Bill for the Purchase Order is validated.

Avatar
Discard

Ray Carnes:

The cost of the products in the moment of the purchase should not be taken to analize revenue, That is completely wrong unless you have no other choise, which means that you are not integrating your inventory with your accounting, but Odoo already does that.

If you purchase product X specifically for Customer Y for Project Z then it is fine to use the cost, as that is the product you are giving them. You statement relates to using Purchase Orders for products that won't be guaranteed to ship to the Customer.

Author

We have a lot of products which are not specifically purchased for a customer / sales order.

One type of our products is purchased in large quantities and sold as needed.

Other products are raw materials which are used to produce sellable products.

In both cases we need the cost of these products in the analytic account.

You can also review the margin for products in other ways - if you check on "Margins - show margins on orders" in Sales you can then turn on the margin and cost fields and see both on every order - if you check or "Margin Analysis - Monitor your product margins from invoices" in Accounting you get the "Product Margins" report.

If your company purchase for a specific customer/project, there is still no guarantee that the customer will buy them all or that a total consumption will be achieve, you must consider scrapped products or delivery issues for instance. What you are stating means that the COGS, valuation methods and IFRS are not needed.

Companies use "analytics accounts" because it is the only feature that fits for the set up of their business lines, business units, projects (among others) and because in the end what they need is to meassure their profitability. So it is a serious matter that the COGS are not automatically integrated with the analytic accounts, specially since you already have them linked in the sales orders.

Author

Ray Carnes:

We don't need margins for products. We need to analyse our sales / projects.

We need to keep track of all the costs accumulating on a project.

We have costs from working hours in office and on site and record these costs in the analytic account of the sale / project via time tracking.

We have costs from buying products specifically for one products. Selecting an analytic account for products in incoming invoice registers these costs on the analytic account of this sale / project.

And, like I said, we have products in stock for direct usage in different sales or for production of sellable products. And we need to keep track of the costs of these products used for sales / projects.