Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Update product stardard_price

Subscribe

Get notified when there's activity on this post

This question has been flagged
productpurchase_order
2 Replies
12116 Views
Avatar
Stavros Christodoulou

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
Avatar
Discard
Avatar
Ray Carnes
Best Answer

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

0
Avatar
Discard
Stavros Christodoulou
Author

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!

Avatar
Athan Lefas
Best Answer

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

Thank you

0
Avatar
Discard
Stavros Christodoulou
Author

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Error with 'Create & Edit' Option When Adding Products to Purchase
product purchase_order
Avatar
Avatar
1
May 24
2136
How to call a custom field within the purchase order line?
product purchase_order
Avatar
0
Sep 15
4361
Why can I not create an RFQ for an item that is not a product
product purchase_order
Avatar
Avatar
2
Mar 15
7218
Update Product custom field value when a Purchase Order is validated
product purchase_order
Avatar
Avatar
1
Mar 15
4768
automatic product filtering by supplier in purchase
product purchase_order provider
Avatar
Avatar
1
Apr 24
1685
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now