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

Export MO Costs shown in overview report

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
costManufacturing Order
3 Replies
3740 Tampilan
Avatar
Rob Pletscher

This seems like a simple question but I have not been able to get the result I am looking for. I am track the parts and labour of a complicated assembly with many sub assemblies. I want to see which sub assembly was more/less expensive than when we previously built the exact same thing. 

Since I can't export a top level cost break down from a large assembly my approach is to expand the entire traceability report from the top level (this will show me the work orders each component was built under) and then export another list of all our closed work orders and their corresponding costs. Match them up in excel and then I will be able to compare different builds. 

My current struggle is to figure out the best way to export the MO cost shown on the overview report. I tried a previously suggested approach of adding the unit price to the stock moves window but for some reason the numbers on the stock moves list does not match the numbers seen on the overview report or cost analysis report. 

0
Avatar
Buang
Avatar
Hamid Ahmadimoghaddam
Jawaban Terbai

Hi Rob,

check "Production Analysis" Report in Pivot-view. Maybe that would be enough? Besides, you can export it to the spreadsheet in Odoo, too.


I hope it helped.

Hamid - bitigloo GmbH

0
Avatar
Buang
Avatar
Rob Pletscher
Penulis Jawaban Terbai

Hi Darshan, 

In theory this sounds like exactly what I need to do. However, I don't see the ability to export the cost analysis report. If I select the check box in MO list view, and go to Actions - I don't see anything for cost analysis. If I open up the MO and then select the cost analysis button at the top of the screen I only have the option to print to PDF but no option to export a .csv. Am I missing something?

0
Avatar
Buang
Rob Pletscher
Penulis

Hamid, I can't seem to comment on your post but yes that is exactly what I was looking for! Thank you so much you are a life saver!

Avatar
Darshan Gajjar
Jawaban Terbai

Hello Rob,

To efficiently export the manufacturing order (MO) costs from the overview report in Odoo, you can follow these steps:

  1. Navigate to Manufacturing Module: Go to the Manufacturing module in your Odoo instance.
  2. Access the Manufacturing Orders: Navigate to the list of manufacturing orders and select the specific manufacturing order you want to track costs for.
  3. Generate a Cost Analysis Report: From the specific manufacturing order, generate a cost analysis report that includes all the costs associated with the assembly. This report will provide you with a breakdown of costs for parts, labor, and any other expenses.
  4. Export the Cost Analysis Report: Export the cost analysis report to a format compatible with Excel (e.g., CSV) so that you can manipulate and analyze the data in Excel.
  5. Export Closed Work Orders and Costs: Export a list of all closed work orders and their corresponding costs from Odoo. This data should include the costs associated with previous builds of the same assembly.
  6. Match and Compare in Excel: Import both the cost analysis report and the exported data of closed work orders into Excel. Match the costs of each subassembly or component from the cost analysis report with the costs from previous builds. You can then calculate the differences to determine which subassemblies were more or less expensive in comparison to previous builds.

Ensure that you accurately capture and align the costs and data from the cost analysis report and the exported closed work order data for a comprehensive comparison.

If you encounter discrepancies between the numbers in the stock moves list and the overview report, consider reviewing the configurations and settings related to costing methods and stock valuations in Odoo to ensure consistency in cost calculations.

0
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 not calculated for by products in V18 E
accounting cost Manufacturing Order
Avatar
Avatar
1
Sep 25
546
Editing the Cost of Components in the Cost Analysis
cost analysis Manufacturing Order
Avatar
Avatar
Avatar
Avatar
4
Agu 24
2971
How do you find the amount of raw materials from finished products?
Manufacturing Order
Avatar
Avatar
1
Mei 24
2424
How Can I set about Manufacturing Order?
Manufacturing Order
Avatar
0
Mei 24
2003
Manufacturing 'Mark as Done' error
Manufacturing Order
Avatar
Avatar
2
Mar 23
3127
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