We have parts masters that might have 10-30 sub assemblies I would like to
write a report that will show sub contracting operations for all the various
sub assemblies. I have already written this query from the job side. I am
now trying to create it on the part master record. I used the joins you
referenced + (Parted). I am able to see all subcontracting operations, but
my report displays the parent part number for each sub contracting operation
instead of the sub assembly part number.
States Electric Mfg.
Sent: Tuesday, October 24, 2000 8:31 AM
Subject: RE: [Vantage] report builder ?
I am not clear as to what information you are trying to get? We do not have
BOM's in our part list, so maybe that's where my confusion is.
If you are looking for the subcontracted operations on jobs, than you can
use the joboper table and filter on only subcontracted operations. If you
are looking through your part list at the BOM's for subcontracting
operations, than use the PartOper table, again filtering on subcontract. To
get subassemblies, you may have to link Part to PartMtl to PartOper. As I
said, I've never done this, so this is just a guess.
[Non-text portions of this message have been removed]