Skip to Content
This question has been flagged
1 Reply
756 Views
Avatar
Bowman Analytics

I am looking to track things like Travel costs which are not a standard cost from one SO to the next. Our database is set up to pull up the part number cost into the SO as a default which is good, but if i change that amount in the SO, it then changes that value with in inventory>product.


As a result, the cost is the same on all of our historical SOs.

Avatar
Discard
Chris TRINGHAM

Standard Odoo should not do that. The price on the product (or from the pricelist) is used on the Sales Order. You can feely change the price on the sales order but that won't affect the product price or the pricelist. Maybe you have an add-on or customization?

Bowman Analytics
Author

Thank you Chris and Parth. I have this particular part as Sevice / Travel (US), and it changes in the way i describe. I'm not sure where to check if this is a customization thing or if there is something in the cost method below (AVCO, FIFO, Standards Price).


Avatar
Parth Unjiya
Best Answer

For costs that vary from one SO to another (like travel), the best practice is to create "service" type products. Here's how:

  1. Create a Service Product:
    • Go to Sales > Products.
    • Create a new product (e.g., "Travel Expenses").
    • Set the "Product Type" to "Service."
    • Under the "Sales" tab, you can set a default price, but this is just a suggestion. You'll be able to modify it on each Sales Order.
  2. Add the Service Product to the Sales Order:
    • When creating a Sales Order, add the "Travel Expenses" product as a line item.
    • Enter the specific cost for that particular Sales Order. This will not affect the cost of the actual product or any other Sales Orders.

Why This Works

  • No Inventory Impact: Service products don't affect your inventory valuation.
  • Flexibility: You can set a different price for the service on each Sales Order.
  • Accurate Cost Tracking: You'll have a clear record of travel expenses (or other variable costs) associated with each specific sale.
Avatar
Discard