Hi.

I Have something interesting.

I want to be able to tag standard parts (from my own folder) with 2 options of text. 

1. "purchase by manufacturer"

2. "purchase by Client"

the reason is that I may have a standard part appearing in an assembly multiple times. in some, I want the manufacturer of the entire assembly to buy them, some may appear in a reference assembly which I assemble in house so I need them shipped to my company.

This can be achieved manually by using configurations for the standard part but then the designer must remember to select the proper conf.

The best option to achieve this is or it to be automatic:

In excel I can use a formula that runs on the indented BOM and understands the hierarchy of the BOM, and if the child part appears under a parent with "BOM type" (variable) value of "production" , then the Child part will receive a tag of "purchase by vendor".
If the parent BOM Type value is "Ref assy", the child part will receive a "purchase by client" tag.

now since I don't want to write this formula manually every time I export a BO to a CSV file, I am looking to have this formula already in a custom Excel template for the export of the BOM.

Regards

Ben