Does anyone have a way to identify the components of a bom marked “pull-as-assembly”?
So far we have only being successful identifying assemblies that contain parts checked pull-as-assembly.
We need the actual component.
Not sure if I’m following your question fully. However, this should be
stored in the *PartMtl *table, *PullAsAsm *field (PartMtl.PullAsAsm). This
query would list all materials listed as pull as asm on all approved
ParentParts. These examples as in SQL, but you should be able to do the
same in a BAQ.
SELECT r.partnum as ParentPart, r.RevisionNum as ParentRev, m.MtlPartNum,
m.PullAsAsm
FROM erp.PartMtl m
INNER JOIN erp.PartRev r ON
m.Company = r.Company AND
m.PartNum = r.PartNum
WHERE m.PullAsAsm = 1 AND r.Approved = 1
Or you could group it by MtlPartNum and get the number of times a part is
being used as PullAsAsm, like this.
SELECT Count(r.partnum) as NumberOfParentParts, m.MtlPartNum
FROM erp.PartMtl m
INNER JOIN erp.PartRev r ON
m.Company = r.Company AND
m.PartNum = r.PartNum
WHERE m.PullAsAsm = 1 AND r.Approved = 1
GROUP BY m.MtlPartNum
Order BY Count(r.partnum) desc
Hope this helps…
Thanks,
Norman Hutchins
System Administrator
Howell Laboratories, Inc.
A Pull as Assembly part will show its materials on the job of its parent, and so is very similar to a job feeding into another job. The biggest differences are that the quantities between the two are axiomatically linked and use the same job number and traveler; they are locked together.
The Method Tracker can be used to see the Pull as Assembly part just as any other part. I think it was around 9.05.701 that the Method Tracker was put on the menu, though it existed from the context menu for the Revision field at least in 700C when I saw, and exists on the menu by default in 702A.
Norman,
Thank you for the reply. We did figure out how to add the PullAsAsm field to the BOM Listing report and get what we needed. Your examples will be of benefit as well. Thanks again.
RJ
Thanks Jim!
Glad it helped!