Overslaan naar inhoud
Odoo Menu
  • Aanmelden
  • Probeer het gratis
  • Apps
    Financiën
    • Boekhouding
    • Facturatie
    • Onkosten
    • Spreadsheet (BI)
    • Documenten
    • Ondertekenen
    Verkoop
    • CRM
    • Verkoop
    • Kassasysteem winkel
    • Kassasysteem Restaurant
    • Abonnementen
    • Verhuur
    Websites
    • Websitebouwer
    • E-commerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Bevoorradingsketen
    • Voorraad
    • Productie
    • PLM
    • Inkoop
    • Onderhoud
    • Kwaliteit
    Personeelsbeheer
    • Werknemers
    • Werving & Selectie
    • Verlof
    • Evaluaties
    • Aanbevelingen
    • Wagenpark
    Marketing
    • Social media Marketing
    • E-mailmarketing
    • SMS Marketing
    • Evenementen
    • Marketingautomatisering
    • Enquêtes
    Diensten
    • Project
    • Urenstaten
    • Buitendienst
    • Helpdesk
    • Planning
    • Afspraken
    Productiviteit
    • Chat
    • Goedkeuringen
    • IoT
    • VoIP
    • Kennis
    • WhatsApp
    Apps van derden Odoo Studio Odoo Cloud Platform
  • Bedrijfstakken
    Detailhandel
    • Boekhandel
    • kledingwinkel
    • Meubelzaak
    • Supermarkt
    • Bouwmarkt
    • Speelgoedwinkel
    Food & Hospitality
    • Bar en Pub
    • Restaurant
    • Fastfood
    • Gastenverblijf
    • Drankenhandelaar
    • Hotel
    Vastgoed
    • Makelaarskantoor
    • Architectenbureau
    • Bouw
    • Vastgoedbeheer
    • Tuinieren
    • Vereniging van eigenaren
    Consulting
    • Accountantskantoor
    • Odoo Partner
    • Marketingbureau
    • Advocatenkantoor
    • Talentenwerving
    • Audit & Certificering
    Productie
    • Textiel
    • Metaal
    • Meubels
    • Eten
    • Brewery
    • Relatiegeschenken
    Gezondheid & Fitness
    • Sportclub
    • Opticien
    • Fitnesscentrum
    • Wellness-medewerkers
    • Apotheek
    • Kapper
    Trades
    • Klusjesman
    • IT-hardware & support
    • Zonne-energiesystemen
    • Schoenmaker
    • Schoonmaakdiensten
    • HVAC-diensten
    Andere
    • Non-profitorganisatie
    • Milieuagentschap
    • Verhuur van Billboards
    • Fotograaf
    • Fietsleasing
    • Softwareverkoper
    Browse all Industries
  • Community
    Leren
    • Tutorials
    • Documentatie
    • Certificeringen
    • Training
    • Blog
    • Podcast
    Versterk het onderwijs
    • Onderwijs- programma
    • Scale Up! Business Game
    • Bezoek Odoo
    Download de Software
    • Downloaden
    • Vergelijk edities
    • Releases
    Werk samen
    • Github
    • Forum
    • Evenementen
    • Vertalingen
    • Word een Partner
    • Services for Partners
    • Registreer je accountantskantoor
    Diensten
    • Vind een partner
    • Vind een boekhouder
    • Een adviseur ontmoeten
    • Implementatiediensten
    • Klantreferenties
    • Ondersteuning
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Vraag een demo aan
  • Prijzen
  • Help

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

  • CRM
  • e-Commerce
  • Boekhouding
  • Voorraad
  • PoS
  • Project
  • MRP
All apps
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Help

Cost price update based on last PO price/average price

Inschrijven

Ontvang een bericht wanneer er activiteit is op deze post

Deze vraag is gerapporteerd
cost_price
7 Antwoorden
23120 Weergaven
Avatar
Paulo Matos‏

Dear all,

I cannot find a way to have Odoo 7 to automatically update the product cost price based on the last purchase order made or at least by the average cost price.

What I need is to have Odoo to automatically update the product cost price whenever I register a PO.

Any idea?

Thank you very much

Paulo

 

0
Avatar
Annuleer
Avatar
Zura Tsiklauri
Beste antwoord

The solution is Anglo Saxion Accounting. Then set the default in caaounting tab of product: Valuation: Real Time, Automated. and also set: Average price default in procurement tab of product.

U get auto update of cost price based on average and also cost of goods journal entry when selling. 

2
Avatar
Annuleer
Avatar
Akhil P Sivan
Beste antwoord

