BOM and bulk item shenanigans
BOM and bulk item shenanigans
(OP)
hi folks,
okay, here's what i have: top assy is a skid with pressure vessels, pipe runs, cabinets, etc. each pipe run is a subassy of fittings, valves, gauges, etc located on a datum curve defined by points (offset csys). the pipe itself is a part created in assy and thin protrusions extruded between fittings. the drawing i'm working on will depict several of these runs in simp reps on each sheet showing the particular pipe runs integration to the skid, with a BOM for each on it's related sheet. now...
1. i'm using the pipe as a bulk item, so i want the part in the BOM to have a qty of AR. to the table relations i've added:
IF asm_mbr_ptnum == "105426"
qty="A/R"
else
qty=rpt_qty
endif
but it's not passing the "AR" value to the table. i get no errors either. i've tried modifying the syntax a couple different ways to no avail.
2. once i get this working, i'd like to pass a value for the approx length of pipe i've used to a drawing note. hopefully by way of a simple relation to add the parameter:
APPROX_PIPE_LENGTH=pro_mp_mass()/.071
i've done the BOM report before, but using a different report parameter, and it worked. dunno why this one isn't. i haven't exactly the same kind of function with the mass parameter. i feel like i'm missing a step, but all the references i'm looking at are from 2001. maybe some of the required syntax changed? any help will be greatly appreciated.
okay, here's what i have: top assy is a skid with pressure vessels, pipe runs, cabinets, etc. each pipe run is a subassy of fittings, valves, gauges, etc located on a datum curve defined by points (offset csys). the pipe itself is a part created in assy and thin protrusions extruded between fittings. the drawing i'm working on will depict several of these runs in simp reps on each sheet showing the particular pipe runs integration to the skid, with a BOM for each on it's related sheet. now...
1. i'm using the pipe as a bulk item, so i want the part in the BOM to have a qty of AR. to the table relations i've added:
IF asm_mbr_ptnum == "105426"
qty="A/R"
else
qty=rpt_qty
endif
but it's not passing the "AR" value to the table. i get no errors either. i've tried modifying the syntax a couple different ways to no avail.
2. once i get this working, i'd like to pass a value for the approx length of pipe i've used to a drawing note. hopefully by way of a simple relation to add the parameter:
APPROX_PIPE_LENGTH=pro_mp_mass()/.071
i've done the BOM report before, but using a different report parameter, and it worked. dunno why this one isn't. i haven't exactly the same kind of function with the mass parameter. i feel like i'm missing a step, but all the references i'm looking at are from 2001. maybe some of the required syntax changed? any help will be greatly appreciated.
Ed Lee
Sr. Designer
H2Gen
Alexandria, VA





RE: BOM and bulk item shenanigans
-Hora
RE: BOM and bulk item shenanigans
Here goes...
We do something similar: (R2001)
I could not get it to work until I changed qty to Qty in my relation - very annoying.
Here is an example:
if asm_mbr_bulk_item==yes
Qty="AS REQ."
Else
qty=rpt_qty
Endif
Also...
Does the quantity column in your repeat region reference the relation?
Example:
{0:&rpt.rel.Qty}
Again, watch for the capitol "Q" - very annoying.
Hope there is something here that helps.
Cheers,
JW
RE: BOM and bulk item shenanigans
incidentally, i tried an upper and lower case q, with no difference. maybe this annoyance has passed with wf3 (which i forgot to specify).
i'm going to look into using the bulk_item method you have there too. i'd rather have users create a component in the assy using a pipe part template as opposed to messing with the table relations every time.
thanks to you both. that nailed the first part. the second part is not a priority, but more a curiosity.
Ed Lee
Sr. Designer
H2Gen
Alexandria, VA