Report builder?

"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."

Dan,

Try adding the subassembly part number to the report, I believe that would
be the PartMatl part#.

Sarah
I am trying to write a report builder report to read all sub contracting
operations on parts with multi-level bill of materials. I am uncertain of
the joins required to read the individual assemblies. The data dictionary
contains two temporary tables PARTBOM and PARTBOO are these the tables I
need ? what are the indexes?

Thanks
Dan Shallbetter
States Electric Mfg.
Dan,

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.


Sarah
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.

Thanks
Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, October 24, 2000 8:31 AM
To: vantage@egroups.com
Subject: RE: [Vantage] report builder ?


Dan,

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]