I need to be able to export a csv/excel file representing a Bill of Materials for our circuit board manufature, it seems i am able to get most of the information except I have not found a way to add all of the supplier information which is critical for them. I would expect to find "BOM Lines/Product/Supplier Product Code" and "BOM Lines/Product/Supplier Product Name" in the export dialog but they are not there.
I have also installed the "Export Data in Excel" module to possibly add my own custom exporting features but cannot locate where in the data model that supplier information is stored.
My question is am i just missing something that is preventing me from completing this action using the normal export? it is very odd to me that this is not included. If it is not possible normally where in the data model is this is this information stored so that I might create my own export features?
I also have this requirement and so far I've had to do export the vendor pricelist and BOM and then use Xlookup function in Excel to get the manufacturer PNs.
It is rather disappointing that this feature is not available.
See my answer below