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?

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.