Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Diskusi
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

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

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Cost price update based on last PO price/average price

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
cost_price
7 Replies
23092 Tampilan
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
Buang
Avatar
Zura Tsiklauri
Jawaban Terbai

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
Buang
Avatar
Akhil P Sivan
Jawaban Terbai

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
Buang
Avatar
Paulo Matos‏
Penulis Jawaban Terbai

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
Buang
Avatar
E.R. Spada
Jawaban Terbai

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
Buang
Paulo Matos‏
Penulis

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
Victor PANG KIN LAN
Jawaban Terbai

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
Buang
Avatar
Kevin McMenamin
Jawaban Terbai

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
Buang
Avatar
Manchester Factory
Jawaban Terbai

w

-1
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Cost Price for Variants
cost_price
Avatar
Avatar
1
Apr 21
5065
Allow Warehouse Manager user to edit cost price in Product form
cost_price
Avatar
Avatar
1
Sep 20
3385
COSTING METHOD
cost_price
Avatar
Avatar
1
Jan 20
3494
Porduct Cost - How Can I add this?
cost_price
Avatar
Avatar
Avatar
3
Agu 17
3548
Production order settlement
cost_price
Avatar
0
Mar 15
4479
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة 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 adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

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