Genealogy by Work Order report

The Genealogy by Work Order report shows, by work order, which input or raw material items were consumed directly and indirectly to create production items.

To enable genealogy, you must ensure that produced items of the same production level share a common operation ID, work order ID, sequence number, and lot number.

The following criterion is being used to establish the correct linkage:

item_prod.wo_id = item_cons.wo_id AND

item_prod.oper_id = item_cons.oper_id AND

item_prod.seq_no = item_cons.seq_no AND

item_prod.lot_no = item_cons.fg_lot_no

The Genealogy by Work Order report displays for any specified produced item of a specified grade and status all consumed items that went into its production.

Genealogy does not take into account sublots.