Skip to Content
Odoo Menu
  • Prisijungti
  • Išbandykite nemokamai
  • Programėlės
    Finansai
    • Apskaita
    • Pateikimas apmokėjimui
    • Sąnaudos
    • Skaičiuoklė (BI)
    • Dokumentai
    • Pasirašymas
    Pardavimai
    • CRM
    • Pardavimai
    • Kasų sistema - Parduotuvė
    • Kasų sistema - Restoranas
    • Prenumeratos
    • Nuoma
    Svetainės
    • Svetainių kūrėjimo įrankis
    • El. Prekyba
    • Internetinis Tinklaraštis
    • Forumas
    • Tiesioginis pokalbis
    • eMokymasis
    Tiekimo grandinė
    • Atsarga
    • Gamyba
    • PLM
    • Įsigijimai
    • Priežiūra
    • Kokybė
    Žmogaus ištekliai
    • Darbuotojai
    • Įdarbinimas
    • Atostogos
    • Įvertinimai
    • Rekomendacijos
    • Transporto priemonės
    Rinkodara
    • Socialinė rinkodara
    • Rinkodara el. paštu
    • SMS rinkodara
    • Renginiai
    • Rinkodaros automatizavimas
    • Apklausos
    Paslaugos
    • Projektas
    • Darbo laiko žiniaraščiai
    • Priežiūros tarnyba
    • Pagalbos tarnyba
    • Planavimas
    • Rezervacijos
    Produktyvumas
    • Diskucija
    • Patvirtinimai
    • IoT
    • VoIP
    • Žinių biblioteka
    • WhatsApp
    Trečiųjų šalių programos Odoo Studija Odoo debesijos platforma
  • Pramonės šakos
    Mažmeninė prekyba
    • Knygynas
    • Drabužių parduotuvė
    • Baldų parduotuvė
    • Maisto prekių parduotuvė
    • Techninės įrangos parduotuvė
    • Žaislų parduotuvė
    Food & Hospitality
    • Barai ir pub'ai
    • Restoranas
    • Greitasis maistas
    • Guest House
    • Gėrimų platintojas
    • Hotel
    Nekilnojamasis turtas
    • Real Estate Agency
    • Architektūros įmonė
    • Konstrukcija
    • Estate Managament
    • Sodininkauti
    • Turto savininkų asociacija
    Konsultavimas
    • Accounting Firm
    • Odoo Partneris
    • Marketing Agency
    • Teisinė firma
    • Talentų paieška
    • Auditai & sertifikavimas
    Gamyba
    • Textile
    • Metal
    • Furnitures
    • Maistas
    • Brewery
    • Įmonių dovanos
    Sveikata & Fitnesas
    • Sporto klubas
    • Akinių parduotuvė
    • Fitneso Centras
    • Sveikatos praktikai
    • Vaistinė
    • Kirpėjas
    Trades
    • Handyman
    • IT įranga ir palaikymas
    • Saulės energijos sistemos
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Kiti
    • Nonprofit Organization
    • Aplinkos agentūra
    • Reklaminių stendų nuoma
    • Fotografavimas
    • Dviračių nuoma
    • Programinės įrangos perpardavėjas
    Browse all Industries
  • Bendrija
    Mokykitės
    • Mokomosios medžiagos
    • Dokumentacija
    • Sertifikatai
    • Mokymai
    • Internetinis Tinklaraštis
    • Tinklalaidės
    Skatinkite švietinimą
    • Švietimo programa
    • Scale Up! Verslo žaidimas
    • Aplankykite Odoo
    Gaukite programinę įrangą
    • Atsisiųsti
    • Palyginkite versijas
    • Leidimai
    Bendradarbiauti
    • Github
    • Forumas
    • Renginiai
    • Vertimai
    • Tapkite partneriu
    • Services for Partners
    • Registruokite jūsų apskaitos įmonę
    Gaukite paslaugas
    • Susiraskite partnerį
    • Susirask buhalterį
    • Susitikti su konsultantu
    • Diegimo paslaugos
    • Klientų rekomendavimas
    • Palaikymas
    • Atnaujinimai
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Gaukite demo
  • Kainodara
  • Pagalba

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

  • CRM
  • e-Commerce
  • Apskaita
  • Atsarga
  • PoS
  • Projektas
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Žymos (View all)
odoo accounting v14 pos v15
About this forum
Pagalba

Export MO Costs shown in overview report

Prenumeruoti

Get notified when there's activity on this post

This question has been flagged
costManufacturing Order
3 Replies
3851 Rodiniai
Portretas
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
Portretas
Atmesti
Portretas
Hamid Ahmadimoghaddam
Best Answer

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
Portretas
Atmesti
Portretas
Rob Pletscher
Autorius Best Answer

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
Portretas
Atmesti
Rob Pletscher
Autorius

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!

Portretas
Darshan Gajjar
Best Answer

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
Portretas
Atmesti
Enjoying the discussion? Don't just read, join in!

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

Registracija
Related Posts Replies Rodiniai Veikla
Cost not calculated for by products in V18 E
accounting cost Manufacturing Order
Portretas
Portretas
1
rugs. 25
616
Editing the Cost of Components in the Cost Analysis
cost analysis Manufacturing Order
Portretas
Portretas
Portretas
Portretas
4
rugp. 24
3087
How do you find the amount of raw materials from finished products?
Manufacturing Order
Portretas
Portretas
1
geg. 24
2467
How Can I set about Manufacturing Order?
Manufacturing Order
Portretas
0
geg. 24
2052
Manufacturing 'Mark as Done' error
Manufacturing Order
Portretas
Portretas
2
kov. 23
3189
Bendrija
  • Mokomosios medžiagos
  • Dokumentacija
  • Forumas
Atvirasis kodas
  • Atsisiųsti
  • Github
  • Runbot
  • Vertimai
Paslaugos
  • Odoo.sh talpinimas
  • Palaikymas
  • Atnaujinti
  • Pritaikytas programavimo kūrimas
  • Švietimas
  • Susirask buhalterį
  • Susiraskite partnerį
  • Tapkite partneriu
Apie mus
  • Mūsų įmonė
  • Prekės ženklo turtas
  • Susisiekite su mumis
  • Darbo pasiūlymai
  • Renginiai
  • Tinklalaidės
  • Internetinis Tinklaraštis
  • Klientai
  • Teisinis • Privatumas
  • Saugumas
الْعَرَبيّة 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 yra atvirojo kodo verslo programų rinkinys, kuris apima visas įmonės poreikius: CRM, El. Prekybą, Apskaitą, Atsargų, Kasų sistemą, Projektų valdymą ir kt.

Unikali Odoo vertės pasiūla – būti tuo pačiu metu labai lengvai naudojama ir visiškai integruota sistema.

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