Hello forum,
How do people generally handle bulk items like paint or thread sealant in an assembly BOM?
We would like to have a line-item in the BOM and the quantity to be listed as "A/R" or "As Req'd" or such. We don't need a balloon callout pointing to where in the assembly the sealant is to be applied, as we would make notes pointing to where sealant is applied. I found this article and I was hoping I could adapt it to our purposes. I wanted to make a part with no geometry, create a custom property called "BOM_QUANTITY" with the value "A/R", and set that property as the part BOM quantity as shown below.
This does not work as the BOM quantity must be a numerical value. Say I give it a value of 0.25, but insert the part in two locations, then the quantity in the assembly BOM will read 0.5. Makes sense, but our shop consumables are tracked separately and we don't want to start ordering based on BOM quantities.
Does anybody know how we can get a part quantity to be automatically listed as a text string rather than a numerical value?
Thanks!
I have a solution for you. You are half way there.
Here's how I did that... Create a custom property called "BOM QTY." in your part (you've already got it.) Then in the parts you want to be A/R just add a "A/R". You could use any text here, but it has to be exactly the same for all A/R parts. Then create a column in your BOM Template next to the real QTY. column. I called it QTY without the period (remember you can't name columns the same as existing reserved column names). Now here's the part you were missing, add an equation.
Then add the following in the text box:
Where BOM QTY. is your custom property from your part. The first "A/R" is the text in that property. The second A/R is what you want to be displayed in the BOM. Finally, if the value returns false, ie., BOM QTY != "A/R", then the actual QTY. field is displayed in your BOM. Now hide the QTY. field and save this BOM as a template.
Files attached.
Problem solved?