--- In Axapta-Knowledge-Village@yahoogroups.com, yaya karya <magive...@...> wrote: > > HI All, > > > Can anybody show me fields and related tables to make link between > InventTrans and prodTable so I can see where do material come from for a > finish goods. it is the same as inventory tracing. > thx. > > > Regards > > Ya2 >
hi magive249, If u simply want relation between inventtrans and prodtable then inventtrans.transrefid==prodtable.prodid inventtrans.itemid==prodtable.itemid inventtrans.inventtransid==prodtable.inventtransid inventtrans.transtype=='production'; and using inventtrans.itembomid ==bom.bomid u can find the current item is linked to which bom of finished good .