You can build your own custom module for this requirement. You can proceed in these ways: You should first inherit mrp.bom and add a new field 'price_unit': fields.float('Unit Price') and redefine the onchange_product_id function define compute_price and compute_total function to calculate "line price" and "total price" Then you have to inherit mrp.production and define compute_production_cost function to update cost_price from BOM. We have created this custom module and it works perfect , in my module it takes avg purcahse price in BOM and we added an extra tab to manufactring form to compute Production Cost , in that tab you can add extra charges like electicity etc.. , that charges also added to cost by calculating per_unit charge depending on UOM. for any help you can contact  akhil.p.sivan007@gmail.com

1
Avatar
Annuleer
Avatar
Paulo Matos‏
Auteur Beste antwoord

Dear Kevin,

Thank you very much.

In fact, what I need is a module that updates the product cost price when we register a Purchase Order.

When we register a PO on core Odoo, the product price on the product table is not automatically updated. What I need is to have a module that updates this price whenever I register a purchase order. Perhaps there's a way to do it on standard Odoo functionality but I do not know how. Can you please help?

Thank you once again

Regards

Paulo Matos

1
Avatar
Annuleer
Avatar
E.R. Spada
Beste antwoord

Yes, the above is correct as we are using purchase_landed_costs and confirm the following with camptocamp module:

=> I understand. The point is, this is very difficult and cost a lot to achieve due to the structure of OpenERP (or odoo).

Currently, we solved that this way: * AVG price is computed with the PO landed costs when receiving the goods (picking ->done)

 * The margin in the SO line are computed using the current value (means the actual AVG price before ordering new goods to the supplier)

 * IF THE CUSTOMER INVOICE is generated AFTER deliveries, then you can have the proper margin computed in the invoice line using the product_historical_margin module). Because here, the AVG cost taken is the one after validating the incoming shipment from the supplier. So:

a) SO confirmed by customer with margin = current value

b) PO ordred to supplier

c) Goods received and AVG price updated

d) Customer invoice generated with proper margin

So my advice is here to compute commission based on invoice line instead of sales order lines.

Our next module is to create an a workflow "Waiting Landed Costs" so we will not receive the product until we have all Landed costs on the product view and sales order line. With using margin-analysis modules from camptocamp we can generate the true margin for reporting

1
Avatar
Annuleer
Paulo Matos‏
Auteur

Thank you E.R. Spada, I will give it a try on this modules and see how it works for my actual needs Regards

Avatar
Kevin McMenamin
Beste antwoord

Obviously this is not standard logic where the average price is updated based on the receipt of the goods.

You could change your cost method to standard cost and develop a module that updates the standard cost that is called on PO confirm.

0
Avatar
Annuleer
Avatar
Victor PANG KIN LAN
Beste antwoord

In the previous OpenERP version, average cost could be activated. However, the calculation was incorrect in some cases pertaining to the sequence of the stock moves.

0
Avatar
Annuleer
Avatar
Manchester Factory
Beste antwoord

w

-1
Avatar
Annuleer
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden
Gerelateerde posts Antwoorden Weergaven Activiteit
Cost Price for Variants
cost_price
Avatar
Avatar
1
apr. 21
5099
Allow Warehouse Manager user to edit cost price in Product form
cost_price
Avatar
Avatar
1
sep. 20
3396
COSTING METHOD
cost_price
Avatar
Avatar
1
jan. 20
3505
Porduct Cost - How Can I add this?
cost_price
Avatar
Avatar
Avatar
3
aug. 17
3557
Production order settlement
cost_price
Avatar
0
mrt. 15
4489
Community
  • Tutorials
  • Documentatie
  • Forum
Open Source
  • Downloaden
  • Github
  • Runbot
  • Vertalingen
Diensten
  • Odoo.sh Hosting
  • Ondersteuning
  • Upgrade
  • Gepersonaliseerde ontwikkelingen
  • Onderwijs
  • Vind een boekhouder
  • Vind een partner
  • Word een Partner
Over ons
  • Ons bedrijf
  • Merkelementen
  • Neem contact met ons op
  • Vacatures
  • Evenementen
  • Podcast
  • Blog
  • Klanten
  • Juridisch • Privacy
  • Beveiliging
الْعَرَبيّة 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 een suite van open source zakelijke apps die aan al je bedrijfsbehoeften voldoet: CRM, E-commerce, boekhouding, inventaris, kassasysteem, projectbeheer, enz.

Odoo's unieke waardepropositie is om tegelijkertijd zeer gebruiksvriendelijk en volledig geïntegreerd te zijn.

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