Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
1159 Tampilan

Hello Odooers,


In the past I made this post : "How to replace BoM lines with import" (Edit : links strips all the post content)


Now it's not working anymore. Odoo 17 Enterprise edition.


If I remove a BOM component of my Excel import file, mrp_bom_line aren't removed. Example file :


NB : the "External ID" aren't changed.


The only way I found is to remove all mrp_bom_line via SQL query, and re-import BOMs.


DELETE FROM mrp_bom_line

WHERE mrp_bom_line.id IN (

    SELECT mrp_bom_line.id

    FROM mrp_bom_line

    JOIN mrp_bom ON mrp_bom_line.bom_id = mrp_bom.id

    JOIN stock_picking_type ON mrp_bom.picking_type_id = stock_picking_type.id

    JOIN stock_warehouse ON stock_picking_type.warehouse_id = stock_warehouse.id

    WHERE stock_picking_type.sequence_code = 'MO'

    AND stock_warehouse.code = 'SPAM'

);


Thanks



Avatar
Buang
Jawaban Terbai

Hi Stéphane Reynders,

I think this video can help you (starting at 51:00 in this video):

https://www.youtube.com/watch?v=Auaqj6WtdcM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=5

Avatar
Buang
Penulis

Thank you, but I will not buy a 900 € addon which I need to re-purchase when Odoo version upgrade.

Hi Stéphane Reynders,

I see in the description of this module there is a sentence "Just purchase a version and you'll get free updates when new versions become available" so if the lack of a solution costs you more than the amount you have to spend for this module, you can contact the module author to ask for details. Hope you will soon find an effective solution.

Post Terkait Replies Tampilan Aktivitas
3
Sep 24
3074
2
Okt 23
2346
0
Jan 25
973
1
Jun 25
4683
0
Feb 19
3901