This question has been flagged
1 Reply
21088 Views
purchaseproductpriceppvvariance
Avatar
Geoff Kimpton

Purchase price variance (PPV) is the difference between the actual purchased price of an item and a standard cost (or baseline cost, or received cost) of that same item. In systems that process the inbound delivery from the Vendor prior to the Invoice from the Vendor, there can be discrepancies - mainly due to either the Vendor charging more or less than promised - or because the standard / baseline cost is not being updated when prices change.

Does Odoo support this concept?

How would PPV be managed during the processing of the inbound delivery and/or the recording of the vendor invoice?


Avatar
Discard
Ray Carnes

It seems that this may be a feature which would be unneccisary for my sole trader business.

So, the remaining question is can I leave the "price difference account" field blank or would this cause other problems?

James White

Thanks @Ray.  That almost made it work for me....  but I am an I.T. guy, not an accountant.  I think the question still in my mind is: why would the PO price be different than the Invoice price?  Is this simply just in case of errors?  Or is this going to be due to possible fluctuations in currency values?  I think that both of those cases would require a DIFFERENT account be used (Expense:VendorError or Currency)

If you (or anyone who can answer) are still monitoring this thread, can you give an example of which accounts you are using for:

  • Income Account

  • Expense Account

  • Price Difference Account


Ray Carnes (ray)

Differences are due to the Vendor charging more or less than they quoted you for and should be investigated. (Many businesses sign quotes and push back on any differences).

Avatar
Ray Carnes
Best Answer

UPDATED FOR v13, v14, v15.


This field is setup on each Product category when you have Automated Inventory valuation setup:


The help (when you hover over the field label) is "This account will be used to value price difference between purchase price and accounting cost."

If a Purchase Order shows an item is $25 but the Invoice is for $26 then $1 X is charged to this account, since the warehouse has already received $25 x and the corresponding entry on Invoicing needs to balance with it.

You should periodically review the balance in this account, to determine if your Vendors are adhering to your purchasing agreements, and re class the balance to COGS once the goods are sold.

You may also want to investigate the use of Landed Costs if you wish to increase the value of Inventory assets already received.

Avatar
Discard
Audrey Ng

Hi Ray,

I am using the Anglo Saxon accounting method.
My accountant is stating that the product's value is not matching with the amount in the bill. I have set up this Price Difference Account, but how can we reflect the difference as an additional cost of the product?

Our business places a PO, receives the goods, and then receives a bill from the supplier after that.

Eg;
PO is $100
After receiving goods, product value is recorded as $100.
Bill received is $150
Price Difference account record $50.

Is there a way where we can "update" the inventory valuation for this item to be $150 (based on the amount in the bill), or do you know what is the best practice in this case?

Much Appreciated.

Thank you.

Regards,
Audrey Ng

Dallas Dean (dade)

@Audrey Ng,

As Ray mentioned, a Landed Cost would be the best way to update the inventory valuation of the product to match the bill (assuming a FIFO or AVCO costing method). You can add a $50 landed cost to the receipt of the product to increase the value of the product to $150.

For more information on landed costs, check out the documentation here:
https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/reporting/integrating_landed_costs.html