Skip to Content

Sales Order Line Cost Price

by
Odoo

$ 160.38

v 17.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
• Sales (sale_management)
• Invoicing (account)
Lines of code 113
Technical Name fal_sale_order_line_cost_price
LicenseOPL-1
Websitehttps://www.cluedoo.com/shop/lic-clu-set-0032-sales-order-line-cost-price-5846
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
• Sales (sale_management)
• Invoicing (account)
Lines of code 113
Technical Name fal_sale_order_line_cost_price
LicenseOPL-1
Websitehttps://www.cluedoo.com/shop/lic-clu-set-0032-sales-order-line-cost-price-5846

STORY BEHIND THE FEATURE

ODOO BEHAVIOUR

By default, Odoo does not include fields such as Delivery Out Cost Price, Snapshot Cost Price, Product Margin, or Product Margin (%) under Order Lines in Sales Order.


CLUEDOO BEHAVIOR

Cluedoo has added extended features to address specific limitations and to enhance the sales process in Odoo:
1. Delivery Out Cost Price: Provides more accurate cost and profitability calculations based on the actual cost of goods at the time of delivery.
2. Snapshot Cost Price: By locking in the cost at the sales order creation, businesses can estimate their profit margins at the time of order confirmation.
3. Product Margin & Profit Margin (%):
- Accurate Profit Tracking: By calculating the margin based on the Delivery Out Cost Price after stock picking is done, businesses get a true representation of profitability.
- Pre-Delivery Margin Analysis: When stock picking is not done, calculating the margin based on Snapshot Cost Price gives businesses an early indication of profitability, helping in decision-making before the product is even delivered.
CLUEDOO RECOMMENDATIONS

​Install on 100% of the database.




HOW TO USE THIS MODULE

1. Create Sales Order. We have several additional fields in SO lines. Delivery Out Cost Price, Snapshot Cost Price, Product Margin, Product Margin (%).

Snapshot Cost Price is the cost price at the time we create the sales order.

We will get the delivery out cost after we deliver the products.

The delivery cost depends on the cost price of the product at the time of delivery.

We can also manually update the Snapshot Cost Price and Delivery Out Cost Price. If we update the delivery out cost, it will update the product margin too.


if the Stock Picking is done, the calculation is Sales Price - Delivery Out Cost Price
if the Stock Picking is not done, the calculation is Sales Price - Snapshot Cost Price 









Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
by
Superfoodsonline B.V.
on 6/26/25, 4:06 AM

Hi, 

In our connected ms power bi, we require a reliable way to report and analyze the actual purchase cost per sale order line at the time of delivery/invoicing, including all landed costs and possible retroactive corrections. 

Currently, Odoo’s standard field purchase_price on the sale order line reflects only the cost known at the moment of sale/invoice creation. In case of customer backorders, partial deliveries, or when landed costs are applied after the sale, this value is often incorrect or empty (0).

In this context, backorders refer to a customer ordering a product via the webshop that is not available in our warehouse at that moment. The product is only purchased after the customer has placed the order. It may then be delivered in one or more batches. As a result, the actual cost (including purchase price and possible landed costs) is often only known after the sale or invoice is created.

Does your product support the "retroactive cost per sale line" and can be installed on odoo 14?

Greetings,
Pieter