Really big struggle getting this figured out. Seems like it should be really simple.
I am going to make the example simple as possible:
I have a single welded part. The part contains 3 weldment profiles/materials 1 square tube,1 round tube, and 1 rectangle bar.
each profile selection creates 5 unique cutlist bodies.
without manually manipulating the cutlist on each part. (we do lots of custom weldments with 15-50 cutlist items each and manually editing is to time intensive)
I want a BOM that contains the total qty of each material without listing each cutlist item. one line for each material in that part.
Here is the kicker, I want it to pull this way from within an assembly. (BOM indented with detailed cutlist)
Example: Assembly contains 2 of a standard part (SP1) and one of my Weldment (Weld1)
| Number | Description | QTY |
|---|---|---|
| SP1 | Standard part 1 | 2 |
| Weld1 | Custom Weldment | 1 |
| weld1.1 | Square Tube | 15.25' |
| weld1.2 | Round Tube | 6.5' |
| weld1.3 | Rect. Bar | 26.75' |
We had High hopes for a semblance of this with 2021 PDM pro BOM templates allowing cutlist in BOM... Our VAR is looking into getting that working correctly, but I am pretty sure the functionality isn't there.
Am I chasing the impossible or is this something that can be done?
Just as an update if anyone needs this in the future.
PDM admin BOM templates(pro only):
weldment profiles must have Description custom property in them.
Make sure to add Description to columns linked to Description variable: This is how PDM determines if it is a unique material or not.
Last but very important- Part cards need to have a variable that writes a custom property with an attribute of UNIT_OF_MEASURE
this allows you to use <Reference count> for the QTY column and get the linear qty of each type of material.
This is what I get on a test Assembly with parts containing weldments:
The only thing We really have to pay attention to when exporting as csv is that the qty of weldment materials is per part in the assembly. so how we deal with BOMs we need to multiply it out before sending it on.
Overall this takes a fair bit of set up, but once it is set up it works great for how we process BOMs
hope this helps someone else along the way.