re: Genealogy

Hi,

Does anyone have the query behind the genealogy (lot) form.

We need a small change so looking for the query and make the change and deploy a custom report.

Basically we use blanket work orders and produce multiple FGs from sub-assemblies(separate work order) Each sub-assembly and FG have unique Lot# assigned.

Each FG and Sub-Assembly are separate Work order completions.

FG Lot-1 ( Work order-1) consumes Sub-assembly Lot-1W ( work order-2)

FG Lot-2 (work order-1) consumes Sub-assembly Lot-2W ( work order-2)

When query by Lot-1 need the genealogy to show

Lot-1 (Item) -> Lot-1W ( Item)

Lot-2(item) -> Lot-2W (Item).