ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

How we can extract particular data in excel?

bom

#1

how we extract particular data excel, Now If I try to extract data from BOM, all Bom getting extracted , Any solution???


#2

I haven’t tried this via export, but you could write a mysql query to extract specific data. It does get messy if you try to do all the BOM levels at once (with my limited sql skills anyway). I just ran separate queries for each like this

SELECT parent,item_code, qty_consumed_per_unit,rate, amount, stock_uom FROM `tabBOM Item` 
WHERE parent LIKE '%YOUR_PRODUCT_CODE%' 
/*group by item_code*/ /*optional*/
ORDER BY parent, item_code

SELECT parent,item_code, qty_consumed_per_unit,rate, amount, stock_uom FROM `tabBOM Explosion Item` 
WHERE parent LIKE '%BOM_ChildCode%'
/*group by item_code*/
ORDER BY parent, item_code


#3

thanks for the sharing.