Skip to Content
Menu
This question has been flagged
3 Replies
928 Views


I receive fixed quotes from my vendor for a requested product quantity. The product price is tied to a commodity with a variable price. For instance I request a quote for 500 units and the vendor quotes $206. 

I am unable to edit the 'Tax Excl.' column on the Purchase Order line item to handle this fixed price. My only option is to calculate the unit price. This is often a fractional value (i.e. $.412/unit) which is rounded and yields the wrong PO total. This problem propogates to the bill as well.

The quantities I request vary and I may request 500 but only 499 are available. It is not feasible to creating units of measure to accomodate all of these quantities.

I am using v17. I have previously used v14 and don't recall this being a problem.

Is there a setting or mechanism to handle this problem?

Avatar
Discard
Best Answer

See response below

Avatar
Discard
Best Answer

In Odoo 17, you can handle the scenario where the vendor provides a fixed quote for a requested product quantity by utilizing the "Fixed Price" feature in the Purchase Order. Here's how you can address this issue:

  1. Create a Purchase Order:
    • Navigate to the Purchase app.
    • Create a new Purchase Order for the desired vendor and product.
  2. Add Product:
    • Add the product to the Purchase Order line.
  3. Set Fixed Price:
    • In the Purchase Order line item, click on the 'Unit Price' field.
    • Select the "Fixed Price" option from the dropdown menu.
    • Enter the fixed price provided by the vendor.
  4. Adjust Quantity (if needed):
    • If the requested quantity varies from the vendor's quote, adjust the quantity accordingly on the Purchase Order line item.
  5. Verify Total Amount:
    • Verify that the total amount on the Purchase Order reflects the fixed quote provided by the vendor.
  6. Create Invoice:
    • When you receive the bill from the vendor, create an invoice based on the Purchase Order.
  7. Match Invoice:
    • Match the invoice with the corresponding Purchase Order to ensure accuracy.

By using the "Fixed Price" option in the Purchase Order, you can accurately reflect the vendor's fixed quote and avoid rounding issues with fractional unit prices. This approach ensures consistency between the Purchase Order and the invoice, allowing for accurate billing based on the vendor's quote.

Avatar
Discard
Author

Muhammad,

There is no 'Fixed Price' option when I click the 'Unit Price' field on a PO line item.

Best Answer

I think it was the same in V14, that you only can change the unit price. There is a reason for this for calculation of product cost, I think. (FIFO and AVCO cost, use the unit price for calculation

What we do: Product are measured in Kilos og Meter, we purchase and sell in Tons and Kilometer.  Then the price is more accurate.

Even then it not always match. In the vendor bill we add a line with the correction, so the total bill value matches. I

It is not perfect solution, but the discrepancies are acceptable.

Avatar
Discard
Related Posts Replies Views Activity
2
May 25
349
0
May 25
193
1
Apr 25
280
1
Apr 25
304
1
Apr 25
319