Genealogy by Lot report

The Genealogy by Lot report shows, by lot, which work orders and produced lots consumed specific raw materials.

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 Lot report displays for any specified raw material lot number all work orders that used it. This report is essentially the reverse of the Genealogy by Work Order report.

Genealogy does not take into account sublots.