Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Update product stardard_price

By
Stavros Christodoulou
on 3/22/14, 2:38 PM 1,651 views

I would like to change the standard_price of product to include the discount from my supplier. At the moment the standard_price is updated without the discount.

Where I can find the the code which updates the standard_price when the product is received after the purchase order?

Thank you

0
Athan Lefas
On 10/20/14, 4:31 AM

I have the same problem as Stavros. Is there any possible way to fix that?

Thank you

Dear Athan, Our company can help you with that. Contact me at info(at)arinet.com.cy

Stavros Christodoulou
on 10/20/14, 4:37 AM
0

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 3/22/14, 3:19 PM

Is average pricing what you want?


OpenERP will automatically set the product price in response to each goods receipt movement into the warehouse (a Purchase from a Supplier).

At each goods receipt, the product price is recalculated using the following accounting formula:

NP = (OP * QS + PP * QR) / (QS + QR)

The following notation is used:

  • NP: New Price,

  • OP: Old Price,

  • QS: Quantity actually in Stock,

  • PP: Price Paid for the quantity received,

  • QR: Quantity Received.

If the products are managed in this way, OpenERP will open a window that lets you specify the price of the product received at each goods receipt. The purchase price is, by default, set from the purchase order, but you can change the price to add the cost of delivery to the various received products.

Once the receipt has been confirmed, the price is automatically recalculated and entered on the product form.


To congfigure OpenERP to do this:


1) Navigate to Settings --> Configuration --> Purchasing

2) Check the box next to Compute Product cost price based on average cost:

image description

3) On each product you want managed this way, on the Procurements tab, set the Costing Method to Average Price:

image description

Dear Ray, Thank you for the quick response! The average price is computed correctly. This is done when an Invoice for a purchase is validated. What I want to achieve is to save the last purchase price of an item in a new field. When a purchase order is validated and received, OpenERP updates the standard_price of the item but it does not include any discounts given by the supplier (Purchase order lines with discounts module). I want to know which part of the source code saves the new standard_price to the product. Thanks again for your help!

Stavros Christodoulou
on 3/24/14, 7:00 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 3/22/14, 2:38 PM
Seen: 1651 times
Last updated: 3/16/15, 8:10 AM