Export Bill Of material with name of products

NickSch

I'm able to export a list of products with the BOM-ID and the current product ID. Is there a possibility to show the name/ description of the parent of the BOM-product. If I export this, I then can group the BOM-products by their Parent-product, showing me a nice export of all the needed quantity as well as the sales of each BOM-product.

Example of how I'd like to export this:

Is this possible?

Thanks in advance,
Nick Sch.

(Related question: I've also asked a recent question regarding the filtering on a certain range of dates for my export: https://forum.stockmanagementlabs.com/d/5168-creating-an-import-with-products-filtered-on-a-certain-date-range-year)

japiera

Hi NickSch ,

Thanks for your post.

The parent product title can be exported by adding the "Title" field from the Products entity.

Unfortunately, adding the BOM product name is a little more difficult and would involve custom coding.

Alternatively, you can get the sheet you want by exporting the BOM products (including the title and the ID) to a new sheet, and cross-referencing the data on any spreadsheet software with the previous sheet by using the ID.

Best Regards,
José Andrés

NickSch

Thanks for the suggestion. I will try this!

japiera

Hi NickSch ,

You're welcome.

Best Regards,
José Andrés